Classic View: Behavior > Reports > Behavior Attendance Audit; Attendance > Reports > Behavior Attendance Audit
Search Terms: Behavior Attendance Audit
The Behavior Attendance Audit Report identifies students who have behavior resolutions not linked to an entry in their attendance record or have specified attendance codes not covered by a behavior resolution. If attendance modification from Behavior Management has been enabled, the Behavior Attendance Audit report displays instances where an attendance record was created from a behavior resolution.
Behavior Attendance Audit Report
For states that do not use School Months, that option does not display on the Report Editor.
Report Logic
Students who have Behavior Resolutions without a selected corresponding Attendance Code are included in the report when:
- The student has one or more of the selected behavior resolutions.
- The behavior resolution start or end date falls between the date range specified or within the School Month specified.
- The student does not have one or more of the selected attendance codes in every scheduled period with an attendance-taking course during the time of the behavior resolution.
- Start and End times of the resolution are considered. If the resolution begins at 1pm, the student only needs to have an attendance record in periods from 1pm to the end of the day.
- Roster start and end times are considered. The student does not need to have attendance in a period for a course-section that has been dropped or that starts in the future.
- Non-instructional periods are considered if there is an attendance-taking course in the period unless the Exclude Non-Instructional Periods option is selected on the report editor.
Students who have an Attendance without any corresponding Behavior Resolution are included in the report when:
- The student's attendance data has one or more of the selected attendance codes between the date range specified.
- There is not an attendance-linked behavior resolution between the date range specified.
Students who have Attendance created from a Behavior Resolution are included in the report when:
- The student has an attendance record created from a behavior resolution between the entered date range.
- The resolution type and attendance code were selected in the report options.
Resolution Types that are not active during the date range or school month selected are not included in reported data.
Behavior resolutions that start the last minute of a period or end the first minute of a period are ignored.
Report Editor
The following fields are available for selection.
| Field | Description |
|---|---|
| Select Dates | Enter a Date Range to return behavior/attendance data that occurred on or after the From date and on or before the To date. Dates are entered by typing in mmddyy format or by using the calendar icon to select a date. For states that use School Months, select which school months to include in the report. Note that dates must be entered on the School Month editor for dates to be listed here. |
| Exclude Non-Instructional Periods | If marked, non instructional periods are excluded from reported data. This option is not available for Kentucky users. |
| Select Students | Students can be selected by choosing either a Grade level or a saved Ad hoc Filter.
|
Selection Resolution Types and Attendance Codes | Determine which Resolution Types to include in the report:
Determine which Attendance Codes to include in the report:
|
| Select a Report Type | Selection which audit information to display:
|
| Select a Print Sort Order | Options for data sorting on the report are dependent on the options chosen for Display.
|
| Report Format | All of the report types can be generated in either PDF or DOCX format. |
Link Behavior Records and Attendance Records
This report looks for inconsistencies in behavior and attendance data when behavior records are linked to attendance records. The following steps should be followed to use this functionality.
| Task | Tool |
|---|---|
| Mark the appropriate attendance codes that relate to behavior resolutions. | Attendance Codes |
| Mark the appropriate behavior resolution types to allow for attendance modification. | Resolution Types |
| Create a behavior incident, assigning events and participants. | |
| Enter a behavior resolution for the event participants. | |
| Verify the entered behavior event and resolution, and mark the incident complete. | Behavior Management |
| Verify the behavior event displays on the student's behavior tab. | Student Behavior |
| Verify the attendance tab displays an entry for the behavior resolution. | Student Attendance |
| Generate a report looking for any inconsistencies in linked behavior/attendance records. | Behavior Attendance Audit Report |
Generate the Behavior Attendance Audit Report
A calendar must be selected in the Campus toolbar in order to generate the report.
- Select the students to include in the report by choosing a Grade level or an Ad hoc Filter.
- Enter the desired Date Range or select the desired School Months.
- Select the desired Resolution Types and Attendance Codes to include.
- Determine what information to include on the report by marking the Behavior without Valid Attendance checkbox, the Attendance without any Behavior Resolutions checkbox or both options.
- Select the desired Print Sort Order.
- Select the desired Report Format.
- Click the Generate Report button. The selected report type(s) display in the selected format.
Behavior Attendance Audit Report Layout
The Behavior Attendance Audit Report is broken into three specific sub-reports.
All Reports
Selecting the All Reports option includes all three sub-reports within the report.
Behavior Attendance Audit Report
Behavior Resolutions without a selected Corresponding Attendance Code
This report generates a list of all students who have the selected behavior resolution(s) with an attendance code that does not match an attendance code selected on the report editor.
Behavior Attendance Audit Report - No Attenance Code
| Column | Description | Campus Database | Campus Location |
|---|---|---|---|
| Student Name and Number | The reporting student's name and student number. | Identity.firstName Identity.lastName Person.studentNumber | Census > People > Demographics > First Name, Last Name, Student Number |
| Grade | The reporting student's grade level. | Student.grade | Student Information > General > Enrollments > Grade |
| Incident Title | The title of the behavior incident tied to an attendance record(s). | BehaviorIncident.title | Behavior > Behavior Management > Incident Detail Information > Incident Title |
| Incident Date & Time | The date and time in which the behavior incident was recorded. | BehaviorIncident.timestamp | Behavior > Behavior Management > Incident Detail Information > Date of Incident, Time of Incident |
| Res ID | The Resolution ID of the behavior resolution tied to the behavior incident. | BehaviorResolution.resolutionID | Behavior > Behavior Management > Incident Detail Information > Add Resolution > Resolution Details |
| Res Name | The name of the behavior resolution for the behavior incident. | BehaviorResolution.name | Behavior > Behavior Management > Incident Detail Information > Add Resolution > Resolution Details > Resolution Type |
| Res Start Date & Time | The time and date in which the behavior resolution began. | BehaviorResolution.discAssignDate | Behavior > Behavior Management > Incident Detail Information > Add Resolution > Resolution Details > Resolution Start Date, Resolution Start Time |
| Res End Date & Time | The time and date in which the behavior resolution ended. | BehaviorResolution.endDate | Behavior > Behavior Management > Incident Detail Information > Add Resolution > Resolution Details > Resolution End Date, Resolution End Time |
| Attn Date | The date of the student's attendance record that is missing an attendance code generated from the behavior resolution. | Attendance.date | Student Information > General > Attendance > Date |
Attendance without any Corresponding Behavior Resolution
This report generates a list of students who have an attendance record with an attendance code matching the attendance code(s) selected on the report editor but the attendance record is not tied to a behavior resolution.
Behavior Attendance Audit Report - No Behavior Resolution
| Column | Description | Campus Database | Campus Location |
|---|---|---|---|
| Student Name and Number | The reporting student's name and student number. | Identity.firstName Identity.lastName Person.studentNumber | Census > People > Demographics > First Name, Last Name, Student Number |
| Grade | The reporting student's grade level. | Student.grade | Student Information > General > Enrollments > Grade |
| Attn Code | The attendance code for the attendance record. | AttendanceExcuse.code | Student Information > General > Attendance > Code |
| Attn Date | The date of the student's attendance record that has a behavior-linked attendance code but is not associated with a behavior resolution. | Attendance.date | Student Information > General > Attendance > Date |
Attendance Created from a Behavior Resolution
This report generates a list of all behavior resolutions which created an attendance record(s) within the Date Range or School Month selected on the report editor.
Behavior Attendance Audit Report - Attendance from a Behavior Resolution
| Column | Description | Campus Database | Campus Location |
|---|---|---|---|
| Student Name and Number | The reporting student's name and student number. | Identity.firstName Identity.lastName Person.studentNumber | Census > People > Demographics > First Name, Last Name, Student Number |
| Grade | The reporting student's grade level. | Student.grade | Student Information > General > Enrollments > Grade |
| Incident Title | The title of the behavior incident tied to the behavior resolution which created an attendance record. | BehaviorIncident.title | Behavior > Behavior Management > Incident Detail Information > Incident Title |
| Incident Date & Time | The date and time in which the behavior incident was recorded. | BehaviorIncident.timestamp | Behavior > Behavior Management > Incident Detail Information > Date of Incident, Time of Incident |
| Res ID | The Resolution ID of the behavior resolution tied to the behavior incident. | BehaviorResolution.resolutionID | Behavior > Behavior Management > Incident Detail Information > Add Resolution > Resolution Details |
| Res Name | The name of the behavior resolution. | BehaviorResolution.name | Behavior > Behavior Management > Incident Detail Information > Add Resolution > Resolution Details > Resolution Type |
| Res Start Date & Time | The time and date in which the behavior resolution began. | BehaviorResolution.startDate | Behavior > Behavior Management > Incident Detail Information > Add Resolution > Resolution Details > Resolution Start Date, Resolution Start Time |
| Res End Date & Time | The time and date in which the behavior resolution ended. | BehaviorResolution.endDate | Behavior > Behavior Management > Incident Detail Information > Add Resolution > Resolution Details > Resolution End Date, Resolution End Time |
| Attn Code | The attendance code of the attendance record(s) created by the behavior resolution. | AttendanceExcuse.code | Student Information > General > Attendance > Code |
| Attn Date | The date attendance records were created by the behavior resolution. | Attendance.date | Student Information > General > Attendance > Date |
