HR ORG UNIT HIERARCHY Table
Master data table containing the new HR organization unit hierarchy.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
HR_ORG_UNIT_HIER_SEARCH_CODE |
XXX |
VARCHAR2 |
75 |
HR_ORG_UNIT_HIER_SEARCH_NAME |
XXX |
VARCHAR2 |
75 |
HR_ORG_UNIT_KEY |
This field should be used to join HR_ORG_UNIT and HR_ORG_UNIT_HIERARCHY tables with such fact tables as HR_APPOINTMENT_DETAIL, HR_APPT_TX_DETAIL, and HR_POSITION_DETAIL and their LIMITED versions. |
VARCHAR2 |
8 |
LEVEL1_ABBR |
XXX |
VARCHAR2 |
75 |
LEVEL1_NAME |
The Profit Center Group name assigned to this hierarchy node in SAP. |
VARCHAR2 |
40 |
LEVEL1_SORT |
This field should be used for ordering the level 1 categories in the order assigned to them in SAP. It must be selected every time LEVEL1_CATEGORY is selected, then placed in the Pivot or Detail report outliner before LEVEL1_CATEGORY in the same window. It can be then "hidden", by hiding headers/footers in the Detail, or squeezing it out in the Pivot. |
NUMBER |
22 |
LEVEL2_ABBR |
XXX |
VARCHAR2 |
75 |
LEVEL2_NAME |
The Profit Center Group name assigned to this hierarchy node in SAP. |
VARCHAR2 |
40 |
LEVEL2_SORT |
This field should be used for ordering the level 2 categories in the order assigned to them in SAP. It must be selected every time LEVEL2_CATEGORY is selected, then placed in the Pivot or Detail report outliner before LEVEL2_CATEGORY in the same window. It can be then "hidden", by hiding headers/footers in the Detail, or squeezing it out in the Pivot. |
NUMBER |
22 |
LEVEL3_ABBR |
XXX |
VARCHAR2 |
75 |
LEVEL3_NAME |
The Profit Center Group name assigned to this hierarchy node in SAP. |
VARCHAR2 |
40 |
LEVEL3_SORT |
This field should be used for ordering the level 3 categories in the order assigned to them in SAP. It must be selected every time LEVEL3_CATEGORY is selected, then placed in the Pivot or Detail report outliner before LEVEL3_CATEGORY in the same window. It can be then "hidden", by hiding headers/footers in the Detail, or squeezing it out in the Pivot. |
NUMBER |
22 |
LEVEL4_ABBR |
XXX |
VARCHAR2 |
75 |
LEVEL4_NAME |
The Profit Center Group name assigned to this hierarchy node in SAP. |
VARCHAR2 |
40 |
LEVEL4_SORT |
This field should be used for ordering the level 4 categories in the order assigned to them in SAP. It must be selected every time LEVEL4_CATEGORY is selected, then placed in the Pivot or Detail report outliner before LEVEL4_CATEGORY in the same window. It can be then "hidden", by hiding headers/footers in the Detail, or squeezing it out in the Pivot. |
NUMBER |
22 |
LEVEL5_ABBR |
XXX |
VARCHAR2 |
75 |
LEVEL5_NAME |
The Profit Center Group name assigned to this hierarchy node in SAP. |
VARCHAR2 |
40 |
LEVEL5_SORT |
This field should be used for ordering the level 5 categories in the order assigned |
NUMBER |
22 |