Tool Search: VT SLDS Reports
The Course submission enhances Vermont's ability to efficiently and accurately manage, analyze, and use education data.
Example 12 Course Extract EditorReport Logic
- All courses set up on or prior to the selected Effective Date report.
- To report, the course must have an SCED code assigned to the course located in Scheduling & Courses > Courses > Course Information > NCES Data > NCES Code.
Report Editor
| Field | Description |
|---|---|
| Submission Code for File Name | The report naming convention based on the submission time frame of the report. |
| Extract Type | 12 Course |
| 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 Settings > District > District Information > District Detail > State District Number |
| POSID | The VT AOE assigned unique identifier for the organization representing the "Place of Service" where the staff person is performing a role. | Alphanumeric, 6 characters | School.number | Census > Staff > District Assignments > Teacher AND Census > Staff > District Assignment > District Assignment > School |
| LOCALCOURSEID | A unique identifier assigned by the school to each of their courses offered in a school year. | Alphanumeric, 55 characters | Course.number | Scheduling & Courses > Courses > Course Information > Course Editor > Number |
| COURSECODE | A code indicating the federal School Codes for the Exchange of Data (SCED) code identifier of a course including the subject area. | Alphanumeric, 5 characters | Course.scedSubjectArea AND Course.scedCourseID | Scheduling & Courses > Courses > Course Information Course Editor > NCES Data > NCES Code |
| COURSENAME | The school assigned name of the course being taught. | Alphanumeric, 255 characters | Course.name | Scheduling & Courses > Courses > Course Information > Course Editor > Name |
| Addit_COURSECAT | A set of codes that identify an additional course category that is different from the CourseCode reported above. This field stores multiple code sets which are separated by "|" (pipes). | Alphanumeric, 30characters | Course.abbreviation | Scheduling & Courses > Courses > Course Information Course/Section > Course Information > Additional Category |
| SY | The school year for which data is being submitted. | Numeric, 4 digits YYYY | N/A | N/A |
