Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 ISPAYMENTCOUNTED bit   Default = 0
 ISPLEDGECOUNTED bit   Default = 0
 ISRECURRINGGIFTCOUNTED bit   Default = 0
 INCLUDEPAYMENTACTIVITYTYPECODE tinyint   Default = 0
 INCLUDEPAYMENTACTIVITYTYPE nvarchar(25) (Computed) CASE [INCLUDEPAYMENTACTIVITYTYPECODE] WHEN 0 THEN N'any designation' WHEN 1 THEN N'specific designations' WHEN 2 THEN N'the following designation' END
 ISEVENTREGISTRATIONCOUNTED bit   Default = 0
 INCLUDEEVENTTYPECODE tinyint   Default = 0
 INCLUDEEVENTTYPE nvarchar(29) (Computed) CASE [INCLUDEEVENTTYPECODE] WHEN 0 THEN N'any event' WHEN 1 THEN N'events in a specific category' END
 ISMEMBERSHIPDUECOUNTED bit   Default = 0
 INCLUDEMEMBERSHIPTYPECODE tinyint   Default = 0
 INCLUDEMEMBERSHIPTYPE nvarchar(30) (Computed) CASE [INCLUDEMEMBERSHIPTYPECODE] WHEN 0 THEN N'membership in any level' WHEN 1 THEN N'membership in a specific level' END
 ISMULTIPLEREVENUETRANSACTIONSCOUNTED bit   Default = 0
 WHATHAPPENSIFTHEYGIVEMORECODE tinyint   Default = 0
 WHATDATETOCALCULATEEXPIRATIONDATECODE tinyint   Default = 0
 WHATDATETOCALCULATEEXPIRATIONDATE nvarchar(48) (Computed) CASE [WHATDATETOCALCULATEEXPIRATIONDATECODE] WHEN 0 THEN N'the transaction date of the gift' WHEN 1 THEN N'the last day of the month the gift was received' WHEN 2 THEN N'specific dates' END
 DATEADDED datetime   Default = getdate()
 DATECHANGED datetime   Default = getdate()
 TS timestamp  
 TSLONG bigint (Computed) CONVERT(bigint, TS)
 WHATHAPPENSIFTHEYGIVEMORE nvarchar(21) (Computed) CASE [WHATHAPPENSIFTHEYGIVEMORECODE] WHEN 0 THEN N'as additional revenue' WHEN 1 THEN N'toward an upgrade' WHEN 2 THEN N'toward a renewal' END

Foreign Key Field Type Null Notes Description
 ID uniqueidentifier   MEMBERSHIPLEVEL.ID
 DESIGNATIONID uniqueidentifier DESIGNATION.ID
 IDSETREGISTERID uniqueidentifier IDSETREGISTER.ID
 EVENTCATEGORYCODEID uniqueidentifier EVENTCATEGORYCODE.LOCALID
 MEMBERSHIPPROGRAMID uniqueidentifier MEMBERSHIPPROGRAM.ID
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID

Index Name Field(s) Unique Primary Clustered
 IX_MEMBERSHIPLEVELCONTRIBUTION_DATEADDED DATEADDED    
 IX_MEMBERSHIPLEVELCONTRIBUTION_DATECHANGED DATECHANGED      
 PK_MEMBERSHIPLEVELCONTRIBUTION ID  

Trigger Name Description
 TR_MEMBERSHIPLEVELCONTRIBUTION_AUDIT_UPDATE
 TR_MEMBERSHIPLEVELCONTRIBUTION_AUDIT_DELETE

Referenced by Field
 MEMBERSHIPLEVELCONTRIBUTIONEXPIRATIONDATERANGE MEMBERSHIPLEVELCONTRIBUTIONID

Entity-Relationship diagram of this table