Skip to content

Minor Release: new reports and updates to existing reports
Compare
Choose a tag to compare
@nthfloor nthfloor released this 27 Jun 12:05
· 21 commits to master since this release
1.4.0
85d4969

Changes include:

  • PEPFAR MER 2.3 Quarterly - Updated
    • Base Cohort updated
      • The base cohort that affect all the reports was changed to include patients on ART who don’t have their first appointment for some reason (eg. migration) but were enrolled and are in treatment.
    • TX_NEW
      • Removed the gender filter on the pregnancy and breastfeeding queries.
      • Now including patients who initiated and restarted treatment during the reporting period.
    • TX_PVLS
      • Breastfeeding and pregnant queries
        • Now checking the criterias that occurred during the 18 or 9 months period instead of looking at the last observation.
        • Removes the gender check for breastfeeding and pregnancy everywhere in the code
      • Patients who have at least one (the last) Viral Load result registered during the last 12 months period:
        • Changed to exclude patients who have the last Viral Load Result on the first day of 12 months period, to avoid duplication from previous reporting period.
      • Routine queries
        • Criteria 1
          • Excluding 1 day from the six months date for routine criteria 1 when checking if a patient has any other viral load observation between ART Initiation date and six months later.
          • Including equal boundaries to all our date limits
        • Criteria 2
          • Including equal boundaries to all our date limits
        • Criteria 3
          • Excluding patients who have viral load between therapy changing date and therapy changing date+6 months as opposed to end of reporting period-12 months
          • Including equal boundaries to all our date limits
  • IM-ER (Early Retentions Indicators) - Updated
    • Base cohort updated
  • PEPFAR MER 2.3 Semi-Annual Report - Updated
    • Base cohort updated
  • TX_CURR Report 2.1 - Updated
    • Base cohort updated
  • QUALITY IMPROVEMENT REPORT 2019 - New report from sql
    • Implemented report from sql scripts
  • TX RET 2.1 Report - New report from sql
    • Implemented report from sql scripts
  • RESUMO MENSAL US - HIV/SIDA - Ficha de Seguimento - New report from sql
    • Implemented report from sql scripts
Assets 3
Loading