Each year, we are required to submit four student data extract files to the Virginia Department of Education:
The first three reports consist of records for every student who was enrolled in one of our schools during the reporting period, even if the student was only enrolled for one day. The summer report includes students who graduate during the summer.
The reports consist of individual student records, such as the following:
B 1234567890 123456 086 0120 086 0120 A E1 08/22/2007 5 F 01/01/1985 07 N N N N N N N N N 4 N 175 5 N N 136 N N N N Susan Mary Student
We extract this information from our student information system; therefore, any errors in our student information system will become state reporting errors. The aggregate data compiled by the state--dropouts, graduation rates, etc.--comes from these individual student records; therefore, accurate and complete data entry is the foundation for high-quality data reporting. The most effective way to enter data is to get it right the first time. For example, a simple error, such as coding a student entry or withdrawal code incorrectly, can result in an entire student data extract file being rejected. This results in the data entry person having to revisit the student's enrollment/withdrawal documentation, then correcting the error in the student information system. The person responsible for submitting the student data extracts has to make a correction and resubmit the entire file.
During the 2007-2008 school year, there were 69 different data elements required for each student. Not every data element is required for each report; the fall report requires the least elements, the end-of-year the most. You can find a list of the required data elements on VDOE's website. Most of the data elements have to be coded in a specific way. You can find a list of those codes on the VDOE website. Please note that these data elements and codes may change from year to year. If you print the list, please revisit the online version to ensure that you have the latest version. The revision date is printed in the lower left-hand corner of each page.
Neglected/Delinquent status used to be a Yes/No field. It is being changed to gather more detailed data. The new Neglected/Delinquent categories are on the VDOE website. This information will be collected in User Code 22 in the Student Atom. User Code 22 will default to blank, which means a student is not classified as neglected or delinquent. If you have a student who falls into one of the Neglected/Delinquent categories:
Neglected/Delinquent status will be required in all four student reports and it cannot change during the school year; i.e., if you report a student as neglected/delinquent in the fall, he or she must be reported as neglected/delinquent on the spring and end-of-year collections.
We will be required to report the number of unexcused absences on the end-of-year report. This will be a calculated field that won't require any special data entry; that is, the Pearson reporting software will accumulate the number of unexcused absences for each student.
The old Yes/No Homeless Flag has been retired. The Initial Primary Nighttime Residence Code replaces it. This code has the following values:
Homeless information will be recorded on Page 3 of the Student Atom. The Homeless checkbox on that page will be replaced with a dropdown list with the valid homeless values. Homeless status will be required in all four student reports and it cannot change during the school year; i.e., if you report a student as homeless in the fall, he or she must be reported as homeless on the spring and end-of-year collections, even if the child's actual homeless status changes.
This code identifies students enrolled in a full course of study for all educational services in a virtual program at the serving school. The following are valid values:
This information will be collected in User Code 21 in the Student Atom. User Code 21 will default to blank, which means a student is not participating in a full-time virtual program. It is unlikely you will have any students who fall into this category. If you do, follow these steps to flag the student:
This Yes/No flag identifies students who are not residents of the school division that is providing their education and:
To identify a child in foster care, check the Foster Home checkbox on Page 3 of the Student Atom.
The current two-character enrollment and withdrawal codes cover a variety of situations. For example, the W2 code actually covers eight situations in which a student transfers from one school to another school in the same LEA. The new four-character codes break these situations down into detail. VDOE is encouraging divisions to use the four-character codes in 2008-2009; it will require them in 2009-1010. Our goal is to have them in place by the start of the 2008-2009 school year. The four-character codes are listed along with the two-character codes on VDOE's Code Values page, in the entry codes and exit/withdrawal codes tables.
ASTU AENR PermNum FN LN LeaveCode IF LeaveCode = "W9"
Be sure to check the Show Inactive Records in the SASI Query Atom to display these records. (Students with a W9 code are inactive.)
ASTU PermNum FN LN If Grade = "12" AND UserCd4 = " "
You can use the following query to check for blank Graduation Plan Codes:
ASTU PermNum FN LN If Grade = "12" AND PostSecond = " "
Students who receive GEDs should be marked with W7 withdrawal codes and the appropriate GED code selected from the Diploma Tag field on Page 3 of the Student Atom.
| PK Code | Description | Note |
|---|---|---|
| 20 | Coordinated Pre-kindergarten Classroom | |
| 21 | Virginia Preschool Initiative (VPI) | Our full-time PK students must use this code or code 22. |
| 22 | Title I Pre-kindergarten | Our full-time PK students must use this code or code 21. |
| 23 | Head Start | 0 hours not permitted for this value. |
| 30 | Coordinated Special Education | Use this code for students who attend a day care center and come to us for special ed services only. |
| 31 | Special Education Only | Use this code for students who come to us for special ed services only. |
| 40 | Government - Tuition Charged | |
| 50 | Private Provider | Student cannot be in grade PK. |
| 51 | Licensed Family Home Provider | Student cannot be in grade PK. |
| 60 | No Formal or Institutional PK Program | Student cannot be in grade PK. This code and Code 99 are the only two codes in which 0 hours are allowed. |
| 61 | Other | Zero hours cannot be used with this code. |
| 99 | Not Provided | This code and code 60 are the only two codes in which 0 hours are allowed. |
Pearson has added new capabilites for transcripts regarding:
See page 5 of the Virginia Individual Student Record Collection and Student Transcripts document for details.