Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse SSM SUBJECT TYPE Table


View exposing subject-type and cluster-type assignments by term and converted master-subject identifier.


Field Name

Description

Data Type

Length

CLUSTER_TYPE

Cluster type associated with the record.

VARCHAR2

1

CONVERTED_MASTER_SUBJECT_ID

Business identifier for the converted master subject.

VARCHAR2

8

SUBJECT_TYPE

Subject type associated with the record.

VARCHAR2

20

TERM_CODE

Term code associated with the record.

VARCHAR2

6

WAREHOUSE_INSERT_TIMESTAMP

Warehouse insert timestamp associated with the warehouse record.

DATE

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE

WAREHOUSE_UPDATE_TIMESTAMP

Warehouse update timestamp associated with the warehouse record.

DATE