VISITOR JOB CODES FOR TLO Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
JOB_ID |
The SAP 8-digit object id assigned to the job. |
VARCHAR2 |
8 |
JOB_TITLE |
In MIT's HR tables this field contains the official MIT job Title. This title is tied to the Job ID, and can only be changed by the Compensation Office. |
VARCHAR2 |
40 |
MIT_JOB_CODE |
Indicates the job code used by Human Resources. For admin and support staff jobs, the codes include the level of the job (e.g. HR-QG034, HR-04FN01). |
VARCHAR2 |
12 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |