For schools in England, you can now run Data Check Reports in the School census by selecting a Return, clicking on Reports and choosing either On Roll or Leavers from the dropdown list.
▶ On Roll Data Check Report
The On RollData Check Report consists of the following tabs and column headers:
Pupil Identifiers - UPN, Surname, Forename, DOB, ULN, Former UPN, Middle Names, Preferred Surname, Former Surname, Sex
Pupil Characteristics - UPN, Surname, Forename, DOB, Language, School Lunch Taken, YSSA, Service Child, Top Ip Funding, PLAA
FSM Eligibility - UPN, Surname, Forename, DOB, FSM Start Date, FSM End Date, Country
Early Years Funding - UPN, Surname, Forename, DOB, Funded Hours, Extended Hours, Expanded Hours, Eligibility Code, DAF Indicator, Hours At Setting, Funding Basis, EYPP, EYPP Basis for Funding
Pupil Status - UPN, Surname, Forename, DOB, Enrol Status, Entry Date, Part Time, Boarder, NC Year
Special Educational Needs(excludes Special & Pupil Referral Unit) - UPN, Surname, Forename, DOB, SEN Provision, SEN Unit Indicator, Resourced Provision Indicator
AP Provision Detail(Pupil Referral Unit only) -
School Arranged AP Detail(excludes Nursery) - UPN, Surname, Forename, DOB, URN, UKPRN, AP Setting Type, Company Number, AP Placement Postcode, Placement Reason, Entry Date, SEN Provision on Entry, Leaving Date, SEN Provision on Leaving, AP Attendance Pattern, AP Sessions Per Week
Exclusion (excludes Nursery) - UPN, Surname, Forename, DOB, Category, Reason1, Reason2, Reason3, Start Date, Sessions, SEN provision on Start date of Exclusion
Address - UPN, Surname, Forename, DOB, Postcode, UPRN, Address Line 1, Address Line 2, Address Line 3, Address Line 4, Address Line 5
Pupil Status - UPN, Surname, Forename, DOB, Leaving Date, Entry Date, Part Time, Boarder, NC Year
AP Provision Detail(Pupil Referral Unit only) -
School Arranged AP Detail - UPN, Surname, Forename, DOB, URN, UKPRN, AP Setting Type, Company Number, AP Placement Postcode, Placement Reason, Entry Date, SEN Provision on Entry, Leaving Date, SEN Provision on Leaving, AP Attendance Pattern, AP Sessions Per Week
Exclusions - UPN, Surname, Forename, DOB, Category, Reason1, Reason2, Reason3, Start Date, Sessions, SEN provision on Start date of Exclusion
Address(Secondary, All-Through, & Pupil Referral Unit only) - UPN, Surname, Forename, DOB, Postcode, UPRN, Address Line 1, Address Line 2, Address Line 3, Address Line 4, Address Line 5
Export the tabs individually to a downloaded Excel file.
Hover over a column header to click on the three bars and reveal the options to Pin Column, Autosize This Column, Autosize All Columns, and Reset Columns.
Config > Setup > Roles And Permissions
The Reports option will have to be enabled from the Census module for the appropriate roles.