Field |
Field Type |
Null |
Notes |
Description |
CUSTOMNAMEFORMAT |
nvarchar(100) |
|
Default = '' |
The custom name for the recognition name for this recognition. |
CONSTITUENTNAME |
nvarchar(700) (Computed) |
|
case when not CONSTITUENTNAMEFORMATID is null then dbo.UFN_NAMEFORMAT_GETFORMATTEDNAME(CONSTITUENTNAMEFORMATID) else CUSTOMNAMEFORMAT end |
The constituent name used for this recognition. |
STARTDATE |
UDT_FUZZYDATE |
|
Default = '00000000' |
The date that the constituent is recognized for the donation. |
ENDDATE |
UDT_FUZZYDATE |
|
Default = '00000000' |
The date that the constituent will stop being recognized for the donation, if any. |
AMOUNT |
money |
|
Default = 0 |
The amount the organization will recognize for the constituent's donation. |
QUANTITY |
int |
|
Default = 1 |
The number of naming opportunities associated with this recognition. |
INSCRIPTION |
nvarchar(max) |
|
Default = '' |
Text to be engraced or placed onto the item. |
SPECIALREQUEST |
nvarchar(max) |
|
Default = '' |
Any special requests that the donor has made regarding the appearance or other facets of the naming opportunity. |
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(max) |
|
Default = '' |
Free-form comments related to this specific recognition. |
ORGANIZATIONAMOUNT |
money |
|
Default = 0 |
Amount in organization currency. |
DESCRIPTION |
nvarchar(200) (Computed) |
|
dbo.UFN_NAMINGOPPORTUNITYRECOGNITION_BUILDNAME(ID) |
Provides a translation field for the recognition record |
Index Name |
Field(s) |
Unique |
Primary |
Clustered |
IX_NAMINGOPPORTUNITYRECOGNITION_BASECURRENCYID |
BASECURRENCYID |
|
|
|
IX_NAMINGOPPORTUNITYRECOGNITION_CONSTITUENTID |
CONSTITUENTID |
|
|
|
IX_NAMINGOPPORTUNITYRECOGNITION_CONSTITUENTNAMEFORMATID |
CONSTITUENTNAMEFORMATID |
|
|
|
IX_NAMINGOPPORTUNITYRECOGNITION_DATEADDED |
DATEADDED |
|
|
|
IX_NAMINGOPPORTUNITYRECOGNITION_DATECHANGED |
DATECHANGED |
|
|
|
IX_NAMINGOPPORTUNITYRECOGNITION_NAMINGOPPORTUNITYID |
NAMINGOPPORTUNITYID |
|
|
|
IX_NAMINGOPPORTUNITYRECOGNITION_ORGANIZATIONEXCHANGERATEID |
ORGANIZATIONEXCHANGERATEID |
|
|
|
PK_NAMINGOPPORTUNITYRECOGNITION |
ID |
|
|
|