Generate Documentation
CIIDCIID-ReportsG3GitHub
  • Introduction to Generate
  • User Guide
    • Getting Started
      • Requesting Generate
      • User Roles and Logging In
      • Navigating Generate
    • Resources
    • Data Population Summary
      • Producing Reports
      • Reports
      • Running Reports
    • Standard Reports
      • EDFacts Reports
        • Creating Submission Files
      • SPP/APR Reports
      • Reports Library
    • Settings
      • Toggle
      • Update
      • Metadata
      • Data Migration
    • Quality Assurance
    • Support
  • Developer Guides
    • Getting Started
    • Installation
      • OAuth Configuration
      • Configuring Metadata Updates
      • Subfolder configuration
      • Optional Installations
      • Azure Installation Guide
      • Upgrade
        • Generate Update
        • Optional Installations
    • Migration
      • Fact Type Table
        • Assessment Fact Type
        • Child Count Fact Type
        • Directory Fact Type
        • Discipline Fact Type
        • Exiting Fact Type
        • Membership
        • Staff
    • Generate Utilities
      • File Comparison
        • Loading Files
        • Run the File Comparison
        • Reviewing Results
        • Researching Mismatches
      • Staging Validation
        • Staging Table Validation Process
      • Rebuild Indexes
      • Cleanup Grades Offered
      • Cleanup Debug Tables
      • Source System Reference Data Mapping Utility
        • Source System Reference Data
      • Staging Table Snapshot
      • Fact Type Table Validation Process
      • Debug Views for Staging and the Fact tables
    • Generate Architecture
    • GitHub Guide
    • Discord Guide
    • Working With Generate Code
      • Migration Stored Procedures
        • Staging.RUN_DMC
        • RDS.Get_MembershipReportData
        • Staging.Staging-to-DimPeople
        • Staging.Staging-To-DimPeople_K12Students
        • Staging.Staging-to-FactK12ProgramParticipations
        • Staging.Staging-To-FactK12SeclusionsOrRestraints
        • Staging.Staging-to-FactK12StudentCounts_ChildCount
        • Staging.Staging-to-FactK12StudentCounts_Chronic
        • Staging.Staging-to-FactK12StudentCounts_Dropout
        • Staging.Staging-to-FactK12StudentCounts_GraduationRate
        • Staging.Staging-to-FactK12StudentCounts_Homeless
        • Staging.Staging-to-FactK12StudentCounts_HSGradPSEnroll
        • Staging.Staging-to-FactK12StudentCounts_Membership
        • Staging.Staging-to-FactK12StudentCounts_MigrantEducationProgram
        • Staging.Staging-to-FactK12StudentCounts_NeglectedOrDelinquent
        • Staging.Staging-to-FactK12StudentCounts_SpecEdExit
        • Staging.Staging-to-FactK12StudentCourseSections
        • Staging.Staging-to-FactK12StudentDisciplines
        • Staging.Staging-to-FactK12StudentEnrollments
        • Staging.Staging-To-FactSpecialEducation
      • Unit Test By File Spec
        • App.DimK12Staff_TestCase
        • App.DimK12Students_TestCase
        • App.FS002_TestCase
        • App.FS005_TestCase
        • App.FS006_TestCase
        • App.FS007_TestCase
        • App.FS009_TestCase
        • App.FS032_TestCase
        • App.FS033_TestCase
        • App.FS040_TestCase
  • Release Notes
    • Introduction
    • Release Notes 12.4
    • Release Notes 12.3
    • Release Notes 12.2
    • Release Notes 12.1
    • Archive
      • Release Notes 12.0
      • Release Notes 11.4
      • Release Notes 11.3
      • Release Notes 11.2
      • Release Notes 11.1
      • Release Notes 11.0
      • Release Notes 5.3
        • Generate 5.3 Office Hour
      • Release Notes 5.2
        • Generate 5.2 Office Hour
      • Release Notes 5.1
        • Generate 5.1 Office Hour
      • Release Notes 5.0
        • Generate 5.0 Office Hour
      • Release Notes 4.1
      • Release Notes 4.0
      • Release Notes 3.8
      • Release Notes 3.7
      • Release Notes 3.6
      • Release Notes 3.5
      • Release Notes 3.4
      • Release Notes 3.3
      • Release Notes 3.2
      • Release Notes 3.1
      • Release Notes 3.0
      • Release Notes 2.4
    • Release Notes 12.3
  • Hot Fixes
    • Hot Fix - 4/13/2023
Powered by GitBook
On this page
  • Using CEDS to Prepare for a Generate Implementation
  • CEDS Data Warehouse

Was this helpful?

Edit on GitHub
  1. Developer Guides

Generate Architecture

PreviousDebug Views for Staging and the Fact tablesNextGitHub Guide

Last updated 9 months ago

Was this helpful?

The (CEDS) is an education data management initiative developed by education stakeholders through funding by the National Center for Education Statistics (NCES). CEDS allows different entities to speak the same language by having a common terminology or common dictionary. CEDS also includes a toolset - Align and Connect.

Using CEDS to Prepare for a Generate Implementation

There are several steps you will need to take to prepare for the Generate implementation, several of which include the use of the CEDS tools as described below. This information is an initial orientation to the CEDS tools. For more detailed steps on how to prepare for a Generate implementation, see the .

One of the first steps in a Generate implementation is to map your source data elements to CEDS using the Align tool. Align provides a bridge between different datasets. By aligning your datasets to CEDS and then using CEDS as the bridge, you can see how those two datasets intersect. Align also includes a location for database and table names allowing for the alignment between the datasets to be viewed at a more technical level. Datasets that have been aligned to CEDS are called maps.

The Connect tool has many uses, one of which is to define and analyze data used for reporting to the federal government, such as EDFacts reports. Every EDFacts report in Generate has a corresponding CEDS Connection built for it. The Connection identifies the data elements required for the report and offers a crosswalk between the CEDS element and the EDFacts permitted value. When an Align map is created, the data elements from the map can then be compared to the data elements within the Connection using a gap analysis process called myConnect. myConnect informs the technical team of the location of data elements which then informs the ETL process.

Once the Align maps have been created, myConnect can be run with the Generate Connections to identify the location of the data elements in the source, as well as to identify any gaps.

For support with aligning to CEDS, review the available on the CEDS website or contact CIID at or CEDS @ for assistance.

CEDS Data Warehouse

The Generate application is built foundationally on the Common Education Data Standards (CEDS) which provides a standard understanding of elements and their meaning. CEDS is comprised of over 1,700 elements that range from Early Childhood through Workforce. States using Generate may find additional uses for the CEDS Data Warehouse which will contain a standard longitudinal look at their students. The ability to add additional details for research or other local reporting requirements would facilitate the need for these additional CEDS elements. This Implementation Guide provides details on best practices for loading the Staging environment to ensure a successful implementation of Generate.

Common Education Data Standards
CIID Data Integration Toolkit
tutorials
ciidta@aemcorp.com
https://ceds.ed.gov/contactUs.aspx