Local Authority Education Record Contextual Data
Table ID: BiB_Education_Record.edrecs_annual_context
| Entity type | Variables | Entities | Updated | Related tables |
|---|---|---|---|---|
| Participant | 10 | 11717 | 2022-10-12 | NA |
Data set in long form with contextual information for each academic year a child is at school and data is available. Collected information includes school identifieers, SEN status, free school meals status and ‘Gifted and Talented’ status. edcont_schoolid provides a unqiue ID for each school; as this is based on UPRN this ID will not be affected by academisation/name changes. edcont_psuedoURN can be used to link to the edrecs_additional_school_info table to obtain school level information for each child
| variable | label | value_type | summary |
|---|---|---|---|
| edcont_schoolentry | Year started school | decimal | mean (sd) 2013.00 (1.14) min < median < max 2011.00 < 2013.00 < 2015.00 Complete: 115562 (100.00%) |
| edcont_academicyear | School year data was taken from | decimal | 1 : R 10 : Y9 11 : Y10 2 : Y1 3 : Y2 4 : Y3 5 : Y4 6 : Y5 7 : Y6 8 : Y7 9 : Y8 Complete: 114822 (99.36%) |
| edcont_eal | Does child have English as a second language? | decimal | 1 : No 2 : Yes Complete: 81159 (70.23%) |
| edcont_fsm | Is child is in receipt of free school meals? | decimal | 1 : No 2 : Yes Complete: 109685 (94.91%) |
| edcont_g_t | Is child classed as ‘gifted and talented’? | decimal | 1 : No 2 : Yes Complete: 109685 (94.91%) |
| edcont_lac | Is child in the care of their local authority? | decimal | 1 : No 2 : Yes Complete: 109685 (94.91%) |
| edcont_sen | Does child have special educational needs? | decimal | 1 : EHCP 2 : Not SEN 3 : School Action 4 : School Action Plus 5 : SEN Support 6 : Statement Complete: 107856 (93.33%) |
| edcont_schoolstatus | School and education administrative status | decimal | 1 : LA school in Bradford 2 : Unknown - application processing 3 : Unknown - unable to trace 4 : Home educated 5 : Independpent school 6 : LA school outisde Bradford LA Complete: 105439 (91.24%) |
| edcont_schoolid | Unique BiB generated school ID | decimal | mean (sd) 85.42 (47.53) min < median < max 1.00 < 88.00 < 168.00 Complete: 100008 (86.54%) |
| edcont_psuedoURN | Psueodnymised URN number | text | 193 unique values 99484 non-missing values 1 to 40 characters |