HR ORG ACCESSIBLE Table
This table contains a view of HR Organizations filtered by what the user has access to. For use in driving selection screens
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
HR_DEPARTMENT_CODE |
Department number, such as HR-871000 |
VARCHAR2 |
12 |
HR_DEPARTMENT_CODE_OLD |
Prior department number |
VARCHAR2 |
6 |
HR_DEPARTMENT_ID |
MIT-assigned identification number of a department, school, center, or lab. |
VARCHAR2 |
8 |
HR_DEPARTMENT_NAME |
Name of the department, school, center, or lab. |
VARCHAR2 |
75 |
HR_DEPARTMENT_NAME_ALPHA |
Name of the department, school, center, or lab. |
VARCHAR2 |
75 |
HR_DEPARTMENT_NAME_LONG |
Name of the department, school, center, or lab. |
VARCHAR2 |
100 |
HR_ORG_LEVEL1_ID |
XXX |
VARCHAR2 |
8 |
HR_ORG_LEVEL1_NAME |
Name assigned to the organization level to be used to create hierarchies in reporting |
VARCHAR2 |
75 |
HR_ORG_LEVEL1_SORT |
Sort order number to order the levels within the organization levels |
NUMBER |
4 |
HR_ORG_LEVEL2_ID |
XXX |
VARCHAR2 |
8 |
HR_ORG_LEVEL2_NAME |
Name assigned to the organization level to be used to create hierarchies in reporting |
VARCHAR2 |
75 |
HR_ORG_LEVEL2_SORT |
Sort order number to order the levels within the organization levels |
NUMBER |
4 |
HR_ORG_LEVEL3_ID |
XXX |
VARCHAR2 |
8 |
HR_ORG_LEVEL3_NAME |
Name assigned to the organization level to be used to create hierarchies in reporting |
VARCHAR2 |
75 |
HR_ORG_LEVEL3_SORT |
Sort order number to order the levels within the organization levels |
NUMBER |
4 |
HR_ORG_LEVEL4_ID |
XXX |
VARCHAR2 |
8 |
HR_ORG_LEVEL4_NAME |
Name assigned to the organization level to be used to create hierarchies in reporting |
VARCHAR2 |
75 |
HR_ORG_LEVEL4_SORT |
Sort order number to order the levels within the organization levels |
NUMBER |
4 |
HR_ORG_LEVEL5_ID |
XXX |
VARCHAR2 |
8 |
HR_ORG_LEVEL5_NAME |
Name assigned to the organization level to be used to create hierarchies in reporting |
VARCHAR2 |
75 |
HR_ORG_LEVEL5_SORT |
Sort order number to order the levels within the organization levels |
NUMBER |
4 |
HR_ORG_LEVEL6_ID |
XXX |
VARCHAR2 |
8 |
HR_ORG_LEVEL6_NAME |
XXX |
VARCHAR2 |
75 |
HR_ORG_LEVEL6_SORT |
XXX |
VARCHAR2 |
4 |
HR_ORG_LEVEL7_ID |
XXX |
VARCHAR2 |
8 |
HR_ORG_LEVEL7_NAME |
XXX |
VARCHAR2 |
75 |
HR_ORG_LEVEL7_SORT |
XXX |
VARCHAR2 |
4 |
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 |
8 |
HR_ORG_UNIT_LEVEL |
Tells what organizational level this record represents: top level, department, or sub-department |
VARCHAR2 |
30 |
HR_ORG_UNIT_TITLE |
Name of the department, school, center, or lab. (Known as Org Units in SAP.) |
VARCHAR2 |
75 |
ORG_HIER_ROOT_NAME |
Identifies the main level root this structure falls under, such as MIT-All |
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 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |