| ISACTIVE |
bit |
|
Default = 1 |
Sponsorship is Active |
| NAME |
nvarchar(50) |
|
Default = '' |
Registration Type Name |
| DESCRIPTION |
nvarchar(1000) |
|
Default = '' |
Registration Type Description |
| ISNOTAVAILABLEONLINEREG |
bit |
|
Default = 0 |
Not Available for Online Registration |
| FEESAMOUNT |
money |
|
Default = 0 |
Amount |
| TAXDEDUCTIBLEAMOUNT |
money |
|
Default = 0 |
Tax Deductible Amount |
| EARLYREGISTRATIONDATE |
datetime |
yes |
|
Register before this date to get early bird discount |
| EARLYREGISTRATIONDISCOUNT |
money |
|
Default = 0 |
Earlybird Discount Amount |
| LATEFEEDATE |
datetime |
yes |
|
If you Register after this date then you have to pay Late Fee |
| LATEFEE |
money |
|
Default = 0 |
Late Fee Amount |
| MINFUNDRAISINGGOAL |
money |
|
Default = 0 |
Fundraising Goal |
| ISNOTLOWERFUNDRAISINGGOAL |
bit |
|
Default = 0 |
Cannot be lower than Fundraising Goal |
| SPONSORMUSTPAYBALANCE |
bit |
|
Default = 0 |
Sponsor Must Pay Balance |
| SPONSORPAYSBALANCEMESSAGE |
nvarchar(1000) |
|
Default = '' |
Sponsor pays Balance Message |
| RECRUITEMENT |
int |
|
Default = 0 |
Recruitment Goal |
| ISNOTLOWERRECRUITEMENT |
bit |
|
Default = 0 |
Cannot be lower than Recruitment Goal |
| VOLUNTEERRECRUITEMENT |
int |
|
Default = 0 |
Volunteer Recruitment |
| ISNOTLOWERVOLUNTEERRECRUITEMENT |
bit |
|
Default = 0 |
Cannot be lower than Volunteer Recruitment Goal |
| DONORRETENTION |
decimal(7, 2) |
|
Default = 0 |
Donor Retention Goal |
| ISNOTLOWERDONORRETENTION |
bit |
|
Default = 0 |
Cannot be lower than Donor Retention Goal |
| UNIT |
int |
|
Default = 0 |
Unit Goal |
| ISNOTLOWERUNIT |
bit |
|
Default = 0 |
Cannot be lower than Unit Goal |
| COMMUNICATIONS |
int |
|
Default = 0 |
Communications Goal |
| ISNOTLOWERCOMMUNICATION |
bit |
|
Default = 0 |
Cannot be lower than Communications Goal |
| LABELFORUNITGOAL |
nvarchar(50) |
|
Default = '' |
Label for Unit Goal |
| NUMBERAVAILABLE |
int |
|
Default = 0 |
Number Available |
| TURNONWAITLIST |
bit |
|
Default = 0 |
Turn on wait list |
| DISPLAYSPOTSAVAILABLE |
bit |
|
Default = 0 |
Display remaining spots available |
| SENDEVENTCONTACTALERTMAXREACHED |
bit |
|
Default = 0 |
Send event contact alert when max is reached |
| WAITLISTMESSAGE |
nvarchar(1000) |
|
Default = '' |
Wait list message |
| 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. |
| ALLOWSPONSORWAIVEBENEFITS |
bit |
|
Default = 1 |
Allow sponsor to waive benefits |
| COPYSOURCEID |
uniqueidentifier |
yes |
|
Original copy from ID |
| COPYBATCHGUID |
uniqueidentifier |
yes |
|
Copy batch ID |