Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse EPR SUPER ACL Table


XXX


Field Name

Description

Data Type

Length

KERBEROS_NAME

The Kerberos username of the person. If this field starts with a dollar sign ($), then it is not a real Kerberos username, but an algorithmically generated pseudo Kerberos username, used as a placeholder in the EHS system.

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

ROLES_FUNCTION_ID

XXX

NUMBER

ROLES_FUNCTION_NAME

XXX

VARCHAR2

50

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE