Templates Available in the Template Library

This article is a list of templates available in the Template Library (Reporting > Template Library). As the Template Library offering expands, this guidance will be updated too.

You can use the table below to do things like: 

• Decide whether a specific template fits your needs
• Identify any areas you might need to add to a report or remove from it after you create it from a template in the library.
• Gather ideas for creating your own bespoke report

You can find more guidance on what the template library is and how to use the Template library to create reports in our Using the Template Library in Arbor guide.

The table and list below show the following:

• The name of the template
• The report focus a template uses (the people or area of Arbor that the report is about)
• A description of what the template is for
• The columns and fields included in each template

Template Library Templates - Table View

Template Library Templates - List View

Admissions Register report

Report Focus: Students

Report Description: Lists your admissions into your school along with their basic personal details.

Report Columns: Name, Legal First Name, Legal Middle Name(s), Legal Last Name, Date of Birth, Sex, Postal Address (Full), Postal Address (Move In Date), Previous Postal Address(es), Primary Guardian Postal Addresses, Primary Guardian Main Telephone Numbers, SEN?, LAC?, School History, Entry Date (First), Attendance Patterns, Leaving Date, Unenrolment Reason, Destination

All Contacts By Student

Report Focus: Parents, Guardians and Contacts

Report Description: List of primary guardians with full contact details including phone number, email, and address.

Report Columns: UPN, Legal First Name, Legal Last Name, Year group(s), Arbor Student ID, Title, First Name, Last Name, Arbor Guardian ID, All email address(es), Emergency Contact Priority, Postal Address (Line 1), Postal Address (Line 2), Postal Address (Line 3), Postal Address (Town), Postal Address (State), Postal Address (Postal Code), Postal Address (Country), Identification Document Number, Relationship Type, Is Primary Guardian?, Is Legal Guardian?, Unsubscribed From Comms, Is Authorised To Collect?, Telephone Number (Mobile)

All Guardians Emergency Contact Numbers Report

Report Focus: Parents, Guardians and Contacts

Report Description: List of primary guardians, relationship type, and contact numbers.

Report Columns: Student, Registration form(s), Guardian, Relationship Type, Emergency Contact Priority, Telephone Number (Mobile), Telephone Number (Home), Telephone Number (Work)

All Siblings report

Report Focus: Students

Report Description: Students and all of their siblings.

Report Columns: Name, Registration form(s), Siblings (All)

Attendance Concern Report

Report Focus: Students

Report Description: Highlights students with 90% or below attendance and assigns points based on specific criteria to categorise them as 'Concern' or 'Monitoring'.

Report Columns: Name, Year group(s), Registration form(s), Reg. Form Tutor(s), Interventions, No. of sessions present last week, No. of sessions present this week, Last week comparison, Attendance this academic year, No. of sessions missed, No. of days missed this academic year (All Absence), Session of unauthorised absence this year, No. of Days missed this academic year due to unauthorised absence, Statutory/Roll Call Attendance (Custom), Concern?

Attendance Current Year VS Last Year

Report Focus: Students

Report Description: Compare student attendance for the current and previous year or term. Edit to add grouping for Year group or another student group.

Report Columns: Name, Registration form(s), Present This Academic Year, Auth. Absent This Academic Year, Unauth. Absent This Academic Year, Late This Academic Year, Present Last Academic Year, Auth. Absent Last Academic Year, Unauth. Absent Last Academic Year, Late Previous Academic Year

Attendance of ASP Groups

Report Focus: Students

Report Description: Attendance and suspension data by demographic group, with group size and term averages.

Report Columns: ASP Group (Whole School), Group Size (number of students in the ASP grouping), Statutory/Roll Call Attendance (Present), Total Suspensions

Behaviour by student and by type

Report Focus: Behavioural Incidents

Report Description: Total amount of each Behavioural Incident that is recorded against each student.

Report Columns: Students, Incident Name, Group Size (Number of Incidents)

Class codes linked to subjects

Report Focus: Courses and Classes

Report Description: Parent course, course/class name, and subject.

Report Columns: Parent Course, Course/Class Name, Subject

Class Numbers

Report Focus: Courses and Classes

Report Description: Class enrollment report detailing student demographics, including gender, SEN, and pupil premium counts.

Report Columns: Parent Course, Course/Class Name, Course Leads, Number of Enrolled Students, Female Students, Male Students, Number of In Year Admissions, Number of SEN Students, Number of Pupil Premium Eligible Students, Number of FSM Students

Courses and classes with detentions (count)

Report Focus: Courses and Classes

Report Description: List of courses and classes with count of detentions.

Report Columns: Parent Course, Course/Class Name, Total Detentions

Current Staff Members

Report Focus: Staff

Report Description: Contact details for all current staff members only.

Report Columns: Name, Postal Address (Full), Telephone Number (Mobile), Telephone Number (Home), All email address(es)

Date of Birth and student details report

Report Focus: Students

Report Description: Basic details for students, alongside their date of birth and age.

Report Columns: Name, Year group(s), Registration form(s), Sex, Postal Address (Full), Postal Address (Line 1), Postal Address (Line 2), Postal Address (Line 3), Postal Address (Town), Postal Address (Postal Code), Primary Guardian Main Telephone Numbers, Date of Birth, Age (Years)

Dietary Requirements Report

Report Focus: Students

Report Description: Students' dietary requirements and allergies.

Report Columns: Name, Year group(s), Dietary Requirements

EHCP and social worker report for the DfE Form

Report Focus: Students

Report Description: Students' SEN status and their inclusion in a Social Worker custom group.

Report Columns: Name, SEN status, Custom Groups

Enrolled Siblings report

Report Focus: Students

Report Description: Students and their siblings who are currently enrolled

Report Columns: Name, Registration form(s), Siblings (Enrolled Only)

Family and student information

Report Focus: Parents, Guardians and Contacts

Report Description: Students and their primary guardians, plus student ages so you can sort columns to find the oldest siblings.

Report Columns: Name, Class, Guardian, Relationship Type, Student Lives with Guardian, Age (Chronological), Date of Birth, Siblings (Enrolled Only)

Free School Meal Students' Primary Guardian information for Supermarket Vouchers

Report Focus: Parents, Guardians and Contacts

Report Description: Primary guardian contact details for FSM students, used to issue supermarket vouchers. No data shown.

Report Columns: Student First Name (delete before sending), Student Last Name (delete before sending), Relationship Type (delete before sending), Contact Priority (delete before sending), Guardian First Name, Guardian Surname, Guardian Email address

Gender Pay Gap

Report Focus: Staff Contract Post

Report Description: Necessary data, including staff details and salary information.

Report Columns: Name, Title, Sex, Position, Reference number, Start date, End date, Pay Scale, Spinal Point, FTE salary, Base pay pro rata, Weekly Working Hours

Individual student demographics report

Report Focus: Students

Report Description: Whether each student falls into each key demographic or not, e.g. tick for Pupil Premium, X for FSM etc.

Report Columns: Name, EAL?, FSM?, Ever 6 FSM?, SEN?, LAC?, Pupil Premium Eligible?, Pupil Premium Recipient?, Service Child?, EYPP Recipient?, Disadvantaged?, Born in Summer?, Young Carer?

Leavers

Report Focus: Students

Report Description: Leavers from the previous academic year, including dates, destinations, and reasons for leaving.

Report Columns: Name, Registration form(s), Statutory/Roll Call Attendance (Present)

Less than 90% Attendance Report

Report Focus: Students

Report Description: Students with 10% or more absences this academic year.

Report Columns: Name, Registration form(s), Statutory/Roll Call Attendance (Present)

Looked after students and their guardians' contact details report

Report Focus: Students

Report Description: Students who are Looked After (In Care) and the contact details for their primary guardians.

Report Columns: Name, LAC?, Looked After (In Care) Status, Looked After (In Care): Responsible Local Authority, Primary Guardians, Highest Priority Primary Guardian Email Address, Primary Guardian Mobile Numbers, Primary Guardian Main Telephone Numbers

Mode of Travel Report

Report Focus: Students

Report Description: Student UPN, name, DOB, postcode, transportation mode (e.g. car), year group, sex and ethnicity.

Report Columns: UPN, Forename, Surname, DOB, Postcode, Modes of travel, NCYear, Sex, Ethnicity, Ethnicity Code

Number of Behaviour Incidents with each Severity this year

Report Focus: Students

Report Description: Each student's totals for positive, neutral, and negative incidents, as well as a count of how many of each severity for this academic year.

Report Columns: Name, Year group(s), Registration form(s), Pupil Premium Eligible?, EAL?, SEN?, SEN need(s), Total Number of Positive Incidents, Total +1 Incidents, Total +2 Incidents, Total +3 Incidents, Total +4 Incidents, Total + 5 Incidents, Number of Neutral Incidents, Total Number of Negative Incidents, Total -1 Incidents, Total -2 Incidents, Total -3 Incidents, Total -4 Incidents, Total -5 Incidents

Nursery/Reception Milk Numbers Report

Report Focus: Students

Report Description: Dates of birth of your reception and nursery students to see who is entitled to free milk.

Report Columns: Name, Date of Birth

Parent Contact Details

Report Focus: Parents, Guardians and Contacts

Report Description: Primary guardian contact details for this academic year, including phone, email, and postal address.

Report Columns: First Name, Last Name, Relationship Type, First Name, Last Name, Telephone Number (Mobile), Telephone Number (Home), Telephone Number (Work), Email Address (Main), Postal Address (Full)

Physical Intervention Count by Staff

Report Focus: Students involved in Behavioural Incidents

Report Description: The number of physical interventions recorded for each staff member who has been involved in a restraint or physical intervention this year.

Report Columns: Restraint Staff, Group size (number of restraints)

Population Analysis Report

Report Focus: Students

Report Description: How many males, females and overall numbers you have in each of your registration forms.

Report Columns: Year group(s), Registration Form, Sex, Group Size (number of students in the Year Group)

Primary guardians who are down as not living with their child

Report Focus: Parents, Guardians and Contacts

Report Description: Guardians who are recorded as Primary guardians and whether or not they currently live with their child.

Report Columns: Guardian, Guardian address, Relationship Type, Student, Student address

Reception Baseline Assessment Report

Report Focus: Students

Report Description: This report by default does not contain any student assessment marks, only student details for importing.

Report Columns: UPN, First Name, Surname, Sex, Date Of Birth, Class Name, Date Started at Establishment

Religion %

Report Focus: Students

Report Description: The percentage and number of students following each religion in a cohort.

Report Columns: Religion Group Percentage (percentage of students with that religion), Group Size (number of students with that religion)

ScholarPack Staff Details report template

Report Focus: Staff

Report Description: Staff with a range of fields, including job titles, contact details and date of birth.

Report Columns: Title, Name, Sex, Gender Identity, Arbor Staff ID, Identification Document Number, Date of Birth, Medical Conditions, Ethnicity, Is Teaching Staff?, Business Roles, Most Recent Position Category, Job Title(s), Expected End Date, Email Address (Main), All email address(es), Telephone Number (Home), Telephone Number (Mobile), Postal Address (Full), Continuous service start date

SEN report template

Report Focus: SEN

Report Description: Student information with breakdown of special education needs.

Report Columns: UPN, Name, Year group(s), Registration form(s), Date of Birth, Ethnicity, SEN status, Sen Need, SEN Description, SEN Need Ranking, Start Date, Funded Hours, SEN status

Single Central Staff Record

Report Focus: Staff

Report Description: Staff details for the academic year, including identity documents, DBS checks, prohibition from teaching, and right to work status

