HR ORG UNIT Table
Stores current (non-snapshot) organizational hierarchy and department alignment attributes for HR organizational units. Each row represents an HR organizational unit, including descriptive fields and its placement within the organizational hierarchy used for reporting and analytics.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
DLC_KEY |
Composite key representing the DLC (department, lab, or center) grouping associated with the organizational unit. |
VARCHAR2 |
180 |
DLC_NAME |
Name of the DLC (department, lab, or center) grouping associated with the organizational unit. |
VARCHAR2 |
840 |
HR_DEPARTMENT_CODE |
Current department code associated with the organizational unit. |
VARCHAR2 |
12 |
HR_DEPARTMENT_CODE_OLD |
Historical or legacy department code associated with the organizational unit. |
VARCHAR2 |
6 |
HR_DEPARTMENT_ID |
Business identifier for the HR department associated with the organizational unit. |
VARCHAR2 |
8 |
HR_DEPARTMENT_NAME |
Official department name associated with the organizational unit. |
VARCHAR2 |
75 |
HR_DEPARTMENT_NAME_ALPHA |
Alphabetically normalized department name used for sorting and reporting. |
VARCHAR2 |
75 |
HR_DEPARTMENT_NAME_LONG |
Extended descriptive department name. |
VARCHAR2 |
100 |
HR_ORG_LEVEL1_ID |
Identifier for hierarchical level 1 organization associated with this unit. |
VARCHAR2 |
8 |
HR_ORG_LEVEL1_NAME |
Name of the hierarchical level 1 organization. |
VARCHAR2 |
75 |
HR_ORG_LEVEL1_SORT |
Sort value for hierarchical level 1 organization. |
VARCHAR2 |
4 |
HR_ORG_LEVEL2_ID |
Identifier for hierarchical level 2 organization associated with this unit. |
VARCHAR2 |
8 |
HR_ORG_LEVEL2_NAME |
Name of the hierarchical level 2 organization. |
VARCHAR2 |
75 |
HR_ORG_LEVEL2_SORT |
Sort value for hierarchical level 2 organization. |
VARCHAR2 |
4 |
HR_ORG_LEVEL3_ID |
Identifier for hierarchical level 3 organization associated with this unit. |
VARCHAR2 |
8 |
HR_ORG_LEVEL3_NAME |
Name of the hierarchical level 3 organization. |
VARCHAR2 |
75 |
HR_ORG_LEVEL3_SORT |
Sort value for hierarchical level 3 organization. |
VARCHAR2 |
4 |
HR_ORG_LEVEL4_ID |
Identifier for hierarchical level 4 organization associated with this unit. |
VARCHAR2 |
8 |
HR_ORG_LEVEL4_NAME |
Name of the hierarchical level 4 organization. |
VARCHAR2 |
75 |
HR_ORG_LEVEL4_SORT |
Sort value for hierarchical level 4 organization. |
VARCHAR2 |
4 |
HR_ORG_LEVEL5_ID |
Identifier for hierarchical level 5 organization associated with this unit. |
VARCHAR2 |
8 |
HR_ORG_LEVEL5_NAME |
Name of the hierarchical level 5 organization. |
VARCHAR2 |
75 |
HR_ORG_LEVEL5_SORT |
Sort value for hierarchical level 5 organization. |
VARCHAR2 |
4 |
HR_ORG_LEVEL6_ID |
Identifier for hierarchical level 6 organization associated with this unit. |
VARCHAR2 |
8 |
HR_ORG_LEVEL6_NAME |
Name of the hierarchical level 6 organization. |
VARCHAR2 |
75 |
HR_ORG_LEVEL6_SORT |
Sort value for hierarchical level 6 organization. |
VARCHAR2 |
4 |
HR_ORG_LEVEL7_ID |
Identifier for hierarchical level 7 organization associated with this unit. |
VARCHAR2 |
8 |
HR_ORG_LEVEL7_NAME |
Name of the hierarchical level 7 organization. |
VARCHAR2 |
75 |
HR_ORG_LEVEL7_SORT |
Sort value for hierarchical level 7 organization. |
VARCHAR2 |
4 |
HR_ORG_UNIT_ID |
Business identifier for the HR organizational unit. |
VARCHAR2 |
8 |
HR_ORG_UNIT_KEY |
Surrogate key uniquely identifying the HR organizational unit record. |
VARCHAR2 |
10 |
HR_ORG_UNIT_LEVEL |
Description of the hierarchical level of the HR organizational unit. |
VARCHAR2 |
30 |
HR_ORG_UNIT_TITLE |
Official title of the HR organizational unit. |
VARCHAR2 |
75 |
ORG_HIER_ROOT_NAME |
Name of the root-level organization in the hierarchy. |
VARCHAR2 |
75 |
ORG_HIER_SCHOOL_AREA_NAME |
Name of the school or major academic area within the organizational hierarchy. |
VARCHAR2 |
75 |
ORG_HIER_TOP_LEVEL_NAME |
Name of the top-level organization within the hierarchy. |
VARCHAR2 |
75 |
WAREHOUSE_LOAD_DATE |
Timestamp indicating when the record was loaded into the data warehouse. |
DATE |