SOL SRI Exclusion Verification Report
Contents
Report Description
This report extracts all test records that are excluded from the the SOL Student Registration Import Report. The report includes test records that are marked as Excluded from SRI and students who already meet graduation requirements for the subject area of the associated test. This report must be run with the SOL Student Registration Import to ensure all required student registrations are submitted. If a student is included in this file that should be registered, this file is maintained in the same format as the SRI and the record can be easily copied then inserted into the SRI file.
Selection Criteria
Selection criteria determine which database records are used in the report.
School Selection
The school where the student is enrolled must not be excluded from state reporting.
Student Selection
The report selects student records based on the following criteria:
The student's SOL test must be excluded from SRI OR the student must have met graduation requirements in the subject area of the associated SOL test. For subject areas Math and Science, the student must have met both graduation and federal requirements.
The student must have a valid school enrollment during the terms in the report date range.
The student must not be excluded from state reporting.
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
Select Schools | If run at the district level, choose one of the following:
If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list. |
Students to Include | Indicate which students to include in the report by selecting one of the following options:
Note: If running the report for a single student, or group of students, select the students prior to running report. |
Report Start Date | Enter start date for the reporting period. Students with an active school enrollment on or after the start date are included in the report. Note: The Report Start Date defaults to the First Day defined for the current year in the District. |
Report End Date | Enter end date for the reporting period. Students with an active school enrollment on or before the end date are included in the report. Note: The Report End Date defaults to the Last Day defined for the current year in the District. |
Administrative Type | Choose Writing or Non-Writing for the type of test administered. This selection determines which qualifying tests are extracted. |
The Test Administration Season | Choose the Test Administration Season for which the report is being generated:
Note: The Test Administration Season selected has no effect on which records get extracted. The selection determines the filename and the output for Administration (column 1). |
The Year of the Test Administration (yyyy) | Enter the year the test was administered. |
Include Teachers Fields (Columns 52-52) | Choose Yes or No to indicate whether to include teacher fields in the report output. |
Column 9 value (If Group Name not defined at the Section Level) | If the Group Name is not defined at the section level, choose a value. |
Exclude TermIDs from the Report (comma separated list) | Enter in the TermID for the test enrollments that should not be extracted. |
Include Previous School Enrollments | Choose Yes or No. If Yes is chosen, the students with previous test enrollments are included in the report output. |
Include Only ReTesters | Choose Yes or No to indicate if the report output should include only retester students. |
Scheduling | Select when to run the report. |
Report Output
Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.
Item # | Data Element | Description | [Table]FieldName |
1 | Administration | The code representing the administration for which the student is being reported (e.g., wrtg1920 = Writing 2019-2020; nwfall19 = Non-Writing Fall 2019; or nwsprg20 = Non-Writing Spring 2020). | Derived |
2 | Student Last Name | The last name of the student who is excluded from the SRI report. Note: If populated, the student's legal name overrides the student's preferred name. | [StudentCoreFields]PSCore_Legal_Last_Name [Students]Last_Name |
3 | Student First Name | The first name of the student who is excluded from the SRI report. Note: If populated, the student's legal name overrides the student's preferred name. | [StudentCoreFields]PSCore_Legal_First_Name [Students]First_Name |
4 | Student Middle Name | The middle name of the student who is excluded from the SRI report. Note: If populated, the student's legal name overrides the student's preferred name. | [StudentCoreFields]PSCore_Legal_Middle_Name [Students]Middle_Name |
5 | Login ID | The student's TestNav login ID. | N/A |
6 | Division Code | The state-assigned code of the division where the student is enrolled. | [Prefs]value where [Prefs]name=”districtnumber” |
7 | School Code | The state-assigned code of the school where the student is enrolled. | [Schools]Alternate_School_Number [Students]SchoolID |
8 | Test Code | The test code. | [S_VA_Test_S]Code |
9 | Group Name | This field may contain a teacher name and period number, block number, or other common identifier. | [S_VA_STU_SecTestExcep_C]SDUGroupName [S_VA_SEC_X]SDUGroupName |
10 | Group Code | This optional field is available for use by divisions to further identify or track group information e.g., course number, section number, period number, or other identifier). | [S_VA_STU_SecTestExcep_C]SDUGroupCode [S_VA_SEC_X]SDUGroupCode |
11 | Date of Birth | The student’s date of birth. | [Students]DOB |
12 | Grade | The student's grade level. | [S_VA_STU_X]Grade_Level_Code [Students]Grade_Level |
13 | Gender | The student's gender. Note: If populated, the student's legal name overrides the student's preferred name. | [StudentCoreFields]PSCore_Legal_Gender [Students]Gender |
14 | State Testing Identifier (STI) | The student's state testing identifier. | [Students]State_StudentNumber |
15 | Ethnicity: Hispanic or Latino | A Yes or No field indicating if the student is Hispanic or Latino. | [Students]FedEthnicity |
16 | Race | The student’s race. | [StudentRace]RaceCd [S_VA_STU_X]Virginia_Ethnicity_Race_Code |
17 | Military Connected Student Code | This field indicates the student's connection to the military. | [S_VA_STU_X]Military_Connected |
18 | Multidivision Online Provider (MOP) | Indicates whether the student participated in a multi-divisional online provider (MOP) program. | [S_VA_STU_X]VA_MOPFlag If a value is stored, report Y, or report N |
19 | Resident Division | The resident division code for the MOP program | [S_VA_STU_X]MOP_Resident_Division |
20 | Virtual Virginia | This field displays 'Y' if the student was enrolled in the course associated with this test through the Virginia Department of Education's program, Virtual Virginia (VVA). Eligible Virginia students enroll in Virtual Virginia through their local schools. | [S_VA_STU_SecTestExcep_C]Virtial_Virginia_TF |
21 | Student Number | The student's locally assigned student number, if populated. | [Students]Student_Number |
22 | Initial Primary Nighttime Resident Code | If the student is classified as Homeless, this field contains the code indicating the student's primary nighttime residence. | [S_VA_STU_X]Primary_Nighttime_Res_Code |
23 | Foster Care | This field contains a Y if the student is in foster care. | [S_VA_STU_X]Foster_Care_Flag_TF |
24 | N-Code/Economically Disadvantaged | This field contains a Y if the student is classified as economically disadvantaged. | [S_VA_STU_X]Disadvantaged_TF |
25 | EL Overall Proficiency Level | If the student participated in WIDA ACCESS for ELLs 2.0 testing in Spring 2017, this field contains the student’s ACCESS for ELLs 2.0 Overall Proficiency Level. | [S_VA_STU_X]ELL_Composite_Score |
26 | Disability Status | If the student has a disability, the student's disability code is reported. | [S_VA_STU_X]Primary_Disability_Code |
27 | Temporary Condition | This field contains a Y for students who do not have an Individualized Education Program (IEP), 504 Management Plan, or EL Student Assessment Participation Plan but who, due to a temporary condition such as a broken arm or injured hand, are in need of a test accommodation to access the Virginia Standards of Learning (SOL) tests. | [S_VA_STU_X]Temporary_Condition_TF |
28 | Formerly EL | If the student meets English Language Proficiency (ELP) criteria, this field is populated. Valid values:
| [S_VA_STU_X]Formerly_EL |
29 | X-Code-B | This field is blank unless authorized by VDOE. | N/A |
30 | X-Code-C | This field is blank unless authorized by VDOE. | N/A |
31 | X-Code-D | This field is blank unless authorized by VDOE. | N/A |
32 | SOA Adjustment-EL | This field contains a value of Y if the student is currently classified as an EL AND the student has been enrolled in a Virginia public school for fewer than 11 semesters. Note: Students who are in membership for the majority of days in a semester are counted as enrolled for that semester. | [S_VA_STU_X]SOA_Adjustment_LEP_TF |
33 | Transfer | This field contains a Y if the student meets any of the Transfer criteria. See SOL SDU File Requirements for further details on data elements. | [S_VA_STU_X]SOA_Adjustment_Transfer_TF |
34 | Recently Arrived EL | This field contains a D if the student is classified as an EL AND has been enrolled in a U.S. schools less than 12 months. This includes EL students who enrolled in a U.S. school on or after the first day of school in the 2018-2019 school year. | [S_VA_STU_X]sol_ayp_d |
35 | Local Use Data – Student | This field is available for optional use by the school division. | N/A |
36 | Local Use Data – Test | This field is available for optional use by the school division. Valid values are A-Z, 0-9, and blank. | [S_VA_CRS_CRSTestExcep_C]LocalUseDataTest [S_VA_STU_SECTestExcep_C]LocalUseDataTest [S_VA_STU_Test_C]LocalUseDataTest |
36 | Online Testing | This field contains a Y if the student requires a paper test for a typically online test. This field applies to the specific test being assigned in field 8 (Test Code). | [S_VA_STU_SECTestExcep_C]papertesting |
37 | Session Name | The name of the test session. This field is only applicable if field 34 Online Testing is set to Y. Valid values include: 0-9, A-Z, space, and special characters: - ‘ ( ) / \ & + | [S_VA_STU_Test_C]AssessmentSession_Name and/or [S_VA_STU_SECTestExcep_C] AssessmentSession_Name and/or [S_VA_CRS_CRSTestExcep_C] AssessmentSession_Name |
38 | Recovery | This field contains a Y if the student is classified as described in Appendix A | [S_VA_STU_SECTestExcep_C]Recovery |
39 | Retest | This field contains a Y if the student is classified as described in Appendix A. | [S_VA_STU_SECTestExcep_C]Retest |
40 | D-Code | This field contains a Y if the student is in grades 9, 10, 11, or 12; taking Grade 8 Reading and/or grade 8 Mathematics; and pursuing a Modified Standard Diploma. | [S_VA_STU_X]SOL_D_Code_TF |
41 | SLIFE | This field displays a 'Y' if the student is classified as SLIFE (Students with Limited and/or interrupted Formal Education). | [S_VA_STU_X]SLIFE_Status_YN |
42 | Term Grad | For the Fall 2014 Writing Administration, this field contains a Y if the student is attempting to accrue sufficient verified credits to graduate by August 31, 2015. Although a Term Graduate student may take two EOC Writing tests, the student’s record should be uploaded with only one test assignment for the EOC Writing test. | [S_VA_STU_X]Term_Grad_Non_Writing_TF [S_VA_STU_X]TermGradWriting |
43 | Project Graduation | This field contains a Y for all Writing and Non-Writing SOL tests that would be administered to current Project Graduation students if the record was not excluded. | [S_VA_STU_SECTestExcep_C]ProjectGraduation [S_VA_STU_X]ProjectGraduation |
44 | Parent Requested | If the test is requested by a parent or guardian, a value of C is extracted. Otherwise, this field is blank. | [S_VA_STU_TEST_C]Parent_Req_Test_TF |
45 | Z-Code-E | This field is blank unless authorized by VDOE. | N/A |
46 | Z-CODE-F | This field is blank unless authorized by VDOE. | N/A |
47 | Z-Code-G | This field is blank unless authorized by VDOE. | N/A |
48 | Code VTLN | The Virginia Teacher Licensure Number (VTLN) for the teacher associated with the specific SOL test record. Note: This field is only included if the Include Teachers Fields parameter is set to Yes. | [Users]SIF_StatePrID |
49 | Code TLN | The last name of the teacher associated with the specific SOL test record. Note: This field is only included if the Include Teachers Fields parameter is set to Yes. | [Users]Last_Name |
50 | Code TFN | The first name of the teacher associated with the specific SOL test record. Note: This field is only included if the Include Teachers Fields parameter is set to Yes. | [Users]FIrst_Name |
51 | PNP Calculator | Indicates whether the student with disability requires the use of the Desmos Virginia calculator on test items of the Grades 6 or 7 Mathematics SOL computer adaptive tests (CAT) in which a calculator is not allowed. Valid values:
| [S_VA_STU_TEST_C]PNPCalculator_Indicator |
48 | End of Record | This field always contains a Y. | N/A |