| Data element |
Definition |
AFFILIATION
Format VARCHAR2(30)
Indexed? Yes
May be Null? Yes |
The self-reported affiliation of the traveller at the time the itinerary is booked.
Values:
STUDENT
UPHS/AGENCY
FACULTY/STAFF
POS/OTHER |
EMPLOYEE_ID
Format VARCHAR2(27)
Indexed? No
May be Null? Yes |
The traveler Penn ID. |
FIRST_NAME
Format VARCHAR2(30)
Indexed? No
May be Null? Yes |
The traveler first name. |
HOME_DEPT_ORG
Format VARCHAR2(4)
Indexed? Yes
May be Null? Yes |
For faculty and staff, the traveler home org as of the date the Passenger Name Record (PNR) is loaded to the data warehouse. |
HOME_SCHOOL_CTR
Format VARCHAR2(2)
Indexed? Yes
May be Null? Yes |
For faculty and staff, the traveler home school/center as of the date the Passenger Name Record (PNR) is loaded to the data warehouse. |
LAST_NAME
Format VARCHAR2(30)
Indexed? No
May be Null? Yes |
The traveler last name. |
PASSENGER_ID
Format VARCHAR2(30)
Indexed? No
May be Null? Yes |
|
PASSENGER_NUMBER
Format VARCHAR2(2)
Indexed? Yes
May be Null? No |
The numeric identifier used to uniquely identify the passenger associated with the PNR record. |
PASSPORT_COUNTRY
Format VARCHAR2(9)
Indexed? No
May be Null? Yes |
|
PASSPORT_DOC_NUM
Format VARCHAR2(10)
Indexed? No
May be Null? Yes |
|
PASSPORT_EXP
Format VARCHAR2(10)
Indexed? No
May be Null? Yes |
|
PENN_ID
Format VARCHAR2(8)
Indexed? Yes
May be Null? Yes |
The traveler Penn ID. |
PNR_ID
Format VARCHAR2(16)
Indexed? Yes
May be Null? No |
The Passenger Name Record (PNR) associated with this passenger 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 passenger record was last updated. |
PRIMARY_APPT_JOB_CLASS
Format VARCHAR2(6)
Indexed? Yes
May be Null? Yes |
For faculty and staff, the traveler primary appointment job class as of the date the Passenger Name Record (PNR) is loaded to the data warehouse. |
PRIMARY_DEPT_ORG
Format
Indexed? No
May be Null? Yes |
For faculty and staff, the traveler primary appointment org as of the date the Passenger Name Record (PNR) is loaded to the data warehouse. |
PRIMARY_SCHOOL_CTR
Format
Indexed? No
May be Null? Yes |
For faculty and staff, the traveler primary appointment school/center as of the date the Passenger Name Record (PNR) is loaded to the data warehouse. |
TSA_FIRST
Format VARCHAR2(30)
Indexed? No
May be Null? Yes |
Transportation Security Administration First Name. |
TSA_LAST
Format VARCHAR2(30)
Indexed? No
May be Null? Yes |
Transportation Security Administration Last Name. |
TSA_MIDDLE
Format VARCHAR2(30)
Indexed? No
May be Null? Yes |
Transportation Security Administration Middle initial. |
