Classic View: RI State Reporting > Enrollment Census > Attendance
Search Terms: Enrollment Census
The Enrollment Census Attendance extract is used to report attendance information to the state. The Enrollment Census Extracts collect various types of student information, including demographics, address and contact information, behavior events and program participation.
Enrollment Census - Attendance Extract
Report Logic
Any student who has an Enrollment Status of W (Summer Withdrawal) does not report.
All students who have one or more of the attendance codes listed after the report layout as of the Effective Date report.
- If Whole Day Absence and Half Day Absence Minutes are both null or a zero value, the code posted for the student reports.
- If Whole Day Absence and Half Day Absence Minutes are not null or different than a zero value:
- An Absence Code or Present code can not be reported in the same day as a tardy or early dismissal code.
- An Absence or Present Code reports if period minutes total at least equal to a whole day absent total entered on the Calendar Whole Day Absence Minutes field.
- A Tardy or Early Dismissal code reports if there is less than a full day of absence.
SQL Query
XX = calendarID
EXECUTE dbo.get_RI_EnrollmentAttendance @calendarList = 'xx', @startDate = 'mm/dd/yyyy', @endDate = 'mm/dd/yyy
Generate the Attendance Extract
- Select Attendance from the Extract Type dropdown list.
- Enter an Effective Date in mmddyyyy format or by clicking the calendar icon and selecting a date. When generating the Attendance Extract, enter Start and End Dates.
- Select the Format in which the report should generate. Options are CSV and HTML.
- If the student's legal name and gender information should report from the Protected Identity Information area, mark the Report Legal Identities checkbox.
- Click Generate Extract to generate the report.
Attendance Extract - CSV Format
Attendance Extract - HTML Format
Attendance Extract Layout
Element Name | Description | Location |
|---|---|---|
DIST CODE | The reporting district code. Numeric, 2 digits | Student Information > General > Enrollments Tab > State Reporting Fields > Resident District Code Enrollment.servingDistrict |
SCH CODE | Identifies the school code. Numeric, 5 digits | System Administration > Resources > School > School Detail > State School Number School.number |
SASID | The student's unique state assigned student ID. Numeric, 10 digits | Census > People > Demographics > Personal Identifiers > Student State ID Person.stateID |
LASID | The student's unique locally assigned student ID. Numeric, 16 digits | Census > People > Demographics > Person Identifiers > Local Student Number Person.studentNumber |
ATTEND_DATE | Identifies the date of attendance. Date Field 10 characters (MM/DD/YYYY) | Student Information > General > Attendance Tab > Date AttendanceDetail.date |
ATTEND_TYPE | Indicates the student's attendance code on the reported date. See the Attendance Codes for options.
Alphanumeric, 2 characters | Student Information > General > Attendance Tab > Code AttendanceDetail.stateCode |
Attendance Codes
Code | Description |
|---|---|
1A | In School, regular instruction program |
1B | Nontraditional school setting, regular instruction |
1C | Disciplinary action, receiving instruction |
1D | Out of School, regular instructional program active |
1E | Out of School, school-approved extracurricular |
| 1F | Out of School Distance Learning |
2A | Non-instructional activity recognized by state |
2B | Religious observation |
2C | Illness, injury, health treatment or examination |
2D | Family emergency or bereavement |
2E | Disciplinary action, not receiving instruction |
2F | Legal or judicial requirement |
2G | Family activity |
2H | Student employment |
2I | Transportation provided by school - not Available |
2J | Student is skipping school |
2K | Absent - Unexcused Other |
2L | Absent - Excused Other |
3B | Religious observation |
3C | Illness, injury, health treatment or examination |
3D | Family emergency/bereavement |
3F | Legal or judicial requirement |
3G | Family activity |
3H | Student Employment |
3I | Transportation Not Available |
3J | Student is tardy |
3K | Tardy - Unexcused Other |
3L | Tardy - Excuse - Other |
4B | Religious observational |
4C | Illness, injury, health treatment or examination |
4D | Family emergency/bereavement |
4E | Disciplinary action, not receiving instruction |
4F | Legal or judicial requirement |
4G | Family activity/vacation |
4H | Student employment |
4I | Transportation Not Available |
4J | Student left school early/cut |
4K | Early Dismissal - Unexcused Other |
4L | Early Dismissal - Excused Other |
