Tool Search: SLDS
The PS Grade Program extract enhances Vermont's ability to efficiently and accurately manage, analyze, and use education data. This extract reports all student's with an enrollment on or prior to the Effective Date selected on the extract editor.
Example Extract EditorReport Logic
- This extract reports all student's with an enrollment on or prior to the Effective Date selected on the extract editor.
- Students are NOT included if their enrollment is marked as State Exclude.
The 04 Year End Official Collection includes a second line of data with next year's info for all promoted students that are expected to remain in school next year. When the End Action is P, the second line includes the following data: GRADE, GRADEBEGIN, GRADEEND (reports blank), and SY (reports the current reporting year).
Multiple records report if the student has two or more ENORGIDs in a Supervisory Union or District.
Report Editor
| Field | Description |
|---|---|
| Submission Code for File Name | The report naming convention based on the submission time frame of the report. |
| Extract Type | 5 PS Grade Prog |
| Effective Date | The date from which data is pulled for the report. |
| Format | Determines the format for the report. Use State Submission when submitting the final data. Use HTML for data review and testing. |
| Select Calendars | The calendar(s) from which data is pulled for the report. This option is only available when you select HTML for the File Format and can assist you with verifying data for individual calendars. |
Generate Report Submit to Batch | Users have the option of submitting the report request to the batch queue by clicking Submit to Batch instead of Generate Extract. This process allows larger reports to generate in the background without disrupting the use of Campus. |
Report Layout
| Element | Logic | Format and Length | Campus Database | Campus Location |
|---|---|---|---|---|
| ADMINID | The VT AOE assigned unique identifier for the Supervisory Union/District that is submitting data. | Alphanumeric, 6 characters | District.number | School & District Information > District Information > District Detail > State District Number |
| ENRORGID | The VT AOE assigned unique identifier for an organization providing direct instructional or educational services. | Alphanumeric, 6 characters | School.number | School & District Information > School Information > School Detail > State School Number |
| PERMNUMBER | The VT AOE assigned unique student identifier. This number is distinct for each student over time. | Numeric, 10 digits | Person.stateID | Census > People > Demographics > Person Identifiers > Student State ID |
| GRADE | The grade level or primary instructional level at which a student received services in a school or educational institution. | Alphanumeric, 2 characters | Enrollment.stateGrade | Student Information > Enrollments > State Reporting Fields > Grade |
| GRADEBEGIN | The month, day, and year on which an individual enters a grade level. | Date Field MM/DD/YYYY | Enrollment.startDate | Student Information > General > Enrollments > General Enrollment Information > Start Date |
| GRADEEND | The last month, day, and year after which an individual exits a grade level. | Date Field MM/DD/YYYY | Enrollment.endDate | Student Information > General > Enrollments > General Enrollment Information > End Date |
| SY | The school year for which data is being submitted. | Numeric, 4 digits YYYY | Calendar.endYear - 1 | N/A |
