Penn Computing

University of Pennsylvania
Penn Computing << go backback
CT_TA_ITINERARY_ROW Table   Tables and Data Elements   Travel & Expense Management Home    Data Warehouse Home

CT_TA_ITINERARY_ROW Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.



Data element Definition
ARRIVAL_DATE

Indexed - no
Format - date
May be null? yes
Date of arrival.
ARRIVAL_LN_KEY

Indexed - yes
Format - number
May be null? yes
Unique system-assigned key that identifies the arrival location.
DEPART_DATE

Indexed - no
Format - date
May be null? yes
Date of departure.
DEPART_LN_KEY_LN_KEY

Indexed - yes
Format - number
May be null? yes
Unique system-assigned key that identifies the departure location.
IR_KEY

Indexed - yes
Format - number
May be null? no
Unique system-assigned key that identifies the itinerary row associated with the travel allowance row.
ITIN_KEY

Indexed - yes
Format - number
May be null? no
Unique system-assigned key that identifies the itinerary associated with the travel allowance.
LAST_MODIFIED

Indexed - no
Format - date
May be null? yes
Date on which the travel allowance itinerary row record was last modified.

CT_TA_ITINERARY_ROW Table   Tables and Data Elements   Travel & Expense Management Home    Data Warehouse Home


Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania