HR POSITION LIM DET HISTORY Table
View exposing historical limited HR position detail attributes including position identifiers, titles, job relationships, and period-based reporting fields used for lightweight position history reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COST_PLANNING_TYPE |
Column COST_PLANNING_TYPE. |
VARCHAR2 |
14 |
END_DATE |
Column END_DATE. |
DATE |
|
EXPECTED_FILL_DATE |
Column EXPECTED_FILL_DATE. |
DATE |
|
HR_JOB_FP_KEY |
Column HR_JOB_FP_KEY. |
VARCHAR2 |
14 |
HR_ORG_UNIT_FP_KEY |
Column HR_ORG_UNIT_FP_KEY. |
VARCHAR2 |
210 |
HR_ORG_UNIT_KEY |
Column HR_ORG_UNIT_KEY. |
VARCHAR2 |
10 |
HR_POSITION_FP_KEY |
Column HR_POSITION_FP_KEY. |
VARCHAR2 |
14 |
HR_POSITION_STATUS_KEY |
Column HR_POSITION_STATUS_KEY. |
VARCHAR2 |
14 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
POSITION_FTE_PERCENT |
Column POSITION_FTE_PERCENT. |
NUMBER |
7,4 |
RECORD_COUNTER |
Column RECORD_COUNTER. |
NUMBER |
|
START_DATE |
Column START_DATE. |
DATE |
|
TIME_MONTH_KEY |
Column TIME_MONTH_KEY. |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
Column WAREHOUSE_LOAD_DATE. |
DATE |
|
WEBHIRE_REQ_NUMBER |
Column WEBHIRE_REQ_NUMBER. |
VARCHAR2 |
12 |
WORK_WEEK_HOURS |
Column WORK_WEEK_HOURS. |
NUMBER |
5,2 |