Penn Computing

University of Pennsylvania
Penn Computing << go backback
ITEM Table    Tables and Data Elements   World Travel Home   Data Warehouse Home

ITEM Table - Data Element Index

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




Data element Definition

ITEM_NAME

Format VARCHAR2(3)

Indexed? Yes

May be Null? No

The custom item number associated with this item record. 

ITEM_VALUE

Format VARCHAR2(200)

Indexed? No

May be Null? Yes

The custom item value associated with this item record. 

PNR_ID

Format VARCHAR2(16)

Indexed? Yes

May be Null? No

The Passenger Name Record (PNR) associated with this item record. 

PNR_LAST_UPDATED_DATE

Format DATE

Indexed? Yes

May be Null? No

The the date that the Passenger Name Record (PNR) associated with this item record was last updated. 

 
ITEM Table    Tables and Data Elements   World Travel 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