Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(100)   Default = '' The name of this naming opportunity.
 DESCRIPTION nvarchar(250)   Default = '' A short description of this naming opportunity.
 QUANTITY int   Default = 1 The total number of recognition opportunities that this naming opportunity supports.
 MINIMUMAMOUNT money   Default = 0 The minimum amount that must be donated in order to be recognized for this naming opportunity.
 COMMENTS nvarchar(max)   Default = '' Free-form comments about this 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.
 ISACTIVE bit   Default = 1 Indicates whether or not the record is active.
 REMAINING int (Computed) dbo.UFN_NAMINGOPPORTUNITY_GETREMAINING(NAMINGOPPORTUNITY.QUANTITY, NAMINGOPPORTUNITY.ID) The total number of remaining recognition opportunities for this naming opportunity.
 SPECIALHANDLING nvarchar(max)   Default = '' Free-form special handling instructions for this naming opportunity.
 ORGANIZATIONMINIMUMAMOUNT money   Default = 0 Min amount in organization currency.

Foreign Key Field Type Null Notes Description
 NAMINGOPPORTUNITYTYPECODEID uniqueidentifier NAMINGOPPORTUNITYTYPECODE.ID The type of this naming opportunity.
 CONTACTID uniqueidentifier CONSTITUENT.LOCALID The staff member who is overseeing the naming opportunity.
 PURPOSEID uniqueidentifier   DESIGNATIONLEVEL.ID The fundraising purpose that donations for this naming opoortunity will suport.
 SITEID uniqueidentifier SITE.ID The site that owns this naming opportunity.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 FACILITYID uniqueidentifier NAMINGOPPORTUNITYFACILITY.ID The specific facility of this naming opportunity.
 CAMPAIGNID uniqueidentifier CAMPAIGN.LOCALID The campaign to which this naming opportunity is tied.
 ORGANIZATIONEXCHANGERATEID uniqueidentifier CURRENCYEXCHANGERATE.ID The exchange rate used to convert from min amount to organization min amount.
 BASECURRENCYID uniqueidentifier CURRENCY.ID The base currency associated with this naming opportunity.

Index Name Field(s) Unique Primary Clustered
 IX_NAMINGOPPORTUNITY_BASECURRENCYID BASECURRENCYID      
 IX_NAMINGOPPORTUNITY_CONTACTID CONTACTID      
 IX_NAMINGOPPORTUNITY_DATEADDED DATEADDED    
 IX_NAMINGOPPORTUNITY_DATECHANGED DATECHANGED      
 IX_NAMINGOPPORTUNITY_ORGANIZATIONEXCHANGERATEID ORGANIZATIONEXCHANGERATEID      
 IX_NAMINGOPPORTUNITY_PURPOSEID PURPOSEID      
 PK_NAMINGOPPORTUNITY ID  
 UIX_NAMINGOPPORTUNITY_SITEID_NAME SITEID, NAME    

Trigger Name Description
 TR_NAMINGOPPORTUNITY_AUDIT_UPDATE
 TR_NAMINGOPPORTUNITY_AUDIT_DELETE
 TR_NAMINGOPPORTUNITY_INSERTUPDATE_CURRENCY

Referenced by Field
 NAMINGOPPORTUNITYATTACHMENT NAMINGOPPORTUNITYID
 NAMINGOPPORTUNITYMEDIALINK NAMINGOPPORTUNITYID
 NAMINGOPPORTUNITYMGOPPORTUNITY NAMINGOPPORTUNITYID
 NAMINGOPPORTUNITYNOTE NAMINGOPPORTUNITYID
 NAMINGOPPORTUNITYRECOGNITION NAMINGOPPORTUNITYID

Entity-Relationship diagram of this table