Stores information about a registrants travel and lodging.
Foreign Key Fields
| Foreign Key |
Field Type |
Null |
Notes |
Description |
|
REGISTRANTDEPARTURETRAVELTYPECODEID
|
uniqueidentifier
|
true
|
|
FK to EVENTREGISTRANTTRAVELTYPECODE
|
|
REGISTRANTDEPARTURETRAVELNAMECODEID
|
uniqueidentifier
|
true
|
|
FK to EVENTREGISTRANTTRAVELNAMECODE
|
|
REGISTRANTARRIVALTRAVELTYPECODEID
|
uniqueidentifier
|
true
|
|
FK to EVENTREGISTRANTTRAVELTYPECODE
|
|
REGISTRANTARRIVALTRAVELNAMECODEID
|
uniqueidentifier
|
true
|
|
FK to EVENTREGISTRANTTRAVELNAMECODE
|
|
COUNTRYID
|
uniqueidentifier
|
true
|
|
The country for this phone number.
|
|
ROOMTYPEID
|
uniqueidentifier
|
true
|
|
The type of room the registrant is staying in.
|
|
EVENTLODGINGID
|
uniqueidentifier
|
true
|
|
The event and lodging record for this registrants lodging information.
|
|
ADDEDBYID
|
uniqueidentifier
|
false
|
|
FK to CHANGEAGENT.
|
|
CHANGEDBYID
|
uniqueidentifier
|
false
|
|
FK to CHANGEAGENT.
|
Fields
| Field |
Field Type |
Null |
Notes |
Description |
|
DEPARTURETIME
|
UDT_HOURMINUTE
|
false
|
|
The registrants travel departure time.
|
|
DEPARTUREDATE
|
datetime
|
true
|
|
The registrants travel departure date.
|
|
DEPARTURENUMBER
|
nvarchar(25)
|
false
|
|
The number of the scheduled departure travel mode (ie flight number)
|
|
ARRIVALTIME
|
UDT_HOURMINUTE
|
false
|
|
The registrants travel arrival time.
|
|
ARRIVALDATE
|
datetime
|
true
|
|
The registrants travel arrival date.
|
|
ARRIVALLNUMBER
|
nvarchar(25)
|
false
|
|
The number of the scheduled arrival travel mode (ie flight number)
|
|
CONTACTPHONENUMBER
|
nvarchar(100)
|
false
|
|
The phone number to contact the registrant.
|
|
ROOMNUMBER
|
nvarchar(10)
|
false
|
|
The room number the registrant is staying in.
|
|
CONFIRMATIONNUMBER
|
nvarchar(10)
|
false
|
|
The confirmation number for the lodging of the registrant.
|
|
CHECKINDATE
|
datetime
|
true
|
|
The date the registrant will check in to the lodging.
|
|
CHECKINTIME
|
UDT_HOURMINUTE
|
false
|
|
The time the registrant will check in to the lodging.
|
|
CHECKOUTDATE
|
datetime
|
true
|
|
The date the registrant will check out of the lodging.
|
|
CHECKOUTTIME
|
UDT_HOURMINUTE
|
false
|
|
The time the registrant will check out of the lodging.
|
|
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.
|
|
NUMBERNOFORMAT
|
nvarchar(100) (Computed)
|
true
|
|
The non-formatted version of the contact phone number.
|
