v2024.06.01

Summary

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

What's Changed

• Filtering for honoured and not honoured in the Appointments cascade by @Marymary-dev in #421
• Feature/Adding-switched-to--2nd-regimenline-from-1st-regimenline by @nobert-mumo in #423
• Bugfix/Uasin-Gishu-seems-not-to-have-any-client-onTLD-based-regimen by @nobert-mumo in #424
• Removed the visitID in the uniqueness check under the ct_patientPharm… by @DennisGibz in #425
• Feature/Adding-SiteAbstraction-date-to-concordance-report by @nobert-mumo in #427
• Removed the lineARTHistory from the static folder to the main folder … by @DennisGibz in #428
• Refactor last Encounter model to pick the max Expected return from t… by @Marymary-dev in #426
• Removed LastEncounterDate on the LastEncounterPharmacy cte under Inte… by @DennisGibz in #429
• updated CT_Artpatient StartARTDate to StartARTAtThisFacility where St… by @DennisGibz in #430
• Adding Owner, Kephlevel and infrastructure type columns by @Marymary-dev in #431
• Added a new extract on ODS named Ushauri_PatientReferral on ODS.Delet… by @DennisGibz in #433
• Added an update on the CT_patientStatus to clean the ExitDate and Exi… by @DennisGibz in #432
• 1. Added A case statement to update voiding source on all the C&T ext… by @DennisGibz in #435
• Introduced a try_cast on RiskCategory case statement. Also renamed L… by @DennisGibz in #438
• Introduced Max ID in the inner query just to pick max created unique … by @DennisGibz in #439
• Modified AggregateHTSUptake to only consider records for the reportin… by @DennisGibz in #437
• Added ODS DQC scripts by @NewtonMutugi in #434

New Contributors

• @NewtonMutugi made their first contribution in #434

Full Changelog: v2024.04.01...v2024.05.01