Stores information for each naming opportunity.
Foreign Key Fields
| Foreign Key |
Field Type |
Null |
Notes |
Description |
|
NAMINGOPPORTUNITYTYPECODEID
|
uniqueidentifier
|
true
|
|
The type of this naming opportunity.
|
|
CONTACTID
|
uniqueidentifier
|
true
|
|
The staff member who is overseeing the naming opportunity.
|
|
PURPOSEID
|
uniqueidentifier
|
false
|
|
The fundraising purpose that donations for this naming opoortunity will suport.
|
|
SITEID
|
uniqueidentifier
|
true
|
|
The site that owns this naming opportunity.
|
|
ADDEDBYID
|
uniqueidentifier
|
false
|
|
FK to CHANGEAGENT.
|
|
CHANGEDBYID
|
uniqueidentifier
|
false
|
|
FK to CHANGEAGENT.
|
|
FACILITYID
|
uniqueidentifier
|
true
|
|
The specific facility of this naming opportunity.
|
|
CAMPAIGNID
|
uniqueidentifier
|
true
|
|
The campaign to which this naming opportunity is tied.
|
|
ORGANIZATIONEXCHANGERATEID
|
uniqueidentifier
|
true
|
|
The exchange rate used to convert from min amount to organization min amount.
|
|
BASECURRENCYID
|
uniqueidentifier
|
true
|
|
The base currency associated with this naming opportunity.
|
Fields
| Field |
Field Type |
Null |
Notes |
Description |
|
NAME
|
nvarchar(100)
|
false
|
|
The name of this naming opportunity.
|
|
DESCRIPTION
|
nvarchar(250)
|
false
|
|
A short description of this naming opportunity.
|
|
QUANTITY
|
int
|
false
|
|
The total number of recognition opportunities that this naming opportunity supports.
|
|
MINIMUMAMOUNT
|
money
|
false
|
|
The minimum amount that must be donated in order to be recognized for this naming opportunity.
|
|
COMMENTS
|
nvarchar(max)
|
false
|
|
Free-form comments about this naming opportunity.
|
|
DATEADDED
|
datetime
|
false
|
|
Indicates the date this record was added.
|
|
DATECHANGED
|
datetime
|
false
|
|
Indicates the date this record was last changed.
|
|
TS
|
timestamp
|
false
|
|
Timestamp.
|
|
TSLONG
|
bigint (Computed)
|
true
|
|
Numeric representation of the timestamp.
|
|
ISACTIVE
|
bit
|
false
|
|
Indicates whether or not the record is active.
|
|
REMAINING
|
int (Computed)
|
true
|
|
The total number of remaining recognition opportunities for this naming opportunity.
|
|
SPECIALHANDLING
|
nvarchar(max)
|
false
|
|
Free-form special handling instructions for this naming opportunity.
|
|
ORGANIZATIONMINIMUMAMOUNT
|
money
|
false
|
|
Min amount in organization currency.
|
