ROLES DETAIL Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
KRB_NAME |
Kerberos Name |
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 |
|
ROLES_FUNCTION_KEY |
XXX |
NUMBER |
|
ROLES_FUNCTION_NAME |
XXX |
VARCHAR2 |
50 |
ROLES_QUALIFIER_CODE |
XXX |
VARCHAR2 |
15 |
ROLES_QUALIFIER_KEY |
XXX |
NUMBER |
12 |
ROLES_QUALIFIER_NAME |
XXX |
VARCHAR2 |
50 |
ROLES_QUALIFIER_TYPE |
XXX |
VARCHAR2 |
4 |
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 |
9 |
ROLE_ASSIGN_TYPE_CODE |
XXX |
VARCHAR2 |
1 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |