LSO PROVIDER Table
MIT Org unit information (SAP HR)
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
DLC_KEY |
a unigue key to enable joining information stored with other forms of Department Key |
VARCHAR2 |
15 |
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_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 |
LSO_PROVIDER_KEY |
XXX |
VARCHAR2 |
10 |
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 |