TRAVELER Table
View exposing traveler reference records including traveler identifiers, expense group, names, Kerberos username, email, office contact information, department, and employment-related attributes used for travel and expense administration.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
DEPARTMENT_NAME |
Department name associated with the traveler. |
VARCHAR2 |
75 |
DEPARTMENT_NUMBER |
Department number associated with the traveler. |
VARCHAR2 |
6 |
EMAIL_ADDRESS |
Email address associated with the traveler. |
VARCHAR2 |
100 |
FIRST_NAME |
First name associated with the traveler. |
VARCHAR2 |
40 |
FULL_NAME |
Full name associated with the traveler. |
VARCHAR2 |
100 |
KERBEROS_NAME |
Kerberos username associated with the traveler. |
VARCHAR2 |
8 |
KERBEROS_NAME_UPPERCASE |
Uppercase Kerberos username used for case-insensitive matching and integration. |
VARCHAR2 |
8 |
LAST_NAME |
Last name associated with the traveler. |
VARCHAR2 |
40 |
MIDDLE_NAME |
Middle name associated with the traveler. |
VARCHAR2 |
40 |
PERSONNEL_AREA |
Personnel area associated with the traveler. |
VARCHAR2 |
40 |
PERSONNEL_AREA_CODE |
Code identifying the personnel area associated with the traveler. |
VARCHAR2 |
4 |
PERSONNEL_SUBAREA |
Personnel subarea associated with the traveler. |
VARCHAR2 |
40 |
PERSONNEL_SUBAREA_CODE |
Code identifying the personnel subarea associated with the traveler. |
VARCHAR2 |
4 |
PRIMARY_OFFICE_LOCATION |
Primary office location associated with the traveler. |
VARCHAR2 |
40 |
PRIMARY_OFFICE_PHONE |
Primary office phone number associated with the traveler. |
VARCHAR2 |
20 |
RECORD_COUNTER |
Record counter used to distinguish multiple traveler records or revisions. |
NUMBER |
|
SOURCE_OF_DATA |
Source system from which the traveler record was derived. |
VARCHAR2 |
9 |
TRAVELER_DESCRIPTION |
Description or label associated with the traveler record. |
VARCHAR2 |
50 |
TRAVELER_EXPENSE_GROUP |
Expense group assigned to the traveler for travel and expense processing. |
VARCHAR2 |
50 |
TRAVELER_ID |
Unique identifier for the traveler within the travel and expense system. |
VARCHAR2 |
60 |
TRAVELER_PERSON_STATUS |
Travel-specific status associated with the traveler. |
VARCHAR2 |
14 |
TRAVEL_PERSON_TYPE |
Travel-specific person type associated with the traveler. |
VARCHAR2 |
40 |
TRAVEL_SOURCE_OF_DATA |
Travel-specific source system associated with the traveler record. |
VARCHAR2 |
16 |