Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse ROLES QUALIFIER CHILD Table


View exposing parent-child relationships among roles qualifiers used in authorization hierarchy processing.


Field Name

Description

Data Type

Length

CHILD_QUALIFIER_CODE

Code identifying child qualifier.

VARCHAR2

15

CHILD_QUALIFIER_KEY

Surrogate key identifying the child qualifier.

NUMBER

12

PARENT_QUALIFIER_CODE

Code identifying parent qualifier.

VARCHAR2

15

PARENT_QUALIFIER_KEY

Surrogate key identifying the parent qualifier.

NUMBER

12

PARENT_QUALIFIER_TYPE

Parent qualifier type associated with the record.

VARCHAR2

4

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE