HR ORG UNIT NEW Table
View exposing HR organizational unit data using the newer organizational structure definition, including organizational identifiers, titles, hierarchy attributes, and related reporting fields.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
DLC_KEY |
Column DLC_KEY. |
VARCHAR2 |
180 |
HR_DEPARTMENT_ABBR |
Column HR_DEPARTMENT_ABBR. |
VARCHAR2 |
12 |
HR_DEPARTMENT_CODE |
Column HR_DEPARTMENT_CODE. |
VARCHAR2 |
8 |
HR_DEPARTMENT_CODE_OLD |
Column HR_DEPARTMENT_CODE_OLD. |
VARCHAR2 |
6 |
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. |
VARCHAR2 |
4 |
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. |
VARCHAR2 |
4 |
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. |
VARCHAR2 |
4 |
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. |
VARCHAR2 |
4 |
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. |
VARCHAR2 |
4 |
HR_ORG_UNIT_ID |
Column HR_ORG_UNIT_ID. |
VARCHAR2 |
8 |
HR_ORG_UNIT_KEY |
Column HR_ORG_UNIT_KEY. |
VARCHAR2 |
10 |
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 |
WAREHOUSE_LOAD_DATE |
Column WAREHOUSE_LOAD_DATE. |
DATE |