Open topic with navigation

ITINERARYITEM (4.0SP20)

no changes

Top
Primary Key
Foreign Key Fields
Fields
Indexes
Triggers
Referenced by

This table contains information for an itinerary item.

Primary Key
Primary Key	Field Type
ID	uniqueidentifier

Foreign Key Fields
Foreign Key	Field Type	Null	Notes	Description
PROGRAMID	uniqueidentifier	true	PROGRAM.ID	The program that is linked to a scheduled or unscheduled Daily admission program itinerary item.
EVENTID	uniqueidentifier	true	EVENT.ID	The event that is linked to a scheduled or unscheduled Daily admission program itinerary item.
ITINERARYID	uniqueidentifier	false	ITINERARY.ID	The itinerary in which this itinerary item is linked.
ADDEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
EVENTLOCATIONID	uniqueidentifier	true	EVENTLOCATION.ID	The location for a custom item.

Fields
Field	Field Type	Null	Notes	Description
STARTTIME	UDT_HOURMINUTE	false	''	The start time for this itinerary item.
ENDTIME	UDT_HOURMINUTE	false	''	The end time for this itinerary item.
NAME	nvarchar(100)	false	''	The name for this itinerary item.
NOTES	nvarchar(500)	false	''	The notes for this itinerary item.
BLOCKEVENT	bit	false	0	Indicates whether to block event from other groups.
DATEADDED	datetime	false	getdate()	Indicates the date this record was added.
DATECHANGED	datetime	false	getdate()	Indicates the date this record was last changed.
TS	timestamp	false		Timestamp.
TSLONG	bigint (Computed)	true		Numeric representation of the timestamp.
STARTDATE	date	false		The start date for an itinerary item.
ENDDATE	date	false		The end date for an itinerary item.
ITEMTYPECODE	tinyint	false	0	The type of itinerary item
ITEMTYPE	nvarchar(23) (Computed)	true		Provides a translation for the 'ITEMTYPECODE' field.
INVALIDREASONCODE	tinyint	false	0	For unscheduled items, the reason the item is invalid
INVALIDREASON	nvarchar(72) (Computed)	true		Provides a translation for the 'INVALIDREASONCODE' field.
STARTDATETIME	datetime (Computed)	true		The start date and time of the conflicting event.
ENDDATETIME	datetime (Computed)	true		The end date and time of the conflicting event.

Indexes
Index Name	Field(s)	Unique	Primary	Clustered
IX_ITINERARYITEM_DATEADDED	DATEADDED	False	False	True
IX_ITINERARYITEM_DATECHANGED	DATECHANGED	False	False	False
IX_ITINERARYITEM_EVENTID	EVENTID	False	False	False
IX_ITINERARYITEM_EVENTLOCATIONID	EVENTLOCATIONID	False	False	False
IX_ITINERARYITEM_ITINERARYID	ITINERARYID	False	False	False
IX_ITINERARYITEM_PROGRAMID	PROGRAMID	False	False	False
PK_ITINERARYITEM	ID	True	True	False

Triggers
Trigger Name	Description
TR_ITINERARYITEM_INSERTUPDATE_ITINERARYSTAFFRESOURCEUPDATE
TR_ITINERARYITEM_DELETE_ITINERARYSTAFFRESOURCEUPDATE
TR_ITINERARYITEM_AUDIT_UPDATE
TR_ITINERARYITEM_AUDIT_DELETE
TR_ITINERARYITEM_UPDATE_ITINERARYITEMSTAFFRESOURCEUPDATE
TR_ITINERARYITEM_INSERT_RESOURCE_UPDATE
TR_ITINERARYITEM_DELETE_RESOURCE_UPDATE

Referenced by
Referenced by	Field
ITINERARYITEMLOCATION	ID
ITINERARYITEMRESOURCE	ITINERARYITEMID
ITINERARYITEMSTAFFRESOURCE	ITINERARYITEMID