Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse EXTERNAL CREDIT SUBJECT Table


View exposing subject reference data associated with external credit evaluation and assignment within student records processes.


Field Name

Description

Data Type

Length

APP_CREDIT_SUBJECT_CODE

Code identifying app credit subject.

VARCHAR2

20

APP_CREDIT_SUBJECT_NUMBER

App credit subject number associated with the record.

VARCHAR2

20

EXTERNAL_CREDIT_SUBJECT_KEY

Surrogate key identifying the external credit subject.

VARCHAR2

80

GEN_CREDIT_SUBJECT_CODE

Code identifying gen credit subject.

VARCHAR2

20

GEN_CREDIT_SUBJECT_NUMBER

Gen credit subject number associated with the record.

VARCHAR2

20

REG_SUBJECT_CODE

Code identifying reg subject.

VARCHAR2

3

REG_SUBJECT_NUMBER

Reg subject number associated with the record.

VARCHAR2

4

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE