Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse EXTERNAL CREDIT GENERATED Table


This table "integrates" the test scores with the credit results generated. Join this table with the EXTERNAL TEST SCORE DETAIL table to get the credit results generated from the tests.


Field Name

Description

Data Type

Length

APPLY_CREDIT_MESSAGE

Message/note associated with an applied credit. Some of the more common messages are: "No credit because registered for subject" (ie. the student is qualifed for a generated and an applied credit for the subject but did not get a credit because he had already registered for the subject.) and "Credit was manually applied" (ie. the credit was manually applied, and in this case, the APP CREDIT SUBJECT CODE field usually contains the value 'APPL', and the APP CREDIT SUBJECT NUMBER field contains a 'MAN').

VARCHAR2

150

APP_CREDIT_SUBJECT_CODE

Applied credit subject code.

VARCHAR2

20

APP_CREDIT_SUBJECT_NUMBER

The subject number in the applied credit subject. (Eg. "01" in the subject "18.01")

VARCHAR2

20

APP_CREDIT_UNITS

Applied credit units.

VARCHAR2

20

CREDIT_RESULT_CATEGORY

Credit rule category. Some of the categories are: 'IB' - international baccalaureate, 'AL' - GCE A-Level, 'AP' - Advanced Placement, 'TC' - Transfer Credit.

VARCHAR2

2

CREDIT_RESULT_DESC

Description of the credit result rule.

VARCHAR2

50

CREDIT_RESULT_NAME

Name of the credit result rule.

VARCHAR2

20

CREDIT_RULE_DATE

Date when the credit rule was last updated.

DATE

8

EXTERNAL_CREDIT_GENERATED_KEY

Use this field to join together the EXTERNAL CREDIT GENERATED and the EXTERNAL TEST SCORE DETAIL tables for the credits that are associated (generated and/or applied) with the external tests.

VARCHAR2

19

GEN_CREDIT_SUBJECT_CODE

Generated credit subject code.

VARCHAR2

20

GEN_CREDIT_SUBJECT_NUMBER

The subject number in the generated credit subject. (Eg. "01" in the subject "18.01")

VARCHAR2

20

GEN_CREDIT_UNITS

Generated credit units.

VARCHAR2

20

REG_SUBJECT_CODE

Registration subject code. This represents the subject code for applied credit in the student's academic record.

VARCHAR2

3

REG_SUBJECT_NUMBER

Registration subject number. This represents the subject number of a subject for applied credit in the student's academic record.

VARCHAR2

4

REG_UNITS

Number of registration units for the applied credit in the student's academic record.

NUMBER

2

TRANSFER_CREDIT_SCHOOL_NAME

The name of the school from where the transfer credit is granted.

VARCHAR2

100

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE

8