Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse ROLES FUNCTION Table


View exposing roles function reference records including function names, descriptions, categories, qualifier types, primary authorization indicators, and audit fields.


Field Name

Description

Data Type

Length

RECORD_COUNTER

Record counter associated with the record.

NUMBER

ROLES_FUNCTION_CATEGORY

Roles function category associated with the record.

VARCHAR2

4

ROLES_FUNCTION_CATEGORY_CODE

Code identifying roles function category.

VARCHAR2

4

ROLES_FUNCTION_CREATE_USER

Roles function create user associated with the record.

VARCHAR2

8

ROLES_FUNCTION_DESCRIPTION

Description of roles function.

VARCHAR2

50

ROLES_FUNCTION_KEY

Surrogate key identifying the roles function.

NUMBER

ROLES_FUNCTION_NAME

Roles function name associated with the record.

VARCHAR2

30

ROLES_FUNCTION_PRIMARY_AUTH

Roles function primary auth associated with the record.

VARCHAR2

1

ROLES_FUNCTION_QUALIFIER_TYPE

Roles function qualifier type associated with the record.

VARCHAR2

4

ROLES_FUNCTION_UPDATE_DATE

Date associated with roles function update.

DATE

ROLES_FUNCTION_UPDATE_USER

Roles function update user associated with the record.

VARCHAR2

8

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE