Reporting on Students Involved in Behavioural Incidents

This guide will explain the possible reports you could create when using our custom report writer to create a report using the report focus of Students involved in behavioural incidents.

For help with Arbor's built-in behaviour analysis tools, please refer to Behaviour Analysis - Reporting on incidents, detentions, exclusions and suspensions instead.

Students involved in behaviour incidents Specific Report Fields

• Comment (behavioural incident student involvement)
• Recorded by (behavioural incident student involvement)
• Recorded on (behavioural incident student involvement)
• Resolved by (behavioural incident student involvement)
• Restraint staff
• Restraint student
• Restraint technique type
• Restraint witness
• Severity (behavioural incident student involvement)
• Student involvement status

Permissions

Access to data in the Custom Report Writer is based on a user's permissions. This means you are able to regulate what data they can see in order to safeguard your students and staff. Certain types of data may be restricted for some staff members without the correct permissions. For example, if you are unable to view data for students involved in behavioural incidents, you won't be able to see them on the Custom Report Writer. 

You can view the permissions needed to report on each thing in Arbor by going to School > Users & Security > Access Control > Permissions. 

If you need to give someone permission to create reports or report on certain items, you can follow these instructions.

Top Tip: You may find it easier to click 'Skip setup wizard' after choosing your report focus and title to head straight to the main Edit screen. 

Adding a Filter

If you would like to filter your report to look for specific students, incidents, etc you can do so by scrolling down to the Filters section.

From the drop down, select the filter that you are interested in. For example, if you would like your report to only show students involved in a certain incident severity, you could choose the Severity filter.

Select Severity from the drop-down, and then click the green Add filter button on the right-hand side.

Then you can set your filter parameters. For example, if you select Greater than (>) 1 you will see all students involved in a behavioural incident logged above severity level 1

Adding a Grouping

If you would like to sort the data into groups, you can do this by adding a grouping to the report. 

Please be aware that when adding a grouping you may loose some of the contextual information and end up with just the number of items. 

For example, if you add a grouping of Resolved By to the report, you will see how many behavioural incidents have been resolved by each staff member, but you would no longer see the detail of the students or incidents, such as the incident name or the student names.

You can see which data will no longer be displayed in the Report Columns section as it adds (Hidden - does not support groupings) after the column name.

To add a grouping, scroll down to Groupings. From the drop-down, select the grouping that you are interested in, for example, Resolved By. Then click on the green Add grouping  button.

Set the parameters if required and then click Save.

Adding a Collation

Collating a report allows you to collect results into different sections. This means when you download the report, you can choose how rows are grouped. 

For example, if your report is a list of all students involved in behavioural incidents, but you want them to appear on separate pages depending on the Year Groups that the involved students are in when you print or download the report, you add a collation to do this. 

Collations are not compatible with groupings, so if you added a grouping, you will see a message stating "Sorry - you can't add a collation to this report, as your report is already grouped." you would need to delete your grouping using the bin icon. 

To add a collation, scroll down to Collations and then choose the relevant option from the drop-down menu, for example, Year group(s).

Click the green Add collation button. Set the date range in the slide-over and then click Save.

Once you are happy with your report, you can click on the green Save & View Report button. 

All Available Report Fields for Students involved in behavioural incidents Reports

To see a matrix of all available report fields and which report types they can be used with, please take a look at this article: What report fields can I use with each report type in the custom report writer?

• % of assessment marks above, at or below target
• % of students who have a baseline below, at or above a specific grade
• % of students who have an year target below, at or above a specific grade
• % of students with a curriculum mastery
• % of students with an average curriculum mark
• % of students working below, at or above a specific grade
• 1. Total number of students on roll (today)
• 10 years old Student Count
• 10 years old?
• 10. Confirmed case of Covid-19 (today)
• 11 years old Student Count
• 11 years old?
• 11. Required to stay at home or isolate due to returning from abroad or requested to remain at home/isolate
• by NHS Test and Trace (today)
• 12 years old Student Count
• 12 years old?
• 12. Absent due to attendance restrictions put in place to manage an outbreak within your setting (today)
• 13 years old Student Count
• 13 years old?
• 13. Total of all absences due to Covid-19 (today)
• 14 years old Student Count
• 14 years old?
• 14. Total absent due to phased return (today)
• 15 years old Student Count
• 15 years old?
• 16 years old Student Count
• 16 years old?
• 17 years old Student Count
• 17 years old?
• 18 years old Student Count
• 18 years old?
• 19 years old Student Count
• 19 years old?
• 2 Year Old Funding Basis
• 2 years old Student Count
• 2 years old?
• 2. Students with an EHCP on roll (today)
• 20 years old Student Count
• 20 years old?
• 3 years old Student Count
• 3 years old?
• 3. Students with a social worker on roll (today)
• 4 years old Student Count
• 4 years old?
• 4. Students eligible for FSM on roll (today)
• 5 years old Student Count
• 5 years old?
• 5. Total number of students attending (today)
• 6 years old Student Count
• 6 years old?
• 6. Students with an EHCP attending (today)
• 7 years old Student Count
• 7 years old?
• 7. Students with a social worker attending (today)
• 8 years old Student Count
• 8 years old?
• 8. Students eligible for FSM attending (today)
• 9 years old Student Count
• 9 years old?
• 9. Suspected case of Covid-19 (today)
• Access Arrangement
• Access Arrangement Reason
• Account Balance
• Achievement against school assessment measures
• Actions Taken
• Ad Hoc Assessment Mark
• Consents
• Advanced Calculation/Formula Column
• Age (Chronological)
• Age (Months)
• Age (Years) (Student)
• All email address(es)
• All Guardians
• AM Roll Call Mark
• AM Roll Call Note
• Arbor Student ID
• Are all primary guardians key workers?
• Assignee(s)
• Attendance Mark (Specific Date)
• Attendance Patterns
• Behaviour type by subject
• Behaviours
• Birth Certificate Document Number
• Birth Certificate Expiry Date
• Born in April Student Count
• Born in April?
• Born in August Student Count
• Born in August?
• Born in Autumn Student Count
• Born in Autumn?
• Born in December Student Count
• Born in December?
• Born in February Student Count
• Born in February?
• Born in January Student Count
• Born in January?
• Born in July Student Count
• Born in July?
• Born in June Student Count
• Born in June?
• Born in March Student Count
• Born in March?
• Born in May Student Count
• Born in May?
• Born in November Student Count
• Born in November?
• Born in October Student Count
• Born in October?
• Born in September Student Count
• Born in September?
• Born in Spring Student Count
• Born in Spring?
• Born in Summer Student Count
• Born in Summer?
• Candidate Number
• Census School Phase
• Child Protection Status
• Citizen Nationality
• Club Absent Attendance for all clubs
• Club Late Attendance for all clubs
• Club Present Attendance for all clubs
• Clubs
• Comment (Behavioural incident student involvement)
• Compulsory School Age (5 - 15) Student Count
• Compulsory School Age (5 - 15)?
• Count of unactioned attendance fine records (last 10 weeks)
• Country of Birth
• Course Name (Bottom level by subject)
• Courses/classes
• Current Boarding Status on Friday
• Current Boarding Status on Monday
• Current Boarding Status on Saturday
• Current Boarding Status on Sunday
• Current Boarding Status on Thursday
• Current Boarding Status on Tuesday
• Current Boarding Status on Wednesday
• Curriculum Average Mark
• Curriculum Average Mastery (%)
• Curriculum Completion
• Curriculum Mark (By Module)
• Curriculum Mark (By Statement)
• Curriculum Mastery (%)
• Curriculum Mastery Mark
• Custom Groups
• Date of Birth (Student)
• Demographics
• Department
• Destination
• Destination (Address)
• Destination (Telephone)
• Detention Type(s) Happening
• Detention Type(s) Issued
• Dietary Requirements
• Disadvantaged (Ofsted 2023) Student Count
• Disadvantaged (Ofsted 2023)?
• Disadvantaged Student Count
• Disadvantaged?
• Driving License Document Number
• Driving License Expiry Date
• EAL Student Count
• EAL?
• Eligibility Code
• Email Address (Main)
• English Proficiency (Most Recent)
• Enrolment Mode
• Enrolment/Unenrolment Note
• Entry Date (First)
• Entry Date (Most Recent)
• Ethnicity (Student)
• Ethnicity Category (Student)
• Event (Behavioural Incident)
• Ever 6 FSM Student Count
• Ever 6 FSM?
• Ever 6 Service Child Student Count
• Ever 6 Service Child?
• Exam/Qualification Result
• Extended Hours
• EYPP Recipient Student Count
• EYPP Recipient?
• Final target
• First Language
• First Name (Student)
• Former Name(s) (Student)
• FSM Eligibility (Current Dates)
• FSM Eligibility (Current End Date)
• FSM Eligibility (Current Start Date)
• FSM Student Count
• FSM?
• Funded Hours
• Gender Identity (Student)
• Gender Identity (Preferred Term)
• Gifted + Talented Student Count
• Gifted + Talented?
• Gifted Student Count
• Gifted?
• Gifts
• Globally Unique Student ID
• GP/Doctor/Medical Relationships
• Group Percentage
• Gypsy / Roma / Traveller Student Count
• Gypsy / Roma / Traveller?
• Handedness
• Has Key Worker Guardian Student Count
• Has Key Worker Guardian?
• Head(s) of Year
• Highest Priority Primary Guardian Email Address
• Home Local Authority
• Hours At Setting
• House Tutor(s)
• House(s)
• In Covid-19 Social Worker Group? (today)
• In Covid-19 Vulnerable Group? (today)
• In House Exam Result
• In Year Admission Student Count
• In Year Admission?
• Incident Date/Time
• Incident Name
• Incident Reporter(s)
• Incident Status
• Incident Watcher(s)
• Individual Education Plan (IEP)
• Internal Exclusion Reason(s)
• Internal Exclusion Type(s)
• Intervention Categories
• Intervention Groups
• Intervention Subjects
• Interventions
• Judgement against attainment expectations
• Key Stage(s)
• Key worker primary guardian count
• Language(s)
• Last Login
• Last Name (Student)
• Learning Aim enrolments
• Leaving Date (Enrolment History)
• Legacy System ID (Student)
• Legal First Name (Student)
• Legal Guardians
• Legal Last Name (Student)
• Legal Middle Name(s) (Student)
• Legal Name (Student)
• Lesson Attendance (Absent)
• Lesson Attendance (Auth. Absent)
• Lesson Attendance (Average Mins Late)
• Lesson Attendance (Late)
• Lesson Attendance (Persistent Absentees)
• Lesson Attendance (Present)
• Lesson Attendance (Specific Marks)
• Lesson Attendance (Total Mins Late)
• Lesson Attendance (Unauth. Absent)
• Lessons With Incidents
• Location (Behavioural Incident)
• Looked After (In Care) Status
• Looked After (In Care) Student Count
• Looked After (In Care): Responsible Local Authority
• Looked After (In Care)?
• Meal Account Balance
• Meal Price Category Statistic
• Medical Conditions (Student)
• Mobile (Y10 & Y11) Student Count
• Mobile (Y10 & Y11)?
• Mobile (Y5 & Y6) Student Count
• Mobile (Y5 & Y6)?
• Mode(s) of Transport
• Month of Birth
• Name (Student)
• Narrative (Behavioural Incident)
• National Identity Card Document Number
• National Identity Card Expiry Date
• National Insurance Number Document Number
• National Insurance Number Expiry Date
• Nationality and Nationality Status
• Native Language(s)
• NC Reception?
• NC Year 1?
• NC Year 10?
• NC Year 11?
• NC Year 12?
• NC Year 13?
• NC Year 2?
• NC Year 3?
• NC Year 4?
• NC Year 5?
• NC Year 6?
• NC Year 7?
• NC Year 8?
• NC Year 9?
• NC Year Group on Leaving
• NC Year(s)
• NHS number
• Number of Clubs
• Number of current postal addresses
• Number of days in Internal Exclusion(s)
• Number of hours in Internal Exclusion(s)
• Number of Trips
• Out Of Age Group Cohort Student Count
• Out Of Age Group Cohort?
• Outcomes Met by Student
• Overall Curriculum Grade
• Passport Document Number
• Passport Expiry Date
• Permanent Exclusion Decision Date
• Permanent exclusion reason(s)
• Permanent Exclusion Start Date
• Planned EEP Hours
• Planned Learning Hours (Student: Funding)
• PM Roll Call Mark
• PM Roll Call Note
• Postal Address (Country)
• Postal Address (Full)
• Postal Address (Line 1)
• Postal Address (Line 2)
• Postal Address (Line 3)
• Postal Address (Move In Date)
• Postal Address (Postal Code)
• Postal Address (State)
• Postal Address (Town)
• Predicted Final Mark
• Predicted Mark
• Previous Postal Address(es)
• Primary Guardian Addressee
• Primary Guardian count
• Primary Guardian Home Numbers
• Primary Guardian Main Telephone Numbers
• Primary Guardian Mobile Numbers
• Primary Guardian Postal Addresses
• Primary Guardian Work Numbers
• Primary Guardians
• Profile Picture
• Pupil Premium Eligible Student Count
• Pupil Premium Eligible?
• Pupil Premium Recipient Student Count
• Pupil Premium Recipient?
• Recorded By (Behavioural Incident)
• Recorded By (Behavioural incident student involvement)
• Recorded On (Behavioural Incident)
• Recorded On (Behavioural incident student involvement)
• Reg. Form Tutor(s)
• Registration form(s)
• Regular meal provision
• Religion (Student)
• Resolved By (Behavioural incident student involvement)
• Restraint Staff
• Restraint Student
• Restraint Technique Type
• Restraint Witness
• School History
• School History (Address)
• School History (Telephone)
• SEN need description(s)
• SEN need(s)
• SEN notes
• SEN status
• SEN Student Count
• SEN?
• Service Child Student Count
• Service Child?
• Severity (Behavioural Incident)
• Severity (Behavioural incident student involvement)
• Sex (Student)
• Siblings (All)
• Siblings (Enrolled Only)
• Staff (Behavioural Incident)
• Standardised Assessment Mark
• Statutory/Roll Call Attendance (Absent)
• Statutory/Roll Call Attendance (Absent) by Day of the Week
• Statutory/Roll Call Attendance (Auth. Absent)
• Statutory/Roll Call Attendance (Auth. Absent) by Day of the Week
• Statutory/Roll Call Attendance (Average Mins Late)
• Statutory/Roll Call Attendance (Custom)
• Statutory/Roll Call Attendance (Late)
• Statutory/Roll Call Attendance (Persistent Absentees)
• Statutory/Roll Call Attendance (Present)
• Statutory/Roll Call Attendance (Present) by Day of the Week
• Statutory/Roll Call Attendance (Specific Marks)
• Statutory/Roll Call Attendance (Total Mins Late)
• Statutory/Roll Call Attendance (Unauth. Absent)
• Statutory/Roll Call Attendance (Unauth. Absent) by Day of the Week
• Statutory/Roll Call Continuous Sessions (Specific Marks)
• Student Funding Type(s)
• Student Involvement Status
• Student linked to Court Order
• Student Number
• Student ParentMail Identifier
• Students
• Students With Lesson Attendance Above/Below...
• Students With Lesson Authorised Absence Above/Below...
• Students With Lesson Unauthorised Absence Above/Below...
• Students With Roll-Call Attendance Above/Below...
• Students With Roll-Call Attendance Authorised Absence Above/Below...
• Students With Roll-Call Attendance Unauthorised Absence Above/Below...
• Students with specific grade(s)
• Summative Baseline
• Summative Mark
• Summative Mark Comment
• Suspension reason(s)
• Talented Student Count
• Talented?
• Talents
• Teacher Number Document Number
• Teacher Number Expiry Date
• Teaching group(s)
• Telephone Number (Home)
• Telephone Number (Mobile)
• Timetabled event (Student timetable)
• Timetabled lesson attendance mark
• Timetabled location (Student timetable)
• Total Detentions
• Total Incidents
• Total Internal exclusions
• Total Intervention Cost
• Total Permanent Exclusions
• Total sessions for suspensions
• Total Suspensions
• Traveller Status
• Trips
• UCI
• ULN
• Unactioned attendance fine records (last 10 weeks)
• Unenrolment Reason
• UPN
• User defined fields
• Username
• Visa Document Number
• Visa Expiry Date
• Year Group On Joining
• Year Group On Leaving
• Year group(s)
• Year target
• Young Carer Student Count
• Young Carer?