HR ORG UNIT HIERARCHY Table
View exposing a flattened HR organizational hierarchy for each HR organizational unit, including search-friendly hierarchy name/code fields and level-based sort/name/abbreviation attributes used for navigation, reporting rollups, and filtering.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
HR_ORG_UNIT_HIER_SEARCH_CODE |
Concatenated or standardized hierarchy search code for the organizational unit, used for searching and reporting. |
VARCHAR2 |
75 |
HR_ORG_UNIT_HIER_SEARCH_NAME |
Concatenated or standardized hierarchy search name for the organizational unit, used for searching and reporting. |
VARCHAR2 |
75 |
HR_ORG_UNIT_KEY |
Identifier linking this hierarchy record to an HR organizational unit. |
VARCHAR2 |
31 |
LEVEL1_ABBR |
Abbreviation of the organization at hierarchy level 1. |
VARCHAR2 |
75 |
LEVEL1_NAME |
Name of the organization at hierarchy level 1. |
VARCHAR2 |
75 |
LEVEL1_SORT |
Numeric sort order value for hierarchy level 1. |
NUMBER |
|
LEVEL2_ABBR |
Abbreviation of the organization at hierarchy level 2. |
VARCHAR2 |
75 |
LEVEL2_NAME |
Name of the organization at hierarchy level 2. |
VARCHAR2 |
75 |
LEVEL2_SORT |
Numeric sort order value for hierarchy level 2. |
NUMBER |
|
LEVEL3_ABBR |
Abbreviation of the organization at hierarchy level 3. |
VARCHAR2 |
75 |
LEVEL3_NAME |
Name of the organization at hierarchy level 3. |
VARCHAR2 |
75 |
LEVEL3_SORT |
Numeric sort order value for hierarchy level 3. |
NUMBER |
|
LEVEL4_ABBR |
Abbreviation of the organization at hierarchy level 4. |
VARCHAR2 |
75 |
LEVEL4_NAME |
Name of the organization at hierarchy level 4. |
VARCHAR2 |
75 |
LEVEL4_SORT |
Numeric sort order value for hierarchy level 4. |
NUMBER |
|
LEVEL5_ABBR |
Abbreviation of the organization at hierarchy level 5. |
VARCHAR2 |
75 |
LEVEL5_NAME |
Name of the organization at hierarchy level 5. |
VARCHAR2 |
75 |
LEVEL5_SORT |
Numeric sort order value for hierarchy level 5. |
NUMBER |