ADM GRAD TEST SCORE DETAIL Table
This is a fact table which contains a record for a test score of a standardized graduate admissions test (e.g. GRE, TOEFL). The record also includes the date the test was taken and the source of the test score.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADM_GRAD_APPLICANT_KEY |
Graduate admissions applicant key. This field is used to join ADM GRAD APPLICANT table and a Graduate Admissions fact table (e.g. ADM GRAD APPLICATION DETAIL, ADM GRAD TEST SCORE DETAIL and ADM GRAD ATTENDED SCHOOL). |
VARCHAR2 |
8 |
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 |
ADM_GRAD_TEST_TAKEN_TIME_KEY |
XXX |
VARCHAR2 |
6 |
IS_HIGHEST_SCORE |
A flag (Y/N) indicates whether this is the highest score of all the same admissions tests submitted to the Admissions Office. |
VARCHAR2 |
1 |
SCORE_PERCENT |
Percent of test score. |
NUMBER |
22 |
SCORE_VALUE |
Score of the admissions test. |
NUMBER |
22 |
TEST_SCORE_UPDATED_DATE |
Date when this test score record was last modified/updated. |
DATE |
8 |
TEST_TAKEN_UPDATED_DATE |
Date when the test taken data was last modified/updated. |
DATE |
8 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |