This table includes details about constituents who perform a sponsorship for a specific event.
Fields
| Field |
Field Type |
Null |
Notes |
Description |
|
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.
|
|
EVENTSPONSORSHIPLOGOID
|
int
|
false
|
|
Event Sponsor Logo image id
|
|
EVENTSPONSORSHIPURL
|
UDT_WEBADDRESS
|
false
|
|
Event sponsor URL
|
|
SPONSORSHIPMESSAGE
|
nvarchar(2000)
|
false
|
|
FAF Event sponsor message
|
|
FEESAMOUNT
|
money
|
false
|
|
The final amount sponsor paid.
|
|
ORGANIZATIONCONSTITUENTID
|
uniqueidentifier
|
true
|
|
The constituent ID of the organization record.
|
|
BENEFITSWAIVED
|
bit
|
false
|
|
Indicates if this registrant has waived benefits.
|
|
ISCANCELLED
|
bit
|
false
|
|
Designates whether or not the registrant has cancelled.
|
|
CUSTOMIDENTIFIER
|
nvarchar(100)
|
false
|
|
User-definable custom identifier.
|
|
SEQUENCEID
|
int
|
false
|
|
Identity column used to increment the default lookupid.
|
|
LOOKUPID
|
nvarchar(100) (Computed)
|
true
|
|
Unique identifer that supports user defined values as well as system generated values.
|
|
FEESWAIVED
|
bit
|
false
|
|
Indicates if this registration fee is waived.
|
|
ALLOWADMINACCESSHQ
|
bit
|
false
|
|
|
