| MINIMUMAGE |
int |
|
Default = 0 |
Age Minimum |
| MAXIMUMAGE |
int |
|
Default = 120 |
Age Maximum |
| EARLYREGISTRATIONDATE |
datetime |
yes |
|
Register before this date to get earlybird 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 |
| MAXQUANTITY |
int |
|
Default = 9999 |
Registration Count Limit |
| 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. |
| DESCRIPTION |
nvarchar(1000) |
|
Default = '' |
Registration Type Description |
| ISNOTAVAILABLEONLINEREG |
bit |
|
Default = 0 |
Not Available for Online Registration |
| ISREGTYPEAVAILABLEINDIVIDUAL |
bit |
|
Default = 0 |
Registration Type available for individual |
| ISREGTYPEAVAILABLEFAMILYMEMBER |
bit |
|
Default = 0 |
Registration Type available for family member |
| ISREGTYPEAVAILABLEHEADHOUSEHOLD |
bit |
|
Default = 0 |
Registration Type available for head of household |
| ISREGTYPEAVAILABLETEAMMEMBER |
bit |
|
Default = 0 |
Registration Type available for team member |
| ISREGTYPEAVAILABLETEAMLEADER |
bit |
|
Default = 0 |
Registration Type available for team leader |
| ISREGTYPEAVAILABLECOMPANYLEADER |
bit |
|
Default = 0 |
Registration Type available for company leader |
| 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 |
| ISACTIVE |
bit |
|
Default = 1 |
Registration is Active |
| ALLOWPARTICIPANTSWAIVEBENEFITS |
bit |
|
Default = 1 |
Allow participant to waive benefits |
| USEDQUANTITY |
int |
|
Default = 0 |
Used Quantity |
| COPYSOURCEID |
uniqueidentifier |
yes |
|
Original copy from EVENTPRICEID |
| COPYBATCHGUID |
uniqueidentifier |
yes |
|
Copy batch ID |