HR ORG UNIT HISTORY Table
View exposing historical HR organizational unit hierarchy data by fiscal period including organizational levels, department identifiers, school or area rollups, and month-based reporting keys used for workforce and organizational history reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
HR_DEPARTMENT_CODE |
Column HR_DEPARTMENT_CODE. |
VARCHAR2 |
12 |
HR_DEPARTMENT_CODE_OLD |
Column HR_DEPARTMENT_CODE_OLD. |
VARCHAR2 |
6 |
HR_DEPARTMENT_ID |
Column HR_DEPARTMENT_ID. |
VARCHAR2 |
8 |
HR_DEPARTMENT_NAME |
Column HR_DEPARTMENT_NAME. |
VARCHAR2 |
75 |
HR_DEPARTMENT_NAME_ALPHA |
Column HR_DEPARTMENT_NAME_ALPHA. |
VARCHAR2 |
75 |
HR_DEPARTMENT_NAME_LONG |
Column HR_DEPARTMENT_NAME_LONG. |
VARCHAR2 |
100 |
HR_ORG_LEVEL1_ID |
Column HR_ORG_LEVEL1_ID. |
VARCHAR2 |
8 |
HR_ORG_LEVEL1_NAME |
Column HR_ORG_LEVEL1_NAME. |
VARCHAR2 |
75 |
HR_ORG_LEVEL1_SORT |
Column HR_ORG_LEVEL1_SORT. |
NUMBER |
|
HR_ORG_LEVEL2_ID |
Column HR_ORG_LEVEL2_ID. |
VARCHAR2 |
8 |
HR_ORG_LEVEL2_NAME |
Column HR_ORG_LEVEL2_NAME. |
VARCHAR2 |
75 |
HR_ORG_LEVEL2_SORT |
Column HR_ORG_LEVEL2_SORT. |
NUMBER |
|
HR_ORG_LEVEL3_ID |
Column HR_ORG_LEVEL3_ID. |
VARCHAR2 |
8 |
HR_ORG_LEVEL3_NAME |
Column HR_ORG_LEVEL3_NAME. |
VARCHAR2 |
75 |
HR_ORG_LEVEL3_SORT |
Column HR_ORG_LEVEL3_SORT. |
NUMBER |
|
HR_ORG_LEVEL4_ID |
Column HR_ORG_LEVEL4_ID. |
VARCHAR2 |
8 |
HR_ORG_LEVEL4_NAME |
Column HR_ORG_LEVEL4_NAME. |
VARCHAR2 |
75 |
HR_ORG_LEVEL4_SORT |
Column HR_ORG_LEVEL4_SORT. |
NUMBER |
|
HR_ORG_LEVEL5_ID |
Column HR_ORG_LEVEL5_ID. |
VARCHAR2 |
8 |
HR_ORG_LEVEL5_NAME |
Column HR_ORG_LEVEL5_NAME. |
VARCHAR2 |
75 |
HR_ORG_LEVEL5_SORT |
Column HR_ORG_LEVEL5_SORT. |
NUMBER |
|
HR_ORG_UNIT_FP_KEY |
Column HR_ORG_UNIT_FP_KEY. |
VARCHAR2 |
14 |
HR_ORG_UNIT_ID |
Column HR_ORG_UNIT_ID. |
VARCHAR2 |
8 |
HR_ORG_UNIT_LEVEL |
Column HR_ORG_UNIT_LEVEL. |
VARCHAR2 |
30 |
HR_ORG_UNIT_TITLE |
Column HR_ORG_UNIT_TITLE. |
VARCHAR2 |
75 |
ORG_HIER_ROOT_NAME |
Column ORG_HIER_ROOT_NAME. |
VARCHAR2 |
75 |
ORG_HIER_SCHOOL_AREA_NAME |
Column ORG_HIER_SCHOOL_AREA_NAME. |
VARCHAR2 |
75 |
ORG_HIER_TOP_LEVEL_NAME |
Column ORG_HIER_TOP_LEVEL_NAME. |
VARCHAR2 |
75 |
TIME_MONTH_KEY |
Column TIME_MONTH_KEY. |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
Column WAREHOUSE_LOAD_DATE. |
DATE |