Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(100)   Default = '' The name of the membership level.
 DESCRIPTION nvarchar(255)   Default = '' The description of the membership level.
 MEMBERSALLOWED smallint   Default = ((0)) The number of members allowed for this level.
 CHILDRENALLOWED smallint   Default = ((0)) The number of children allowed for this level.
 CARDSALLOWED smallint   Default = ((0)) The number of cards allowed for this level.
 BEFOREEXPIRATION tinyint   Default = 0 The renewal window before the expiration date.
 AFTEREXPIRATION tinyint   Default = 0 The renewal window after the expiration date.
 FORCEMANUALDOWNGRADES bit   Default = 0 The ability to automatically force a downgrade to a different level..
 ISACTIVE bit   Default = 0 The active option for a membership level.
 DATEADDED datetime   Default = getdate() Indicates the date this record was added.
 DATECHANGED datetime   Default = getdate() Indicates the date this record was last changed.
 TS timestamp   Timestamp.
 TSLONG bigint (Computed) CONVERT(bigint, TS) Numeric representation of the timestamp.
 SEQUENCE int   Default = 0 The sequence order of the levels.
 OVERRIDECAMPAIGNS bit   Default = 0 Determines whether the campaigns on the membership program are being overridden by the level.
 RENEWALWINDOWSTARTTYPECODE tinyint   Default = 2
 RENEWALWINDOWSTARTTIMECODE tinyint   Default = 0
 RENEWALWINDOWSTARTTIME nvarchar(2) (Computed) CASE [RENEWALWINDOWSTARTTIMECODE] WHEN 0 THEN N'1' WHEN 1 THEN N'2' WHEN 2 THEN N'3' WHEN 3 THEN N'4' WHEN 4 THEN N'5' WHEN 5 THEN N'6' WHEN 6 THEN N'7' WHEN 7 THEN N'8' WHEN 8 THEN N'9' WHEN 9 THEN N'10' WHEN 10 THEN N'11' WHEN 11 THEN N'12' WHEN 12 THEN N'13' WHEN 13 THEN N'14' WHEN 14 THEN N'15' WHEN 15 THEN N'16' WHEN 16 THEN N'17' WHEN 17 THEN N'18' WHEN 18 THEN N'19' WHEN 19 THEN N'20' WHEN 20 THEN N'21' WHEN 21 THEN N'22' WHEN 22 THEN N'23' WHEN 23 THEN N'24' WHEN 24 THEN N'25' WHEN 25 THEN N'26' WHEN 26 THEN N'27' WHEN 27 THEN N'28' WHEN 28 THEN N'29' WHEN 29 THEN N'30' WHEN 30 THEN N'31' WHEN 31 THEN N'32' WHEN 32 THEN N'33' END
 RENEWALWINDOWSTARTINTERVALCODE tinyint   Default = 0
 RENEWALWINDOWSTARTINTERVAL nvarchar(6) (Computed) CASE [RENEWALWINDOWSTARTINTERVALCODE] WHEN 0 THEN N'Days' WHEN 1 THEN N'Months' END
 RENEWALWINDOWSTARTCUTOFFDAY tinyint   Default = 1
 RENEWALWINDOWREVENUETYPECODE tinyint   Default = 0
 RENEWALWINDOWREVENUETYPE nvarchar(14) (Computed) CASE [RENEWALWINDOWREVENUETYPECODE] WHEN 0 THEN N'Rejoin' WHEN 1 THEN N'New membership' END
 MEMBERSHIPTERMTYPECODE tinyint   Default = 0
 MEMBERSHIPTERMTYPE nvarchar(7) (Computed) CASE [MEMBERSHIPTERMTYPECODE] WHEN 0 THEN N'Rolling' WHEN 1 THEN N'Fixed' END
 RECEIPTAMOUNT money   Default = 0
 NONRENEWALACTIONTYPECODE tinyint   Default = 4
 NONRENEWALACTIONTYPE nvarchar(7) (Computed) CASE [NONRENEWALACTIONTYPECODE] WHEN 4 THEN N'Lapsed' WHEN 5 THEN N'Expired' END
 OBTAINLEVELCODE tinyint   Default = 0
 OBTAINLEVEL nvarchar(26) (Computed) CASE [OBTAINLEVELCODE] WHEN 0 THEN N'Purchased with dues' WHEN 1 THEN N'Awarded with contributions' END
 RENEWALWINDOWSTARTTYPE nvarchar(28) (Computed) CASE [RENEWALWINDOWSTARTTYPECODE] WHEN 0 THEN N'Given time before expiration' WHEN 1 THEN N'Day of month of expiration' WHEN 2 THEN N'No automatic renewal' END

