EXTERNAL CREDIT RESULT DETAIL Table
This table contains credit results that are generated from and/or applied to the freshmen external tests such as Advanced Placement, International Baccalaureate, GCE A-Level, Transfer Credit, and Advanced Standing. Generated credits result from applying the MIT credit rules associated with specific tests. Applied credit is the actual credit applied to a student's academic record. Students and/or the Registrar's Office may apply credit differently from the way it is initially generated based on the subjects the student students register for and also other factors. Credit comes in two forms: Credit for a specific subject (as specified in SUBJECT CODE and SUBJECT NUMBER) with associated units, and general elective credit units.
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_UNITS |
Applied credit units. |
VARCHAR2 |
20 |
COUNTER |
Numeric field used to count entries in a table. Can be summed on a report. Example - if this field appeared on a table of Person information, it could be used on reports to show headcounts. |
NUMBER |
1 |
DATA_EXTRACT_DATE |
Date when the external test score record was extracted from MITSIS. |
DATE |
8 |
EXTERNAL_CREDIT_RULE_KEY |
Use this field to join together the EXTERNAL CREDIT RULE and the EXTERNAL CREDIT RESULT DETAIL tables. |
VARCHAR2 |
20 |
EXTERNAL_CREDIT_SUBJECT_KEY |
Use this field to join together the EXTERNAL CREDIT RESULT DETAIL and the EXTERNAL CREDIT SUBJECT tables for the generated, applied and registrered subject information associated with the external test credit result. |
VARCHAR2 |
30 |
EXTERNAL_TEST_GENERATED_KEY |
Use this field to join together the EXTERNAL TEST GENERATED and the EXTERNAL CREDIT RESULT DETAIL tables for the external tests that are associated with the generated or applied credits. |
VARCHAR2 |
17 |
GEN_CREDIT_UNITS |
Generated credit units. |
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 |
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 |