HR POSITION DETAIL HISTORY Table
View exposing historical detailed HR position data including position identifiers, titles, organizational relationships, job attributes, and period-based reporting fields used for workforce and organizational history analysis.
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_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_BUDGET |
Column POSITION_BUDGET. |
NUMBER |
13,2 |
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 |