ADM GRAD TEST SCORE DETAIL Table
View exposing graduate applicant test score detail by applicant, test, and test-taking time including score values, percentages, and highest-score indicator used for graduate admissions reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADM_GRAD_APPLICANT_KEY |
Surrogate key identifying the adm grad applicant. |
VARCHAR2 |
9 |
ADM_GRAD_TEST_KEY |
Surrogate key identifying the adm grad test. |
VARCHAR2 |
12 |
ADM_GRAD_TEST_TAKEN_TIME_KEY |
Surrogate key identifying the adm grad test taken time. |
VARCHAR2 |
6 |
IS_HIGHEST_SCORE |
Indicator identifying whether highest score (Y/N). |
VARCHAR2 |
1 |
SCORE_PERCENT |
Score percent as provided by the source. |
NUMBER |
4,1 |
SCORE_VALUE |
Score value as provided by the source. |
NUMBER |
6,1 |
TEST_SCORE_UPDATED_DATE |
Date associated with test score updated. |
DATE |
|
TEST_TAKEN_UPDATED_DATE |
Date associated with test taken updated. |
DATE |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |