Common Education Data Standards Logo
Create an Account Forgot User Name  or Password

Integrated Data Store

  • IDS factors the entities and attributes of the DES with standard technical syntax and 3rd normal form.
  • The IDS Logical Model provides a standard framework for integration of P-20 data systems through a well-normalized “operational data store”.
  • A “record” is generally added for each Person-Organization Relationship change event in the system. This CEDS logical model does not directly address the production aspects of log and change management.



This video describes how the CEDS Integrated Data Store (IDS) can help developers with new education software projects.

CEDS Integrated Data Store (IDS)

CEDS Integrated Data Store (IDS)

The CEDS IDS files reside on the CEDS Open Source Community (OSC) site on GitHub. Previous version scripts were modified to reflect this change. "NDS" changed to "IDS" with IDS versioning appended to the end of the database names, e.g., [CEDS-NDS-V7] became [CEDS-IDS-V7_0_0_0].


    To access the CEDS IDS on GitHub, click on the GitHub button then select the CEDS-IDS repository.

Data Model Documentation

Documents providing a printable representation of the CEDS Data Model, including entity relationship diagrams, case studies, and the integrated data store tables and fields, can be found on the CEDStandards/CEDS-IDS GitHub repository in the /doc/ directory.

Database Model Downloads

SQL Script

A database script to generate a sample database is provided for those users who would like to take the entities shown on the entity relationship diagrams and work with them on a sample database representing the IDS model.

Scripts for creating a new instance of the latest CEDS IDS, upgrading existing instances of the IDS, load CEDS Element metadata, and load CEDS Option Set values to reference tables, can be found on the CEDStandards/CEDS-IDS GitHub repository in the /src/ directory.


Archive files for each release of CEDS IDS can be found on the CEDStandards/CEDS-IDS GitHub repository in the Releases tab.

Person to person relationships

Clicking on any of the buttons or links above, except the CEDS IDS presentation, will exit the CEDS website. We have provided access to these external sites because they have information that may be of interest to our users. CEDS does not necessarily endorse the views expressed or the data and facts presented on these external sites.

Common Education Data Standards