ADM GRAD TEST Table
Information about the various standardized graduate admissions tests such as: GRE, and TOEFL.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADM_GRAD_TEST_KEY |
Graduate Admissions Test Key. Use this field to join the ADM GRAD TEST table to the Graduate Admissions Application fact table (ADM GRAD APPLICATION DETAIL). |
VARCHAR2 |
12 |
IS_GRE |
Is this part of a GRE test? Y or N |
VARCHAR2 |
1 |
IS_PERCENT_ASSOCIATED |
XXX |
VARCHAR2 |
1 |
IS_TEST_FOR_GRADUATE |
Is this a standardized test for graduate admissions? Y, N. |
VARCHAR2 |
1 |
IS_TEST_FOR_INTERNATIONAL |
Is this a standardized test required for international students? Y, N. |
VARCHAR2 |
1 |
IS_TEST_FOR_UNDERGRADUATE |
Is this a standardized test for undergraduatge admissions? Y, N. |
VARCHAR2 |
1 |
IS_TOEFL |
Is this part of the TOEFL test? Y, N. |
VARCHAR2 |
1 |
LAST_ACTIVITY_DATE |
Date when information in the record was last updated. |
DATE |
8 |
MAXIMUM_VALUE |
Maximum score value for the test. |
VARCHAR2 |
7 |
MINIMUM_VALUE |
Minimum score value for the test. |
VARCHAR2 |
7 |
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 |
Source of the test score. |
VARCHAR2 |
30 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |