Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse ROLES QUALIFIER NEW Table


View exposing alternate roles qualifier reference records including qualifier codes, names, types, cost collector attributes, and DLC attributes.


Field Name

Description

Data Type

Length

DLC_KEY

Surrogate key identifying the dlc.

VARCHAR2

15

QUALIFIER_CC

Qualifier cc associated with the record.

VARCHAR2

15

QUALIFIER_CODE

Code identifying qualifier.

VARCHAR2

15

QUALIFIER_KEY

Surrogate key identifying the qualifier.

NUMBER

12

QUALIFIER_NAME

Qualifier name associated with the record.

VARCHAR2

50

QUALIFIER_TYPE

Qualifier type associated with the record.

VARCHAR2

4

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE