Contains information pertaining to an event.
Fields
| Field |
Field Type |
Null |
Notes |
Description |
|
NAME
|
nvarchar(100)
|
false
|
|
The name of the event.
|
|
DESCRIPTION
|
nvarchar(255)
|
false
|
|
The description of the event.
|
|
STARTDATE
|
date
|
false
|
|
Starting date of the event.
|
|
STARTTIME
|
UDT_HOURMINUTE
|
false
|
|
Starting time of the event.
|
|
ENDDATE
|
date
|
false
|
|
Ending date of the event.
|
|
ENDTIME
|
UDT_HOURMINUTE
|
false
|
|
Ending time of the event.
|
|
CAPACITY
|
int
|
false
|
|
The maximum number of registrants allowed for the event.
|
|
ISACTIVE
|
bit
|
false
|
|
|
|
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.
|
|
SCHEDULEID
|
uniqueidentifier
|
true
|
|
Uniquely identifies the scheduling run
|
|
PUBLICDESCRIPTIONTEXT
|
nvarchar(max)
|
false
|
|
The plain text public description.
|
|
PUBLICDESCRIPTIONHTML
|
nvarchar(max)
|
false
|
|
The HTML public description.
|
|
STARTDATETIMEWITHOFFSET
|
datetimeoffset
|
true
|
|
Event start date and time stored with UTC offset
|
|
ENDDATETIMEWITHOFFSET
|
datetimeoffset
|
true
|
|
Event end date and time stored with UTC offset
|
|
CUSTOMIDENTIFIER
|
nvarchar(100)
|
false
|
|
User-definable custom identifier.
|
|
SEQUENCEID
|
int
|
false
|
|
Identity column used to increment the default lookupid.
|
|
LOOKUPID
|
nvarchar(100) (Computed)
|
true
|
|
Unique identifer that supports user defined values as well as system generated values.
|
|
HIDEFROMCALENDAR
|
bit
|
false
|
|
Determines whether or not to hide this item from the event calendar.
|
|
DESIGNATIONSONFEES
|
bit
|
false
|
|
Determines whether or not event allows designations on fees.
|
|
SUPERCEDESPROGRAMPUBLICDESCRIPTION
|
bit
|
false
|
|
|
|
ISPROCESSED
|
bit
|
false
|
|
|
|
STARTDATETIME
|
datetime (Computed)
|
true
|
|
|
|
ENDDATETIME
|
datetime (Computed)
|
true
|
|
|
|
HASCUSTOMREGISTRATIONINFORMATION
|
bit
|
false
|
|
|
