CIID
G3LinkedIn

Release Notes 12.1

This document describes the technical enhancements to Generate version 12.1 released November 1, 2024.

Release Overview

Generate version 12.1 focuses on EDPass submissions due January 8, 2025, specifically enhancing reporting and compatibility for assessment files FS175, FS178, FS179, FS185, FS188, and FS189. Key upgrades include .NET framework updates, streamlined data processing, and expanded test capabilities.

Required State Changes

OAuth Login Support Starting with Generate v12.1, login support using Open Authorization (OAuth) has been added for states that prefer not to use Active Directory (AD). This feature includes configuration options to support OAuth functionality.

Important Note for AD Users Due to a configuration oversight, settings used in the development environment were mistakenly included in the default configuration file. If your state uses AD and you no longer see the login/password option after upgrading to v12.1, follow these steps to restore AD functionality:

  1. Navigate to the location of the Generate files on the web server.

  2. Go to /wwwroot/assets/config and open CONFIG.PROD.JSON.

  3. Update the following variables to be blank:

    jsonCopy code"authType": "",
"clientId": "",
"authority": "",
"redirectUri": ""

  4. Save the file.

  5. Connect to IIS and refresh both the application pool and site for the Generate application.

  6. Clear your browser cache and reload the Generate application.

After completing these steps, the login/password options should reappear, allowing AD to be used for authentication.

🚨 Important .NET update

In Generate 12.1, we’re updating the .NET Core runtime from version 6.0 to 8.0, as support for 6.0 is ending. Use the link below to download the compatible ASP.NET Core Runtime 8.0.10 version for your environment.

NOTE: The server can support multiple versions of .NET at the same time so you can install the newer version prior to upgrading and without removing older versions.

Assessments

We added the ability in version 12.1 to support the reporting of ‘HS’ as the grade level. In order to do that these are the considerations to be aware of.

  1. The Assessment needs to be added/modified with HS selected as the Grade Level. If you are updating existing assessments to use ‘HS’ you would remove the versions of that assessment with Grade Level in 9, 10, 11, or 12. After logging in, from the gear icon, select Toggle. When that page loads select ‘Assessments’ to add or modify State assessment information.

  1. When loading the student assessment data into Staging.AssessmentResult for those assessments, set the GradeLevelWhenAssessed value as ‘HS’.

  2. Add the following mapping to the Staging.SourceSystemReferenceData table to translate the value correctly.

INSERT INTO Staging.SourceSystemReferenceData
VALUES (2024, 'RefGradeLevel', '000126', 'HS', 'HS');

Staging Table Update

In Generate v12.1, the field K12Organization.School_TitleIPartASchoolDesignation has been renamed to K12Organization.School_TitleISchoolStatus. This change may impact any State ETLs that populate Staging.K12Organization or any Snapshot processes that reference the Staging.K12Organization table. Please review your ETL processes and Snapshot configurations to ensure compatibility with this update.

Enhancements

New Testing Capabilities

In Generate 12.1, we have enhanced our testing processes by expanding unit and file specification testing and integrating with EDPass for a streamlined test environment. This integration allows us to validate submission files, verify upload functionality, and conduct data quality checks prior to submission windows, thereby ensuring the reliability and accuracy of Generate’s file specifications.

Documentation Updates

GitHub Guide: This guide provides an overview of working with the Generate GitHub repository. It covers essential steps for accessing the repository, forking and cloning the codebase, submitting pull requests, and reporting issues. This resource is designed to help both new and experienced contributors get involved in the development process and collaborate on Generate’s open-source evolution.

Azure Installation Guide: The new installation guide offers step-by-step instructions for setting up Generate in an Azure environment. It includes guidance on configuring necessary Azure resources, optimizing system performance, and ensuring security within the cloud setup. This guide will streamline the installation process for users aiming to leverage Azure for hosting Generate.

Generate Enhancements

The following EDFacts reports were updated in this release.

Type of Impact:

  • Data – changes will improve data quality and completeness.

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

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

  • Performance – changes improve the performance of the application.

  • Migration – changes impact a data migration process.

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

  • Database – changes to the Generate database structure.

Report #
Report
Change
Ticket
Impact

175 178 179 185 188 189

Assessment

Added ability to include ‘HS' as a Grade Level in Assessment files.

CIID-6030

Data

175 178 179 185 188 189

Assessment

We added 2 columns to Staging.AssessmentResult and added Disability Type to the data that is loaded into the Fact table during migrations to support xxx (need to fill this in)

CIID-7166

Data

039

Directory

Corrected the population of Grades Offered in the submission file for an LEA when the only schools in that LEA are Reportable Programs.

CIID-6904

Data

029

Directory

Cleaned up the population of the State values into the DimLeas, DimK12Schools, DimCharterSchoolAuthorizers, and DImK12CharterSchoolManagementOrganizations tables.

CIID-7057

Data

195

Chronic Absenteeism

Added the dimension table and primary key setup for DimDisabilityStatuses to the report migration process.

CIID-7173

Data

195

Chronic Absenteeism

Cleaned up the Staging to RDS code and the debug views for Chronic Absenteeism to allow migration of the data to support FS195

Data

002

Child Count

Updated the Staging-to-RDS migration for student and staff data to eliminate the possibility of truncation into rds.DimPeople

CIID-7188

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.4.

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)

Generate Office Hour

PreviousRelease Notes 12.2NextRelease Notes 12.0

Last updated