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