EVENTREGISTRANTITINERARY

Stores information about a registrants travel and lodging.

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
DEPARTURETIME	UDT_HOURMINUTE		Default = ''	The registrants travel departure time.
DEPARTUREDATE	datetime	yes		The registrants travel departure date.
DEPARTURENUMBER	nvarchar(25)		Default = ''	The number of the scheduled departure travel mode (ie flight number)
ARRIVALTIME	UDT_HOURMINUTE		Default = ''	The registrants travel arrival time.
ARRIVALDATE	datetime	yes		The registrants travel arrival date.
ARRIVALLNUMBER	nvarchar(25)		Default = ''	The number of the scheduled arrival travel mode (ie flight number)
CONTACTPHONENUMBER	nvarchar(100)		Default = ''	The phone number to contact the registrant.
ROOMNUMBER	nvarchar(10)		Default = ''	The room number the registrant is staying in.
CONFIRMATIONNUMBER	nvarchar(10)		Default = ''	The confirmation number for the lodging of the registrant.
CHECKINDATE	datetime	yes		The date the registrant will check in to the lodging.
CHECKINTIME	UDT_HOURMINUTE		Default = ''	The time the registrant will check in to the lodging.
CHECKOUTDATE	datetime	yes		The date the registrant will check out of the lodging.
CHECKOUTTIME	UDT_HOURMINUTE		Default = ''	The time the registrant will check out of the lodging.
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.
NUMBERNOFORMAT	nvarchar(100) (Computed)	yes	dbo.UFN_PHONE_REMOVEFORMATTING(CONTACTPHONENUMBER)	The non-formatted version of the contact phone number.

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
ID	uniqueidentifier		REGISTRANT.ID	Primary Key.
REGISTRANTDEPARTURETRAVELTYPECODEID	uniqueidentifier	yes	EVENTREGISTRANTTRAVELTYPECODE.ID	FK to EVENTREGISTRANTTRAVELTYPECODE
REGISTRANTDEPARTURETRAVELNAMECODEID	uniqueidentifier	yes	EVENTREGISTRANTTRAVELNAMECODE.ID	FK to EVENTREGISTRANTTRAVELNAMECODE
REGISTRANTARRIVALTRAVELTYPECODEID	uniqueidentifier	yes	EVENTREGISTRANTTRAVELTYPECODE.ID	FK to EVENTREGISTRANTTRAVELTYPECODE
REGISTRANTARRIVALTRAVELNAMECODEID	uniqueidentifier	yes	EVENTREGISTRANTTRAVELNAMECODE.ID	FK to EVENTREGISTRANTTRAVELNAMECODE
COUNTRYID	uniqueidentifier	yes	COUNTRY.LOCALID	The country for this phone number.
ROOMTYPEID	uniqueidentifier	yes	EVENTLODGINGROOM.ID	The type of room the registrant is staying in.
EVENTLODGINGID	uniqueidentifier	yes	EVENTLODGING.ID	The event and lodging record for this registrants lodging information.
ADDEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_EVENTREGISTRANTITINERARY_DATEADDED	DATEADDED			yes
IX_EVENTREGISTRANTITINERARY_DATECHANGED	DATECHANGED
IX_EVENTREGISTRANTITINERARY_EVENTLODGINGID	EVENTLODGINGID
PK_EVENTREGISTRANTITINERARY	ID	yes	yes

Triggers

Trigger Name	Description
TR_EVENTREGISTRANTITINERARY_AUDIT_UPDATE
TR_EVENTREGISTRANTITINERARY_AUDIT_DELETE