| INDIVIDUALSFUNDRAISE |
bit |
|
Default = 1 |
Individuals may fundraise |
| HOUSEHOLDSFUNDRAISE |
bit |
|
Default = 1 |
Households may fundraise |
| HOUSEHOLDAPPROVEBYEVENTADMIN |
bit |
|
Default = 0 |
Households must request to fundraise |
| HOUSEHOLDSJOINTEAMS |
bit |
|
Default = 0 |
Households can join teams |
| TEAMSFUNDRAISE |
bit |
|
Default = 1 |
Teams may fundraise |
| TEAMSREQUESTFUNDRAISE |
bit |
|
Default = 0 |
New Teams must be approved by Event Admin |
| TEAMNAMECHANGEAFTERREG |
bit |
|
Default = 0 |
Team Name can be changed After Registration |
| TEAMLEADERAPPOINTTEAMCOLEADERS |
tinyint |
|
Default = 1 |
Team Leader can Appoint a number of Team Co-Leaders |
| TEAMLEADERAPPROVETEAMMEMBERS |
bit |
|
Default = 0 |
Team Leader must approve team members |
| TEAMLEADEROPTIONAPPROVETEAMMEMBERS |
bit |
|
Default = 1 |
Team Leader has the option to approve team members |
| COMPANIESFUNDRAISE |
bit |
|
Default = 1 |
Companies may fundraise |
| COMPANYTEAMSAPPROVEBYEVENTADMIN |
bit |
|
Default = 0 |
Company teams approved by event admin |
| COMPANYLEADERAPPOINTCOMPANYCOLEADERS |
tinyint |
|
Default = 1 |
Company Leader can Appoint a number of Company Co-Leaders |
| COMPANYNAMECHANGEAFTERREG |
bit |
|
Default = 0 |
Company name can be changed after registration |
| COMPANYLEADERAPPROVETEAMS |
bit |
|
Default = 0 |
Company Leader must Approve Teams |
| COMPANYLEADEROPTIONAPPROVETEAMS |
bit |
|
Default = 1 |
Company Leader has the option to approve teams |
| TEAMMINIMUMGOALFLAG |
bit |
|
Default = 0 |
Team Minimum Goal Flag |
| 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) |
yes |
CONVERT(bigint, TS) |
Numeric representation of the timestamp. |
| HOUSEHOLDMEMBERSLIMIT |
int |
|
Default = 5 |
Household members limit |
| TEAMMEMBERSLIMIT |
int |
|
Default = 50 |
Team members limit |
| COMPANYTEAMSLIMIT |
int |
|
Default = 100 |
Company teams limit |
| COMPANYTEAMMEMBERSLIMIT |
int |
|
Default = 50 |
Company teams members limit |
| PARTICIPANTSCANREACTIVATETEAMS |
bit |
|
Default = 1 |
Participants can re-activate teams |
| FORMERTEAMCANREACTIVATETEAMSCODE |
tinyint |
|
Default = 0 |
Choice of team activation level |
| PARTICIPANTSCANREACTIVATECOMPANYTEAMS |
bit |
|
Default = 1 |
Participants can re-activate company teams |
| FORMERCOMPANYCANREACTIVATETEAMSCODE |
tinyint |
|
Default = 0 |
Choice of company team activation level |
| PARTICIPANTSCANREACTIVATEHOUSEHOLDS |
bit |
|
Default = 1 |
Participants can re-activate households |
| FORMERHOUSEHOLDCANREACTIVATEHOUSEHOLDCODE |
tinyint |
|
Default = 0 |
Choice of household activation level |
| FORMERTEAMCANREACTIVATETEAMS |
nvarchar(58) (Computed) |
yes |
CASE [FORMERTEAMCANREACTIVATETEAMSCODE] WHEN 0 THEN N'Only former team leaders can re-activate teams' WHEN 1 THEN N'Former team leaders and team members can re-activate teams' WHEN 2 THEN N'Anyone can re-activate teams' WHEN 3 THEN N'None' END |
Provides a translation for the 'FORMERTEAMCANREACTIVATETEAMSCODE' field. |
| FORMERCOMPANYCANREACTIVATETEAMS |
nvarchar(77) (Computed) |
yes |
CASE [FORMERCOMPANYCANREACTIVATETEAMSCODE] WHEN 0 THEN N'Only former company leaders can re-activate teams' WHEN 1 THEN N'Former company leaders and company team members can re-activate company teams' WHEN 2 THEN N'Any former company team member can re-activate a company team' WHEN 3 THEN N'None' END |
Provides a translation for the 'FORMERCOMPANYCANREACTIVATETEAMSCODE' field. |
| FORMERHOUSEHOLDCANREACTIVATEHOUSEHOLD |
nvarchar(73) (Computed) |
yes |
CASE [FORMERHOUSEHOLDCANREACTIVATEHOUSEHOLDCODE] WHEN 0 THEN N'Only former household leaders can re-activate households' WHEN 1 THEN N'Former household leaders and household members can re-activate households' WHEN 2 THEN N'None' END |
Provides a translation for the 'FORMERHOUSEHOLDCANREACTIVATEHOUSEHOLDCODE' field. |
| HOUSEHOLDLEADERAPPOINTHOUSEHOLDCOLEADERS |
tinyint |
|
Default = 1 |
household leader can Appoint a number of household Co-Leaders |
| COPYSOURCEID |
uniqueidentifier |
yes |
|
Original copy from ID |
| COPYBATCHGUID |
uniqueidentifier |
yes |
|
Copy batch ID |