Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse EFPR PEOPLE Table


XXX


Field Name

Description

Data Type

Length

FULL_NAME

The full name of the person.

VARCHAR2

100

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

KRB_NAME_UPPERCASE

The Kerberos username of a person, in uppercase.

VARCHAR2

8

MIT_ID

MIT ID number of the person. Use this field to join with other tables containing data about people at MIT.

VARCHAR2

9