Incase of variances in the TX_CURR / Current on ART reports, check the following.
Enrolment form for TIs (completeness and accuracy) for missing clients
Discontinuation form (completeness and accuracy) for missing clients
Recreate ETL tables the re-run the reports
Check patient dashboards for completeness and accurate data entry for missing clients
Generate EMR Report for the specified period
Download the current on ART Line list
Using the DAR, list the unique patient number for all clients considered active for the specified period
Using the compare tool, paste Unique numbers with more numbers on the first column and the one with less on second column (Compare tool has two columns one labelled EMR and paper)
Once the data from both sources is pasted on Input worksheet, click on compare and the results will be populated on output worksheet
Records listed on output on either of the columns indicates what’s in that source but missing in the other
Using the output
Check the Green Card to confirm that the last visit was updated in EMR and the correct TCA documented
Generate Lost to follow-up report and confirm there is no active client listed
Generate list of clients transferred in and confirm that the correct effective dates are updated