Foreign Key Field Type Null Notes Description
 MEMBERSHIPPROGRAMID uniqueidentifier   MEMBERSHIPPROGRAM.ID FK to MEMBERSHIPPROGRAM
 TIERCODEID uniqueidentifier TIERCODE.ID The tier of the membership level.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 BASECURRENCYID uniqueidentifier CURRENCY.ID The base currency associated with this membership level.
 MEMBERSHIPLEVELRENEWAL1ID uniqueidentifier MEMBERSHIPLEVELRENEWAL.ID
 MEMBERSHIPLEVELRENEWAL2ID uniqueidentifier MEMBERSHIPLEVELRENEWAL.ID
 MEMBERSHIPLEVELRENEWAL3ID uniqueidentifier MEMBERSHIPLEVELRENEWAL.ID

Index Name Field(s) Unique Primary Clustered
 IX_MEMBERSHIPLEVEL_BASECURRENCYID BASECURRENCYID      
 IX_MEMBERSHIPLEVEL_DATEADDED DATEADDED    
 IX_MEMBERSHIPLEVEL_DATECHANGED DATECHANGED      
 IX_MEMBERSHIPLEVEL_ID ID      
 IX_MEMBERSHIPLEVEL_MEMBERSHIPPROGRAMID MEMBERSHIPPROGRAMID      
 PK_MEMBERSHIPLEVEL ID  
 UIX_MEMBERSHIPLEVEL_NAME_MEMBERSHIPPROGRAMID NAME, MEMBERSHIPPROGRAMID    

Trigger Name Description
 TR_MEMBERSHIPLEVEL_AUDIT_ETLDELETEDID
 TR_MEMBERSHIPLEVEL_AUDIT_UPDATE
 TR_MEMBERSHIPLEVEL_AUDIT_DELETE
 TR_MEMBERSHIPLEVEL_INSERTUPDATE_CURRENCY

Referenced by Field
 BATCHBBNCMEMBERSHIP MEMBERSHIPLEVELID
 BATCHMEMBERSHIPDUES MEMBERSHIPLEVELID
 BATCHMEMBERSHIPTRANSACTION MEMBERSHIPLEVELID
 BATCHREVENUEAPPLICATIONMEMBERSHIP MEMBERSHIPLEVELID
 COMBINATIONAVAILABILITYMEMBER MEMBERSHIPLEVELID
 COMBINATIONMEMBER MEMBERSHIPLEVELID
 CREDITITEMMEMBERSHIP MEMBERSHIPLEVELID
 DAILYSALEITEMMEMBERSHIP MEMBERSHIPLEVELID
 DISCOUNTAVAILABILITYMEMBER MEMBERSHIPLEVELID
 DISCOUNTMEMBER MEMBERSHIPLEVELID
 DONORCHALLENGEMEMBERSHIPLEVELMAP MEMBERSHIPLEVELID
 MEMBERSHIP MEMBERSHIPLEVELID
 MEMBERSHIPGLMAPPING ID
 MEMBERSHIPLEVELBENEFIT MEMBERSHIPLEVELID
 MEMBERSHIPLEVELCAMPAIGN MEMBERSHIPLEVELID
 MEMBERSHIPLEVELCONTRIBUTION ID
 MEMBERSHIPLEVELDESIGNATION MEMBERSHIPLEVELID
 MEMBERSHIPLEVELRENEWAL MEMBERSHIPLEVELID
 MEMBERSHIPLEVELRENEWALRULES MEMBERSHIPLEVELID
 MEMBERSHIPLEVELTERM LEVELID
 MEMBERSHIPLEVELTYPE LEVELID
 MEMBERSHIPTRANSACTION MEMBERSHIPLEVELID
 MICROSITEMEMBERSHIPLEVEL ID
 PRINTMEMBERSHIPCARDSPROCESS MEMBERSHIPLEVELID
 REVENUESPLITORDER MEMBERSHIPLEVELID
 SALESORDERITEMMEMBERSHIP MEMBERSHIPLEVELID

Entity-Relationship diagram of this table (BATCHBBNCMEMBERSHIP-MEMBERSHIPLEVELRENEWAL)
Entity-Relationship diagram of this table (MEMBERSHIPLEVELRENEWALRULES-TIERCODE)