v7.8.2

New Features

• Added STD_HIV_DATAMART and INV_HIV datamarts to the near Real Time Reporting pipeline.
• Added F_STD_PAGE_CASE fact table to the near Real Time Reporting pipeline.

Full Changelog: v7.8.0...v7.8.2

v7.8.0

What's Changed

• CNDE-1921 by @joshua-mills-cdw in #92
• CNDE-1911 by @joshua-mills-cdw in #96
• CNDE-1945: LAB101 Bugfix by @joshua-mills-cdw in #99
• CNDE-1887: Update for INACTIVE Lab Reports by @upasanapattnaik-eq in #95
• CNDE-1912: Post-processing integration for D_Interview and F_Interview_Case by @sveselev in #90
• CNDE-1942: LAB100 Result Comment Hydration by @sveselev in #101
• CNDE-1916: Align RTR Investigation with baseline by @upasanapattnaik-eq in #100
• CNDE-1916: Hotfix for new nrt obs columns by @upasanapattnaik-eq in #102
• CNDE-1913: Preprocess service and proc changes for F_STD_PAGE_CASE by @johneipe in #103
• CNDE-1951: Re-order Hepatitis datamart post-processing by @sveselev in #104
• CNDE-1950: F_STD_PAGE_CASE Postprocessing by @johneipe in #105
• Hotfix: correct 005-sp_organization_event-001 by @sveselev in #106
• CNDE-1950: F_STD_PAGE_CASE Postprocessing Proc refactored by @johneipe in #108
• CNDE-1950: Renamed column by @johneipe in #109
• CNDE-1982: Update port information by @upasanapattnaik-eq in #110

Full Changelog: v7.7.2...v7.8.0

v7.7.2

New Features

• Added support for Lab 100 and Lab 101 datamarts and dimensions to the near real time reporting pipeline.

What's Changed

• CNDE-1849: Refactor Investigation Service to use Kafka updates for Page Case Answers by @sveselev in #66
• CNDE-1849 Hot fix for tombstone message calls by @sveselev in #68
• CNDE-1843 | enhancement to handle RTR sequence by @johneipe in #67
• CNDE 1402, 1838 by @joshua-mills-cdw in #69
• CNDE-1843 - Updating the liquibase changelog configuration to make the updates to existing stored proc scripts executable. by @alog-enquizit in #70
• CNDE-1802: RTR remove redundant fields from the Investigation by @sveselev in #71
• CNDE-1403: Post-processing integration for LAB100 and LAB101 datamarts by @sveselev in #65
• CNDE 1837 by @joshua-mills-cdw in #72
• CNDE-1861: Fix multivalued data for coded, reason and txt by @sveselev in #74
• CNDE-1848: Updating Hep and Lab Test Result sprocs with enhancements an… by @upasanapattnaik-eq in #73
• CNDE-1848: Hot fix to add runOnChange for hepatitis datamart by @upasanapattnaik-eq in #75
• CNDE-1602: SAS to SQL RTR: Migrate CASE_COUNT SAS dimension to SQL by @johneipe in #76
• CNDE-1602: Hot fix for sql script by @sveselev in #78
• CNDE-1602: Minor but important SQL fix by @sveselev in #79
• Cnde 1844: Migrate Case Management SAS logic to RTR SQL by @sveselev in #77
• CNDE-1602: Fix for datetime field by @johneipe in #80
• CNDE-1878: Postprocessing service integration for case_count by @johneipe in #81
• CNDE-1878: Refactoring changes by @johneipe in #84
• CNDE-1880: RTR - Populate RDB_modern with Case Management data by @sveselev in #82
• CNDE-1902: Legacy Investigation Update (Pre-Processing) by @upasanapattnaik-eq in #83
• CNDE-1875 by @joshua-mills-cdw in #86
• CNDE-1902: Hot fix for investigation_form_cd by @upasanapattnaik-eq in #89
• CNDE-1938 by @joshua-mills-cdw in #91
• Cnde 1908 by @johneipe in #88
• CNDE-1863 Refactor for legacy investigations by @upasanapattnaik-eq in #87
• CNDE-1863: Update Dockerfile by @upasanapattnaik-eq in #93
• CNDE-1908: Code Fix by @johneipe in #94
• Liquibase fix by @upasanapattnaik-eq in #98

Full Changelog: v7.7.0...v7.7.2

v7.7.0

New Features

• The Data Ingestion API now has the ability to ingest ECR PHDC XML data. Rhapsody can call this API to send ECR and ELR xml in PHDC format to be processed and imported into the ODSE tables. More documentation has also been added covering configuration and workflow for the Data Ingestion API including Rhapsody Route Integration.
• A new on-premises Data Sync Service that synchronizes data from the cloud NBS database to an on-premises database. It offers flexible scheduling and supports multiple sync options such as SQL DB sync, S3 Bucket and Local Directory.

What's Changed

• CNDE-1745: update to nrt_investigation_postprocessing by @johneipe in #53
• CNDE-1730: fix to CTE by @johneipe in #55
• Addition of Morbidity Report and Lab_Test_Result Post-Processing Sproc by @upasanapattnaik-eq in #54
• CNDE-1805: RTR Observation: Add new columns and logic by @sveselev in #56
• CNDE-1805 Fix for report_sprt_uid and report_refr_uid by @sveselev in #58
• Data Sync - update rdb query by @ndduc01 in #57
• CNDE-1834: Fix persistence for multivalued observation payloads by @sveselev in #62
• CNDE-1394,1395,1397 Post-processing integration for Morbidity and Lab Test dimensions by @sveselev in #61
• CNDE-1819: Addition of Update and Key Generation to Lab Test Result and Morbidity Report Post-Processing, Wiring of Hepatitis Lab Columns by @upasanapattnaik-eq in #63
• Fix: Rename Morbidity Report Stored Procedure by @upasanapattnaik-eq in #64
• CNDE 1393 by @joshua-mills-cdw in #60
• CNDE-1401 - Lab100 procedure by @johneipe in #59

Full Changelog: v7.6.2...v7.7.0

v7.6.2

New Features Added to Data Ingestion and Near Real Time Reporting

• A new API has been added enabling the ingestion of ELR PHDC XML data without directly linking Rhapsody to database. Rhapsody calls this API to send PHDC.xml to be processed by NBS ELR importer process into ODSE tables. In the next release more documentation will be added covering configuration and workflow for the new API. In this release the Swagger documentation will be available here:
  • https://<>/swagger-ui/index.html
  • Sample swagger documentation here: https://dataingestion.dts1.nbspreview.com/swagger-ui/index.html
• Added Public Health Case Fact (PHCF) datamart to the near Real Time Reporting pipeline. This adds support for standard reports that reference the PHCF datamart within the ODSE to get data in near real time. This brings the total number of datamarts that have been added to the pipeline for the near real time reporting to 2 as follows:
  • Hepatitis (HEP)
  • Public Health Case Fact (PHCF)

What's Changed

• Added pull request template by @rshanmugam-enquizit in #45
• CNDIT-1730: procedure changes to pick only the latest page case answers by @johneipe in #44
• CNDIT 1777: RTR Observation Persist Extension To Persist New Columns by @sveselev in #46
• RTR Notification: Make notification_uid not optional in Kafka message schema by @sveselev in #47
• CNDIT-1777 Fix ObservationNumeric data type for Kafka schema by @sveselev in #49
• CNDIT-1753 Addition of record_status_cd constraint and Role for person_participation by @upasanapattnaik-eq in #48
• Adding script for data exchange config by @ndduc01 in #20
• Remove GO keyword by @ndduc01 in #51
• updated nrt_observation_coded query by @ndduc01 in #52
• CNDE-1724: Fix for PAT_BIRTH_COUNTRY being null by @johneipe in #50

Full Changelog: v7.6.1...v7.6.2

v7.6.1

Bug Fixes and Enhancements

• Upgraded to Java 21
• Addressed security issues

What's Changed

• CNDIT-1786: RTR: Fix the CVE Remediation evaluation issues by @sveselev in #40
• CNDIT-1729: Update observation services for Montana reports by @sveselev in #37
• CNDIT-1729: Minor fix for liquibase script by @sveselev in #41
• CNDIT-1786: Update liquibase to 4.29.2 with Java 21 by @sveselev in #42
• CNDIT-1786 Update liquibase-core and dependdent stuff to the latest by @sveselev in #43

Full Changelog: https://github.com/CDCgov/NEDSS-DataReporting/commits/v7.6.1