Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 REVENUETYPECODE tinyint   Default = 0 0=Donations, 1=Pledges, 2=Recurring gift payments, 3=Event registrations, 4=Admissions, 5=Memberships, 6=Matching gift claims, 7=Other, 8=Planned gifts, 9=Donor challenge claims, 10=Auction item donations, 11=Auction item purchases, 12=Grant awards
 CONSIDERCLAIMEDAMOUNT bit   Default = 0 Indicates if the recent calculations should consider the entire amount pledged/claimed or if it should only consider paid amounts.
 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.
 REVENUETYPE nvarchar(23) (Computed) CASE [REVENUETYPECODE] WHEN 0 THEN N'Donations' WHEN 1 THEN N'Pledges' WHEN 2 THEN N'Recurring gift payments' WHEN 3 THEN N'Event registrations' WHEN 4 THEN N'Admissions' WHEN 5 THEN N'Memberships' WHEN 6 THEN N'Matching gift claims' WHEN 7 THEN N'Other' WHEN 8 THEN N'Planned gifts' WHEN 9 THEN N'Donor challenge claims' WHEN 10 THEN N'Auction item donations' WHEN 11 THEN N'Auction item purchases' WHEN 12 THEN N'Grant awards' END Provides a translation for the 'REVENUETYPECODE' field.

Foreign Key Field Type Null Notes Description
 REVENUELIFECYCLECRITERIAID uniqueidentifier REVENUELIFECYCLECRITERIA.ID FK to REVENUELIFECYCLECRITERIA
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_REVENUELIFECYCLEREVENUECRITERIA_DATEADDED DATEADDED    
 IX_REVENUELIFECYCLEREVENUECRITERIA_DATECHANGED DATECHANGED      
 IX_REVENUELIFECYCLEREVENUECRITERIA_REVENUELIFECYCLECRITERIAID REVENUELIFECYCLECRITERIAID      
 PK_REVENUELIFECYCLEREVENUECRITERIA ID  
 UIX_REVENUELIFECYCLEREVENUECRITERIA_REVENUETYPECODE_REVENUELIFECYCLECRITERIAID REVENUETYPECODE, REVENUELIFECYCLECRITERIAID    

Trigger Name Description
 TR_REVENUELIFECYCLEREVENUECRITERIA_AUDIT_UPDATE
 TR_REVENUELIFECYCLEREVENUECRITERIA_AUDIT_DELETE

Entity-Relationship diagram of this table