Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse HR ORG UNIT Table


Master data table containing the new 8 digit department nuber, title, old department codes, and organization levels.


Field Name

Description

Data Type

Length

DLC_KEY

a unigue key to enable joining information stored with other forms of Department Key

VARCHAR2

15

DLC_NAME

The name of the DLC associated with this room set.

VARCHAR2

50

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_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