Fields
| Field |
Field Type |
Null |
Notes |
Description |
|
INDIVIDUALSFUNDRAISE
|
bit
|
false
|
|
Individuals may fundraise
|
|
HOUSEHOLDSFUNDRAISE
|
bit
|
false
|
|
Households may fundraise
|
|
HOUSEHOLDAPPROVEBYEVENTADMIN
|
bit
|
false
|
|
Households must request to fundraise
|
|
HOUSEHOLDSJOINTEAMS
|
bit
|
false
|
|
Households can join teams
|
|
TEAMSFUNDRAISE
|
bit
|
false
|
|
Teams may fundraise
|
|
TEAMSREQUESTFUNDRAISE
|
bit
|
false
|
|
New Teams must be approved by Event Admin
|
|
TEAMNAMECHANGEAFTERREG
|
bit
|
false
|
|
Team Name can be changed After Registration
|
|
TEAMLEADERAPPOINTTEAMCOLEADERS
|
tinyint
|
false
|
|
Team Leader can Appoint a number of Team Co-Leaders
|
|
TEAMLEADERAPPROVETEAMMEMBERS
|
bit
|
false
|
|
Team Leader must approve team members
|
|
TEAMLEADEROPTIONAPPROVETEAMMEMBERS
|
bit
|
false
|
|
Team Leader has the option to approve team members
|
|
COMPANIESFUNDRAISE
|
bit
|
false
|
|
Companies may fundraise
|
|
COMPANYTEAMSAPPROVEBYEVENTADMIN
|
bit
|
false
|
|
Company teams approved by event admin
|
|
COMPANYLEADERAPPOINTCOMPANYCOLEADERS
|
tinyint
|
false
|
|
Company Leader can Appoint a number of Company Co-Leaders
|
|
COMPANYNAMECHANGEAFTERREG
|
bit
|
false
|
|
Company name can be changed after registration
|
|
COMPANYLEADERAPPROVETEAMS
|
bit
|
false
|
|
Company Leader must Approve Teams
|
|
COMPANYLEADEROPTIONAPPROVETEAMS
|
bit
|
false
|
|
Company Leader has the option to approve teams
|
|
TEAMMINIMUMGOALFLAG
|
bit
|
false
|
|
Team Mimimum Goal Flag
|
|
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.
|
|
HOUSEHOLDMEMBERSLIMIT
|
int
|
false
|
|
Household members limit
|
|
TEAMMEMBERSLIMIT
|
int
|
false
|
|
Team members limit
|
|
COMPANYTEAMSLIMIT
|
int
|
false
|
|
Company teams limit
|
|
COMPANYTEAMMEMBERSLIMIT
|
int
|
false
|
|
Company teams members limit
|
|
PARTICIPANTSCANREACTIVATETEAMS
|
bit
|
false
|
|
Participants can re-activate teams
|
|
FORMERTEAMCANREACTIVATETEAMSCODE
|
tinyint
|
false
|
|
Choice of team activation level
|
|
PARTICIPANTSCANREACTIVATECOMPANYTEAMS
|
bit
|
false
|
|
Participants can re-activate company teams
|
|
FORMERCOMPANYCANREACTIVATETEAMSCODE
|
tinyint
|
false
|
|
Choice of company team activation level
|
|
PARTICIPANTSCANREACTIVATEHOUSEHOLDS
|
bit
|
false
|
|
Participants can re-activate households
|
|
FORMERHOUSEHOLDCANREACTIVATEHOUSEHOLDCODE
|
tinyint
|
false
|
|
Choice of household activation level
|
|
FORMERTEAMCANREACTIVATETEAMS
|
nvarchar(58) (Computed)
|
true
|
|
Provides a translation for the 'FORMERTEAMCANREACTIVATETEAMSCODE' field.
|
|
FORMERCOMPANYCANREACTIVATETEAMS
|
nvarchar(77) (Computed)
|
true
|
|
Provides a translation for the 'FORMERCOMPANYCANREACTIVATETEAMSCODE' field.
|
|
FORMERHOUSEHOLDCANREACTIVATEHOUSEHOLD
|
nvarchar(73) (Computed)
|
true
|
|
Provides a translation for the 'FORMERHOUSEHOLDCANREACTIVATEHOUSEHOLDCODE' field.
|
|
HOUSEHOLDLEADERAPPOINTHOUSEHOLDCOLEADERS
|
tinyint
|
false
|
|
household leader can Appoint a number of household Co-Leaders
|
|
COPYSOURCEID
|
uniqueidentifier
|
true
|
|
Original copy from ID
|
|
COPYBATCHGUID
|
uniqueidentifier
|
true
|
|
Copy batch ID
|
