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
NB: Here is a simple tool for performing the data comparisons across two dataset. Compare
Comments are closed