S_VA_TEST_S (ver 14.9.0)
This is a standalone table for VA Tests.
Column Name | Version | Data Type | Description |
|---|---|---|---|
ID | 14.9.0 | Number(10,0) | System generated Primary Key. |
| S_VA_Test_Category_SID | 14.9.0 | Number(11,0) | Foreign Key to S_VA_Test_Category_S table. |
| Active | 14.9.0 | Number(1,0) | Indicates whether the test is active. |
Code | 14.9.0 | Varchar2(10) | Unique test code. |
| Description | 14.9.0 | Varchar2(4000) | Description of test. |
| Fed_Acc_Test_Req | 19.2.0 | Number(1,0) | Required for Federal Accountability (ESSA). |
| Grad_Subject_Area | 19.2.0 | Varchar2(10) | The graduation subject area. |
Name | 14.9.0 | Varchar2(100) | Name of test. |
| Sub_TestTypeCode | 18.8.0 | Number(11,0) | A code indicating the substitute test is taken instead of the SOL. |
| TestType | 14.9.0 | Varchar2(10) | Type of test (e.g., SOL, VGLA, VAAP, VSEP). |
| UIN | 18.8.0 | Varchar2(25) | The unique identifier assigned to each assessment by the testing company. |
| Test_Active_Date | 19.7.1 | Date | Verified Credit Status page/report uses this field to ensure that only the tests assigned to the course when the student was enrolled are displayed. |