| Data element |
Definition |
AFFILIATION
Format VARCHAR2(30)
Indexed? Yes
May be Null? Yes |
The self-reported affiliation of passenger number 1 for this itinerary at the time the itinerary is booked.
Values:
STUDENT
UPHS/AGENCY
FACULTY/STAFF
POS/OTHER |
APPROVER_EMAIL
Format VARCHAR2(60)
Indexed? No
May be Null? Yes |
The email address of the itinerary approver. |
AUTHORIZING_MANAGER
Format VARCHAR2(5)
Indexed? No
May be Null? Yes |
|
BOOKED_COUNTRY
Format VARCHAR2(1000)
Indexed? No
May be Null? Yes |
|
BOOKED_COUNTRY_CODE
Format VARCHAR2(5)
Indexed? No
May be Null? Yes |
|
BOOKER_EMAIL
Format VARCHAR2(60)
Indexed? No
May be Null? Yes |
The email address of the perosn who booked the itinerary. |
BOOKING_AGENT
Format VARCHAR2(2)
Indexed? No
May be Null? Yes |
|
BRANCH
Format VARCHAR2(5)
Indexed? No
May be Null? Yes |
|
CANCEL_DATE
Format DATE
Indexed? No
May be Null? Yes |
Date the PNR itinerary was canceled. |
CANCEL_NOTES
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
Note associated with the PNR itinerary cancellation. |
CLASS_OF_SERVICE
Format VARCHAR2(8)
Indexed? No
May be Null? Yes |
The travel class of service associated with this itinerary.
Values:
COACH
BUSINESS
FIRST
PREMIUM ECONOMY |
COA_ACCOUNT_NUMBER
Format VARCHAR2(26)
Indexed? Yes
May be Null? Yes |
The seven segment values that comprise the 26-position Accounting Flexfield.
The segments are COA_CNAC, COA_ORG, COA_BC, COA_FUND, COA_OBJECT, COA_PROGRAM, and COA_CREF. Example: 40042274525799519120021438. See also COA_CNAC, COA_ORG, COA_BC, COA_FUND, COA_OBJECT, COA_PROGRAM, and COA_CREF.
Values: List of values not available.
|
COA_BC
Format VARCHAR2(1)
Indexed? Yes
May be Null? Yes |
The 3-character center Net Asset Class (NAC) code.
The first two positions of the COA_CNAC identify the school or center. The last position identifies the Net Asset Class: 0 (Unrestricted); 1 (Temporarily Restricted); 2 (Permanently Restricted). COA_CNAC is the first segment of the Accounting Flexfield. Example: 880 (Medical center, Unrestricted)
Values: Refer to the CNAC_Codes table for values.
|
COA_CNAC
Format VARCHAR2(3)
Indexed? Yes
May be Null? Yes |
The 4-character ORGANIZATION code.
This is a subdivision of the University created for management purposes. An ORGANIZATION belongs to only one responsibility center, and its ORGANIZATION code is unique. That is, no two ORGANIZATIONs will have the same values for COA_ORG. COA_ORG is the second segment of the Accounting Flexfield. Examples: 0702 (Wharton Finance); 0705 (Wharton Legal Studies)
Values: Refer to the ORG_CODES table for values.
|
COA_CREF
Format VARCHAR2(4)
Indexed? Yes
May be Null? Yes |
The budgetary control character that represents the level at which funds availability checking occurs.
COA_BC is the third segment of the Accounting Flexfield. Examples: 1 (CNAC/ORG/FUND Year-To-Date); T (All Funds Checks).
Values: 0 Project-to-Date for capital projects 1 CNAC/ORG/FUND Year-To-Date 2 CNAC/ORG/FUND/CREF Year-To-Date 4 CNAC/ORG/FUND/CREF Project-to-Date A Funds Check parent of 1 B Funds Check parent of 2 D Funds Check parent of 4 T All Funds Checks
|
COA_FUND
Format VARCHAR2(6)
Indexed? Yes
May be Null? Yes |
The 6-character fund number.
A fund is the unique identifier for a specific set of financial resources that needs tracking or management. COA_FUND is the fourth segment of the Accounting Flexfield. Examples: 000000 (General Unrestricted Fund); 010201 (SAS: GEN FUND 1)
Values: Refer to the FUND_CODES table for values.
|
COA_OBJECT
Format VARCHAR2(4)
Indexed? Yes
May be Null? Yes |
The 4-character OBJECT code.
Identifies the asset, liability, revenue, or expense. COA_OBJECT is the fifth segment of the Accounting Flexfield. Examples: 5220 (EXTERNAL OFFICE SUPPLIES); 1149 (CASH SUSPENSE)
Values: Refer to the OBJECT_CODES table for values.
|
COA_ORG
Format VARCHAR2(4)
Indexed? Yes
May be Null? Yes |
The 4-character PROGRAM code.
This is an activity or work process commonly defined across the University for tracking a PROGRAM's activity across schools and centers (or across organizations within a school or center). COA_PROGRAM is the sixth segment of the Accounting Flexfield. Examples: 7311 (Alumni Relations); 0001 (Discretionary)
Values: Refer to the PROGRAM_CODES table for values.
|
COA_PROGRAM
Format VARCHAR2(4)
Indexed? Yes
May be Null? Yes |
The 4-character Center Reference code.
This is an identifier uniquely defined by each school or center. COA_CREF is used to record information that is important to a school or center but is inappropriate for any other segment of the Accounting Flexfield. The value of the center Reference code is unique within a school or center. COA_CREF is the seventh and last segment of the Accounting Flexfield. See the definition for CENTER_REF_CODES / CENTER_REF_CODE. Examples: 4045 (Graduate Programs); 4091 (SAS Newsletter)
Values: Refer to the center_REF_CODES table for values.
|
COST_CENTER
Format VARCHAR2(5)
Indexed? No
May be Null? Yes |
|
CREATION_DATE_TIME
Format DATE
Indexed? No
May be Null? Yes |
The date and time the itinerary was created. |
CREATION_PCC
Format VARCHAR2(4)
Indexed? No
May be Null? Yes |
|
CUSTOMER_NUMBER
Format VARCHAR2(9)
Indexed? No
May be Null? Yes |
|
DEPARTMENT_NUMBER
Format VARCHAR2(5)
Indexed? No
May be Null? Yes |
|
EMPLOYEE_ID
Format WARCHAR2(8)
Indexed? No
May be Null? Yes |
|
EXCEPTION
Format VARCHAR2(5)
Indexed? No
May be Null? Yes |
|
FARE_ACCEPTED
Format NUMBER
Indexed? No
May be Null? Yes |
|
FARE_COUNT
Format VARCHAR2(3)
Indexed? No
May be Null? Yes |
|
FARE_CURRENT
Format NUMBER
Indexed? No
May be Null? Yes |
|
FARE_FOUND_COUNT
Format VARCHAR2(3)
Indexed? No
May be Null? Yes |
|
FARE_ORIGINAL
Format NUMBER
Indexed? No
May be Null? Yes |
|
FARE_STOPPED
Format VARCHAR2(1)
Indexed? No
May be Null? Yes |
|
GDS
Format VARCHAR2(5)
Indexed? No
May be Null? Yes |
|
GLOBAL_CUSTOMER_NUMBER
Format VARCHAR2(5)
Indexed? No
May be Null? Yes |
|
GROUP_ID
Format VARCHAR2(30)
Indexed? No
May be Null? Yes |
|
INTERNATIONAL_FLAG
Format VARCHAR(1)
Indexed? Yes
May be Null? Yes |
Indicates if any travel segment associated with this itinerary is tagged with a non-U.S. country code. The air, car, hotel, rail tour and cruise segments are considered when determining the value of this flag.
Values: Y, N |
IS_BUSINESS_TRAVEL
Format VARCHAR2(5)
Indexed? No
May be Null? Yes |
|
JOB_GRADE
Format VARCHAR2(5)
Indexed? No
May be Null? Yes |
|
LAST_ITIN_CHANGE_DATE
Format DATE
Indexed? No
May be Null? Yes |
|
LAST_UPDATED_DATE_TIME
Format DATE
Indexed? Yes
May be Null? No |
The the date that the Passenger Name Record (PNR) was last updated. |
MULTIPLE_ACCTS_BILLED
Format VARCHAR2(3)
Indexed? No
May be Null? Yes |
|
ONLINE_BOOKING_INDICATOR
Format VARCHAR2(5)
Indexed? No
May be Null? Yes |
|
PNR_ID
Format VARCHAR2(16)
Indexed? Yes
May be Null? No |
The Passenger Name Record (PNR) ID.
This is World Travel's unique identifier for this itinerary. |
PNR_TYPE_CODE
Format VARCHAR2(30)
Indexed? No
May be Null? Yes |
|
PURPOSE_OF_TRIP
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
The self-reported purpose of this trip. |
RECORD_LOCATOR
Format VARCHAR2(6)
Indexed? No
May be Null? Yes |
|
RESPONSIBILITY_PCC
Format VARCHAR2(4)
Indexed? No
May be Null? Yes |
|
ROUTING
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
|
SEAT_BOOKED_COUNT
Format VARCHAR2(3)
Indexed? No
May be Null? Yes |
|
SEAT_COUNT
Format VARCHAR2(3)
Indexed? No
May be Null? Yes |
|
SEAT_STOPPED
Format VARCHAR2(1)
Indexed? No
May be Null? Yes |
|
TRAVEL_DATE
Format DATE
Indexed? Yes
May be Null? Yes |
The earliest travel date associated with this itinerary.
The air, car, hotel, rail tour and cruise segments are considered when determining this value.
|
TRAVEL_END_DATE
Format DATE
Indexed? Yes
May be Null? Yes |
The latest travel date associated with this itinerary.
The air, car, hotel, rail tour and cruise segments are considered when determining this value.
|
TRAVEL_TYPE
Format VARCHAR2(30)
Indexed? Yes
May be Null? Yes |
|
WHARTON_CHINA_CENTER
Format VARCHAR2(23)
Indexed? No
May be Null? Yes |
The self-reported flag to indicate if this itinerary is related to the Wharton China Center. |
