Fields
| Field |
Field Type |
Null |
Notes |
Description |
|
FUNDRAISINGGOAL
|
money
|
false
|
|
Total Fundraising Goal
|
|
ADVOCACYACTIONGOAL
|
int
|
false
|
|
Advocacy Action Goal
|
|
MEMBERECRUITMENTGOAL
|
int
|
false
|
|
Total Participant Recruitment Goal
|
|
COMMUNICATIONGOAL
|
int
|
false
|
|
Total Emails sent Goal
|
|
VOLUNTEERRECRUITMENTGOAL
|
int
|
false
|
|
Volunteer Recruitment Goal
|
|
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.
|
|
TARGETFUNDRAISINGGOAL
|
money
|
false
|
|
Target fundraising goal
|
|
DONORRETENTIONGOAL
|
decimal(9, 4)
|
false
|
|
Percentage of Donors to Retain
|
|
OTHERUNITGOAL
|
int
|
false
|
|
Other Unit Goal
|
|
STATUSCODE
|
tinyint
|
false
|
|
Registrant Status
|
|
STATUS
|
nvarchar(7) (Computed)
|
true
|
|
Provides a translation for the 'STATUSCODE' field.
|
|
ISPRIVATE
|
bit
|
false
|
|
Link to my personal page from other event pages? 0:yes(public as default) 1:no(private)
|
|
ALLOWADMINACCESSHQ
|
bit
|
false
|
|
Allow event admin to access participant's HQ page?
|
|
ORGANIZATIONCONSTITUENTID
|
uniqueidentifier
|
true
|
|
The constituent ID of the organization record.
|
|
ISDASHBOARDHELPERVISIBLE
|
bit
|
false
|
|
Show the dashboard helper popup? 0:Hide 1:Show
|
|
LOCALCORPPOSTCODE
|
nvarchar(12)
|
false
|
|
Contains the address post code of the local corp.
|
|
ALLOWOTHERPARTICIPANTSCONTACTME
|
bit
|
false
|
|
Allow other participants in my group to contact me directly using the Communications Center?
|