Report Columns: First Name, Last Name, Date of Birth, Postal Address (Full), Passport Document Number, Passport Document Expiry Date, Driving License Document Number, Driving License Document Expiry Date, Children's Barred List Check Authenticated By Staff, Children's Barred List Check Authenticated Date (blank if expired), Prohibition From Teaching Check Authenticated By Staff, Prohibition From Teaching Check Authenticated Date (blank if expired), DBS Check Reference Number, DBS Check Authenticated By Staff, DBS Check Authenticated Date (blank if expired), DBS Check Expiry Date (blank if expired), Right to Work in the UK Check Authenticated By Staff, Right to Work in the UK Check Authenticated Date (blank if expired), Academic Qualifications Check Authenticated By Staff, Academic Qualification Check Authenticated Date (blank if expired), Overseas Criminal Record Check Authenticated By Staff, Overseas Criminal Record Check Check Authenticated Date (blank if expired), Overseas Additional Check Authenticated By Staff, Overseas Additional Check Authenticated Date (blank if expired), Identity Check Authenticated By Staff, Identity Check Authenticated Date (blank if expired), Prohibition on participation in management (section 128) Check Authenticated By Staff, Prohibition on participation in management (section 128) Check Authenticated Date (blank if expired)

Staff Leavers This Year Report

Report Focus: Staff

Report Description: View staff members who are leaving or have left the school this year.

Report Columns: Name, Job Title(s), Business Roles, Leaving Date, Staff Destination

Staff Medical Conditions

Report Focus: Staff

Report Description: Medical conditions of current staff.

Report Columns: Name, Profile Picture, Medical Conditions, Next of Kin

Staff Payroll Report

Report Focus: Staff

Report Description: Staff names, payroll details, National Insurance and teacher Numbers.

Report Columns: Title, Legal First Name, Legal Last Name, Payroll Numbers, Passport Number, National Insurance Number, Date of Birth, Teacher Number, Postal Address (Full)

Staff Transport Report

Report Focus: Staff

Report Description: All transportation registration details for staff (Vehicle Reg Number and Postal Address)

Report Columns: Name, Postal Address (Postal Code), Vehicle Reg. Number

Started In Year report

Report Focus: Students

Report Description: Students' current year group, and the year group they joined the school in.

Report Columns: Name, Year group(s), Year Group On Joining, Entry Date (First), Entry Date (Most Recent)

Student Ages now and on chosen date

Report Focus: Students

Report Description: See student ages today and on a date of your choice.

Report Columns: Name, Year group(s), Registration form(s), Age today, Age on specific date (edit report to choose)

Student Starter

Report Focus: Students

Report Description: Student profile details for this academic year, including year group, SEN, UPN, and key demographics.

Report Columns: First Name, Last Name, Year group(s), Registration form(s), Date of Birth, Sex, Ethnicity, Religion, SEN?, SEN status, Gifted + Talented?, UPN, Pupil Premium Eligible?, Ever 6 FSM?, FSM?, Service Child?

Termly 100% Attendance report

Report Focus: Students

Report Description: Find students with 100% attendance this term

Report Columns: Name, Registration form(s), Present last term, Present this term

This Week Last Week Attendance Comparison Report

Report Focus: Students

Report Description: Current week and last week's present attendance percentage for each student, plus a colour-coded comparison.

Report Columns: Name, Last Week Attendance, This Week Attendance, Advanced Formula (has the student's attendance improved week on week?)

Weekly Attendance Report by Year

Report Focus: Students

Report Description: Student weekly attendance grouped by year group.

Report Columns: Year Group, Attendance this week, Number of students in the year group

Year on Year Persistent Absentee percentage % report

Report Focus: Students

Report Description: A Persistent Absence figure for each year group, for each academic year from 2018/2019.

Report Columns: Year group, Number of students this year, Percentage of students PA in 2018/2019, Percentage of students PA in 2019/2020, Percentage of students PA in 2020/2021, Percentage of students PA in 2021/2022, Percentage of students PA in 2022/2023, Percentage of students PA Last year, Percentage of students PA This year, Percentage Difference between last year and this year