v2024.08.01

Summary

These are the scripts that run the DWH refresh on August 2024

What's Changed

• Feature/Adding-Date-Confirmed-HIV-to-Dim-Patient by @nobert-mumo in #443
• Feature/Builidng-reporting-table-for-case-survillence-tiles-for-the-overview-page by @nobert-mumo in #446
• Hiv cs tx continuity by @DennisGibz in #445
• Updated nupi to null where nupi is coming as an empty string by @DennisGibz in #452
• Modified te factART to include factARTHistory incrementally by @DennisGibz in #444
• Added and (LatestExits.ExitReason is null or LatestExits.ExitReason =… by @DennisGibz in #441
• Feat ushauri etl by @NewtonMutugi in #456
• Added new variables on both ODS.dbo.ct_Patientvisit([AppointmentRemin… by @DennisGibz in https://github.com//pull/458
• Included PersonAPatientPkHash and PersonBPatientPkHash Hashing on the… by @DennisGibz in #440
• Added Load Ushauri_HW_Exposure script by @NewtonMutugi in #459
• Added missing update ODS DQC scripts by @NewtonMutugi in #457
• Refactor the column for LastCD4 dates to pick from the latest CD4 CTE by @Marymary-dev in #455
• Feature/Adding-new-reporting-table-for-on-ART--sentinel-event by @nobert-mumo in #449
• Adding changes to ARTOutcomes model by @Marymary-dev in #461
• Updated column to match Fact Column by @cbrianbet in #462
• Feature/Building-Indicator-for-PBFW-as-of-Diagnosis by @nobert-mumo in #463
• Adding Missed opportunities VL gap model by @Marymary-dev in #448
• Adding Linelist for reported cases risks by @Marymary-dev in #466
• Adding Disclosure column by @Marymary-dev in #471
• Feauture hiv advanced disease model by @Marymary-dev in #467
• Feat ct dockets updates by @NewtonMutugi in #468
• Feature/IndexElicitation-&-testing-report-for-case-survillence by @nobert-mumo in #470
• Feature/building a reporting table for substance abuse & sti risk factors by @nobert-mumo in #474
• Fix update mhealth table names by @NewtonMutugi in #469
• Aligned the hashing scripts and added the missing updates. Also remov… by @DennisGibz in #472
• Feat/nishauri profile etl by @NewtonMutugi in #473
• Fix/-Removing-dups-from-the--AHD-model-linelist-for-CS by @nobert-mumo in #480
• aggregate otz outcomes updated to cover active clients by @cbrianbet in #483
• Adding a column for EveronART to DimPatient by @Marymary-dev in #477
• Refactoring prophylaxis data by @Marymary-dev in #465
• Removed ambiguity on the outcome column under the alias on the where … by @DennisGibz in #485
• Modified HTSclientTracing to eliminate duplicates by @DennisGibz in #484
• corrected column PeripheralNeuropath to PeripheralNeuropathy by @DennisGibz in #464
• Added scripts to flag duplicates on the ODS layer by @DennisGibz in #460
• Align ct patient lab remove dups by @DennisGibz in #488
• Moved all the CS based scripts from Reporting main folder to HIVCaseS… by @DennisGibz in #489
• Added new variables on the mnch_ANCVisits by @DennisGibz in #490
• Added a new intermediate table to calculate PBFW. The script has comm… by @DennisGibz in #481
• Fix/nishauri ods by @NewtonMutugi in #491
• Adding Confirmed Treatment failure by @Marymary-dev in #493
• Adding new patient column by @Marymary-dev in #494

Full Changelog: v2024.05.01...v2024.08.01