Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse EHS ROLES DETAIL Table


EHS Roles detail


Field Name

Description

Data Type

Length

EHS_ROLES_FUNCTION_KEY

Key field used to join to the EHS_ROLES_FUNCTION table. This field should only be used for joining data, NOT for reporting

NUMBER

6

EHS_ROLES_QUALIFIER_KEY

Key field used to join to the EHS_ROLES_QUALIFIER table. This field should only be used for joining data, NOT for reporting.

NUMBER

12

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

RECORD_COUNTER

Used to count records within a group on a report. Always contains a value of 1.

NUMBER

1

ROLE_ASSIGNMENT_TYPE

'Direct' means that the authorization was directly assigned. 'Inherited' means that the authorization was assigned at a higher level in the hierarchy. For example, if an authorization is assigned for D_SCHOOL_SCI, then you will see one record where the qualifier maps to 'D_SCHOOL_SCI' and the roles_assignment_type='Direct' and several other records mapping to departments within the school of science (e.g., for 'D_BIOLOGY') with roles_assignment_type='Inherited'.

VARCHAR2

30

WAREHOUSE_LOAD_DATE

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

DATE

8