SHA SALARY ACCESS ORG UNIT Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
HR_ORG_UNIT_ID |
8-digit unique number generated by SAP for each org unit. All levels within the HR org hierarcy (e.g. school, department, sub-department) are assigned an HR Org Unit ID. |
VARCHAR2 |
8 |
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 |
10 |
HR_ORG_UNIT_TITLE |
Name of the department, school, center, or lab. (Known as Org Units in SAP.) |
VARCHAR2 |
75 |
ORG_HIER_SCHOOL_AREA_NAME |
Identifies the school, ie. School of Humanities. |
VARCHAR2 |
75 |
ORG_HIER_TOP_LEVEL_NAME |
Identifies the area the organization "rolls up" into, ie. Provost Area |
VARCHAR2 |
75 |