Open topic with navigation

CONSTITUENTRECOGNITION (4.0SP20)

dbo-4.0-4.0SP1

Top
Primary Key
Foreign Key Fields
Fields
Indexes
Triggers
Referenced by

Stores constituent recognition records.

Primary Key
Primary Key	Field Type
ID	uniqueidentifier

Foreign Key Fields
Foreign Key	Field Type	Null	Notes	Description
CONSTITUENTID	uniqueidentifier	false	CONSTITUENT.ID	The constituent record that has earned this recognition level.
RECOGNITIONPROGRAMID	uniqueidentifier	false	RECOGNITIONPROGRAM.ID	The recognition program that this constituent is in.
RECOGNITIONLEVELID	uniqueidentifier	false	RECOGNITIONLEVEL.ID	The current recognition level for this constituent.
ADDEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
BASECURRENCYID	uniqueidentifier	true	CURRENCY.ID	The base currency associated with this recognition program.
ORGANIZATIONEXCHANGERATEID	uniqueidentifier	true	CURRENCYEXCHANGERATE.ID	The exchange rate used to convert from recognition amount to organization recognition amount.

Fields
Field	Field Type	Null	Notes	Description
JOINDATE	datetime	false		The date this constituent joined this recognition level.
EXPIRATIONDATE	datetime	true		The expiration date for this recognition record. Only valid for annual programs.
TOTALAMOUNT	money	false	0	The total amount given towards this recognition program.
TOTALPLANNEDGIFTAMOUNT	money	false	0	The total planned gift amount given towards this recognition program.
STATUSCODE	tinyint	false	0	Current status of the constituent recognition: 0 - Active, 1 - Dropped, 2 - Pending
DATEADDED	datetime	false	getdate()	Indicates the date this record was added.
DATECHANGED	datetime	false	getdate()	Indicates the date this record was last changed.
TS	timestamp	false		Timestamp.
TSLONG	bigint (Computed)	true		Numeric representation of the timestamp.
COMMENTS	nvarchar(1000)	false	''	Remarks about this recognition.
ISANONYMOUS	bit	false	0	Indicates that this constituent wishes to be an anonymous member of this recognition program.
ORGANIZATIONTOTALAMOUNT	money	false	0	The total amount given towards this recognition program in organization currency.
ORGANIZATIONTOTALPLANNEDGIFTAMOUNT	money	false	0	The total planned gift amount given towards this recognition program in organization currency.
STATUS	nvarchar(16) (Computed)	true

Indexes
Index Name	Field(s)	Unique	Primary	Clustered
IX_CONSTITUENTRECOGNITION_BASECURRENCYID	BASECURRENCYID	False	False	False
IX_CONSTITUENTRECOGNITION_CONSTITUENTID	CONSTITUENTID	False	False	False
IX_CONSTITUENTRECOGNITION_DATEADDED	DATEADDED	False	False	True
IX_CONSTITUENTRECOGNITION_DATECHANGED	DATECHANGED	False	False	False
IX_CONSTITUENTRECOGNITION_ORGANIZATIONEXCHANGERATEID	ORGANIZATIONEXCHANGERATEID	False	False	False
IX_CONSTITUENTRECOGNITION_RECOGNITIONPROGRAMID	RECOGNITIONPROGRAMID	False	False	False
PK_CONSTITUENTRECOGNITION	ID	True	True	False

Triggers
Trigger Name	Description
TR_CONSTITUENTRECOGNITION_INSERTUPDATE_CURRENCY
TR_CONSTITUENTRECOGNITION_AUDIT_UPDATE
TR_CONSTITUENTRECOGNITION_AUDIT_DELETE
TR_CONSTITUENTRECOGNITION_MARKASCONSTITUENT

Referenced by
Referenced by	Field
CONSTITUENTRECOGNITIONBENEFIT	CONSTITUENTRECOGNITIONID