Open topic with navigation

NAMINGOPPORTUNITYRECOGNITION (4.0SP20)

dbo-4.0-4.0SP1

Top
Primary Key
Foreign Key Fields
Fields
Indexes
Triggers
Referenced by

Stores information for each naming opportunity recognition.

Primary Key
Primary Key	Field Type
ID	uniqueidentifier

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

Fields
Field	Field Type	Null	Notes	Description
CUSTOMNAMEFORMAT	nvarchar(100)	false	''	The custom name for the recognition name for this recognition.
CONSTITUENTNAME	nvarchar(700) (Computed)	true		The constituent name used for this recognition.
STARTDATE	UDT_FUZZYDATE	false	'00000000'	The date that the constituent is recognized for the donation.
ENDDATE	UDT_FUZZYDATE	false	'00000000'	The date that the constituent will stop being recognized for the donation, if any.
AMOUNT	money	false	0	The amount the organization will recognize for the constituent's donation.
QUANTITY	int	false	1	The number of naming opportunities associated with this recognition.
INSCRIPTION	nvarchar(max)	false	''	Text to be engraced or placed onto the item.
SPECIALREQUEST	nvarchar(max)	false	''	Any special requests that the donor has made regarding the appearance or other facets of the naming opportunity.
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(max)	false	''	Free-form comments related to this specific recognition.
ORGANIZATIONAMOUNT	money	false	0	Amount in organization currency.
DESCRIPTION	nvarchar(200) (Computed)	true		Provides a translation field for the recognition record

Indexes
Index Name	Field(s)	Unique	Primary	Clustered
IX_NAMINGOPPORTUNITYRECOGNITION_BASECURRENCYID	BASECURRENCYID	False	False	False
IX_NAMINGOPPORTUNITYRECOGNITION_CONSTITUENTID	CONSTITUENTID	False	False	False
IX_NAMINGOPPORTUNITYRECOGNITION_CONSTITUENTNAMEFORMATID	CONSTITUENTNAMEFORMATID	False	False	False
IX_NAMINGOPPORTUNITYRECOGNITION_DATEADDED	DATEADDED	False	False	True
IX_NAMINGOPPORTUNITYRECOGNITION_DATECHANGED	DATECHANGED	False	False	False
IX_NAMINGOPPORTUNITYRECOGNITION_NAMINGOPPORTUNITYID	NAMINGOPPORTUNITYID	False	False	False
IX_NAMINGOPPORTUNITYRECOGNITION_ORGANIZATIONEXCHANGERATEID	ORGANIZATIONEXCHANGERATEID	False	False	False
PK_NAMINGOPPORTUNITYRECOGNITION	ID	True	True	False

Triggers
Trigger Name	Description
TR_NAMINGOPPORTUNITYRECOGNITION_AUDIT_UPDATE
TR_NAMINGOPPORTUNITYRECOGNITION_AUDIT_DELETE
TR_NAMINGOPPORTUNITYRECOGNITION_INSERTUPDATE_CURRENCY

Referenced by
Referenced by	Field
NAMINGOPPORTUNITYRECOGNITIONINSTALLEDLOCATION	NAMINGOPPORTUNITYRECOGNITIONID
NAMINGOPPORTUNITYRECOGNITIONMGLINK	NAMINGOPPORTUNITYRECOGNITIONID
NAMINGOPPORTUNITYRECOGNITIONREVENUESPLIT	NAMINGOPPORTUNITYRECOGNITIONID