Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse ROLES REPORTING DETAIL Table


View exposing summarized role assignment reporting records by Kerberos username, roles function, qualifier, assignment type, and function category.


Field Name

Description

Data Type

Length

FUNCTION_CATEGORY_CODE

Code identifying function category.

VARCHAR2

4

KRB_NAME_UPPERCASE

Krb name uppercase associated with the record.

VARCHAR2

8

ROLES_ASSIGNMENT_TYPE_CODE

Code identifying roles assignment type.

VARCHAR2

1

ROLES_FUNCTION_KEY

Surrogate key identifying the roles function.

NUMBER

ROLES_QUALIFIER_KEY

Surrogate key identifying the roles qualifier.

NUMBER

12