| Primary Key | Field Type |
|---|---|
 ID |
uniqueidentifier |
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 JOINDATE |
datetime | The date this constituent joined this recognition level. | ||
| EXPIRATIONDATE |
datetime |  |
The expiration date for this recognition record. Only valid for annual programs. | |
| TOTALAMOUNT |
money | Default = 0 | The total amount given towards this recognition program. | |
| TOTALPLANNEDGIFTAMOUNT |
money | Default = 0 | The total planned gift amount given towards this recognition program. | |
| STATUSCODE |
tinyint | Default = 0 | Current status of the constituent recognition: 0 - Active, 1 - Dropped, 2 - Pending | |
| 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. |
| COMMENTS |
nvarchar(1000) | Default = '' | Remarks about this recognition. | |
| ISANONYMOUS |
bit | Default = 0 | Indicates that this constituent wishes to be an anonymous member of this recognition program. | |
| ORGANIZATIONTOTALAMOUNT |
money | Default = 0 | The total amount given towards this recognition program in organization currency. | |
| ORGANIZATIONTOTALPLANNEDGIFTAMOUNT |
money | Default = 0 | The total planned gift amount given towards this recognition program in organization currency. | |
| STATUS |
nvarchar(16) (Computed) | |
CASE [STATUSCODE] WHEN 0 THEN N'Active' WHEN 1 THEN N'Dropped' WHEN 2 THEN N'Pending' WHEN 3 THEN N'Inactive (Merge)' END |
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 CONSTITUENTID |
uniqueidentifier | CONSTITUENT.LOCALID | The constituent record that has earned this recognition level. | |
| RECOGNITIONPROGRAMID |
uniqueidentifier | RECOGNITIONPROGRAM.ID | The recognition program that this constituent is in. | |
| RECOGNITIONLEVELID |
uniqueidentifier | RECOGNITIONLEVEL.ID | The current recognition level for this constituent. | |
| 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 recognition amount to organization recognition amount. |
| Index Name | Field(s) | Unique | Primary | Clustered |
|---|---|---|---|---|
 IX_CONSTITUENTRECOGNITION_BASECURRENCYID |
BASECURRENCYID | |||
| IX_CONSTITUENTRECOGNITION_CONSTITUENTID |
CONSTITUENTID | |||
 IX_CONSTITUENTRECOGNITION_DATEADDED |
DATEADDED | |
||
| IX_CONSTITUENTRECOGNITION_DATECHANGED |
DATECHANGED | |||
| IX_CONSTITUENTRECOGNITION_ORGANIZATIONEXCHANGERATEID |
ORGANIZATIONEXCHANGERATEID | |||
| IX_CONSTITUENTRECOGNITION_RECOGNITIONPROGRAMID |
RECOGNITIONPROGRAMID | |||
| PK_CONSTITUENTRECOGNITION |
ID | |
|
| Trigger Name | Description |
|---|---|
 TR_CONSTITUENTRECOGNITION_MARKASCONSTITUENT |
|
| TR_CONSTITUENTRECOGNITION_AUDIT_UPDATE |
|
| TR_CONSTITUENTRECOGNITION_AUDIT_DELETE |
|
| TR_CONSTITUENTRECOGNITION_INSERTUPDATE_CURRENCY |
| Referenced by | Field |
|---|---|
 CONSTITUENTRECOGNITIONBENEFIT |
CONSTITUENTRECOGNITIONID |