The TICKET_TAX Table - Data Element Index


			<< go back

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.

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