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:

• Expand the Data Warehouse Fact and Dimension tables to match the updated CEDS Data Warehouse v11.

• Align the column names between the Generate Staging and CEDS Data Warehouse environments for ease of use and consistency.

• Expand the handling of Disability Types.

• Update all data migrations to use the simplified Staging-to-RDS process.

• Add more visibility into the data migrations by making the Data Migrations Histories Log table viewable on the migration pages.

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.

113KB

Generate 11.0 staging field mapping.xlsx

Open

Excel version of the Generate 11.0 staging field map

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.

Child Count

Report	Approved Change	Reference #	Impact
FS089	Updated Zero Count Logic in RDS.Get_CountSQL to exclude LEAs that don't serve PK	CIID-5771	Data

Discipline

Directory

Membership

CCD School

MEP Students Eligible and Served

Primary Nighttime

User Interface

Approved Change	Reference #	Impact
Made the log table, Data Migration Histories, available in the User Interface during the migrations.	CIID-5693 CIID-5799 CIID-5792	Reports

General

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:

• Windows 10 Pro

• Google Chrome, Version 68 0.3440.106 (Official Build) (64-bit) and Firefox Quantum 61.01 (64 bit)

---

Office Hour

Recording from the Generate 11.0 - Office Hour session