CIID
G3LinkedIn

Release Notes 11.0

This document provides a description of the technical enhancements to Generate version 11.0 (v11) released in August 2023.

Please note: Generate moved from version 5.3 to version 11 in this release to align with the CEDS Data Warehouse.

Release Overview

Generate version 11.0 is a significant update that leverages the updated CEDS Data Warehouse, better aligns the Generate Staging environment with the Data Warehouse, implements Staging-to-RDS for all migrations, and adds some additional tools to aid in the file migration process.

Some of the highlights of this release:

State ETL changes:

There are changes that will be required for existing Staging ETLs to work for v11 and they are detailed below.

  1. The column names within the Staging environment were modified to adhere to the CEDS naming standards, aligning them with those used in the CEDS Data Warehouse. This is the supporting spreadsheet that helps identify the mapping between previous column name and new column name in the tables that are affected.

  1. These three changes are documented in the spreadsheet, however, are called out here since they will impact each of the Student related tables in Staging.

    1. The v5.3 column LEA_Identifier_State will now map to LEAIdentifierSeaAccountability

    2. The v5.3 column School_Identifier_State will now map to SchooldentifierSea

    3. The v5.3 column Student_Identifier_State will now map to StudentIdentifierState

  2. The Staging.PersonStatus table was used to identify Special Education students by populating:

    1. IdeaIndicator

    2. Idea_StatusStartDate

    3. Idea_StatusEndDate

    Those columns have been dropped from that table and a record will need to be loaded into:

    1. Staging.ProgramParticipationSpecialEducation with IdeaIndicator

    2. ProgramParticipationBeginDate

    3. ProgramParticipationEndDate

to identify the student as Special Education.

  1. There is a new staging table and a new dimension table named IDEADisabilityTypes. In v5.3 there was a single field named PrimaryDisabilityType in Staging.PersonStatus . That field has been dropped. This new table allows the state to load every disability that applies to the student so all of them can be captured. So, if a student is identified with four disabilities, you should load four rows into the new table. There are two flags in the table, IsPrimaryDisability and IsSecondaryDisability. For the purposes of EDFacts reporting set the IsPrimaryDisability flag for the row that should be reported for that student.

Generate Enhancements

The following EDFacts reports were updated in this release.

Type of Impact:

  • Data – the changes will improve data quality and completeness.

  • Database – changes to the Generate database structure.

  • Migration – the changes impact a data migration process.

  • Performance – the changes improve the performance of a data migration.

  • Reports - changes that impact the Reports available in Generate.

  • Submission Files – the changes may impact submission file(s)

  • Source to Staging ETL – the changes may require modifications to the SEA’s Source to Staging ETL

  • User Interface – the changes impact the Generate User Interface and/or migration process.

ReportApproved ChangeReference #Impact

FS089

Updated Zero Count Logic in RDS.Get_CountSQL to exclude LEAs that don't serve PK

CIID-5771

Data
Approved ChangeReference #Impact

Made the log table, Data Migration Histories, available in the User Interface during the migrations.

CIID-5693

CIID-5799

CIID-5792

Reports

Upgrade Procedure

No changes have been made to the Generate upgrade procedure for this release. Follow the standard Generate upgrade process to install version 11.0.

Compatible Systems

Generate was tested on the following operating systems and browsers:

Office Hour

PreviousRelease Notes 11.1NextRelease Notes v5.3

Last updated