Tool Search: SLDS
The Profile Student Attendance Report enhances Vermont's ability to efficiently and accurately manage, analyze, and use education data.
Example Extract EditorReport Logic
All students with an Enrollment on or prior to the Effective date selected on the editor are considered for reporting.
Report Editor
| Field | Description |
|---|---|
| Submission Code for File Name | The report naming convention based on the submission time frame of the report. |
| Extract Type | 7 PS Att |
| 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 |
| ENRORGID | The VT AOE assigned unique identifier for an organization providing direct instructional or educational services. | Alphanumeric, 6 characters | School.number | System Administration > Resources > School > 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 |
| ATTEVENTDATE | The month, day, and year for which attendance or absence is reported. Student attendance reports for every day the student is in school on a day marked as one of the following on the Days tab (System Administration > Calendar > Calendar > Days > Day Detail).
| Date Field MM/DD/YYYY | Day.date | N/A |
| DAILY_STATUS | Identifies whether a student was Present or Absent.
| Alphanumeric, 3 characters | Calculated | Student Information > General > Attendance |
| ATTENTYPEID | Indicates whether the attendance event was full-time or part-time or for a kindergarten morning or afternoon part-time session.
| Alphanumeric, 3 characters | Section.classType Enrollment.fullPartTimeStatus | Enrollments > State Reporting Fields > Full-Part Time Status AND State Grade and Course > Half Day Kindergarten |
| ABSCATID | The nature of an absence event; e.g., whether a student absence was excused or unexcused, the absence was a result of a disciplinary exclusion, or that the student was not expected to attend.
| Alphanumeric, 3 characters | AttendanceCode.stateCode | System Administration > Attendance > Attendance Codes > Attendance Excuse Detail |
| DSID_VALUE | The proportional value of a day assigned for the instance of a student's reported daily attendance status.
| Numeric, 3 digits N.NN | Calculated | Student Information > General > Attendance |
| SY | The school year for which data is being submitted. | Numeric, 4 digits YYYY | N/A | N/A |
