ASR HR ORG UNIT Table
View exposing HR organizational unit data used within the Annual Salary Review process for compensation review reporting and administration.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ASR_ORG_UNIT_TITLE |
Asr org unit title as provided by the source. |
VARCHAR2 |
75 |
HR_DEPARTMENT_CODE |
Code identifying hr department. |
VARCHAR2 |
12 |
HR_DEPARTMENT_CODE_OLD |
Hr department code old as provided by the source. |
VARCHAR2 |
6 |
HR_DEPARTMENT_ID |
Business identifier for the hr department. |
VARCHAR2 |
8 |
HR_DEPARTMENT_NAME |
Hr department name as provided by the source. |
VARCHAR2 |
75 |
HR_DEPARTMENT_NAME_ALPHA |
Hr department name alpha as provided by the source. |
VARCHAR2 |
75 |
HR_DEPARTMENT_NAME_LONG |
Hr department name long as provided by the source. |
VARCHAR2 |
100 |
HR_ORG_LEVEL1_ID |
Business identifier for the hr org level1. |
VARCHAR2 |
8 |
HR_ORG_LEVEL1_NAME |
Hr org level1 name as provided by the source. |
VARCHAR2 |
75 |
HR_ORG_LEVEL1_SORT |
Hr org level1 sort as provided by the source. |
NUMBER |
|
HR_ORG_LEVEL2_ID |
Business identifier for the hr org level2. |
VARCHAR2 |
8 |
HR_ORG_LEVEL2_NAME |
Hr org level2 name as provided by the source. |
VARCHAR2 |
75 |
HR_ORG_LEVEL2_SORT |
Hr org level2 sort as provided by the source. |
NUMBER |
|
HR_ORG_LEVEL3_ID |
Business identifier for the hr org level3. |
VARCHAR2 |
8 |
HR_ORG_LEVEL3_NAME |
Hr org level3 name as provided by the source. |
VARCHAR2 |
75 |
HR_ORG_LEVEL3_SORT |
Hr org level3 sort as provided by the source. |
NUMBER |
|
HR_ORG_LEVEL4_ID |
Business identifier for the hr org level4. |
VARCHAR2 |
8 |
HR_ORG_LEVEL4_NAME |
Hr org level4 name as provided by the source. |
VARCHAR2 |
75 |
HR_ORG_LEVEL4_SORT |
Hr org level4 sort as provided by the source. |
NUMBER |
|
HR_ORG_LEVEL5_ID |
Business identifier for the hr org level5. |
VARCHAR2 |
8 |
HR_ORG_LEVEL5_NAME |
Hr org level5 name as provided by the source. |
VARCHAR2 |
75 |
HR_ORG_LEVEL5_SORT |
Hr org level5 sort as provided by the source. |
NUMBER |
|
HR_ORG_UNIT_FP_KEY |
Surrogate key identifying the hr org unit fp. |
VARCHAR2 |
14 |
HR_ORG_UNIT_ID |
Business identifier for the hr org unit. |
VARCHAR2 |
8 |
HR_ORG_UNIT_LEVEL |
Hr org unit level as provided by the source. |
VARCHAR2 |
30 |
ORG_HIER_ROOT_NAME |
Org hier root name as provided by the source. |
VARCHAR2 |
75 |
ORG_HIER_SCHOOL_AREA_NAME |
Org hier school area name as provided by the source. |
VARCHAR2 |
75 |
ORG_HIER_TOP_LEVEL_NAME |
Org hier top level name as provided by the source. |
VARCHAR2 |
75 |
TIME_MONTH_KEY |
Surrogate key identifying the time month. |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |