EXTERNAL TEST SCORE DETAIL Table
This table contains (freshman) external test score information. Data in the table includes all tests and raw test scores maintained by MIT for Advanced Placement (AP), International baccalaureate exams, A-level exams, Transfer credit, Advanced Standing and Freshman Essay Evaluation. Students included in this table are those with an entrance term code of Summer 2003 (2003SU) and beyond, and who were eligible to register for the term.
Field Name |
Description |
Data Type |
Length |
---|---|---|---|
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_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 |
EXTERNAL_TEST_KEY |
Use this field to join together the EXTERNAL TEST and the EXTERNAL TEST SCORE DETAIL tables. |
VARCHAR2 |
12 |
EXTERNAL_TEST_TIME_KEY |
Use this field to join together the EXTERNAL TEST TIME and the EXTERNAL TEST SCORE DETAIL tables. |
VARCHAR2 |
6 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
TEST_SCORE_VALUE |
Test score. |
VARCHAR2 |
7 |
TEST_TAKEN_ACTIVITY_DATE |
Last update date of the test score information. This date gets updated when a change is made to the test taken information. It may be useful in identifying that a score source has been changed. |
DATE |
8 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |