Penn Computing

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

TICKET_TAX Table - Data Element Index

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




Data element Definition

PNR_ID

Format VARCHAR2(16)

Indexed? Yes

May be Null? No

The Passenger Name Record (PNR) associated with this ticket tax 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 ticket tax record record was last updated. 

TAX_AMT

Format NUMBER

Indexed? No

May be Null? Yes

The tax amount for this ticket. 

TAX_CURR_CODE

Format VARCHAR2(3)

Indexed? No

May be Null? Yes

The tax currency code for this ticket. 

TAX_TYPE

Format VARCHAR2(2)

Indexed? No

May be Null? Yes

The two character status code for this ticket. Values: Unknown 

TICKET_NUMBER

Format VARCHAR2(13)

Indexed? Yes

May be Null? Yes

The ticket number associated with this tax record. 

 
TICKET_TAX 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