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

CEDS Data Model - Introduction

The CEDS Data Model includes a hierarchical schema of non-technical domains and entities with each CEDS element in context, and a fully-normalized logical model.

The Domain Entity Schema (DES)

DES Tree

The DES provides a user friendly structure to easily identify elements organized by domain and entity. The domains for the current CEDS version include:

  • Early Learning
  • Elementary and Secondary Education (abbreviated as K12)
  • Postsecondary
  • Career and Technical
  • Adult Education
  • Workforce
  • Assessments
  • Credentials
  • Competencies
  • Learning Resources
  • Facilities
  • Implementation Variables
  • Authentication and Authorization

Later releases of CEDS will expand the domains and add additional elements and content within the current domains.

Entities are commonly thought of as persons, places, events, objects, or concepts about which data can be collected. An entity provides context for a data element. Some examples of entities are Early Learning Child, K12 Student, K12 Staff, Postsecondary Student, Postsecondary Institution, etc. There are over 70 entities in the DES.

Links:


CEDS Data Warehouse

CEDS Data Warehouse

    CEDS Data Warehouse

Modeled for longitudinal storage and reporting of P-20W data, the CEDS Data Warehouse implements star schema data warehouse normalization techniques for improved query performance. The CEDS Data Warehouse files reside on the CEDS Open Source Community (OSC) site on GitHub.

CEDS Data Warehouse Parquet

CEDS Data Warehouse Parquet

    CEDS Data Warehouse Parquet

The CEDS Data Warehouse Parquet (DW Parquet) standard is designed for data engineering and data science needs in the cloud. The DW Parquet Models mirror the SQL-based CEDS Data Warehouse. Parquet files are designed for rapid and distributed reporting across multiple technology stacks, data processing and BI tools, and are cloud vendor agnostic. This standard is ideal for stakeholders implementing reporting structures in a data lake environment. The CEDS Data Warehouse files reside on the CEDS Open Source Community (OSC) site on GitHub.

Open Source Community

Open Source Community

    Open Source Community

The OSC is a P20-W education data community that exists to provide collaborative development between CEDS stakeholders to expand and improve CEDS through adding and updating CEDS Elements, the CEDS Integrated Data Store and the CEDS Data Warehouse and to contribute exchangeable code to the CEDS Open Source Repository for stakeholder use.

CEDS Integrated Data Store (IDS)

CEDS Integrated Data Store (IDS)

    CEDS 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].
Common Education Data Standards