Data

Tools

Indexes

Applications

Experiments

Open Source Science

Recent Releases of https://github.com/cdcgov/nedss-datareporting

https://github.com/cdcgov/nedss-datareporting - v.7.11.0

What's Changed

  • CNDE-2902 Creating script upgrade_db.bat and reordering views by @agonzalez-cloud39 in https://github.com/CDCgov/NEDSS-DataReporting/pull/497
  • CNDE-2848,2849 - Treatment Bug Fix by @VarshineeVenkat in https://github.com/CDCgov/NEDSS-DataReporting/pull/498
  • CNDE-2707: Event Metric Cleanup Job and Stored Procedure by @joshua-mills-cdw in https://github.com/CDCgov/NEDSS-DataReporting/pull/500
  • Added read permission for kafka sync by @jayasudhasundaram in https://github.com/CDCgov/NEDSS-DataReporting/pull/502
  • CNDE-2970 Stored procedure spdlabtestpostprocessing is not saving the lab report comment to LABRPTUSER_COMMENT by @agonzalez-cloud39 in https://github.com/CDCgov/NEDSS-DataReporting/pull/504
  • CNDE-2992: Add NBS_configuration to liquibase CDC script by @joshua-mills-cdw in https://github.com/CDCgov/NEDSS-DataReporting/pull/506
  • CNDE-2995 Fixing fields reported as empty string when null and missing CONFIRMATIONMETHODGT3IND value in TBDATAMART table by @agonzalez-cloud39 in https://github.com/CDCgov/NEDSS-DataReporting/pull/507
  • CNDE-2996: Address STRING_AGG overflow bug in Page Postprocessing by @joshua-mills-cdw in https://github.com/CDCgov/NEDSS-DataReporting/pull/510
  • CNDE-2924 & CNDE-2928 RTR Post-processing Sproc: Create stored procedure to capture missed events into nrt_backfill table by @VarshineeVenkat in https://github.com/CDCgov/NEDSS-DataReporting/pull/503
  • CNDE-2761: Batch Id Cleanup Job and Stored Procedure by @joshua-mills-cdw in https://github.com/CDCgov/NEDSS-DataReporting/pull/514
  • [CNDE-3003] Script to update DB - Modify the column "CONTACTUID" to allow nulls when "COVIDCONTACT_DATAMART" table is modified to add this column by @agonzalez-cloud39 in https://github.com/CDCgov/NEDSS-DataReporting/pull/511
  • [CNDE-2988] RTR - Fixing the process to compute the datamartcolumnnm for LDF. There is difference in naming convention between RDB and RDB_MODERN for LDF fields by @agonzalez-cloud39 in https://github.com/CDCgov/NEDSS-DataReporting/pull/509
  • [CNDE-2985] - DLDFMETA_DATA table data compare mismatch fix for Null or not null by @lramakr in https://github.com/CDCgov/NEDSS-DataReporting/pull/508
  • [CNDE-2993] RTR - CASELABDATAMART table . Disease, Disease_CD mismatch by @agonzalez-cloud39 in https://github.com/CDCgov/NEDSS-DataReporting/pull/513
  • [CNDE-2954] RTR - D_VACCINATION table . Some null fields are saved as empty string by @agonzalez-cloud39 in https://github.com/CDCgov/NEDSS-DataReporting/pull/501
  • Hotfix: Align nrt_observation schema with Liquibase by @upasanapattnaik-eq in https://github.com/CDCgov/NEDSS-DataReporting/pull/516
  • CNDE 2859 (Part 2): Remove and reorder changelog for index addition script by @upasanapattnaik-eq in https://github.com/CDCgov/NEDSS-DataReporting/pull/494
  • CNDE-2923: RTR post-processing: Implement retry cache and re-processing failed IDs by @sveselev in https://github.com/CDCgov/NEDSS-DataReporting/pull/512
  • CNDE-2240: various bugfixes for spinterviewevent by @joshua-mills-cdw in https://github.com/CDCgov/NEDSS-DataReporting/pull/515
  • CNDE-2929: update files to use dbo.condition by @joshua-mills-cdw in https://github.com/CDCgov/NEDSS-DataReporting/pull/519
  • CNDE-2948: Update to procs to support retry via java service by @johneipe in https://github.com/CDCgov/NEDSS-DataReporting/pull/517
  • CNDE-3014: Add support for sp returns by @sveselev in https://github.com/CDCgov/NEDSS-DataReporting/pull/520
  • CNDE-2581 : Added validation script in readme by @jayasudhasundaram in https://github.com/CDCgov/NEDSS-DataReporting/pull/505
  • CNDE-2946 and CNDE-2942 by @johneipe in https://github.com/CDCgov/NEDSS-DataReporting/pull/522
  • CNDE-2976: HEP100 by @upasanapattnaik-eq in https://github.com/CDCgov/NEDSS-DataReporting/pull/518
  • CNDE-3014: fix phc ID column in datamart containing error info by @sveselev in https://github.com/CDCgov/NEDSS-DataReporting/pull/525
  • CNDE-2969: Add records via EVENT_METRIC cleanup job by @joshua-mills-cdw in https://github.com/CDCgov/NEDSS-DataReporting/pull/523
  • CNDE-3042: update config value in event_metric postprocessing by @joshua-mills-cdw in https://github.com/CDCgov/NEDSS-DataReporting/pull/527
  • Update sppublichealthcasefactdatamartevent to use RDB instead of RDB Modern to support RTR running against the RDB database. by @rseshadri99 in https://github.com/CDCgov/NEDSS-DataReporting/pull/526
  • CNDE-3014: remove unconditional debug prints from pagebuider sp by @sveselev in https://github.com/CDCgov/NEDSS-DataReporting/pull/528
  • CNDE-2971: Fix for CONTACT RECORDS by @johneipe in https://github.com/CDCgov/NEDSS-DataReporting/pull/529
  • CNDE-3014: Fix PostProcRepository repository by @sveselev in https://github.com/CDCgov/NEDSS-DataReporting/pull/530
  • CNDE-3014: Fix missing NRT record check in LDF post-processing sp by @sveselev in https://github.com/CDCgov/NEDSS-DataReporting/pull/532
  • CNDE-2971: Fix for metadata columns by @johneipe in https://github.com/CDCgov/NEDSS-DataReporting/pull/533
  • CNDE-3037: Fix for provider country by @johneipe in https://github.com/CDCgov/NEDSS-DataReporting/pull/531
  • Cnde 2845 Added the logic for AOE to update the missed column dynamically by @jayasudhasundaram in https://github.com/CDCgov/NEDSS-DataReporting/pull/476
  • [CNDE-2947] [CNDE-2965] - DProvider - PROVIDERNAMEPREFIX and PATIENTBIRTH_SEX Fix for Data Compare Tool by @lramakr in https://github.com/CDCgov/NEDSS-DataReporting/pull/524
  • Restructure Database Folder by @upasanapattnaik-eq in https://github.com/CDCgov/NEDSS-DataReporting/pull/521
  • Hotfix: Update file number in changelog by @upasanapattnaik-eq in https://github.com/CDCgov/NEDSS-DataReporting/pull/534
  • Liquibase build issue test by @upasanapattnaik-eq in https://github.com/CDCgov/NEDSS-DataReporting/pull/535
  • Hotfix (Part 2): Liquibase build issue test by @upasanapattnaik-eq in https://github.com/CDCgov/NEDSS-DataReporting/pull/536
  • Hotfix (Part 3): Liquibase build issue test by @upasanapattnaik-eq in https://github.com/CDCgov/NEDSS-DataReporting/pull/538
  • Hotfix (Part 4): Liquibase build issue for lookup question by @upasanapattnaik-eq in https://github.com/CDCgov/NEDSS-DataReporting/pull/539
  • Hotfix (Part 5): Liquibase build issue for cleanup jobs by @upasanapattnaik-eq in https://github.com/CDCgov/NEDSS-DataReporting/pull/540
  • Fix to set QUOTED_IDENTIFIER to true. by @johneipe in https://github.com/CDCgov/NEDSS-DataReporting/pull/541
  • CNDE-3021: update to transaction wrapping in labtestresult sp by @johneipe in https://github.com/CDCgov/NEDSS-DataReporting/pull/542
  • CNDE-2709: Re-ordering Legacy Case Datamarts for STLT config changes by @sveselev in https://github.com/CDCgov/NEDSS-DataReporting/pull/543
  • CNDE-2952: Handling of empty or blank string for certain org fields by @johneipe in https://github.com/CDCgov/NEDSS-DataReporting/pull/546
  • Scripts to bulk load Metadata tables from ODSE and SRTE database to the RTR Reporting database as an Onboarding effort. by @rseshadri99 in https://github.com/CDCgov/NEDSS-DataReporting/pull/549
  • CNDE-3057: add retry return values for datamart procedures by @joshua-mills-cdw in https://github.com/CDCgov/NEDSS-DataReporting/pull/548
  • CNDE-2989 & 2977 Updates by @upasanapattnaik-eq in https://github.com/CDCgov/NEDSS-DataReporting/pull/545
  • CNDE-2838: Updates for NRT org, provider, patient by @sveselev in https://github.com/CDCgov/NEDSS-DataReporting/pull/550
  • Hotifx: remove extra return value from hepatitis_datamart by @joshua-mills-cdw in https://github.com/CDCgov/NEDSS-DataReporting/pull/553
  • CNDE-3035: Handling O and CP phone numbers seperately by @johneipe in https://github.com/CDCgov/NEDSS-DataReporting/pull/547
  • CNDE-3058: Replace rdbmodern references with rdb in NBSODSE by @joshua-mills-cdw in https://github.com/CDCgov/NEDSS-DataReporting/pull/551
  • HotFix: Fix for SQL wrapping by @johneipe in https://github.com/CDCgov/NEDSS-DataReporting/pull/554
  • Permissions for RDB jobflowlog in DTS1 environment by @upasanapattnaik-eq in https://github.com/CDCgov/NEDSS-DataReporting/pull/555
  • CNDE 2979-2980-2978 by @upasanapattnaik-eq in https://github.com/CDCgov/NEDSS-DataReporting/pull/552
  • CNDE-2977: Bug fix for VAR Datamart by @upasanapattnaik-eq in https://github.com/CDCgov/NEDSS-DataReporting/pull/544
  • HotFix: include LDF Datamart info into notification processing return by @sveselev in https://github.com/CDCgov/NEDSS-DataReporting/pull/558
  • 7.11.0 documentation centric updates by @upasanapattnaik-eq in https://github.com/CDCgov/NEDSS-DataReporting/pull/557
  • CNDE-3064: RTR post-processing refactor for Datamart retry mechanism by @sveselev in https://github.com/CDCgov/NEDSS-DataReporting/pull/559
  • rdbmodern changelog fix and vardatamart logic update by @upasanapattnaik-eq in https://github.com/CDCgov/NEDSS-DataReporting/pull/560
  • Hot Fix: nrt_treatment PK creation order by @sveselev in https://github.com/CDCgov/NEDSS-DataReporting/pull/561
  • Remove key value 1 for nrtlabtestresultgroup_key by @upasanapattnaik-eq in https://github.com/CDCgov/NEDSS-DataReporting/pull/562
  • CNDE-3065: Handling datamart metadata returned by provider and organization by @sveselev in https://github.com/CDCgov/NEDSS-DataReporting/pull/563
  • Hotfix: job and schedule creation by @joshua-mills-cdw in https://github.com/CDCgov/NEDSS-DataReporting/pull/564
  • CNDE-3066: Dynamic Datamart Dimension-Only Updates by @joshua-mills-cdw in https://github.com/CDCgov/NEDSS-DataReporting/pull/565
  • CNDE-3066: Update Changelog for Dyn Dm Dimension Updates by @joshua-mills-cdw in https://github.com/CDCgov/NEDSS-DataReporting/pull/566
  • CNDE-3066: Changelog Hotfix by @joshua-mills-cdw in https://github.com/CDCgov/NEDSS-DataReporting/pull/567
  • CNDE-3067: Targeted delta update on Datamarts for Pat/Pro/Org Dimensions by @johneipe in https://github.com/CDCgov/NEDSS-DataReporting/pull/556
  • DC bugfix p2 by @upasanapattnaik-eq in https://github.com/CDCgov/NEDSS-DataReporting/pull/568
  • Liquibase: Fix issue in greenfield database deployment by @upasanapattnaik-eq in https://github.com/CDCgov/NEDSS-DataReporting/pull/569
  • nrtdatamartmetadata: Covid Datamart Update by @upasanapattnaik-eq in https://github.com/CDCgov/NEDSS-DataReporting/pull/570
  • LDFDATA: Update LDFDIMENSIONAL_DATA in postprocessing by @upasanapattnaik-eq in https://github.com/CDCgov/NEDSS-DataReporting/pull/571
  • CNDE-2991: Fix for DMOVESTATE state value by @upasanapattnaik-eq in https://github.com/CDCgov/NEDSS-DataReporting/pull/573
  • CNDE-3071: Update the logic used to accurately update changed Provider and Patient data by @johneipe in https://github.com/CDCgov/NEDSS-DataReporting/pull/572
  • CNDE-3071: Additional Logging by @johneipe in https://github.com/CDCgov/NEDSS-DataReporting/pull/575
  • CNDE-3094 : Update the github actions to deploy the latest image tags build from the main branch in the RTR Java services helm chart by @alog-enquizit in https://github.com/CDCgov/NEDSS-DataReporting/pull/577
  • CNDE-3035: Conditionally updating specific to provider by @johneipe in https://github.com/CDCgov/NEDSS-DataReporting/pull/574
  • CNDE-1943:Fix for updates made to datamart from the temp table by @johneipe in https://github.com/CDCgov/NEDSS-DataReporting/pull/578
  • CNDE-2981/CNDE-3091 by @upasanapattnaik-eq in https://github.com/CDCgov/NEDSS-DataReporting/pull/576
  • CNDE-1943:Typo fix by @johneipe in https://github.com/CDCgov/NEDSS-DataReporting/pull/579
  • Update DINVPLACE_REPEAT dimension in Place sproc by @upasanapattnaik-eq in https://github.com/CDCgov/NEDSS-DataReporting/pull/580
  • CNDE-1752: Update notification history ordering by @joshua-mills-cdw in https://github.com/CDCgov/NEDSS-DataReporting/pull/583
  • Remove print statements for retry logs by @upasanapattnaik-eq in https://github.com/CDCgov/NEDSS-DataReporting/pull/584
  • CNDE-2722: Order HEP100 to be only after Hepatitis_Case in postprocessing by @joshua-mills-cdw in https://github.com/CDCgov/NEDSS-DataReporting/pull/585
  • CNDE-1743: PHCF datamart selective updates by @sveselev in https://github.com/CDCgov/NEDSS-DataReporting/pull/587
  • CNDE-1943: Fix for updating Nt Event information in Datamart by @johneipe in https://github.com/CDCgov/NEDSS-DataReporting/pull/586
  • CNDE-3096: Additional permissions to person and org service users by @sveselev in https://github.com/CDCgov/NEDSS-DataReporting/pull/588
  • CNDE-3096: Hot Fix for SQL variable names by @sveselev in https://github.com/CDCgov/NEDSS-DataReporting/pull/589
  • CNDE-3096: Quick fix for JPA signatures by @sveselev in https://github.com/CDCgov/NEDSS-DataReporting/pull/590

Full Changelog: https://github.com/CDCgov/NEDSS-DataReporting/compare/v7.10.1...v.7.11.0

- TSQL
Published by achapm 11 months ago

https://github.com/cdcgov/nedss-datareporting - v7.10.1

What's Changed

  • CNDE-2846: Change treatment UID column types to bigint by @sveselev in https://github.com/CDCgov/NEDSS-DataReporting/pull/445
  • CNDE-2809: Refactor extractUid for NBS_ODSE snapshots by @sveselev in https://github.com/CDCgov/NEDSS-DataReporting/pull/439
  • CNDE-2739 Add nrt key tables to LABTEST and LABRPTUSERCOMMENT in stored procedure spdlabtestpostprocessing by @agonzalez-cloud39 in https://github.com/CDCgov/NEDSS-DataReporting/pull/444
  • Hotfix: Liquibase changelog reordering by @upasanapattnaik-eq in https://github.com/CDCgov/NEDSS-DataReporting/pull/454
  • CNDE-2580: Add admin user creation script to repo by @upasanapattnaik-eq in https://github.com/CDCgov/NEDSS-DataReporting/pull/453
  • CNDE-2836 - NRT Update to include createdtttm & updatedttm by @VarshineeVenkat in https://github.com/CDCgov/NEDSS-DataReporting/pull/452
  • CNDE-2824: Dynamic Datamart Schema Change Update by @joshua-mills-cdw in https://github.com/CDCgov/NEDSS-DataReporting/pull/451
  • CNDE-2740 Add nrt key tables (nrtlabresultcommentkey, nrtlabtestresultgroupkey) for "spdlabtestresult_postprocessing" by @agonzalez-cloud39 in https://github.com/CDCgov/NEDSS-DataReporting/pull/455
  • Added new CC for the INT1 environment by @VarshineeVenkat in https://github.com/CDCgov/NEDSS-DataReporting/pull/403
  • CNDE-2852: reworking COVID contact datamart logic by @sveselev in https://github.com/CDCgov/NEDSS-DataReporting/pull/458
  • CNDE-2416DTS1Morbidity Datamart_Treatment related columns are NULL when user selects OTHER in treatment panel on UI by @agonzalez-cloud39 in https://github.com/CDCgov/NEDSS-DataReporting/pull/456
  • CNDE-2864: add data loading scripts for nrt key tables by @joshua-mills-cdw in https://github.com/CDCgov/NEDSS-DataReporting/pull/457
  • CNDE-2841 Modify Views scripts to IF Exists Drop and then Create (Views) by @agonzalez-cloud39 in https://github.com/CDCgov/NEDSS-DataReporting/pull/459
  • CNDE-2841-1 Removing "GO". Not supported by liquibase by @agonzalez-cloud39 in https://github.com/CDCgov/NEDSS-DataReporting/pull/462
  • CNDE-2841-2 by @agonzalez-cloud39 in https://github.com/CDCgov/NEDSS-DataReporting/pull/463
  • CNDE-2841-3 by @agonzalez-cloud39 in https://github.com/CDCgov/NEDSS-DataReporting/pull/465
  • CNDE-2842 Modify Function scripts to IF Exists Drop and then Create (Functions) by @agonzalez-cloud39 in https://github.com/CDCgov/NEDSS-DataReporting/pull/461
  • CNDE-2865 RTR: Create Insert scripts for initial hydration of Set 2 of nrt key tables by @VarshineeVenkat in https://github.com/CDCgov/NEDSS-DataReporting/pull/460
  • CNDE-2891: Change stored procedures to update nrt key tables when existing keys are passed in by @joshua-mills-cdw in https://github.com/CDCgov/NEDSS-DataReporting/pull/464
  • CNDE 2843 Modify Stored procedures scripts to IF Exists Drop and then Create (Stored procedures) by @agonzalez-cloud39 in https://github.com/CDCgov/NEDSS-DataReporting/pull/466
  • Cnde 2843 by @agonzalez-cloud39 in https://github.com/CDCgov/NEDSS-DataReporting/pull/469
  • Cnde 2843 by @agonzalez-cloud39 in https://github.com/CDCgov/NEDSS-DataReporting/pull/470
  • CNDE-2903 LDFService doesnt contain Businessobject_uid as PK by @VarshineeVenkat in https://github.com/CDCgov/NEDSS-DataReporting/pull/468
  • Cnde 2843 by @agonzalez-cloud39 in https://github.com/CDCgov/NEDSS-DataReporting/pull/472
  • CNDE-2843 SQL Scripts for Procedures to include IF Exists Drop and then Create - Missing 3 scripts pending for modification by @agonzalez-cloud39 in https://github.com/CDCgov/NEDSS-DataReporting/pull/473
  • CNDE-2866: Feature Flags for the Elastic Search topics by @sveselev in https://github.com/CDCgov/NEDSS-DataReporting/pull/471
  • Fix few script checks in the liquibase-admin-user by @alog-enquizit in https://github.com/CDCgov/NEDSS-DataReporting/pull/477
  • Liquibase hotfix: Stop gap for covid contact error by @upasanapattnaik-eq in https://github.com/CDCgov/NEDSS-DataReporting/pull/478
  • CNDE-2837: Remove reference to srte database by @johneipe in https://github.com/CDCgov/NEDSS-DataReporting/pull/480
  • Cnde 2911: Add the SRTE admin tasks script to the changelog by @alog-enquizit in https://github.com/CDCgov/NEDSS-DataReporting/pull/479
  • CNDE-2907 Fixing bug in stored procedure spnrtldfdimensionaldata_postprocessing by @agonzalez-cloud39 in https://github.com/CDCgov/NEDSS-DataReporting/pull/475
  • CNDE-2912 Missing "CDCCDCNATIONALID" when saving and updating LDFDATA in spnrtldf_postprocessing by @agonzalez-cloud39 in https://github.com/CDCgov/NEDSS-DataReporting/pull/482
  • CNDE-2886 Create NRT scripts for LDFDATA & LDFGROUP by @VarshineeVenkat in https://github.com/CDCgov/NEDSS-DataReporting/pull/474
  • Hotfix: Add rhapsody columns to Condition Code by @upasanapattnaik-eq in https://github.com/CDCgov/NEDSS-DataReporting/pull/486
  • Hotfix: Update schema for new SRTE treatment column by @upasanapattnaik-eq in https://github.com/CDCgov/NEDSS-DataReporting/pull/487
  • CNDE-2380: Fix for Kafka sink error on snomed_condition by @upasanapattnaik-eq in https://github.com/CDCgov/NEDSS-DataReporting/pull/488
  • CNDE-2380: update primary key condition for snomed_condition by @upasanapattnaik-eq in https://github.com/CDCgov/NEDSS-DataReporting/pull/491
  • CNDE-2380: 6.0.17 updates to srte treatment_code by @upasanapattnaik-eq in https://github.com/CDCgov/NEDSS-DataReporting/pull/492
  • CNDE-2915 Bug in spnrtldfdimensionaldatapostprocessing. Field "BUSINESSOBJECTNM" is not saved or updated to table LDFDATAMARTCOLUMNREF by @agonzalez-cloud39 in https://github.com/CDCgov/NEDSS-DataReporting/pull/489
  • CNDE-2838 Computing codes from values for missing codes in Dimension and nrt tables by @agonzalez-cloud39 in https://github.com/CDCgov/NEDSS-DataReporting/pull/467
  • Bugfix: nrtplacekey data load script fix by @upasanapattnaik-eq in https://github.com/CDCgov/NEDSS-DataReporting/pull/483
  • Update 001-serviceuserslogin_creation.sql by @upasanapattnaik-eq in https://github.com/CDCgov/NEDSS-DataReporting/pull/484
  • CNDE-2919 Reseed for all nrt key tables after data load by @VarshineeVenkat in https://github.com/CDCgov/NEDSS-DataReporting/pull/493
  • CNDE-2922: Fixing the CVE vulnerabilty CVE-2025-48988,CVE-2025-49125 which recommends tomcat to upgrade to version 11.0.8 10.1.42 or 9.0.106 by @alog-enquizit in https://github.com/CDCgov/NEDSS-DataReporting/pull/495
  • CNDE-2856: Condition Dim Stored Procedure and Service Update by @joshua-mills-cdw in https://github.com/CDCgov/NEDSS-DataReporting/pull/490
  • CNDE-2941: add nrtodseNBS_configuration table by @joshua-mills-cdw in https://github.com/CDCgov/NEDSS-DataReporting/pull/496
  • CNDE-2859 (Part 1): Add primary keys to nrt tables by @upasanapattnaik-eq in https://github.com/CDCgov/NEDSS-DataReporting/pull/481
  • Hotfix: Remove primary key constrainst and key=1 for nrtlabtest_key by @upasanapattnaik-eq in https://github.com/CDCgov/NEDSS-DataReporting/pull/499

Full Changelog: https://github.com/CDCgov/NEDSS-DataReporting/compare/v7.10.0...v7.10.1

- TSQL
Published by achapm about 1 year ago

https://github.com/cdcgov/nedss-datareporting - v7.10.0

What's Changed

Migrated the following data tables to the near real time events based architecture: * L LDFHEPATITIS * LDFGENERIC1 * SPCOVIDCONTACTDATAMART * SPCOVIDLABCELRDATAMART * CovidCaseDatamart * Covidlabdatamart * CovidVaccinationdatamart * DMINVARBOVIRALCASESMMG * DMINVCM2 * DMINVCRH * DMINVFTP * DMINVCPCRE * DMINVNINE * DMINVSAMP * DMINVTBDATAMART * DMINV_UN

Full Changelog: https://github.com/CDCgov/NEDSS-DataReporting/compare/v7.9.3...v7.10.0

- TSQL
Published by achapm about 1 year ago

https://github.com/cdcgov/nedss-datareporting - v7.9.3

What's Changed

Migrated the following data tables to the near real time events based architecture: * LDFBMIRD * LDFFOODBORNE * LDFMUMPS * LDFTETANUS * LDFVACCINEPREVENTDISEASES * LDFGENERICLDFGENERIC1 * LDFGENERIC2 * DLDFMETADATA * LDFHEPATITIS (new after CVE fix) * LDFDATAMARTCOLUMNREF * LDFDATAMARTTABLEREF * DMINVARBOHUMAN * DMINVCAURIS * DMINVCONGSYPHILIS * DMINVCPCRE

Full Changelog: https://github.com/CDCgov/NEDSS-DataReporting/compare/v7.9.2...v7.9.3

- TSQL
Published by achapm about 1 year ago

https://github.com/cdcgov/nedss-datareporting - v7.9.2

What's Changed

  • CNDE-2377: Patient chart number field issue for legacy cases by @sveselev in https://github.com/CDCgov/NEDSS-DataReporting/pull/353
  • CNDE-2513: Code fixes to upstream procs in the dynamic data mart process by @johneipe in https://github.com/CDCgov/NEDSS-DataReporting/pull/354
  • CNDE2447 Error Fix - VARPAM_LDF by @VarshineeVenkat in https://github.com/CDCgov/NEDSS-DataReporting/pull/358
  • CNDE-2372: Fix to the procs identified through integrated testing by @johneipe in https://github.com/CDCgov/NEDSS-DataReporting/pull/357
  • CNDE-2424: Fix for field: SIRURESULT_8 by @johneipe in https://github.com/CDCgov/NEDSS-DataReporting/pull/359
  • CNDE-2509: Fix investigation_key associations in Morbidity Reports by @joshua-mills-cdw in https://github.com/CDCgov/NEDSS-DataReporting/pull/349
  • CNDE-2452 by @joshua-mills-cdw in https://github.com/CDCgov/NEDSS-DataReporting/pull/345
  • CNDE-2510: Bugfix for multiple investigation associated to lab reports by @upasanapattnaik-eq in https://github.com/CDCgov/NEDSS-DataReporting/pull/361
  • CNDE-2372: Fixes from CreateDM validation by @joshua-mills-cdw in https://github.com/CDCgov/NEDSS-DataReporting/pull/356
  • Fixing Bug in DTBHIV by @agonzalez-cloud39 in https://github.com/CDCgov/NEDSS-DataReporting/pull/362
  • Fixing error that provoke wrong group_key for dimension tables when updating data by @agonzalez-cloud39 in https://github.com/CDCgov/NEDSS-DataReporting/pull/364
  • CNDE-2536: update treatment processing for multiple phc uids by @joshua-mills-cdw in https://github.com/CDCgov/NEDSS-DataReporting/pull/363
  • update token permissions by @szamfir in https://github.com/CDCgov/NEDSS-DataReporting/pull/367
  • [CNDE-2489] - RTRSQL: Address gaps in LDF post-processing stored procedure by @lramakr in https://github.com/CDCgov/NEDSS-DataReporting/pull/352
  • CNDE-2501: Add batch_id to numeric observation processing by @joshua-mills-cdw in https://github.com/CDCgov/NEDSS-DataReporting/pull/368
  • CNDE-2502: Add batch_id to observation date processing by @sveselev in https://github.com/CDCgov/NEDSS-DataReporting/pull/370
  • Liquibase: Fix drop column statement by @upasanapattnaik-eq in https://github.com/CDCgov/NEDSS-DataReporting/pull/371
  • Fixing Bugs in TBDATAMART, DTBHIV and TBHIV_DATAMART by @agonzalez-cloud39 in https://github.com/CDCgov/NEDSS-DataReporting/pull/369
  • CNDE-2491: LDF Dimensional Data stored procedure by @agonzalez-cloud39 in https://github.com/CDCgov/NEDSS-DataReporting/pull/365
  • CNDE-2490 LDFGenericDatamart PostProcessing by @VarshineeVenkat in https://github.com/CDCgov/NEDSS-DataReporting/pull/366

Full Changelog: https://github.com/CDCgov/NEDSS-DataReporting/compare/v7.9.1...v7.9.2

- TSQL
Published by achapm about 1 year ago

https://github.com/cdcgov/nedss-datareporting - v7.9.1

What's Changed

  • CNDE-2364: Added spdyndmrepeatnumbericdatapostprocessing by @jayasudhasundaram in https://github.com/CDCgov/NEDSS-DataReporting/pull/313
  • CNDE-2451 FVARPAM by @agonzalez-cloud39 in https://github.com/CDCgov/NEDSS-DataReporting/pull/311
  • CNDE-2369: Dynamic datamart CreateDM sproc by @joshua-mills-cdw in https://github.com/CDCgov/NEDSS-DataReporting/pull/322
  • CNDE-2418: Fix state_code view by @upasanapattnaik-eq in https://github.com/CDCgov/NEDSS-DataReporting/pull/328
  • Update state_code view by @upasanapattnaik-eq in https://github.com/CDCgov/NEDSS-DataReporting/pull/329
  • Hotfix: nrt_srte view fix by @upasanapattnaik-eq in https://github.com/CDCgov/NEDSS-DataReporting/pull/330
  • CNDE-2418: Changelog update by @upasanapattnaik-eq in https://github.com/CDCgov/NEDSS-DataReporting/pull/331
  • CNDE-2340: Enable CDC on ODSE Metadata tables for Dyn DM by @sveselev in https://github.com/CDCgov/NEDSS-DataReporting/pull/332
  • CNDE-2340: hot fix for index refs by @sveselev in https://github.com/CDCgov/NEDSS-DataReporting/pull/333
  • CNDE-2447 - VARPAMLDF Postprocessing by @VarshineeVenkat in https://github.com/CDCgov/NEDSS-DataReporting/pull/317
  • CNDE-2446: Java service update for dyn datamarts (Part 1) by @johneipe in https://github.com/CDCgov/NEDSS-DataReporting/pull/327
  • CNDE-2478 Bug-Fixing Deletion from Dimension groups tables rising an error due to constraints in Fact tables for TB and VAR by @agonzalez-cloud39 in https://github.com/CDCgov/NEDSS-DataReporting/pull/334
  • CNDE-2447 - Renamed numbering for createvarpam_ldf script by @VarshineeVenkat in https://github.com/CDCgov/NEDSS-DataReporting/pull/337
  • [CNDE-2440] - RTR Dyn Datamart: Make output tables for sprocs unique with datamart and batch_id by @lramakr in https://github.com/CDCgov/NEDSS-DataReporting/pull/335
  • CNDE-2382: Update Condition View as primary reference by @upasanapattnaik-eq in https://github.com/CDCgov/NEDSS-DataReporting/pull/326
  • CNDE-2486: Add condition to process only summary report cases by @upasanapattnaik-eq in https://github.com/CDCgov/NEDSS-DataReporting/pull/339
  • CNDE-2483: added missing nrt srte table in liquibase from dts1 by @jayasudhasundaram in https://github.com/CDCgov/NEDSS-DataReporting/pull/340
  • Fix liquibase errors. by @alog-enquizit in https://github.com/CDCgov/NEDSS-DataReporting/pull/343
  • CNDE-2473 Adding table and stored procedure to compute TB_DATAMART by @agonzalez-cloud39 in https://github.com/CDCgov/NEDSS-DataReporting/pull/338
  • CNDE-2474 TBHIVDATAMART and bugs in (dhcprovty3, doutofcntry, dsmr_exam) by @agonzalez-cloud39 in https://github.com/CDCgov/NEDSS-DataReporting/pull/342
  • CNDE-2446: Java service update for dyn datamarts (Part 2) by @johneipe in https://github.com/CDCgov/NEDSS-DataReporting/pull/341
  • CNDE-2427 TBPAMLDF by @agonzalez-cloud39 in https://github.com/CDCgov/NEDSS-DataReporting/pull/318
  • CNDE-2461 VAR_DATAMART Postprocessing by @VarshineeVenkat in https://github.com/CDCgov/NEDSS-DataReporting/pull/344
  • CNDE-2511: add phcuids to nrtobservation by @joshua-mills-cdw in https://github.com/CDCgov/NEDSS-DataReporting/pull/347
  • CNDE-2512: add associatedphcuids to Treatment by @joshua-mills-cdw in https://github.com/CDCgov/NEDSS-DataReporting/pull/348
  • CNDE-2381: Replace SRTE db references within stored procedures to nrt_srte by @sveselev in https://github.com/CDCgov/NEDSS-DataReporting/pull/346
  • CNDE-2455: DynDM Clear Sproc Migration to RTR by @upasanapattnaik-eq in https://github.com/CDCgov/NEDSS-DataReporting/pull/336
  • Fixing bug in DTBHIV stored procedure by @agonzalez-cloud39 in https://github.com/CDCgov/NEDSS-DataReporting/pull/350
  • CNDE-2513: Code Fix and Refactoring changes by @johneipe in https://github.com/CDCgov/NEDSS-DataReporting/pull/351
  • Address the CVE vulnerabilities and patch by @alog-enquizit in https://github.com/CDCgov/NEDSS-DataReporting/pull/355

Full Changelog: https://github.com/CDCgov/NEDSS-DataReporting/compare/v7.9.0...v7.9.1

- TSQL
Published by achapm about 1 year ago

https://github.com/cdcgov/nedss-datareporting - v7.9.0

New Features & Enhancements

  • Migrated DDISEASESITE, DTBPAM, and DADDLRISK data tables to the near real time event-based architecture.
  • Migrated ContactRecordCase, FCONTACTRECORDCASE, and DCONTACT_RECORD data tables to the near real time event-based architecture.
  • Migrated HEP100, HEPATITISCASE, HEPMULTIVALUEFIELDGROUP, and HEPMULTIVALUEFIELD data tables to the near real time event-based architecture.
  • Migrated PERTUSSISCASE, PERTUSSISSUSPECTEDSOURCEFLD/Group, and PERTUSSISTREATEMENTFIELD/GROUP data table to the near real time event-based architecture.
  • Migrated the ANTIMICROBIAL/GROUP data table to the near real time event-based architecture.
  • Migrated the BMIRDCASE, BMIRDMULTIVALUEFIELDGROUP, BMIRDMULTIVALUEFIELD, and BMIRDSTREPPNEUMO_DATAMART data tables to the near real time event-based architecture.

Full Changelog: https://github.com/CDCgov/NEDSS-DataReporting/compare/v7.8.0...v7.9.0

- TSQL
Published by achapm over 1 year ago

https://github.com/cdcgov/nedss-datareporting - v7.8.3

New Features & Enhancements

  • Added CRS, Rubella and Morbidity datamarts to the near real time events based architecture.
  • Added Measles datamart to the near real time events based architecture.
  • Added Generic Case datamart to the near real time events based architecture
  • Added Case Lab datamart to the near real time events based architecture.
  • Added CodeVal, Condition, Dplace, Userprofile, SRTE codeset, totalidm , and codevalgen dimensions and facts to the near real time events based architecture.

Full Changelog: https://github.com/CDCgov/NEDSS-DataReporting/compare/v7.8.2...v7.8.3

- TSQL
Published by achapm over 1 year ago

https://github.com/cdcgov/nedss-datareporting - v7.8.2

New Features

  • Added STDHIVDATAMART and INV_HIV datamarts to the near Real Time Reporting pipeline.
  • Added FSTDPAGE_CASE fact table to the near Real Time Reporting pipeline.

Full Changelog: https://github.com/CDCgov/NEDSS-DataReporting/compare/v7.8.0...v7.8.2

- TSQL
Published by achapm over 1 year ago

https://github.com/cdcgov/nedss-datareporting - v7.8.0

What's Changed

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

Full Changelog: https://github.com/CDCgov/NEDSS-DataReporting/compare/v7.7.2...v7.8.0

- TSQL
Published by achapm over 1 year ago

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

Full Changelog: https://github.com/CDCgov/NEDSS-DataReporting/compare/v7.7.0...v7.7.2

- TSQL
Published by achapm over 1 year ago

https://github.com/cdcgov/nedss-datareporting - 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 nrtinvestigationpostprocessing by @johneipe in https://github.com/CDCgov/NEDSS-DataReporting/pull/53
  • CNDE-1730: fix to CTE by @johneipe in https://github.com/CDCgov/NEDSS-DataReporting/pull/55
  • Addition of Morbidity Report and LabTestResult Post-Processing Sproc by @upasanapattnaik-eq in https://github.com/CDCgov/NEDSS-DataReporting/pull/54
  • CNDE-1805: RTR Observation: Add new columns and logic by @sveselev in https://github.com/CDCgov/NEDSS-DataReporting/pull/56
  • CNDE-1805 Fix for reportsprtuid and reportrefruid by @sveselev in https://github.com/CDCgov/NEDSS-DataReporting/pull/58
  • Data Sync - update rdb query by @ndduc01 in https://github.com/CDCgov/NEDSS-DataReporting/pull/57
  • CNDE-1834: Fix persistence for multivalued observation payloads by @sveselev in https://github.com/CDCgov/NEDSS-DataReporting/pull/62
  • CNDE-1394,1395,1397 Post-processing integration for Morbidity and Lab Test dimensions by @sveselev in https://github.com/CDCgov/NEDSS-DataReporting/pull/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 https://github.com/CDCgov/NEDSS-DataReporting/pull/63
  • Fix: Rename Morbidity Report Stored Procedure by @upasanapattnaik-eq in https://github.com/CDCgov/NEDSS-DataReporting/pull/64
  • CNDE 1393 by @joshua-mills-cdw in https://github.com/CDCgov/NEDSS-DataReporting/pull/60
  • CNDE-1401 - Lab100 procedure by @johneipe in https://github.com/CDCgov/NEDSS-DataReporting/pull/59

Full Changelog: https://github.com/CDCgov/NEDSS-DataReporting/compare/v7.6.2...v7.7.0

- TSQL
Published by achapm over 1 year ago

https://github.com/cdcgov/nedss-datareporting - 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 https://github.com/CDCgov/NEDSS-DataReporting/pull/45
  • CNDIT-1730: procedure changes to pick only the latest page case answers by @johneipe in https://github.com/CDCgov/NEDSS-DataReporting/pull/44
  • CNDIT 1777: RTR Observation Persist Extension To Persist New Columns by @sveselev in https://github.com/CDCgov/NEDSS-DataReporting/pull/46
  • RTR Notification: Make notification_uid not optional in Kafka message schema by @sveselev in https://github.com/CDCgov/NEDSS-DataReporting/pull/47
  • CNDIT-1777 Fix ObservationNumeric data type for Kafka schema by @sveselev in https://github.com/CDCgov/NEDSS-DataReporting/pull/49
  • CNDIT-1753 Addition of recordstatuscd constraint and Role for person_participation by @upasanapattnaik-eq in https://github.com/CDCgov/NEDSS-DataReporting/pull/48
  • Adding script for data exchange config by @ndduc01 in https://github.com/CDCgov/NEDSS-DataReporting/pull/20
  • Remove GO keyword by @ndduc01 in https://github.com/CDCgov/NEDSS-DataReporting/pull/51
  • updated nrtobservationcoded query by @ndduc01 in https://github.com/CDCgov/NEDSS-DataReporting/pull/52
  • CNDE-1724: Fix for PATBIRTHCOUNTRY being null by @johneipe in https://github.com/CDCgov/NEDSS-DataReporting/pull/50

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

- TSQL
Published by achapm over 1 year ago

https://github.com/cdcgov/nedss-datareporting - 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 https://github.com/CDCgov/NEDSS-DataReporting/pull/40
  • CNDIT-1729: Update observation services for Montana reports by @sveselev in https://github.com/CDCgov/NEDSS-DataReporting/pull/37
  • CNDIT-1729: Minor fix for liquibase script by @sveselev in https://github.com/CDCgov/NEDSS-DataReporting/pull/41
  • CNDIT-1786: Update liquibase to 4.29.2 with Java 21 by @sveselev in https://github.com/CDCgov/NEDSS-DataReporting/pull/42
  • CNDIT-1786 Update liquibase-core and dependdent stuff to the latest by @sveselev in https://github.com/CDCgov/NEDSS-DataReporting/pull/43

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

- TSQL
Published by achapm almost 2 years ago