| Data element |
Definition |
CITY_CODE
Format VARCHAR2(3)
Indexed? No
May be Null? Yes |
The IATA code of the city asscoaietd with this phone number. |
CITY_NAME
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The city name associated with this phone number. |
COUNTRY
Format VARCHAR2(1000)
Indexed? No
May be Null? Yes |
The country name associated with this phone number. |
COUNTRY_CODE
Format VARCHAR2(2)
Indexed? No
May be Null? Yes |
The two character country code of the city associated with this phone number.
(NOTE: This is NOT the dialing country prefix number) |
PHONE_NUMBER
Format VARCHAR2(50)
Indexed? Yes
May be Null? No |
The phone number associated with this Passenger Name Record (PNR). |
PHONE_TYPE
Format VARCHAR2(8)
Indexed? No
May be Null? Yes |
The phone type asscoaited with this phone number.
Values: Unknown |
PNR_ID
Format VARCHAR2(16)
Indexed? Yes
May be Null? No |
The Passenger Name Record (PNR) associated with this phone number. |
PNR_LAST_UPDATED_DATE
Format DATE
Indexed? Yes
May be Null? No |
The the date that the Passenger Name Record (PNR) associated with this phone number record was last updated. |
