EXTERNAL TEST GENERATED Table
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.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CREDIT_RULE_DATE |
Date when the credit rule was last updated. |
DATE |
8 |
EXTERNAL_TEST_GENERATED_KEY |
Use this field to join together the EXTERNAL TEST GENERATED and the EXTERNAL CREDIT RESULT DETAIL tables for the external tests that are associated with the generated or applied credits. |
VARCHAR2 |
17 |
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_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_SCORE_SOURCE_CODE |
Source of the test score. |
VARCHAR2 |
2 |
TEST_SCORE_SOURCE_DESC |
Descriptive text for TEST_SCORE_SOURCE_CODE. |
VARCHAR2 |
30 |
TEST_SCORE_VALUE |
Test score. |
VARCHAR2 |
7 |
TEST_SHORT_DESCRIPTION |
Short description of the test. |
VARCHAR2 |
20 |
TEST_TAKEN_MONTH |
Month (in numeric) when the test was taken. |
VARCHAR2 |
2 |
TEST_TAKEN_YEAR |
Year when the test was taken. |
VARCHAR2 |
4 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |