TRAVELER Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
DEPARTMENT_NAME |
The name of the department, school, center, or lab. |
VARCHAR2 |
75 |
DEPARTMENT_NUMBER |
The Institute-assigned identification number of a department, school, center, or lab. |
VARCHAR2 |
6 |
EMAIL_ADDRESS |
A person's complete electronic mail address including user name and node name, for example, username@school.edu. |
VARCHAR2 |
100 |
FIRST_NAME |
The person's first name. |
VARCHAR2 |
40 |
FULL_NAME |
The full name of the person. |
VARCHAR2 |
100 |
KERBEROS_NAME |
The Kerberos username of the person. If this field starts with a dollar sign ($), then it is not a real Kerberos username, but an algorithmically generated pseudo Kerberos username, used as a placeholder in the EHS system. |
VARCHAR2 |
8 |
KERBEROS_NAME_UPPERCASE |
The Kerberos username of the person, in all upper cases. |
VARCHAR2 |
8 |
LAST_NAME |
The person's last name. |
VARCHAR2 |
40 |
MIDDLE_NAME |
The person's middle name (where available). |
VARCHAR2 |
40 |
PERSONNEL_AREA |
Definition of PERSONNEL_AREA_CODE; identifies campus groupings of employees; e.g., academic, nonacademic, external, or Lincoln Lab. |
VARCHAR2 |
40 |
PERSONNEL_AREA_CODE |
4 character code to identify employee groups; e.g., academic, nonacademic, external, or Lincoln Lab. |
VARCHAR2 |
4 |
PERSONNEL_SUBAREA |
Text that further identifies the personnel area into sub groupings of Positions,e.g., Admin Staff, Support Staff. Similar to the old Rank Lists values. |
VARCHAR2 |
40 |
PERSONNEL_SUBAREA_CODE |
4 character code to further identify the personnel area, e.g., CFAC for faculty. |
VARCHAR2 |
4 |
PRIMARY_OFFICE_LOCATION |
The primary office building-room number of the person. |
VARCHAR2 |
40 |
PRIMARY_OFFICE_PHONE |
The primary office phone number of the person. |
VARCHAR2 |
20 |
RECORD_COUNTER |
Used to count records within a group on a report. Always contains a value of 1. |
NUMBER |
|
SOURCE_OF_DATA |
XXX |
VARCHAR2 |
9 |
TRAVELER_DESCRIPTION |
XXX |
VARCHAR2 |
50 |
TRAVELER_EXPENSE_GROUP |
XXX |
VARCHAR2 |
50 |
TRAVELER_ID |
XXX |
VARCHAR2 |
60 |
TRAVELER_PERSON_STATUS |
XXX |
VARCHAR2 |
14 |
TRAVEL_PERSON_TYPE |
XXX |
VARCHAR2 |
40 |
TRAVEL_SOURCE_OF_DATA |
XXX |
VARCHAR2 |
16 |