EXTERNAL TEST Table
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.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
EXTERNAL_TEST_KEY |
Use this field to join together the EXTERNAL TEST and the EXTERNAL TEST SCORE DETAIL tables. |
VARCHAR2 |
12 |
IS_HASS_ELIGIBLE_TEST |
A 'Y' in this field in this field indicates that this AP test is eligible for HASS general elective credit. |
VARCHAR2 |
1 |
TEST_CATEGORY_CODE |
The category in which the (freshman) external test is in. Valid categories include: "AP" (advanced placement), "AS" (advanced standing), "TC" (transfer credit), "IB" (International Baccalaureate), "GC" (GCE A-Level), etc. |
VARCHAR2 |
2 |
TEST_CATEGORY_DESC |
Descriptive text for TEST_CATEGORY_CODE. |
VARCHAR2 |
30 |
TEST_CODE |
Test identifier. For Graduate Admissions Test data, the test identifiers include: AP, GCE, GRE, TOEFL. For Freshman External Test Score data, the test identifiers include: GCE, IB, TC, ASCHM, ASMTH, ASPHY, FEE, FRADV, MATHD. |
VARCHAR2 |
5 |
TEST_COMPONENT_CODE |
Test component within a test code. Some of the test components for TOEFL are: TWE, SECT1, SECT2, SECT3; for GRE, some of the test components are: ANALY, QUANT, VERB, and WRIT. For Freshman External Tests, some of the test component codes are: '07' (US History), '66' (Calc AB), '68' (Calc BC), '20' (Biology) for Advanced Placement (AP); 'IBB' (IB Biology), 'IBM' (IB Calculus), 'IBP' (IB Physics) for Internal Baccalaureate (IB); 'GEN' for General Transfer Credit and 'MATH' for Transfer Credit in Mathematics. |
VARCHAR2 |
5 |
TEST_DESCRIPTION |
Description of the test. |
VARCHAR2 |
30 |
TEST_SCORE_SOURCE_CODE |
Source of the test score. |
VARCHAR2 |
2 |
TEST_SCORE_SOURCE_DESC |
Descriptive text for TEST_SCORE_SOURCE_CODE. |
VARCHAR2 |
30 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |