External Test Scores
Tables are listed by alphabetical order. Clicking on a table name will display the fields/columns found in that table.
Table Name |
Description |
Type |
Primary Provider |
Sensitivity |
Load Frequency |
Last Load Date |
|---|---|---|---|---|---|---|
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. |
Dimension |
MIT Student Information System |
SENSITIVE |
Daily |
23-APR-2024 |
|
The time dimension table for the External Test Score Star Schema. It contains information about the year and the month the test was taken. |
Fact |
MIT Student Information System |
SENSITIVE |
Weekly |
23-APR-2024 |
|
A dimension table for the External Test Score Star Schema which contains all the external tests and test scores maintained by the Registrar's Office. Data items include Test Category (eg. "AP" for Advanced Placement, "TC" for Transfer Credit, "GC" for GCE A-Level, "AS" for Advanced Standing, etc.), Test Code, Test Component Code, Test Description, and Test Score Source. |
Dimension |
MIT Student Information System |
MIT ONLY |
Weekly |
23-APR-2024 |
|
Contains biograpic, registration, address (home, term, and office), and awarded degree data about all students (including both current and graduated students) of MIT. This table also contains records of applicants to MIT. Only users who are authorized to view records of all students have access to this table. Other users are given access to the STUDENT table. |
Dimension |
MIT Student Information System |
SENSITIVE |
Daily |
23-APR-2024 |
|
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. |
Fact |
MIT Student Information System |
SENSITIVE |
Daily |
23-APR-2024 |