Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse ROLES QUALIFIER Table


View exposing roles qualifier reference records including qualifier codes, names, types, categories, and record counter attributes.


Field Name

Description

Data Type

Length

RECORD_COUNTER

Record counter associated with the record.

NUMBER

ROLES_QUALIFIER_CATEGORY

Roles qualifier category associated with the record.

VARCHAR2

4

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

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE