Behavior Attendance Audit Report

Tool Search: 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.

This report is also available from the Attendance Office Reports and from the Behavior Office Reports toolset.

Screenshot of the Behavior Attendance Audit Report, located at Behavior, Reports. 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.

FieldDescription
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.

  • If choosing a Grade Level, only those grade levels in the selected calendar are listed. All students (in all grade levels) can also be selected.
  • If choosing an Ad hoc Filter, only those students included in the filter are included in the report, assuming they meet other reporting logic and business rules.

Selection Resolution Types and Attendance Codes


Determine which Resolution Types to include in the report:

  • Flagged as attendance-related - Only behavior resolutions with a resolution type marked as attendance-related are included in reported data.
  • All resolution types - All behavior resolution data is used for generating report data.

Determine which Attendance Codes to include in the report:

  • Flagged as behavior-related - Only attendance records with attendance codes marked as behavior-related are included in reported data.
  • All attendance codes - All attendance data is used for generating report data.
Select a Report Type

Selection which audit information to display:

  • All Reports - Selecting the All Reports option includes all three sub-reports within the 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 or with no attendance code at all.
  • 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.
  • 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.
Select a Print Sort Order

Options for data sorting on the report are dependent on the options chosen for Display.

  • If Behavior Resolutions without a selected corresponding Attendance Code is selected, sort options include Student Name, Date, Grade or Resolution Date.
  • If Attendance without any corresponding Behavior Resolution is selected, sort options include Student Name, Date, Grade or Attendance Code.
  • If Attendance created from a Behavior Resolution is selected, sort options include Student Name, Date, Grade, Resolution Type or Attendance Code.
Report FormatAll 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.

TaskTool
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.

Behavior Management

Behavior Referral

Enter a behavior resolution for the event participants.

Behavior Management

Student Behavior

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.

  1. Select the students to include in the report by choosing a Grade level or an Ad hoc Filter
  2. Enter the desired Date Range or select the desired School Months.
  3. Select the desired Resolution Types and Attendance Codes to include.
  4. 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.
  5. Select the desired Print Sort Order.
  6. Select the desired Report Format.
  7. 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.

Screenshot of the All Reports print view. 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.

Screenshot of the No Attendance Code print view. Behavior Attendance Audit Report - No Attendance Code 

ColumnDescriptionCampus DatabaseCampus Location
Student Name and NumberThe reporting student's name and student number.

Identity.firstName

Identity.lastName

Person.studentNumber

Census > People > Demographics > First Name, Last Name, Student Number
GradeThe reporting student's grade level.Student.gradeStudent Information > General > Enrollments > Grade
Incident TitleThe title of the behavior incident tied to an attendance record(s).BehaviorIncident.titleBehavior > Behavior Management > Incident Detail Information > Incident Title
Incident Date & TimeThe date and time in which the behavior incident was recorded.BehaviorIncident.timestampBehavior > Behavior Management > Incident Detail Information > Date of Incident, Time of Incident
Res IDThe Resolution ID of the behavior resolution tied to the behavior incident.BehaviorResolution.resolutionIDBehavior > Behavior Management > Incident Detail Information > Add Resolution > Resolution Details
Res NameThe name of the behavior resolution for the behavior incident.BehaviorResolution.nameBehavior > Behavior Management > Incident Detail Information > Add Resolution > Resolution Details > Resolution Type
Res Start Date & TimeThe time and date in which the behavior resolution began.BehaviorResolution.discAssignDateBehavior > Behavior Management > Incident Detail Information > Add Resolution > Resolution Details > Resolution Start Date, Resolution Start Time
Res End Date & TimeThe time and date in which the behavior resolution ended.BehaviorResolution.endDateBehavior > Behavior Management > Incident Detail Information > Add Resolution > Resolution Details > Resolution End Date, Resolution End Time
Attn DateThe date of the student's attendance record that is missing an attendance code generated from the behavior resolution.Attendance.dateStudent 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.

Screenshot of the Attendance without Behavior Resolution information. Behavior Attendance Audit Report - No Behavior Resolution

ColumnDescriptionCampus DatabaseCampus Location
Student Name and NumberThe reporting student's name and student number.

Identity.firstName

Identity.lastName

Person.studentNumber

Census > People > Demographics > First Name, Last Name, Student Number
GradeThe reporting student's grade level.Student.gradeStudent Information > General > Enrollments > Grade
Attn CodeThe attendance code for the attendance record.AttendanceExcuse.codeStudent Information > General > Attendance > Code
Attn DateThe date of the student's attendance record that has a behavior-linked attendance code but is not associated with a behavior resolution.Attendance.dateStudent 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.

Screenshot of attendance events that were created because of a behavior resolution. Behavior Attendance Audit Report - Attendance from a Behavior Resolution 

ColumnDescriptionLocation
Student Name and NumberThe reporting student's name and student number.Census > People > Demographics > First Name, Last Name, Student Number

Identity.firstName

Identity.lastName

Person.studentNumber

GradeThe reporting student's grade level.Student Information > General > Enrollments > Grade

Student.grade
Incident TitleThe title of the behavior incident tied to the behavior resolution which created an attendance record.Behavior > Behavior Management > Incident Detail Information > Incident Title

BehaviorIncident.title
Incident Date & TimeThe date and time in which the behavior incident was recorded.Behavior > Behavior Management > Incident Detail Information > Date of Incident, Time of Incident

BehaviorIncident.timestamp
Res IDThe Resolution ID of the behavior resolution tied to the behavior incident.Behavior > Behavior Management > Incident Detail Information > Add Resolution > Resolution Details

BehaviorResolution.resolutionID
Res NameThe name of the behavior resolution.Behavior > Behavior Management > Incident Detail Information > Add Resolution > Resolution Details > Resolution Type

BehaviorResolution.name
Res Start Date & TimeThe time and date in which the behavior resolution began. Behavior > Behavior Management > Incident Detail Information > Add Resolution > Resolution Details > Resolution Start Date, Resolution Start Time

BehaviorResolution.startDate
Res End Date & TimeThe time and date in which the behavior resolution ended. Behavior > Behavior Management > Incident Detail Information > Add Resolution > Resolution Details > Resolution End Date, Resolution End Time

BehaviorResolution.endDate
Attn CodeThe attendance code of the attendance record(s) created by the behavior resolution.Student Information > General > Attendance > Code

AttendanceExcuse.code
Attn DateThe date attendance records were created by the behavior resolution.Student Information > General > Attendance > Date

Attendance.date