EXTERNAL TEST Table
View exposing external test records associated with students, including test attributes used for placement, credit evaluation, and student records reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
EXTERNAL_TEST_KEY |
Surrogate key identifying the external test. |
VARCHAR2 |
12 |
IS_HASS_ELIGIBLE_TEST |
Indicator identifying whether hass eligible test (Y/N). |
VARCHAR2 |
1 |
TEST_CATEGORY_CODE |
Code identifying test category. |
VARCHAR2 |
2 |
TEST_CATEGORY_DESC |
Description of test category. |
VARCHAR2 |
100 |
TEST_CODE |
Code identifying test. |
VARCHAR2 |
5 |
TEST_COMPONENT_CODE |
Code identifying test component. |
VARCHAR2 |
5 |
TEST_DESCRIPTION |
Description of test. |
VARCHAR2 |
20 |
TEST_SCORE_SOURCE_CODE |
Code identifying test score source. |
VARCHAR2 |
2 |
TEST_SCORE_SOURCE_DESC |
Description of test score source. |
VARCHAR2 |
30 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |