S_VA_STU_TEST_C (ver 14.9.0)
This table is a child table of [Students] table and is used to relate SOL tests exceptions of test assigned to the student (e.g., outside of class enrollment).
Column Name | Version | Data Type | Description |
|---|---|---|---|
ID | 14.9.0 | Number(10,0) | System generated Primary Key. |
| StudentsDCID | 14.9.0 | Number(10,0) | Foreign Key to Students table. |
S_VA_TEST_SID | 14.9.0 | Number(11,0) | Foreign Key to S_VA_TEST_S table. |
| ExcludeFromSDU | 14.9.0 | Number(1,0) | Indicator to determine whether to extract for Student Data Upload File. |
| LocalCourseNumber | 14.9.0 | Varchar2(11) | Maps to [Courses]course_number, will be used for verified credit. |
| LocalUseDataTest | 16.10.0 | Varchar2(9) | Column 42 in SOL SDU Student Data Upload File Requirements. |
| PaperTesting | 14.9.0 | Number(1,0) | Column 41 in SOL Student Data Upload File Requirements. |
| Parent_Req_Test_TF | 19.2.0 | Number(1,0) | Indicate if an associated student test is parent requested |
| ProjectGraduation | 14.9.0 | Number(1,0) | Column 46 in SOL Student Data Upload File Requirements. Column 45 in VAAP, VGLA, VSEP Student Data Upload File Requirements. |
Recovery | 14.9.0 | Number(1,0) | Column 42 in SOL Student Data Upload File Requirements. Column 41 in VAAP, VGLA, VSEP Student Data Upload File Requirements. |
| ReTest | 14.9.0 | Number(1,0) | Column 43 in SOL Student Data Upload File Requirements. Column 42 in VAAP, VGLA, VSEP Student Data Upload File Requirements. |
| SchoolId | 14.9.0 | Number(11,0) | School Id (e.g., [Schools]school_number) of test assigned to the student. |
| SDUGroupCode | 15.4.0 | Varchar2(10) | Column 10 in SOL SDU Student Data Upload File Requirements. Column 10 in VAAP, VGLA, VSEP Student Data Upload File Requirements. |
| SDUGroupName | 15.4.0 | Varchar2(20) | Column 9 in SOL Student Data Upload File Requirements. Column 9 in VAAP, VGLA, VSEP Student Data Upload File Requirements. |
| TermId | 14.9.0 | Number(11,0) | Term Id of test assigned to the student. |
| AssessmentSession_Name | 17.11.22 | Varchar2(30) | Assessment Session Name |
| Virtual_Virginia_TF | 22.2.1.0 | Number(1,0) | Initiated via Virtual Virginia |