| ALLOWPARTICIPANTCHOOSEBENEFITCODE |
tinyint |
|
Default = 0 |
Type of Benefit (1 or all) |
| ALLOWPARTICIPANTONLYRECEIVEBENEFITLEVELCODE |
tinyint |
|
Default = 1 |
Type of Benefit (each or highest level) |
| ALLOWPARTICIPANTONLYRECEIVEBENEFITLEVEL |
nvarchar(65) (Computed) |
yes |
CASE [ALLOWPARTICIPANTONLYRECEIVEBENEFITLEVELCODE] WHEN 0 THEN N'Allow participant to only receive benefits from each level' WHEN 1 THEN N'Allow participant to only receive benefits from the highest level' END |
Provides a translation for the 'ALLOWPARTICIPANTONLYRECEIVEBENEFITLEVELCODE' field. |
| 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. |
| ALLOWPARTICIPANTSWAIVEBENEFITS |
bit |
|
Default = 1 |
Allow participant to waive benefits |
| FUNDRAISINGCOACHESACTIVATEINDIVIDUAL |
bit |
|
Default = 0 |
Activate fundraising coaches for individual participants |
| FUNDRAISINGCOACHESACTIVATEHOUSEHOLDS |
bit |
|
Default = 0 |
Activate fundraising coaches for households |
| FUNDRAISINGCOACHESACTIVATETEAMS |
bit |
|
Default = 0 |
Activate fundraising coaches for teams |
| FUNDRAISINGCOACHESACTIVATECOMPANIES |
bit |
|
Default = 0 |
Activate fundraising coaches for companies |
| FCGROUPASSIGNMENTSLIMIT |
smallint |
|
Default = ((50)) |
Fundraising coach can have a number of group assignments |
| FCGROUPSASSIGNMENTCODE |
tinyint |
|
Default = 0 |
Assign groups to fundraising coaches (Automatic or Manual) |
| FCGROUPSASSIGNMENT |
nvarchar(50) (Computed) |
yes |
CASE [FCGROUPSASSIGNMENTCODE] WHEN 0 THEN N'Automatically assign groups to fundraising coaches' WHEN 1 THEN N'Manually assign groups to fundraising coaches' WHEN 2 THEN N'None' END |
Provides a translation for the 'FCGROUPSASSIGNMENTCODE' field. |
| ACFMPENDINGDONATIONS |
bit |
|
Default = 0 |
Activate/In-Activate for Pending Donation checkbox |
| ACFMPENDINGMATCHINGGIFTS |
bit |
|
Default = 0 |
Activate/In-Activate for Pending Matching Gifts checkbox |
| ACFMOUTSTANDINGRECURRINGDONATIONS |
bit |
|
Default = 0 |
Activate/In-Activate for Outstanding Recurring Donations checkbox |
| REGISTRATIONFORMENDDATE |
datetime |
yes |
|
Date that registration form will turn off |
| DONATIONFORMENDDATE |
datetime |
yes |
|
Date that donation form will be turn off |
| SPONSORSHIPFORMENDDATE |
datetime |
yes |
|
Date that sponsorship form will be turn off |
| REGISTRATIONREDIRECTLINK |
UDT_WEBADDRESS |
|
Default = '' |
Link to redirect to when registration form turns off |
| DONATIONREDIRECTLINK |
UDT_WEBADDRESS |
|
Default = '' |
Link to redirect to when donation form turns off |
| SPONSORSHIPREDIRECTLINK |
UDT_WEBADDRESS |
|
Default = '' |
Link to redirect to when donation form turns off |
| ALLOWPARTICIPANTCHOOSEBENEFIT |
nvarchar(41) (Computed) |
yes |
CASE [ALLOWPARTICIPANTCHOOSEBENEFITCODE] WHEN 0 THEN N'Allow participant to choose one benefit' WHEN 1 THEN N' Allow participant to choose all benefits' END |
Provides a translation for the 'ALLOWPARTICIPANTCHOOSEBENEFITCODE' field. |
| COPYSOURCEID |
uniqueidentifier |
yes |
|
Original copy from ID |
| COPYBATCHGUID |
uniqueidentifier |
yes |
|
Copy batch ID |