TRAVEL PROFILE Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CONTACT_FIRST_NAME |
The first name of the contact person, all uppercase. |
VARCHAR2 |
40 |
CONTACT_FULL_NAME |
The full name of the contact person. This is all uppercase, in the format "LAST-NAME, FIRST-NAME OPTIONAL-MIDDLE-NAME". |
VARCHAR2 |
100 |
CONTACT_LAST_NAME |
The last name of the contact person, all uppercase. |
VARCHAR2 |
60 |
DLC_KEY |
a unigue key to enable joining information stored with other forms of Department Key |
VARCHAR2 |
15 |
DLC_NAME |
The name of the DLC associated with this room set. |
VARCHAR2 |
70 |
EMPLOYEE_STATUS |
XXX |
VARCHAR2 |
30 |
FULL_NAME |
The full name of the person. |
VARCHAR2 |
100 |
HR_DEPARTMENT_CODE |
Department number, such as HR-871000 |
VARCHAR2 |
12 |
HR_DEPARTMENT_NAME |
Name of the department, school, center, or lab. |
VARCHAR2 |
75 |
HR_ORG_UNIT_ID |
8-digit unique number generated by SAP for each org unit. All levels within the HR org hierarcy (e.g. school, department, sub-department) are assigned an HR Org Unit ID. |
VARCHAR2 |
8 |
HR_ORG_UNIT_LEVEL |
Tells what organizational level this record represents: top level, department, or sub-department |
VARCHAR2 |
30 |
HR_ORG_UNIT_TITLE |
Name of the department, school, center, or lab. (Known as Org Units in SAP.) |
VARCHAR2 |
75 |
PERSON_TYPE |
In the KRB_PERSON and MITID_DB_PERSON tables, PERSON_TYPE is a more specific classification of the type of person: Current employee, Non current employee, Current student, Non current student, Moira account. In the IR AWARD PERSON table, this field identifies whether the person is Faculty, Staff, MIT Alumni, Student, or MIT Corporation member. |
VARCHAR2 |
40 |
PROFILE_EMAIL |
XXX |
VARCHAR2 |
100 |
PROFILE_FIRST_NAME |
XXX |
VARCHAR2 |
32 |
PROFILE_LAST_NAME |
XXX |
VARCHAR2 |
32 |
TRAVEL_EXPENSE_GROUP |
XXX |
VARCHAR2 |
50 |
TRAVEL_PROFILE_ID |
XXX |
VARCHAR2 |
60 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |