Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(100)   Default = '' The name of the membership program.
 DESCRIPTION nvarchar(255)   Default = '' The description of the membership program.
 TYPECODE tinyint   Default = 0 Enumerated value for the type of recognition program: 0 - Annual Giving, 1 - Lifetime Giving
 ISACTIVE bit   Default = 1 Indicates whether this membership program is active.
 EXPIRESONCODE tinyint   Default = 0 Enumerated value indicating the expiration date: 0 - End of calendar year, 1 - End of fiscal year
 BACKDATEMEMBERSHIPS bit   Default = 0 Indicates whether to set memberships starting prior to the cutoff date to the previous month.
 CUTOFFDATEFORYEAR UDT_MONTHDAY   Default = '0000' The date after which memberships will be pushed to expire in the next year.
 GIFTTYPESFILTER xml A collection of gift types to use for filtering revenue when processing this membership program.
 STARTDATE datetime The date to use as a start date for considering revenue when processing this membership program.
 MAXIMUMAMOUNT money   Default = 0 The maximum gift amount used to limit calculation of membership in this program.
 REVENUECODE tinyint   Default = 0 IGNORED. Indicates whether to include revenue only, planned gifts only, or both for a lifetime giving recognition program.
 LASTPROCESSEDON datetime The last time this recognition program was processed.
 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.
 ALLOWINDIVIDUAL bit   Default = 1 Indicates whether this membership program is available to individuals.
 ALLOWHOUSEHOLD bit   Default = 1 Indicates whether this membership program is available to households.
 ALLOWGROUP bit   Default = 1 Indicates whether this membership program is available to groups.
 ALLOWORGANIZATION bit   Default = 1 Indicates whether this membership program is available to organizations.
 PLANNEDGIFTCODE tinyint   Default = 0 Describes whether planned gifts booked as revenue should be counted with revenue, separately, or not at all
 TYPE nvarchar(15) (Computed) CASE [TYPECODE] WHEN 0 THEN N'Annual giving' WHEN 1 THEN N'Lifetime giving' END Provides a translation for the 'TYPECODE' field.
 EXPIRESON nvarchar(20) (Computed) CASE [EXPIRESONCODE] WHEN 0 THEN N'End of calendar year' WHEN 1 THEN N'End of fiscal year' END Provides a translation for the 'EXPIRESONCODE' field.
 REVENUE nvarchar(26) (Computed) CASE [REVENUECODE] WHEN 0 THEN N'Revenue only' WHEN 1 THEN N'Planned giving only' WHEN 2 THEN N'Revenue and planned giving' END Provides a translation for the 'REVENUECODE' field.
 PLANNEDGIFT nvarchar(43) (Computed) CASE [PLANNEDGIFTCODE] WHEN 0 THEN N'No planned gifts' WHEN 1 THEN N'Include planned gifts' WHEN 2 THEN N'Include planned gifts with separate minimum' END Provides a translation for the 'PLANNEDGIFTCODE' field.
 ORGANIZATIONMAXIMUMAMOUNT money   Default = 0 The maximum gift amount in organization currency.
 INCLUDECREDITWITHOUTTYPE bit   Default = 1 Indicates whether to include recognition credit without a type.

Foreign Key Field Type Null Notes Description
 SITEID uniqueidentifier SITE.ID The site to which this membership program belongs.
 SELECTIONID uniqueidentifier IDSETREGISTER.ID The revenue selection used to limit calculation of membership in this program.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 BASECURRENCYID uniqueidentifier CURRENCY.ID The base currency associated with this recognition program.
 ORGANIZATIONEXCHANGERATEID uniqueidentifier CURRENCYEXCHANGERATE.ID The exchange rate used to convert from maximum gift amount to organization maximum gift amount.

Index Name Field(s) Unique Primary Clustered
 IX_RECOGNITIONPROGRAM_BASECURRENCYID BASECURRENCYID      
 IX_RECOGNITIONPROGRAM_DATEADDED DATEADDED    
 IX_RECOGNITIONPROGRAM_DATECHANGED DATECHANGED      
 IX_RECOGNITIONPROGRAM_ORGANIZATIONEXCHANGERATEID ORGANIZATIONEXCHANGERATEID      
 PK_RECOGNITIONPROGRAM ID  
 UC_RECOGNITIONPROGRAM_NAME NAME    

Trigger Name Description
 TR_RECOGNITIONPROGRAM_AUDIT_UPDATE
 TR_RECOGNITIONPROGRAM_AUDIT_DELETE
 TR_RECOGNITIONPROGRAM_INSERTUPDATE_CURRENCY

Referenced by Field
 CONSTITUENTRECOGNITION RECOGNITIONPROGRAMID
 CONSTITUENTRECOGNITIONDECLINEDLEVEL RECOGNITIONPROGRAMID
 CONSTITUENTRECOGNITIONDECLINEDPROGRAM RECOGNITIONPROGRAMID
 CONSTITUENTRECOGNITIONREVENUE RECOGNITIONPROGRAMID
 RECOGNITIONLEVEL RECOGNITIONPROGRAMID
 RECOGNITIONPROGRAMCREDITTYPE RECOGNITIONPROGRAMID
 RECOGNITIONPROGRAMDESIGNATION RECOGNITIONPROGRAMID

Entity-Relationship diagram of this table