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

CEDS Integrated Data Store (IDS)

CEDS supports standardizing educational organizations and their relationships with other organizations, people, and time. The Integrated Data Store is a reference model for operational implementations aligned to the CEDS standards. The P-20W focus of CEDS is supporting a transition from siloed, domain-specific, or location-specific, data sets to data that is compatible across domains and geographic boundaries. In addition to existing state and federal reporting and for analysis and comparison of aggregate statistics, the standards support data that moves with a learner from an early learning program to K12 to postsecondary to adult education and workforce learning programs. The latest release of CEDS also focuses on use cases that support people’s relationship with learning processes — the inputs, process steps (work), and outputs of learning — beginning with learning standards and assessments.

The IDS is a 3rd normal form structure organized around the key concepts of organization, person, and role. The IDS was developed with the goal of supporting physical implementations that could function as an “operational data store” for integrated P-20W data providing the most current available view of each organization, person, and role.

The IDS starts with a flexible directory of organizations that may have multiple parent-child relationships with each other. People exist independently, but they do not have roles outside of their relationship to a specific organization for a specific date range. Each person shares common attributes, or data points, that allow us to represent all levels as ‘Persons.’ Each Person has one or more ‘roles.’ Roles are a time-aware association between a Person and an Organization

At the intersection of organizations, persons, and learning resources are key learning processes. CEDS includes learning resources and process data elements definitions, such as learning standards, learning goals, learner assignments, learner activity, and learner achievements. Also defined in CEDS are the data elements and relationships covering formative, summative, and benchmark assessment processes.


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.

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