Release Notes v3.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.
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.
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.
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
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 |
|
070 | Resolved inflated counts |
112 | Resolved inflated counts |
099 |
|
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 |
|
045 | Resolved issues with migration |
202 | Resolved issue with school name filter |
185, 188, 189 | Resolved issue with zero counts |
039 |
|
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 |
|
|
State Designed Reports (SDRs)
Report | Resolved Defect |
Special Education Report | Fixed report display |
Research Reports | Added two new reports
|
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
Added a warning message when the user tries to exit the Toggle page without saving changes.
Added a “No Response” radio button.
Resolved issues with error messages and color scheme in Assessments Toggle.
Resolved issue with radio button functionality
Data Store
Resolved issues with the reporting data store and reports migrations.
Reversed order of school years on the migration pages.
Added a process that deletes data out of the Reporting Data Store (RDS).
Added functionality for users to view reports after running the ODS migration.
Update
Added a loading indicator to the “Download Next Update” page.
General
Current UI session/cookies are now stored so that a user can restore their session after logging out and back in.
Added a twenty-minute time-out feature that includes a five-minute warning and a countdown clock, located under the User Profile.
Menu links were improved so the user can click anywhere on the button area to activate the link.
Updated link to the new SPP/APR page.
Added functionality for users to configure Resources > About Generate > Environment to say Production.
Resolved broken Connection links
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)
Last updated