HR ORG UNIT HISTORY Table
Master data table containing the new 8 digit department nuber, title, old department codes, and organization levels.
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_UNIT_FP_KEY |
Similar to HR_ORG_UNIT_KEY but used to join HR_ORG_UNIT and HR_ORG_UNIT_HIERARCHY tables to corresponding HR_ORG_UNIT_FP_KEY in Fact tables when retrieving data as it was in the selected past fiscal period rather than current data. Used ONLY for joining data, not for reporting. |
VARCHAR2 |
14 |
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_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 |
TIME_MONTH_KEY |
Key used only for joining the TIME_MONTH table to other tables, NOT for reporting. |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |