v 2023.12.0-1

What's Changed

• Adding AHD indicators into linelist Fact ART by @Marymary-dev in #282
• Adding TBScreening into Fact Latest Obs by @Marymary-dev in #281
• Moved DimArtOutcome to the static Dimensions folder. Also,removed the… by @DennisGibz in #285
• Changing from inner to left join in ARTOutcome CTE + removing the nu… by @Marymary-dev in #286
• Removed null and yes folder by @DennisGibz in #287
• Removed Where voided =0 on DimPatient script by @DennisGibz in #288
• Included F.code >0 for all the ODS C&T Scripts for eliminate data fro… by @DennisGibz in #291
• Feature/Adding-an-IIT-RiskScore-fact-and-report by @nobert-mumo in #290
• Revert "Included F.code >0 for all the ODS C&T Scripts for eliminate data fro…" by @cbrianbet in #292
• Remove voided check on ODS - central scripts by @cbrianbet in #294
• Added voided check (Voided =0 ) for intermediate tables referencing O… by @DennisGibz in #295
• Moved the CBS_Data folder from CT_Docket to- ODS folder by @DennisGibz in #296
• Change to datediff Dispensedate,Expected return by @Marymary-dev in #289
• Added scripts to update records for voided patients by @cbrianbet in #293
• Moved the ODS_VOIDING folder from Utils sub-folder to ODS Main Folder by @DennisGibz in #298
• Patch/reversing scripts by @cbrianbet in #302
• Bugfix/Update-PrepCT-based-on-MER-guidelines by @nobert-mumo in #299
• Change from Dispensedate to LastVisit date by @Marymary-dev in #304
• Starting from FactART and Left join VL by @Marymary-dev in #297
• Bugfix/DSD-Aggregate-models-do-not-give-same-results-as-what-is-in-Linelist-ART by @nobert-mumo in #300
• Addiing MNCH datasets into FactPbfw by @Marymary-dev in #284
• Updated ValidVLResultCategory Limits by @cbrianbet in #305
• Adding Date Confirmed Positive Key into Fact ART by @Marymary-dev in #310
• Optimizing load_FactDefaulterTracing.sql by @cbrianbet in #311
• Optimized the loading of FactTPT by @DennisGibz in #314
• Added [RecordUUID] by @DennisGibz in #318
• Added mhealth folder with ushauri patients and Appointments by @DennisGibz in #319
• MOdified ODS scripts to include more columns in the update. Also adde… by @DennisGibz in #320
• Ushauri on ods by @DennisGibz in #321
• Feature/an aggregate dataset on the reporting layer for the durable u equals u dashboard by @nobert-mumo in #306
• Feature/ Add Positive & started on prep' to the aggregate prep cascade by @nobert-mumo in #313
• Refactoring the model to accomodate AMRS sites by @Marymary-dev in #322
• Adding Fact HTSPOS Concordance by @Marymary-dev in #316
• Adding Aggregate_Concordance_TxCurr by @Marymary-dev in #308
• Adding Fact TxCurr Concordance by @Marymary-dev in #315
• ODS CT Scripts clean up by @DennisGibz in #324
• Feature/Add-EOM-date-in-Fact-ART by @nobert-mumo in #323
• Feature/Refactor-logic-for-ScreenedForBP-&-ScreenedForDiabetes by @nobert-mumo in #317
• Included voided check in the merge to avoid duplication errors. Also … by @DennisGibz in #326
• Modified CT_IPT by @DennisGibz in #327
• Filtering out HasRegimen clients to subset in the unsuppressed category by @Marymary-dev in #312
• Adding reporting Month by @Marymary-dev in #329
• Adding Fact_manifest by @Marymary-dev in #330
• Fix/Omit-records-with-NULL-adverse-events-from-the-fact by @nobert-mumo in #331
• Feat/add mpi golden id by @nthusi-codes in #307
• Adding Aggregate_concordance_HTSPO by @Marymary-dev in #309
• Removing dependency from Fact NCD by @Marymary-dev in #334
• Adding mental health variables into linelist ART by @Marymary-dev in #335
• Renaming rom Aggregate cohort retention to Aggregate_TxNew by @Marymary-dev in #336
• Changed facility source to ODS from HISImplementation by @cbrianbet in #301
• Fix/Some-house-keeping-of-the-repo by @nobert-mumo in #338
• create service desk util by @cbrianbet in #340
• Alignment between .83 scripts the dev branch by @DennisGibz in #339
• Updating release by @cbrianbet in #341

Full Changelog: v1.0.0...202312-1