> For the complete documentation index, see [llms.txt](https://center-for-the-integration-of-id.gitbook.io/generate-documentation/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://center-for-the-integration-of-id.gitbook.io/generate-documentation/release-notes/release-notes-14.0.md). # Release Notes 14.0 Technical enhancements, reporting updates, and upgrade actions in Generate 14.0. Generate 14.0 updates staging columns for CEDS v14. It also improves IDEA and non-IDEA reporting, navigation, and migration debugging. ### Upgrade actions #### Review staging column changes {% hint style="warning" %} **Action required:** Review your source-to-staging ETL migrations before upgrading. CEDS v14 renames, adds, and removes staging columns. Update any affected migration or debugging code. Prioritize columns used for EDFacts reporting. {% endhint %} CEDS v14 renames, adds, and removes staging columns. Review the complete [SEA impact documentation](https://github.com/CEDS-Collaborative-Exchange/Generate/blob/master/docs/Generate%20File%20Storage/SEA%20Impact%20-%20Generate%20changes%20to%20support%20CEDS%20v14.xlsx). #### Configure OAuth API access {% hint style="warning" %} **Action required for OAuth states:** Generate now uses JWT Bearer tokens for API authorization. This replaces custom token authorization. If your state uses OAuth for login validation, configure the `access_as_user` API scope before upgrading. {% endhint %} Start with [OAuth Configuration](/generate-documentation/developer-guides/installation/oauth-configuration.md), then follow the instructions below: 1. Open the Generate Azure app registration. 2. Select **Expose an API**. 3. Add the `access_as_user` scope. 4. Allow admin and user consent. 5. Enable the scope. ### Summary of changes #### IDEA reporting * **Discipline (006):** Updated removal-duration aggregation. This aligns with PSC guidance across removal types. * If a student has an in-school removal < .5 days and an out-of-school removal < .5 days but the 2 together total > .5 days the student is included in the Generate counts because their total removal length is > .5 days. The question was how to report the student by Removal Type. Generate was using tie-breaker logic to pick one of the removal types. The guidance we received from PSC was that the student should be reported in EACH removal type they experienced whether or not that removal type exceeded .5 days. #### Non-IDEA reporting * **Membership (039):** Loads LEA grades offered directly into staging. * **Membership (226):** Adds zero-count logic to the new report migration. * **Neglected or Delinquent (218–221):** Adds zero-count logic to the new report migration. ### User interface changes * **Assessments:** Updated the Toggle Assessments interface by adding filtering and sorting to better manage the loaded Assessments. * **Reports:** Added a loading icon to the reports page as a visual indicator for more intensive and longer loading reports. * **Navigation:** Added page-level navigation across the application to help users understand where they are and return to previous sections. ### General changes #### Utilities * Added `[Utilities].[GetEdFactsReportSubmissionData]` to return report data in EDFacts format. See [Get EdFacts Report Submission Data](/generate-documentation/developer-guides/generate-utilities/get-edfacts-report-submission-data.md). * Added `[Utilities].[CompareRecordsAcrossMigrations]` to compare records across migrations. See [Compare Records Across Migrations](/generate-documentation/developer-guides/generate-utilities/compare-records-across-migrations.md). #### Debugging and validation Run every Staging-to-Fact stored procedure in debug mode. See [Debugging the Staging-to-Fact Migrations](/generate-documentation/developer-guides/migration/troubleshooting/debugging-the-staging-to-fact-migrations.md). ### Release tickets Review [Generate 14.0 release tickets](https://github.com/CEDS-Collaborative-Exchange/Generate/issues?q=is%3Aissue%20state%3Aopen%20label%3Av14.0) in the CEDS Collaborative Exchange. *** ### Generate Office Hour {% embed url="" %} Video: Generate 14.0 Office Hour recording {% endembed %} --- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation by asking a question. Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters: ``` GET https://center-for-the-integration-of-id.gitbook.io/generate-documentation/release-notes/release-notes-14.0.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.