HR POSITION Table
View exposing HR position master data including position identifiers, titles, personnel area and subgroup attributes, job relationships, and position lifecycle dates used for workforce and organizational reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
EMPLOYEE_GROUP |
Column EMPLOYEE_GROUP. |
VARCHAR2 |
20 |
EMPLOYEE_GROUP_CODE |
Column EMPLOYEE_GROUP_CODE. |
VARCHAR2 |
1 |
EMPLOYEE_SUBGROUP |
Column EMPLOYEE_SUBGROUP. |
VARCHAR2 |
20 |
EMPLOYEE_SUBGROUP_CODE |
Column EMPLOYEE_SUBGROUP_CODE. |
VARCHAR2 |
2 |
EMPLOYEE_TYPE |
Column EMPLOYEE_TYPE. |
VARCHAR2 |
30 |
HR_JOB_KEY |
Column HR_JOB_KEY. |
VARCHAR2 |
10 |
HR_POSITION_KEY |
Column HR_POSITION_KEY. |
VARCHAR2 |
10 |
IS_SHIFT_ELIGIBLE |
Column IS_SHIFT_ELIGIBLE. |
VARCHAR2 |
1 |
JOB_TITLE |
Column JOB_TITLE. |
VARCHAR2 |
50 |
MIT_JOB_CODE |
Column MIT_JOB_CODE. |
VARCHAR2 |
12 |
PERSONNEL_AREA |
Column PERSONNEL_AREA. |
VARCHAR2 |
30 |
PERSONNEL_AREA_CODE |
Column PERSONNEL_AREA_CODE. |
VARCHAR2 |
4 |
PERSONNEL_SUBAREA |
Column PERSONNEL_SUBAREA. |
VARCHAR2 |
20 |
PERSONNEL_SUBAREA_CODE |
Column PERSONNEL_SUBAREA_CODE. |
VARCHAR2 |
4 |
POSITION_BEGIN_DATE |
Column POSITION_BEGIN_DATE. |
DATE |
|
POSITION_DESCRIPTION_FLAG |
Column POSITION_DESCRIPTION_FLAG. |
VARCHAR2 |
1 |
POSITION_END_DATE |
Column POSITION_END_DATE. |
DATE |
|
POSITION_ID |
Column POSITION_ID. |
VARCHAR2 |
8 |
POSITION_SORT |
Column POSITION_SORT. |
VARCHAR2 |
12 |
POSITION_TITLE |
Column POSITION_TITLE. |
VARCHAR2 |
45 |
POSITION_TITLE_LONG |
Column POSITION_TITLE_LONG. |
VARCHAR2 |
50 |
TIME_GROUP |
Column TIME_GROUP. |
VARCHAR2 |
65 |
TIME_GROUP_CODE |
Column TIME_GROUP_CODE. |
VARCHAR2 |
10 |
UROP_LIMIT |
Column UROP_LIMIT. |
NUMBER |
9,2 |
WAREHOUSE_LOAD_DATE |
Column WAREHOUSE_LOAD_DATE. |
DATE |