ADM GRAD TEST Table
View exposing graduate admissions test reference data including test codes, descriptions, source, score ranges, and test-category indicators used for graduate admissions reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADM_GRAD_TEST_KEY |
Surrogate key identifying the adm grad test. |
VARCHAR2 |
12 |
IS_GRE |
Indicator identifying whether gre (Y/N). |
VARCHAR2 |
1 |
IS_PERCENT_ASSOCIATED |
Indicator identifying whether percent associated (Y/N). |
VARCHAR2 |
1 |
IS_TEST_FOR_GRADUATE |
Indicator identifying whether test for graduate (Y/N). |
VARCHAR2 |
1 |
IS_TEST_FOR_INTERNATIONAL |
Indicator identifying whether test for international (Y/N). |
VARCHAR2 |
1 |
IS_TEST_FOR_UNDERGRADUATE |
Indicator identifying whether test for undergraduate (Y/N). |
VARCHAR2 |
1 |
IS_TOEFL |
Indicator identifying whether toefl (Y/N). |
VARCHAR2 |
1 |
LAST_ACTIVITY_DATE |
Date associated with last activity. |
DATE |
|
MAXIMUM_VALUE |
Maximum value as provided by the source. |
VARCHAR2 |
7 |
MINIMUM_VALUE |
Minimum value as provided by the source. |
VARCHAR2 |
7 |
TEST_CODE |
Code identifying test. |
VARCHAR2 |
5 |
TEST_COMPONENT_CODE |
Code identifying test component. |
VARCHAR2 |
5 |
TEST_DESCRIPTION |
Description of test. |
VARCHAR2 |
30 |
TEST_SCORE_SOURCE |
Test score source as provided by the source. |
VARCHAR2 |
30 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |