Fields
| Field |
Field Type |
Null |
Notes |
Description |
|
NAME
|
nvarchar(100)
|
false
|
|
|
|
DESCRIPTION
|
nvarchar(255)
|
false
|
|
|
|
CAPACITY
|
int
|
false
|
|
The default capacity for this program
|
|
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.
|
|
ISACTIVE
|
bit
|
false
|
|
Indicates whether this program is active
|
|
ISDAILYADMISSION
|
bit
|
false
|
|
Indicates whether this is a daily admission program
|
|
ISPREREGISTERED
|
bit
|
false
|
|
Indicates whether this program creates pre-registered events.
|
|
PUBLICDESCRIPTIONTEXT
|
nvarchar(max)
|
false
|
|
The plain text public description.
|
|
PUBLICDESCRIPTIONHTML
|
nvarchar(max)
|
false
|
|
The HTML public description.
|
|
DEFAULTPRICINGSTRUCTURECODE
|
tinyint
|
false
|
|
Quick itinerary default pricing structure code.
|
|
DEFAULTPRICINGSTRUCTURE
|
nvarchar(10) (Computed)
|
true
|
|
Provides a translation for the 'DEFAULTPRICINGSTRUCTURECODE' field.
|
