Release Notes 3.4

Generate Release Notes Version 3.4

Introduction

The purpose of this document is to communicate the technical and general updates made to Generate 3.4, released in March 2020.

Technical Release Summary

Before you upgrade

A JavaScript file must be copied to your Generate server in order to use the auto-upgrade feature. Please copy the JavaScript file (6.03a95cc8bbce5b3218ff.js) to the following location “\generate.web\ClientApp\dist” on the server. After the file has been copied to the server, log into Generate and press SHIFT-F5 to update the cached file from your local computer.

After you upgrade

Generate 3.4 includes several upgrades to the way data is loaded and stored in Generate, including changes to the staging environment that require states to make updates to the Generate loading scripts. Below is an overview of the steps that will need to be completed.

1. Organization operational statuses are now required in Generate to properly produce zero count records. Generate expects a record for every school that should be reported (open schools) for the school year. The initial operational status for each district and each school that needs to be counted for the school year must be set in LEA_OperationalStatus and School_OperationalStatus. Use the default start date of 7/1/YYYY (the first day of the school year) to populate the LEA and School effective dates (LEA_UpdatedOperationalStatusEffectiveDate and School_UpdatedOperationalStatusEffectiveDate) in order for Generate to include the LEA/School in EDFacts Reports.

2. To produce the FS029 – Directory file, the state must provide a record in Staging.Organization for all organizations that need to be reported with the initial operational status effective date set to 7/1/YYYY of the school year.

3. Operational status values for LEAs and Schools are translated using the ODS.SourceSystemReferenceData table. Please ensure that any accepted state values for that field are properly translated to the appropriate CEDS values in that table. Also, the TableFilter value in ODS.SourceSystemReferenceData for mapping to RefOperationalStatus now uses the proper codes from RefOperationalStatusType. Ensure that your mapping in ODS.SourceSystemReferenceData is using these codes:

   • TableFilter of “001418” = LEA Operational Statuses

   • TableFilter of “000533” = School Operational Statuses

4. Two new fields, RecordStartDateTime and RecordEndDateTime, have been added to several tables. These are used to inform Generate of the lifespan of the data in the record and allow Generate to store the accurate historical information for each Organization and Person. For instance, if an organization changes their mailing address during the school year, a record needs to be added to Staging.OrganizationAddress with the new address and RecordStartDateTime set to the date when the name mailing address change is effective. Likewise for student or personnel details, if a student changed their official birthdate during the school year, create a new record in Staging.Person with the new birthdate and RecordStartDateTime set to the time the new birthdate takes effect. RecordEndDateTime is handled within Generate. When a new record with an updated RecordStartDateTime for an existing organization or person is submitted the currently stored record is automatically end-dated one day prior to the start date of the new record. If you explicitly want to set the RecordEndDateTime outside that logic, the field can be populated in staging and that date will be used.

The tables affected include:

• • Staging.Organization (LEA_RecordStartDateTime, LEA_RecordEndDateTime, School_RecordStartDateTime, School_RecordEndDateTime)

  • Staging.OrganizationAddress

  • Staging.OrganizationGradeOffered

  • Staging.OrganizationPhone

  • Staging.Person

General Release Summary

Generate Version 3.4 introduces several new features that affect Toggle, the Data Store, and the application in general, as well as defect resolution.

Updated Reports

The following Standard EDFacts reports were updated in this release.

Report	Resolved Defect
002	Added permitted value AGE05K Age 5 (Kindergarten) to Category Age (School Age) for 2019-20 school year
089	Added permitted value AGE05NOTK Age 5 (not Kindergarten) to Category Age for 2019-20 school year
143	Updated total category set and MISSING counts Resolved issue where count of distinct incidents was occurring rather than removals
070	Resolved inflated counts

112	Resolved inflated counts
099	Updated staff categories that were not showing up in the submission file with their FTE counts Updated zero counts that were missing from submission file Resolved issues with Basis of Exit and zero counts
006	Changed aggregation grouping based on report level
009	Resolved issue where zero counts for Basis for Exit were included in the file
144	Resolved issue where discipline incidents and IDEA statuses were not pulled by School
189	Resolved issue where table type was not populating for SY 2018-19
141	Resolved issue where LEP was not filtering on Grade level when Migrating Data into the RDS
202	Resolved issue with discrepancy in report view and submission file
029	Added new EDFacts fields Updated report logic to calculate operational status and updated operational status using the effective date
045	Resolved issues with migration
202	Resolved issue with school name filter
185, 188, 189	Resolved issue with zero counts
039	Left justified organization name columns Added SEA and LEA names
002, 033, 052, 059, 089, 141, 185, 188, 189	Rolled over metadata to year 2019-20
005	Updated report migration test scripts
059, 070, 099, 112, 203	Changed column name from Rate to Total
207	Inactivated report because it is not active in ESS
Personnel reports	Resolved issue with metadata and stored procedure
All	Logically arranged selection filters Changed Order of School Year to descending Corrected overlapping dropdown fields Resolved binding issue when selecting menu options from two different dropdowns simultaneously Updated reporting logic for file specs that look for only open schools to calculate the list based on operational status effective date Resolved response time issues

	Corrected calculation for child count dates and birthdays Updated UI to address issue where Total of the Education Unit row was partially cut off by the row below it Rolled over metadata for SY 2019-20 from previous year Updated LEA identifier to populate correct field

State Designed Reports (SDRs)

Report	Resolved Defect
Special Education Report	Fixed report display
Research Reports	Added two new reports Assessment Attendance Patterns
Migrant category	Added migrant category to existing research reports
Assessment and Discipline	Resolved performance issues
All	Customized graph functionality
SDR	Resolved data display issue with Special Education Report
URLs	Created URLs to the Connection link when the report is downloaded

Updated Pages

Toggle

1. Added a warning message when the user tries to exit the Toggle page without saving changes.

2. Added a “No Response” radio button.

3. Resolved issues with error messages and color scheme in Assessments Toggle.

4. Resolved issue with radio button functionality

Data Store

1. Resolved issues with the reporting data store and reports migrations.

2. Reversed order of school years on the migration pages.

3. Added a process that deletes data out of the Reporting Data Store (RDS).

4. Added functionality for users to view reports after running the ODS migration.

Update

1. Added a loading indicator to the “Download Next Update” page.

General

1. Current UI session/cookies are now stored so that a user can restore their session after logging out and back in.

2. Added a twenty-minute time-out feature that includes a five-minute warning and a countdown clock, located under the User Profile.

3. Menu links were improved so the user can click anywhere on the button area to activate the link.

4. Updated link to the new SPP/APR page.

5. Added functionality for users to configure Resources > About Generate > Environment to say Production.

6. Resolved broken Connection links

Compatible Systems

Generate was tested on the following operating systems and browsers:

1. Windows 10 Pro

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