EXTERNAL TEST GENERATED Table
View exposing generated external test records associated with students, including processed test attributes used for placement and academic credit evaluation.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CREDIT_RULE_DATE |
Date associated with credit rule. |
DATE |
|
EXTERNAL_TEST_GENERATED_KEY |
Surrogate key identifying the external test generated. |
VARCHAR2 |
17 |
IS_HASS_ELIGIBLE_TEST |
Indicator identifying whether hass eligible test (Y/N). |
VARCHAR2 |
1 |
TEST_CATEGORY_CODE |
Code identifying test category. |
VARCHAR2 |
2 |
TEST_CODE |
Code identifying test. |
VARCHAR2 |
5 |
TEST_COMPONENT_CODE |
Code identifying test component. |
VARCHAR2 |
5 |
TEST_SCORE_SOURCE_CODE |
Code identifying test score source. |
VARCHAR2 |
2 |
TEST_SCORE_SOURCE_DESC |
Description of test score source. |
VARCHAR2 |
30 |
TEST_SCORE_VALUE |
Test score value associated with the record. |
VARCHAR2 |
7 |
TEST_SHORT_DESCRIPTION |
Description of test short. |
VARCHAR2 |
20 |
TEST_TAKEN_MONTH |
Test taken month associated with the record. |
VARCHAR2 |
2 |
TEST_TAKEN_YEAR |
Test taken year associated with the record. |
VARCHAR2 |
4 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |