Primary Key Field Type
 ID uniqueidentifier

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

Foreign Key Field Type Null Notes Description
 NAMINGOPPORTUNITYID uniqueidentifier   NAMINGOPPORTUNITY.ID The naming opportunity this recognition is made against.
 CONSTITUENTID uniqueidentifier   CONSTITUENT.LOCALID The constituent who is being recognized by this recognition.
 CONSTITUENTNAMEFORMATID uniqueidentifier NAMEFORMAT.ID The system-defined name format for the recognition name for this recognition.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 ORGANIZATIONEXCHANGERATEID uniqueidentifier CURRENCYEXCHANGERATE.ID The exchange rate used to convert from amount to organization amount.
 BASECURRENCYID uniqueidentifier CURRENCY.ID The base currency associated with this naming opportunity recognition.

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  

Trigger Name Description
 TR_NAMINGOPPORTUNITYRECOGNITION_INSERTUPDATE_CURRENCY
 TR_NAMINGOPPORTUNITYRECOGNITION_AUDIT_UPDATE
 TR_NAMINGOPPORTUNITYRECOGNITION_AUDIT_DELETE

Referenced by Field
 NAMINGOPPORTUNITYRECOGNITIONINSTALLEDLOCATION NAMINGOPPORTUNITYRECOGNITIONID
 NAMINGOPPORTUNITYRECOGNITIONMGLINK NAMINGOPPORTUNITYRECOGNITIONID
 NAMINGOPPORTUNITYRECOGNITIONREVENUESPLIT NAMINGOPPORTUNITYRECOGNITIONID

Entity-Relationship diagram of this table