		Home About IS&T Contact IS&T Site Map	Search Advanced Search

	Related Links:
	Data and Reporting Services

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
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	Student Services Information Technology (SSIT)	SENSITIVE	Daily	12-OCT-2008
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	Student Services Information Technology (SSIT)	SENSITIVE	Daily	10-OCT-2008
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	Student Services Information Technology (SSIT)	SENSITIVE	Weekly	12-OCT-2008
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	Student Services Information Technology (SSIT)	SENSITIVE	Weekly	12-OCT-2008
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	Student Services Information Technology (SSIT)	SENSITIVE	Daily	10-OCT-2008


		Home \| Getting Started \| Getting Services \| Getting Help \| About IS&T \| Accessibility Ask a technology question or send a comment about this web page.