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 |