Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse EPR ACL Table


View exposing access control data used to manage permissions for Employee Professional Record data and related professional profile information.


Field Name

Description

Data Type

Length

KERBEROS_NAME

Kerberos name associated with the record.

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

Business identifier for the roles function.

NUMBER

ROLES_FUNCTION_NAME

Roles function name associated with the record.

VARCHAR2

50

ROLES_QUALIFIER_CODE

Code identifying roles qualifier.

VARCHAR2

15

ROLES_QUALIFIER_MIT_ID

Business identifier for the roles qualifier mit.

VARCHAR2

9

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE