Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse EXTERNAL CREDIT RESULT DETAIL Table


View exposing detailed external credit result records including evaluation outcomes and related attributes used to determine recognized student academic credit.


Field Name

Description

Data Type

Length

APPLY_CREDIT_MESSAGE

Apply credit message associated with the record.

VARCHAR2

150

APP_CREDIT_UNITS

App credit units associated with the record.

VARCHAR2

20

COUNTER

Counter associated with the record.

NUMBER

DATA_EXTRACT_DATE

Date associated with data extract.

DATE

EXTERNAL_CREDIT_RULE_KEY

Surrogate key identifying the external credit rule.

VARCHAR2

20

EXTERNAL_CREDIT_SUBJECT_KEY

Surrogate key identifying the external credit subject.

VARCHAR2

80

EXTERNAL_TEST_GENERATED_KEY

Surrogate key identifying the external test generated.

VARCHAR2

18

GEN_CREDIT_UNITS

Gen credit units associated with the record.

VARCHAR2

20

MIT_ID

MIT ID number of the person. Use this field to join with other tables containing data about people at MIT.

VARCHAR2

9

REG_UNITS

Reg units associated with the record.

NUMBER

2

TRANSFER_CREDIT_SCHOOL_NAME

Transfer credit school name associated with the record.

VARCHAR2

100

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE