Data Dictionary and Entity Relationship Diagrams
Technical documents are stored on the on the Capita Software 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 (3.82 onwards) | Technical | 12/03/2024 | technical | 3-82 |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 |