HR ORG ACCESSIBLE Table
Stores flattened and hierarchical Human Resources organizational unit reference data, including department identifiers, organizational levels, and reporting hierarchy attributes. Used to support HR reporting, access control, and organizational rollups.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
HR_DEPARTMENT_CODE |
Current department code used to identify the HR department. |
VARCHAR2 |
12 |
HR_DEPARTMENT_CODE_OLD |
Legacy or historical department code previously associated with the HR department. |
VARCHAR2 |
6 |
HR_DEPARTMENT_ID |
Business identifier for the HR department associated with the organizational unit. |
VARCHAR2 |
8 |
HR_DEPARTMENT_NAME |
Standard descriptive name of the HR department. |
VARCHAR2 |
75 |
HR_DEPARTMENT_NAME_ALPHA |
Alphabetized or normalized department name used for sorting or display purposes. |
VARCHAR2 |
75 |
HR_DEPARTMENT_NAME_LONG |
Extended or formal name of the HR department. |
VARCHAR2 |
100 |
HR_ORG_LEVEL1_ID |
Identifier for the first-level organizational hierarchy node. |
VARCHAR2 |
8 |
HR_ORG_LEVEL1_NAME |
Name of the first-level organizational hierarchy node. |
VARCHAR2 |
75 |
HR_ORG_LEVEL1_SORT |
Sort order value used to sequence first-level organizational hierarchy nodes. |
VARCHAR2 |
4 |
HR_ORG_LEVEL2_ID |
Identifier for the second-level organizational hierarchy node. |
VARCHAR2 |
8 |
HR_ORG_LEVEL2_NAME |
Name of the second-level organizational hierarchy node. |
VARCHAR2 |
75 |
HR_ORG_LEVEL2_SORT |
Sort order value used to sequence second-level organizational hierarchy nodes. |
VARCHAR2 |
4 |
HR_ORG_LEVEL3_ID |
Identifier for the third-level organizational hierarchy node. |
VARCHAR2 |
8 |
HR_ORG_LEVEL3_NAME |
Name of the third-level organizational hierarchy node. |
VARCHAR2 |
75 |
HR_ORG_LEVEL3_SORT |
Sort order value used to sequence third-level organizational hierarchy nodes. |
VARCHAR2 |
4 |
HR_ORG_LEVEL4_ID |
Identifier for the fourth-level organizational hierarchy node. |
VARCHAR2 |
8 |
HR_ORG_LEVEL4_NAME |
Name of the fourth-level organizational hierarchy node. |
VARCHAR2 |
75 |
HR_ORG_LEVEL4_SORT |
Sort order value used to sequence fourth-level organizational hierarchy nodes. |
VARCHAR2 |
4 |
HR_ORG_LEVEL5_ID |
Identifier for the fifth-level organizational hierarchy node. |
VARCHAR2 |
8 |
HR_ORG_LEVEL5_NAME |
Name of the fifth-level organizational hierarchy node. |
VARCHAR2 |
75 |
HR_ORG_LEVEL5_SORT |
Sort order value used to sequence fifth-level organizational hierarchy nodes. |
VARCHAR2 |
4 |
HR_ORG_LEVEL6_ID |
Identifier for the sixth-level organizational hierarchy node. |
VARCHAR2 |
8 |
HR_ORG_LEVEL6_NAME |
Name of the sixth-level organizational hierarchy node. |
VARCHAR2 |
75 |
HR_ORG_LEVEL6_SORT |
Sort order value used to sequence sixth-level organizational hierarchy nodes. |
VARCHAR2 |
4 |
HR_ORG_LEVEL7_ID |
Identifier for the seventh-level organizational hierarchy node. |
VARCHAR2 |
8 |
HR_ORG_LEVEL7_NAME |
Name of the seventh-level organizational hierarchy node. |
VARCHAR2 |
75 |
HR_ORG_LEVEL7_SORT |
Sort order value used to sequence seventh-level organizational hierarchy nodes. |
VARCHAR2 |
4 |
HR_ORG_UNIT_ID |
Business identifier for the HR organizational unit, sourced from upstream HR systems. |
VARCHAR2 |
8 |
HR_ORG_UNIT_KEY |
Surrogate key uniquely identifying the HR organizational unit within the data warehouse. |
VARCHAR2 |
10 |
HR_ORG_UNIT_LEVEL |
Indicates the hierarchical level or classification of the HR organizational unit. |
VARCHAR2 |
30 |
HR_ORG_UNIT_TITLE |
Descriptive title or name of the HR organizational unit. |
VARCHAR2 |
75 |
ORG_HIER_ROOT_NAME |
Root-level organizational name representing the highest node in the hierarchy. |
VARCHAR2 |
75 |
ORG_HIER_SCHOOL_AREA_NAME |
Name of the school or area within the organizational hierarchy to which the unit belongs. |
VARCHAR2 |
75 |
ORG_HIER_TOP_LEVEL_NAME |
Name of the top-level organizational entity in the hierarchy. |
VARCHAR2 |
75 |
WAREHOUSE_LOAD_DATE |
Date on which the record was loaded or refreshed in the data warehouse. |
DATE |