Reporting on Learning Aim Enrolments

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 Learning Aim Enrolments.

Learning Aim Enrolments Specific Report Fields

• Learning aim name
• Learning aim instance
• Planned start date
• Planned end date
• Actual end date
• Completion status
• Withdrawal reason
• Classification
• Qualification Award
• Note
• Aim type
• Main learning aim (Core aim)
• Partner UKPRN
• Planned learning hours (Planned learning hours (2nd Year)
• Traineeship?

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 any learning aim enrolments, 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 learning aim enrolment details, 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 learning aim enrolments with a certain planned end date, you could choose the Planned end date filter.

Select Planned end date 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, identify which date you are interested in. You can select whether the date is:

• Equal (=) to a specific date
• Does not equal a specific date
• Before a specific date
• After a specific date
• Is empty/blank
• Is not empty/ blank

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 Planned start date to the report, you will see how many learning aim enrolments have a certain start date, but you would no longer see the detail of the learning aim enrolment, such as learning aim name, learning aim instance, etc

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, Planned start date. 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 learning aim enrolments in your school, but you want them to appear on separate pages depending on the Learning Aim Instance 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, Learning Aim Instance.

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 Learning Aim Enrolments 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
• Actual End Date
• Ad Hoc Assessment Mark
• Consents
• Advanced Calculation/Formula Column
• Age (Chronological)
• Age (Months)
• Age (Years) (Student)
• Aim Type
• All email address(es)
• All Guardians
• AM Roll Call Mark
• AM Roll Call Note
• Arbor Student ID
• Are all primary guardians key workers?
• Attendance Mark (Specific Date)
• Attendance Patterns
• Behaviour type by subject
• 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
• Classification
• Club Absent Attendance for all clubs
• Club Late Attendance for all clubs
• Club Present Attendance for all clubs
• Clubs
• Completion Status
• 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
• 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)
• 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?
• 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
• Learning Aim Instance
• Learning Aim Name
• 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
• Looked After (In Care) Status
• Looked After (In Care) Student Count
• Looked After (In Care): Responsible Local Authority
• Looked After (In Care)?
• Main Learning Aim (Core Aim)
• 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)
• 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
• Note (Learning Aim Enrolment)
• 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
• Partner UKPRN
• Passport Document Number
• Passport Expiry Date
• Permanent Exclusion Decision Date
• Permanent exclusion reason(s)
• Permanent Exclusion Start Date
• Planned EEP Hours
• Planned End Date
• Planned Learning Hours (Student: Funding)
• Planned Learning Hours (Learning Aim Enrolment)
• Planned Learning Hours (2nd year)
• Planned Start Date
• PM Roll Call Mark
• PM Roll Call Note
• Point Award Count Statistic
• 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?
• Qualification Award
• Reg. Form Tutor(s)
• Registration form(s)
• Regular meal provision
• Religion (Student)
• 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?
• Sex (Student)
• Siblings (All)
• Siblings (Enrolled Only)
• 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 linked to Court Order
• Student Number
• Student ParentMail Identifier
• 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)
• Third party standardised test result
• Third party standardised test statistic
• 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 Point Awards
• Total sessions for suspensions
• Total Suspensions
• Traineeship?
• Traveller Status
• Trips
• UCAS Campus
• UCAS Course Code
• UCAS Course Name
• UCAS Institution Code
• UCAS Institution Name
• UCAS number
• UCAS Year of Entry
• UCI
• ULN
• Unactioned attendance fine records (last 10 weeks)
• Unenrolment Reason
• UPN
• User defined fields
• Username
• Visa Document Number
• Visa Expiry Date
• Withdrawal Reason
• Year Group On Joining
• Year Group On Leaving
• Year group(s)
• Year target
• Young Carer Student Count
• Young Carer?