[x] There was a count mismatch in the linelist and the aggregate of 'TB family screening (Program: TB)' due to the dynamic WHERE clause not being updated to ETL.
[x] There was a count mismatch in the linelist and the aggregate of 'TB patients with any new comorbidity (Program: TB)' due to the dynamic WHERE clause not being updated to ETL. Additionally, two joins (missing for Ganiyari and clinic lab result encounters) were added in the 'TB common linelist,' which is utilized by the following aggregates:
Patients diagnosed with different types of TB
Patients diagnosed with extrapulmonary TB with different types
Below are the list of Priority 1 (P1) ETL Migration Reports to be done for the Hypertension Whoever is working on it, kindly update the status as Completed in the Report To ETL sheet: Kindly Update "Completed" status here: https://docs.google.com/spreadsheets/d/15U3mOkcVjHhXlr318uj8DRQNzC6mBOTf-GEPf9SLfTM/edit#gid=431825339