SLDS Data Warehouse Data Mapping to CEDS

2026-11-03

1 . Align SLDS data warehouse elements for 20 assessment domain tables and approximately 5 finance domain tables with the CEDS data model . The mapping should be guided by the Common Education Data Standards found at https :// ceds . ed . gov /. a . If an element from our SLDS data warehouse does not align with the CEDS data model , the vendor will extend the CEDS data model to incorporate it . b . Develop workflows and processes to Extract , Transform , and Load ( ETL ) data from the old databases to the new CEDS data model . i . A complete set of process and procedure documentation , including step - by - step training guides for NHED staff . ii . Delivery of staff training sessions . iii . The vendor will work with staff to initially run the old and new data models in parallel until the transition is completed and verified . iv . Troubleshoot data migration issues . 2 . Create 19 data mart domains ( e . g ., Attendance , membership , graduation & cohort , demographics , assessment , accountability , educators , financial , etc ....) from CEDS that closely resemble NHED ’ s existing data marts . The directory and enrollment data marts have been completed . i . A complete set of process and procedure documentation , including step - by - step training guides for NHED staff . ii . Delivery of staff training sessions . iii . The vendor will work with staff to reconcile the old and new data marts . iv . Troubleshoot data migration issues . 3 . Upgrade CEDS from CEDS data warehouse v11 to CEDS data warehouse v13 and work with NHED personal to walkthrough and document the process . This process may include moving some extension elements to core elements and updating the orchestration and ETL scripts . 4 . Vendor must align the data dictionary for the assessment and finance domains from the current SLDS data warehouse to the CEDS data model saved in the GitHub repository ( NHED ’ s version control software ). 5 . Windows Active directory will be used to maintain security to the new CEDS data model . 6 . The existing SLDS data warehouse and the new CEDS data model are both housed on servers maintained by the New Hampshire Department of Information Technology ( NHDOIT ) and the vendor chosen through this process will work extensively with NHDOIT personnel and the Bureau of Education Statistics personnel .

New Hampshire

2026-04-28