Release Notes 11.1
This document provides a description of the technical enhancements to Generate version 11.1 released in September 2023.
Release Overview
Generate version 11.1 is primarily focused on the Special Education Assessment files, file specifications 175, 178, 179, 185, 188, and 189. Changes were made to update the staging and dimension tables to bring them into line with CEDS like the v11 release. The code was also modified to accommodate the changes to the file specifications for SY 2023.
SEA ETL changes: The changes to the Assessment file specifications for SY 2023 have two significant modifications. First, there are twelve new Assessment types that are available as permitted values. Second, the available Assessment types are broken down by Grade Level, 3-8 and 9-12. Below are the changes to be aware of regarding SEA ETL code.
Table Updates
Staging.Assessment
AssessmentTypeAdministeredToChildrenWithDisabilities
was renamed toAssessmentTypeAdministered
Staging.AssessmentResult
Student_Identifier_State
was renamed toStudentIdentifierState
LEA_Identifier_State
will be mapped toLeaIdentifierSeaAccountability
School_Identifier_State
was renamed toSchoolIdentifierSea
AssessmentTypeAdministeredToChildrenWithDisabilities
was renamed toAssessmentTypeAdministered
Two new fields added to Staging.AssessmentResult
AssessmentIdentifier
AssessmentRegistrationReasonNotTested
Mapping Update
Staging.SourceSystemReferenceData
The new Assessment Types were added for SY 2023 to TableName = ‘RefAssessmentTypeAdministered’ with default mapping.
Update as necessary
Mapping for the new column,
AssessmentRegistrationReasonNotTested
was added for SY 2023 to TableName = ‘RefAssessmentReasonNotTested’ with default mappings
Update as necessary
Toggle
Review your existing Toggle Assessments to ensure they are accurate for the new Assessment Types for SY 2023
Several of the new assessments are only included in the submission file if they are used by the SEA. There are two new Toggle questions that allow you to define the assessments used in your SEA. The questions are located in the standard Toggle screen (not the Toggle Assessments link) in the Assessments section.
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.
Report | Approved Change | Reference # | Impact |
---|---|---|---|
FS175 FS178 FS179 FS185 FS188 FS189 | Assessment files 175, 178, 179 not producing zero counts. Assessment Files (175, 178, 179, 185, 188, 189) - No Records to Display Create Report data produces no record. Assessment Zero Counts not considering the Participation Status/Grade Level/Subject Assessment Files Technical changes FS175, FS178, FS179, FS185, FS188, FS189 - Metadata & Reports Functionality Assessment Staging-to-RDS changes FS175, FS178, FS179, FS185, FS188, FS189 | CIID-4740 CIID-4921 CIID-5260 CIID-5704 CIID-5905 | Data |
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.1.
Compatible Systems
Generate was tested on the following operating systems and browsers:
Office Hour
Last updated