Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse External Test Credit Results


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_TEST_GENERATED

This table "integrates" the credit results with the test scores. Join this table with the EXTERNAL CREDIT RESULT DETAIL table to get the tests from which the credit results were generated.

Dimension

MIT Student Information System

SENSITIVE

Daily

08-JAN-2020

EXTERNAL_CREDIT_RULE

A dimension table for the External Test Credit Result Star Schema. It contains the credit rule names and categories.

Dimension

MIT Student Information System

SENSITIVE

Daily

08-JAN-2020

EXTERNAL_CREDIT_SUBJECT

A dimension table for the External Test Credit Result Star Scema. It contains the generated, applied and registration subject codes and numbers for the credit results.

Fact

MIT Student Information System

SENSITIVE

Daily

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_CREDIT_RESULT_DETAIL

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.

Fact

MIT Student Information System

SENSITIVE

Daily

08-JAN-2020