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(32) (Computed) CASE [INCLUDEMEMBERSHIPTYPECODE] WHEN 0 THEN N'membership in any program' WHEN 1 THEN N'membership in a specific program' 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   MEMBERSHIPPROGRAM.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_MEMBERSHIPPROGRAMCONTRIBUTION_DATEADDED DATEADDED    
 IX_MEMBERSHIPPROGRAMCONTRIBUTION_DATECHANGED DATECHANGED      
 PK_MEMBERSHIPPROGRAMCONTRIBUTION ID  

Trigger Name Description
 TR_MEMBERSHIPPROGRAMCONTRIBUTION_AUDIT_UPDATE
 TR_MEMBERSHIPPROGRAMCONTRIBUTION_AUDIT_DELETE

Referenced by Field
 MEMBERSHIPPROGRAMCONTRIBUTIONEXPIRATIONDATERANGE MEMBERSHIPPROGRAMCONTRIBUTIONID

Entity-Relationship diagram of this table