Travel information for an event registrant.
Foreign Key Fields
| Foreign Key |
Field Type |
Null |
Notes |
Description |
|
REGISTRANTCONSTITUENTID
|
uniqueidentifier
|
false
|
|
FK to CONSTITUENT
|
|
MAINEVENTID
|
uniqueidentifier
|
false
|
|
FK to EVENT
|
|
REGISTRANTDEPARTURETRAVELTYPECODEID
|
uniqueidentifier
|
true
|
|
FK to EVENTREGISTRANTTRAVELTYPECODE
|
|
REGISTRANTDEPARTURETRAVELNAMECODEID
|
uniqueidentifier
|
true
|
|
FK to EVENTREGISTRANTTRAVELNAMECODE
|
|
REGISTRANTARRIVALTRAVELTYPECODEID
|
uniqueidentifier
|
true
|
|
FK to EVENTREGISTRANTTRAVELTYPECODE
|
|
REGISTRANTARRIVALTRAVELNAMECODEID
|
uniqueidentifier
|
true
|
|
FK to EVENTREGISTRANTTRAVELNAMECODE
|
|
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.
|
|
ARRIVALNUMBER
|
nvarchar(25)
|
false
|
|
The number of the scheduled arrival travel mode (ie flight number)
|
|
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.
|
