Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse TQF DEPARTMENT ACCESS Table


View exposing TQF department-access detail including unit level, unit name, organization identifier, unit identifier, and sequence number.


Field Name

Description

Data Type

Length

TQF_UNIT_LEVEL

Tqf unit level associated with the record.

NUMBER

TQF_UNIT_ORG_ID

Business identifier for the tqf unit org.

VARCHAR2

1

TQF_UNIT_SEQ_NO

Tqf unit seq no associated with the record.

NUMBER

TQF_UNIT_UNIT_ID

Business identifier for the tqf unit unit.

VARCHAR2

6

TQF_UNIT_UNIT_NAME

Tqf unit unit name associated with the record.

VARCHAR2

50