Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 DONORPERIOD int   Default = 3 The number of years in which a constituent must have given revenue in order to be considered a donor.
 MIDLEVELDONORGIFTAMOUNT money   Default = 250 The minimum largest gift amount which a constituent must have given to have the Major donor constituency.
 CONSIDERRECOGNITION bit   Default = 0 Consider recognition credits when evaluating the Major donor constituency.
 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.
 DONORASOFDATE date Specifies the as of date used when evaluating whether or not a constituent will be considered a donor.
 USECONSECUTIVELOYALYEARS bit   Default = 1 Determines whether or not to consider consecutive years when evaluating whether or not a constituent will be considered a loyal donor.
 CONSECUTIVELOYALYEARS int   Default = 3 Number of consecutive years a constituent needs to give in order to be considered a loyal donor.
 NOAFFINITYPERIOD int   Default = 10 Number of years to consider when evaluting whether or not a constituent has shown any affinity towards the organization.
 DONORFILTERTYPECODE tinyint   Default = 0 0=NODATERANGE, 1=USEYEARRANGE, 2=USEASOFDATE
 DONORFILTERTYPE nvarchar(12) (Computed) CASE [DONORFILTERTYPECODE] WHEN 0 THEN N'NODATERANGE' WHEN 1 THEN N'USEYEARRANGE' WHEN 2 THEN N'USEASOFDATE' END Provides a translation for the 'DONORFILTERTYPECODE' field.
 USEMULTIPLELOYALYEARS bit   Default = 1 Determines whether or not to consider multiple years when evaluating whether or not a constituent will be considered a loyal donor.
 LOYALDONORMULTIYEARVALUE int   Default = 3 The minimum number of years a constituent has to have given in order to be considered a loyal donor.
 LOYALDONORMULTIYEARRANGE int   Default = 6 The number of years to look at evaluating whether or not a constituent will be considered a loyal donor.
 USEMAJORDONORSINGLEGIFT bit   Default = 1 Determines whether or not a single large gift can qualify a constituent as a major donor.
 MAJORDONORSINGLEGIFTAMOUNT money   Default = 1000 Minimum amount required on a single gift to qualify a constituent as a major donor.
 USEMAJORDONORLIFETIMEGIVING bit   Default = 1 Determines whether or not a constituent's lifetime giving can qualify them as a major donor.
 MAJORDONORLIFETIMEGIVINGAMOUNT money   Default = 2000 Minimum lifetime giving amount required to qualify a constituent as a major donor.
 INCLUDEMAJORDONORPROSPECTS bit   Default = 0 Determines whether or not to consider constituents with the 'Major Donor Prospect' constituency as major donors.
 PLANNEDGIFTMUSTHAVEPAYMENTS bit   Default = 0 Determines whether or not a planned gift must have at least one payment before a constituent can be considered a planned giver.

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

Index Name Field(s) Unique Primary Clustered
 IX_REVENUELIFECYCLECRITERIA_DATEADDED DATEADDED    
 IX_REVENUELIFECYCLECRITERIA_DATECHANGED DATECHANGED      
 PK_REVENUELIFECYCLECRITERIA ID  

Trigger Name Description
 TR_REVENUELIFECYCLECRITERIA_AUDIT_UPDATE
 TR_REVENUELIFECYCLECRITERIA_AUDIT_DELETE

Referenced by Field
 REVENUELIFECYCLEREVENUECRITERIA REVENUELIFECYCLECRITERIAID

Entity-Relationship diagram of this table