HR POSITION HISTORY Table
View exposing historical HR position data including position identifiers, titles, organizational relationships, and period-based reporting fields used for workforce and organizational history reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
EMPLOYEE_GROUP |
Column EMPLOYEE_GROUP. |
VARCHAR2 |
240 |
EMPLOYEE_GROUP_CODE |
Column EMPLOYEE_GROUP_CODE. |
VARCHAR2 |
12 |
EMPLOYEE_SUBGROUP |
Column EMPLOYEE_SUBGROUP. |
VARCHAR2 |
240 |
EMPLOYEE_SUBGROUP_CODE |
Column EMPLOYEE_SUBGROUP_CODE. |
VARCHAR2 |
24 |
EMPLOYEE_TYPE |
Column EMPLOYEE_TYPE. |
VARCHAR2 |
360 |
HR_POSITION_FP_KEY |
Column HR_POSITION_FP_KEY. |
VARCHAR2 |
168 |
IS_SHIFT_ELIGIBLE |
Column IS_SHIFT_ELIGIBLE. |
VARCHAR2 |
12 |
JOB_TITLE |
Column JOB_TITLE. |
VARCHAR2 |
600 |
MIT_JOB_CODE |
Column MIT_JOB_CODE. |
VARCHAR2 |
144 |
PERSONNEL_AREA |
Column PERSONNEL_AREA. |
VARCHAR2 |
360 |
PERSONNEL_AREA_CODE |
Column PERSONNEL_AREA_CODE. |
VARCHAR2 |
48 |
PERSONNEL_SUBAREA |
Column PERSONNEL_SUBAREA. |
VARCHAR2 |
240 |
PERSONNEL_SUBAREA_CODE |
Column PERSONNEL_SUBAREA_CODE. |
VARCHAR2 |
48 |
POSITION_DESCRIPTION_FLAG |
Column POSITION_DESCRIPTION_FLAG. |
VARCHAR2 |
12 |
POSITION_ID |
Column POSITION_ID. |
VARCHAR2 |
96 |
POSITION_SORT |
Column POSITION_SORT. |
VARCHAR2 |
144 |
POSITION_TITLE |
Column POSITION_TITLE. |
VARCHAR2 |
540 |
POSITION_TITLE_LONG |
Column POSITION_TITLE_LONG. |
VARCHAR2 |
600 |
TIME_GROUP |
Column TIME_GROUP. |
VARCHAR2 |
780 |
TIME_GROUP_CODE |
Column TIME_GROUP_CODE. |
VARCHAR2 |
120 |
TIME_MONTH_KEY |
Column TIME_MONTH_KEY. |
VARCHAR2 |
72 |
WAREHOUSE_LOAD_DATE |
Column WAREHOUSE_LOAD_DATE. |
DATE |