Classic View: VT State Reporting > SLDS > Extract Type > 12 Course
Search Term: SLDS
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 Course > Course Editor > 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 | System Administration > Resources > 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 > People > District Assignment > Employement Assignments > Teacher AND Census > People > District Assignment > Employement Assignments > 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 > Course > 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 | Course > Course Editor > NCES Data > NCES Code |
| COURSENAME | The school assigned name of the course being taught. | Alphanumeric, 255 characters | Course.name | Scheduling > Courses > Course > 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 | Course/Section > Course Information > Additional Category |
| SY | The school year for which data is being submitted. | Numeric, 4 digits YYYY | N/A | N/A |
