The following data items are imported from the DfE Weekly Attendance file into Nexus. Since DfE can change this with little to no notice, this list may not be current and fully comprehensive (the full file is imported).
Latest Available Structure
Data Item |
Notes |
|---|---|
academic_term |
text |
UPN |
usual UPN format |
DOB |
date |
sex |
male/female only |
ethnicity |
census ethnicity codes |
| english_additional_language | yes/no/unknown |
compulsory_school_age |
yes/no |
sen_support |
yes/no/unknown |
free_school_meals |
yes/no/unknown |
education_health_care_plan |
yes/no/unknown |
| primary_sen_type | census SEND codes |
| secondary_sen_type | census SEND codes |
looked_after_child |
yes/no/unknown |
previously_looked_after_child |
yes/no/unknown |
child_in_need |
yes/no/unknown |
child_protection_plan |
yes/no/unknown |
persistently_absent |
yes/no |
severely_absent |
yes/no |
unique_reference_number |
free text |
year_group |
N2, N1, R, 1, 2, etc |
| school_local_authority_ukprn | 8 numbers |
| school_local_authority_name | text |
home_local_authority_ukprn |
8 numbers |
home_local_authority_name |
text |
learning_provider-ukprn |
8 numbers |
school_name |
text |
phase |
primary/secondary/special |
pupil_surname |
text |
pupil_forename |
text |
admission_date |
date |
leaving_date |
date |
full_days_missed |
number |
possible_sessions |
number |
absent_sessions |
number |
present_sessions |
number |
approved_educational_activity_sessions |
number |
authorised_absent_sessions |
number |
unauthorised_absent_sessions |
number |
Other Weekly Attendance Guide articles
These articles tell you more about the functionality of Weekly Attendance in Nexus