SOL Student Data Upload – SRP

Select Schools*

If run at the district level, choose one of the following:

• Select Multiple Schools – Select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included. Select schools to include in the report
• All Schools – Run the report for the entire district.

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:

• The selected [number] students only – Run the report for students in the current selection.

• All students – Run the report for all students in the current school or district that meet the selection criteria.

Report Start Date*

Enter the start date for the reporting period. Incidents must occur on or after this date)*

Note: The Report Start Date defaults to the First Day defined for the current year in the District.

Report End Date*

Enter the end date for the reporting period. (Incidents must occur on or after this date)*

Note: The Report End Date defaults to the Last Day defined for the current year in the District.

Administration Type

Select from the pop-up menu the Test Administration Season for which the report is running for.

Note: The Test Administration Season selected has not effect on which records get extracted. The selection is used to determine the filename and Column 1 in the output file.

The year of the Test Administration (yyyy)*

Enter in the year of the Test Administration

Include Teachers Fields (Columns 52-52)

Select Yes/No from the pop-up menu.

Column 9 value (If Group Name not defined at the Section Level)

If the Group Name is not defined at the section level select a value from the pop-up menu.

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

From the pop-up menu select No/Yes. If Yes is selected then students with previous test enrollments will be included.

Show column Field Headers

Select Yes from the pop-up menu for validation purposes.

Scheduling

Select when to run the report.

1

Administration

This field must contain the code representing the administration for which the student is being registered (e.g., wrtg1415 = Writing 2014-2015 or nwfall14 = Non-Writing Fall 2014).

Derived

N/A

N/A

2

Student Last Name

This field must contain the student’s last name.

[students]last_name

String

1-50

3

Student First Name

This field must contain the student’s first name.

[students]first_name

String

1-50

4

Student Middle Initial

The student’s middle initial is not a required field. The limit is 1 character.

[students]middle_name

String

1-20

5

Login ID

This field may contain a unique 10-character ID for a student to use when logging in to TestNav, the online testing application. If this field is left empty, a unique 10-digit number will be assigned as the Login ID for each student.

N/A

N/A

N/A

6

Division Code

This field must contain the three-digit division code assigned to your division by the state.

[prefs]value where [prefs]name=”districtnumber”

String

Variable

7

School Code

This field must contain the four-digit school code assigned to a particular school by the state.

[schools] alternate_school_number

[students]schoolId

String

Integer

Variable

N/A

8

Test Code

This field should contain a valid test code

[s_va_test_s]code

String

1-10

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

String

1-20

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]sdugroupcpde

String

1-10

11

Date of Birth

This field must contain the student’s date of birth and must match the four other associated fields for the student within PearsonAccess including the student’s First and Last Name, Gender, and STI.

[students]dob

Date

N/A

12

Grade

This field contains the student’s grade level and must be one of the following values (leading zeros are required): 01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12, TT

[students]va_gradecode]

[students]grade_level

String

Integer

2

N/A

13

Gender

This field must contain the code representing the student’s gender.

[students]gender

String

1

14

State Testing Identifier (STI)

This field must contain the student’s STI

[students] state_studentNumber

String

1-32

15

Ethnicity: Hispanic

This field must contain a Y if the student’s ethnicity is Hispanic or an N if the student’s ethnicity is Not Hispanic.

[students]fedethnicity

Integer

N/A

16

Race

This 2-character numeric field should contain a code representing the student’s race.

[students]va_ercode

String

2

17

Military Connected Student Code

This field contains an indicator of student’s military connectedness.

Valid values = 1, 2, 3, 4

[S_VA_STU_X]Military_Connected

Alpha-numeric

1

18

Student Number

This field contains a locally assigned student number (optional).

[students] student_number

Integer

N/A

19

Initial Primary Nighttime Resident Code

This field should contain a Y if the student is classified as Homeless.

[students] va_primnight_rescode

Alpha-numeric

1

20

Foster Care

This field should contain a Y if the student is in a foster care setting.

[Students]VA_FosterCare

Alpha-numeric

1

21

N-Code/Economically Disadvantaged

This field should contain a Y if the student is classified as economically disadvantaged.

[students]va_disadvantaged

Integer

N/A

22

ELL Test Tier

If the student participated in WIDA® ACCESS for ELLs® testing in Spring 2014, this field must be A, B, or C to represent the tier of the test completed.

[students]va_ell_test_tier

String

1

23

ELL Overall Proficiency Level

If the student participated in WIDA® ACCESS for ELLs® testing in Spring 2014, this field must contain the student’s ACCESS for ELLs® Composite Proficiency Level.

[students]va_ell_composite_score]

String

1-10

24

ELL Literacy Proficiency Level

If the student participated in WIDA® ACCESS for ELLs® testing in Spring 2014, this field should contain the student’s ACCESS for ELLs® Literacy Proficiency Level.

[students]va_ell_literacy_score

String

1-10

25

Disability Status

The disability status field must be used for any student who is identified as having a disability.

[students]va_primary_dis_code

String

2

26

Temporary Condition

This field should contain a Y for students who do not have an Individualized Education Program (IEP), 504 Management Plan, or LEP 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.

[students]va_sol_temp_cond

Integer

N/A

27

Formerly LEP

This field should be Y for students who met the English Language Proficiency (ELP) criteria.

[students]va_lep_serv_cd

Integer

N/A

28

X-Code-B

This field should be left blank unless authorized by VDOE.

N/A

N/A

N/A

29

X-Code-C

This field should be left blank unless authorized by VDOE.

N/A

N/A

N/A

30

X-Code-D

This field should be left blank unless authorized by VDOE.

N/A

31

SOA Adjustment-LEP

This field should contain a value of Y if the student has not met the English Language Proficiency (ELP) criteria (See field 27 for additional details on ELP criteria) AND the student has been enrolled in a Virginia public school for less than 11 semesters. Students who are in membership for the majority of days in a semester are considered to have been enrolled for that semester.

[students]sol_soa_lep

Integer

N/A

32

SOA Adjustment-Transfer

This field should contain a Y if the student meets any of the Adjustment Transfer criteria- See SOL SDU File Requirements for further details on data elements.

[students]sol_soa_transfer

Integer

N/A

33

AYP Adjustment-A

Transfer from within division -This field should be A if the student was enrolled in the Division on or before September 30 of the school year and has been continuously enrolled in the same division after that date. The student must have transferred to another school within the same division anytime between the initial enrollment date and the date of testing.

[students] sol_ayp_a

String

1

34

AYP Adjustment-B

Transfer from outside division from within Virginia This field should be B if the student was enrolled in a Virginia public school on or before September 30 of the school year and has been continuously enrolled in a Virginia public school after that date. The student must have transferred between school divisions anytime between the initial enrollment date and the date of testing.

[students]sol_ayp_b

String

1

35

AYP Adjustment-C

Transfer from outside the state This field should be C if the student was not enrolled in a Virginia public school on or before September 30 of the school year and transferred into a Virginia public school between October 1 and up to the date of testing and/or has not been continuously enrolled in a Virginia public school throughout the school year up to the first date of testing.

[students]sol_ayp_c

String

1

36

AYP Adjustment-D

Student Classified as LEP and enrolled in U.S. schools less than 12 months This field should be D for students who are classified as LEP and who have been enrolled in U.S. schools for less than 12 months. This includes LEP students who enrolled in a U.S. school on or after the first day of school in the 2014-2015 school year.

[students]sol_ayp_d

String

1

37

Special Code-A

This field should be left blank unless authorized by VDOE.

N/A

N/A

N/A

38

Special Code-B

This field should be left blank unless authorized by VDOE.

N/A

N/A

N/A

39

Special Code-C

This field should be left blank unless authorized by VDOE.

N/A

N/A

N/A

40

RP-Code

This field should contain a Y for any student who is enrolled in a course that requires an SOL assessment AND who has been enrolled in a Regional Alternative Education Project during the 2014-2015 school year.

[students]sol_rp_code

Integer

N/A

41

Local Use Data – Student

This alphanumeric field is available for optional use by the school division.

N/A

N/A

N/A

42

Local Use Data – Test

This field is available for option use by the school division. Valid values are A-Z, 0-9, and blank.

[S_VA_SES_CRSTESTEXCEP_C]LocalUseDataTest

[S_VA_STU_SECTESTEXCEP_C]LocalUseDataTest

[S_VA_STU_TEST_C]LocalUseDataTest

Alpha-numeric

9

43

Online Testing

This field applies to the specific test being assigned in field 8 (Test Code).

[s_va_stu_sectestexcep_c]papertesting

Integer

N/A

44

Recovery

This field should contain a Y if the student is classified as described in Appendix A

[s_va_stu_sectestexcep_c]recovery

Integer

N/A

45

Retest

This field should contain a Y if the student is classified as described in Appendix A.

[s_va_stu_sectestexcep_c]retest

Integer

N/A

46

D-Code

This field should contain 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.

[students]sol_d_code

Integer

N/A

47

Term Grad

For the Fall 2014 Writing Administration, this field should contain 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.

[students]sol_term_grad

[s_va_stu_x]termgradwriting

Integer

N/A

48

Project Graduation

This field should contain a Y for all Writing and Non-Writing SOL tests administered to current Project Graduation students.

[s_va_stu_sectestexcep_c]projectgraduation

[s_va_stu_x]projectgraduation

Integer

N/A

49

Retest for College Readiness

This field should be left blank unless authorized by VDOE This field should be left blank unless authorized by VDOE.

N/A

N/A

N/A

50

Z-Code-B

This field should be left blank unless authorized by VDOE.

N/A

N/A

N/A

51

Z-Code-C

This field should be left blank unless authorized by VDOE.

N/A

N/A

N/A

52

Z-Code-D

This field should be left blank unless authorized by VDOE.

N/A

N/A

N/A

53

Code VTLN

This optional field may be used to associate a valid Virginia Teacher Licensure Number (VTLN) with a specific SOL test record.

[teachers]sif_stateprid

String

1-32

54

Code TLN

This optional field may be used with field 52 to associate a valid Teacher Last Name (TLN) with a specific SOL test record.

[teachers]last_name

String

1-20

55

Code TFN

This optional field may be used with field 52 to associate a valid Teacher First Name (TFN) with a specific SOL test record.

[teachers]first_name

String

1-20

56

End of Record

This field must contain a Y at the end of a student record.

N/A

N/A

N/A