ROLES DETAIL Table
View exposing person-level role assignment records including MIT identifiers, Kerberos usernames, roles functions, qualifiers, assignment types, and record counter attributes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
KRB_NAME |
Krb 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 |
RECORD_COUNTER |
Record counter associated with the record. |
NUMBER |
|
ROLES_FUNCTION_KEY |
Surrogate key identifying 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_KEY |
Surrogate key identifying the roles qualifier. |
NUMBER |
12 |
ROLES_QUALIFIER_NAME |
Roles qualifier name associated with the record. |
VARCHAR2 |
50 |
ROLES_QUALIFIER_TYPE |
Roles qualifier type associated with the record. |
VARCHAR2 |
4 |
ROLE_ASSIGNMENT_TYPE |
Role assignment type associated with the record. |
VARCHAR2 |
9 |
ROLE_ASSIGN_TYPE_CODE |
Code identifying role assign type. |
VARCHAR2 |
1 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |