Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse 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

EXTERNAL_CREDIT_GENERATED

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

08-JAN-2020

EXTERNAL_TEST_TIME

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

08-JAN-2020

EXTERNAL_TEST

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

08-JAN-2020

STUDENT_ALL

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

08-JAN-2020

EXTERNAL_TEST_SCORE_DETAIL

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

08-JAN-2020