v2024.04.01

Summary

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

What's Changed

• Feauture add index patient pk by @Marymary-dev in #395
• Changing from Coalesce to OR Statement and removing extra space by @Marymary-dev in #397
• Filtering for the unsuppressed who had a repeat VL by @Marymary-dev in #400
• Adding Mmd, Apointments category and stability assessment by @Marymary-dev in #401
• Adding PrepEnrollmentDate to the Fact and the Linelist by @Marymary-dev in #396
• Creating Fact Modules Uptake by @Marymary-dev in #399
• Adding linelist modules uptake by @Marymary-dev in #402
• Bugfix/Fix-ambigous-column-name-in-prep-cascade by @nobert-mumo in #404
• Feature/Building-RTC-in-the-last-12-months-from-reporting-period by @nobert-mumo in #398
• Fixing traced indicator in Ushauri appointments by @Marymary-dev in #403
• Modified CT_Relationship,Ushauri_appointments,intermmiadiate ViralLoa… by @DennisGibz in #406
• Task/Put-RTT-intermediate-in-a-sub-folder by @nobert-mumo in #407
• Adding pregnant, breastfeeding and ScreenedDepression date columns by @Marymary-dev in #405
• Resolving conflicts by @Marymary-dev in #408
• Returning deleted column isCT by @cbrianbet in #410
• Modified Intermediate LastVisit to cater for /. Cleaning of the BP co… by @DennisGibz in #411
• Adding PrepVariables into Preplinelist by @Marymary-dev in #409
• Renaming linelistPrep to LinelistPrepAssessments by @Marymary-dev in #412
• Feature/Update-logic-for-checking-if-NCDs-are-controlled-or-not-based-on-the-new-data-points-that-were-added-from-DWAPI by @nobert-mumo in #415
• Adding LinelistPrep by @Marymary-dev in #416
• Aliasing Pregnant column in DSD Unstable model by @Marymary-dev in #417
• Clean Regimen Lines by @Marymary-dev in #414
• Introduced Union to well cater for patients coming from ushauri by @DennisGibz in #418
• Creating look up table for regimen line cleaning by @Marymary-dev in #419
• Added Ushauri_Hei script,removed [TracingCalls],[TracingSMS],[Tracing… by @DennisGibz in https://github.com//pull/413
• Bugfix/-Adapting-Fact-ART-to-handle-updated-logic-for-NCD-controlled-and-screened by @nobert-mumo in #420
• Adding IPT variables into linelist FactART by @Marymary-dev in #422

Full Changelog: v2024.03.01...v2024.04.01