Data Dictionary and Entity Relationship Diagrams
Technical documents are stored on the on the Support Portal and require an account to access them. When you click on a document you will be taken to the portal where a login page will open if you are not already logged in. You can then click on the attachment on the right in the KB article to open the document.
See the One Education Data Dictionary which describes the structure, format, and location of data as it is stored within the database, to help with the creation of reports.
| Document | Product | Last Updated | hf:categories | hf:tax:release |
|---|---|---|---|---|
| One Education Data Dictionary | Technical | 01/11/2024 | technical | 3-82 3-83 3-84 3-85 |
| ERD – ICS Exemplars (3.65 onwards) | SEN/SEND | sen-send | 3-65 3-66 3-67 3-68 3-69 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – Exclusions (3.65 onwards) | Exclusions, Other Modules | exclusions other-modules | 3-65 3-66 3-67 3-68 3-69 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – Training Manager v4 (Finance) (3.65 onwards) | Other Modules, Training Manager | other-modules training-manager-other-modules | 3-65 3-66 3-67 3-68 3-69 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – Hearing and Visual Impairment (HIVI) (3.65 onwards) | Hearing & Visual Impairment, Other Modules | hearing-visual-impairment-other-modules other-modules | 3-65 3-66 3-67 3-68 3-69 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – Email Services (3.65 onwards) | No Specific Product | not-specific-product | 3-65 3-66 3-67 3-68 3-69 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – ICS Adoption (3.65 onwards) | SEN/SEND | sen-send | 3-65 3-66 3-67 3-68 3-69 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – ICS Child Cases (3.65 onwards) | SEN/SEND | sen-send | 3-65 3-66 3-67 3-68 3-69 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – Equipment (3.65 onwards) | No Specific Product | not-specific-product | 3-65 3-66 3-67 3-68 3-69 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – ICS CHIN Report (3.65 onwards) | SEN/SEND | sen-send | 3-65 3-66 3-67 3-68 3-69 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – A&T (GIS) (3.65 onwards) | A&T, GIS, System | at gis system | 3-65 3-66 3-67 3-68 3-69 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – ICS Fostering (3.65 onwards) | SEN/SEND | sen-send | 3-65 3-66 3-67 3-68 3-69 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – ICS Social Networking (3.65 onwards) | SEN/SEND | sen-send | 3-65 3-66 3-67 3-68 3-69 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – ICS (3.65 onwards) | SEN/SEND | sen-send | 3-65 3-66 3-67 3-68 3-69 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – Transport v4 – All tables (3.65 onwards) | Transport | transport-2 | 3-65 3-66 3-67 3-68 3-69 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – People (3.65 onwards) | No Specific Product | not-specific-product | 3-65 3-66 3-67 3-68 3-69 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – Communication Log (3.65 onwards) | System, System | system system-system | 3-65 3-66 3-67 3-68 3-69 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – Provision Types (3.65 onwards) | No Specific Product | not-specific-product | 3-65 3-66 3-67 3-68 3-69 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – Conflict Management (3.65 onwards) | System, System | system system-system | 3-65 3-66 3-67 3-68 3-69 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – Service links to Establishments and Posts (3.65 onwards) | No Specific Product | not-specific-product | 3-65 3-66 3-67 3-68 3-69 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – User Defined Fields (3.65 onwards) | No Specific Product | not-specific-product | 3-65 3-66 3-67 3-68 3-69 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| Entity Relationship Diagram (ERD) Tables (3.65 onwards) | No Specific Product | not-specific-product | 3-65 3-66 3-67 3-68 3-69 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – Governors (3.65 onwards) | Governors, Other Modules | governors-other-modules other-modules | 3-65 3-66 3-67 3-68 3-69 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – Grants and Benefits (3.65 onwards) | Grants and Benefits, Other Modules | grants-and-benefits other-modules | 3-65 3-66 3-67 3-68 3-69 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – Training Manager / Music v4 (3.65 onwards) | Music, Other Modules, Training Manager | music-other-modules other-modules training-manager-other-modules | 3-65 3-66 3-67 3-68 3-69 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – B2B Phase 1 (3.65 onwards) | B2B, Data Management | b2b performance-monitoring-data-management | 3-65 3-66 3-67 3-68 3-69 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – B2B Phase 2 (3.65 onwards) | B2B, Data Management | b2b performance-monitoring-data-management | 3-65 3-66 3-67 3-68 3-69 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – B2B Phase 3 (3.65 onwards) | B2B, Data Management | b2b performance-monitoring-data-management | 3-65 3-66 3-67 3-68 3-69 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – Portal Configuration (3.65 onwards) | Portals | portals | 3-65 3-66 3-67 3-68 3-71 3-72 3-73 3-74 3-75 3-76 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – Provider Portal (3.65 onwards) | Portals, Provider Portal | portals provider-portal | 3-65 3-66 3-67 3-68 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – PULSE Key Stage (3.65 onwards) | Data Management, PULSE | performance-monitoring-data-management pulse-performance-management-data-monitoring | 3-65 3-66 3-67 3-68 3-69 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – PULSE Aspects, Results and Templates (3.65 onwards) | Data Management, PULSE | performance-monitoring-data-management pulse-performance-management-data-monitoring | 3-65 3-66 3-67 3-68 3-69 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – Attendance (3.65 onwards) | Attendance, Data Management | attendance-performance-management-data-monitoring performance-monitoring-data-management | 3-65 3-66 3-67 3-68 3-69 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – CSS (3.65 onwards) | Children's Support Services, Other Modules | childrens-support-services-other-modules other-modules | 3-65 3-66 3-67 3-68 3-69 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – CSS Activities (3.65 onwards) | Children's Support Services, Other Modules | childrens-support-services-other-modules other-modules | 3-65 3-66 3-67 3-68 3-69 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – EY 30-hours (3.65 onwards) | Early Years, Early Years and Headcount | early-years early-years-and-headcount | 3-65 3-66 3-67 3-68 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – CSS Legal Actions (3.65 onwards) | Children's Support Services, Other Modules | childrens-support-services-other-modules other-modules | 3-65 3-66 3-67 3-68 3-69 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – EY Capacity and Times (3.65 onwards) | Early Years, Early Years and Headcount | early-years early-years-and-headcount | 3-65 3-66 3-67 3-68 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – CSS Person (3.65 onwards) | Children's Support Services, Other Modules | childrens-support-services-other-modules other-modules | 3-65 3-66 3-67 3-68 3-69 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – EY Enquiries (3.65 onwards) | Early Years, Early Years and Headcount | early-years early-years-and-headcount | 3-65 3-66 3-67 3-68 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – SEN and SEND (3.65 onwards) | SEN/SEND | sen-send | 3-65 3-66 3-67 3-68 3-69 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – EY Monitoring, Income and Complaints (3.65 onwards) | Early Years, Early Years and Headcount | early-years early-years-and-headcount | 3-65 3-66 3-67 3-68 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – CSS Statutory Returns (3.65 onwards) | Children's Support Services, Other Modules, Statutory Returns | childrens-support-services-other-modules other-modules statutory-returns-2 | 3-65 3-66 3-67 3-68 3-69 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – EY Ofsted (3.65 onwards) | Early Years, Early Years and Headcount | early-years early-years-and-headcount | 3-65 3-66 3-67 3-68 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – EY Payments (3.65 onwards) | Early Years, Early Years and Headcount | early-years early-years-and-headcount | 3-65 3-66 3-67 3-68 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – EY Provider Vacancies (3.65 onwards) | Early Years, Early Years and Headcount | early-years early-years-and-headcount | 3-65 3-66 3-67 3-68 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – EY Providers and Service Provision (3.65 onwards) | Early Years, Early Years and Headcount | early-years early-years-and-headcount | 3-65 3-66 3-67 3-68 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – EY Staff (3.65 onwards) | Early Years, Early Years and Headcount | early-years early-years-and-headcount | 3-65 3-66 3-67 3-68 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – EY Stretched Funding (3.65 onwards) | Early Years, Early Years and Headcount | early-years early-years-and-headcount | 3-65 3-66 3-67 3-68 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – EY Supp (3.65 onwards) | Early Years, Early Years and Headcount | early-years early-years-and-headcount | 3-65 3-66 3-67 3-68 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – EY Early Years and FID (3.65 onwards) | Early Years, Early Years and Headcount, Family Information Services | early-years early-years-and-headcount family-services-information | 3-65 3-66 3-67 3-68 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – EY Extended Childcare Directory / Family Service Directory (3.65 onwards) | Early Years, Early Years and Headcount | early-years early-years-and-headcount | 3-65 3-66 3-67 3-68 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – Carer (3.65 onwards) | Early Years, eSuite | early-years esuite | 3-65 3-66 3-67 3-68 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – Child (3.65 onwards) | Early Years, eSuite | early-years esuite | 3-65 3-66 3-67 3-68 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – A&T (Online Reports) (3.65 onwards) | A&T | at | 3-65 3-66 3-67 3-68 3-69 3-70 3-71 3-72 3-73 3-74 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – Cost Effectiveness (3.65 onwards) | Early Years, eSuite | early-years esuite | 3-65 3-66 3-67 3-68 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – A&T (Online Applications – Public) (3.65 onwards) | A&T | at | 3-65 3-66 3-67 3-68 3-69 3-70 3-71 3-72 3-73 3-74 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – eStart (3.65 onwards) | Early Years, eSuite | early-years esuite | 3-65 3-66 3-67 3-68 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – A&T (Module Administration) (3.65 onwards) | A&T | at | 3-65 3-66 3-67 3-68 3-69 3-70 3-71 3-72 3-73 3-74 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – eStart User (3.65 onwards) | Early Years, eSuite | early-years esuite | 3-65 3-66 3-67 3-68 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – A&T (Manage Transfer Groups – Manage Applications) (3.65 onwards) | A&T | at | 3-65 3-66 3-67 3-68 3-69 3-70 3-71 3-72 3-73 3-74 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – Events (3.65 onwards) | Early Years, eSuite | early-years esuite | 3-65 3-66 3-67 3-68 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – A&T (Manage Allocations) (3.65 onwards) | A&T | at | 3-65 3-66 3-67 3-68 3-69 3-70 3-71 3-72 3-73 3-74 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – Family (3.65 onwards) | Early Years, eSuite | early-years esuite | 3-65 3-66 3-67 3-68 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – A&T (Appeals) (3.65 onwards) | A&T | at | 3-65 3-66 3-67 3-68 3-69 3-70 3-71 3-72 3-73 3-74 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – Location Manager (3.65 onwards) | Early Years, eSuite | early-years esuite | 3-65 3-66 3-67 3-68 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – A&T (All tables) (3.65 onwards) | A&T | at | 3-65 3-66 3-67 3-68 3-69 3-70 3-71 3-72 3-73 3-74 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – UNA (3.65 onwards) | Early Years, eSuite | early-years esuite | 3-65 3-66 3-67 3-68 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – Bases (3.65 onwards) | Bases, Other Modules | bases other-modules | 3-65 3-66 3-67 3-68 3-69 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – Children in Employment (3.65 onwards) | Children in Employment, Other Modules | children-in-employment other-modules | 3-65 3-66 3-67 3-68 3-69 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – Children in Entertainment (3.65 onwards) | Children in Entertainment, Other Modules | children-in-entertainment other-modules | 3-65 3-66 3-67 3-68 3-69 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 | |
| ERD – EPM V4 (3.65 onwards) | Education Plan Monitoring, Other Modules | education-plan-monitoring-other-modules other-modules | 3-65 3-66 3-67 3-68 3-69 3-70 3-71 3-72 3-73 3-74 3-75 3-76 3-77 3-78 3-79 3-80 3-81 3-82 3-83 3-84 3-85 |