Pre-release: query updates & improvements

Changes include:

TXPVLS

    Improvements on query 

BaseCohort

    Changes to not consider transferred in (has been enrolled in “SERVICO TARV – TRATAMENTO” in health facility)  this will affect all indicators using the basecohort

Patch: Updates for TB, ML, Im-ER indicators

Changes include:

• IM-ER
  • restored pregnancy exlcusion from breastfeeding query
• TxTB
  • removed NEG TB screening result from Positive screening query
• TxML
  • Added exclusion for dead patients to "not-consented" query

Patch: Updates for PVLS indicator

Changes include:

• TxPVLS indicator
  • Adults & Children
    • Including Breastfeeding and pregnant patients as part of Adults
    • We were previously excluding breastfeeding and pregnant patients from Adults since they had a separate category.
  • Breastfeeding queries
    • If the patient is both breastfeeding & pregnant (have obs with the same date) classify the patient as breastfeeding
  • Routine queries
    • Criteria 1
      • Spec change:

            (last_vl_registered_date – patient_art_date) >6 and <=9 months
             and
             no VL registered between ART initiation date and (ART initiation date + [6 months(adult) / 3 months(Breastfeeding)])
        

    • Criteria 2
      • Spec change:

         no VL result between (last viral load date -1day and last viral load - 12 meses)
         and
         check if there is any vl with a result of <1000 copies, registered between 12 - 15 months from last
         viral load. 
        

    • Criteria 3
      • Spec change:
        • to update condition: no other VL registered between regimen changing the date and endDate-12 months previously spec was to compare regimenDate to lastVlDate
        • when looking up regimen obs need to use encounter type 18 instead of 6,9
      • Bug fix: excluding regimenDate boundary, changed from including regimenDate as a boundary limit
  • Excel template
    • Changed to match FGH

Minor release: including new PEPFAR Semi-Annual Report

Changes include:

• TX_NEW
  • Code improvements
  • Bug Fix: breastfeeding query updated
    • updated date range (prior 2yr -> reporting period)
• TX_CURR
  • Bug fix: added missing base query on MER Quarterly
  • Code improvements
• Early Retention
  • Bug fix: transferred out query: update to ensure always checking latest patient state
• New Indicators for PEPFAR MER 2.3 Semi-Annual Report
  • TB_PREV
  • TX_TB (Testing still to be finalised for all partners databases)
  • TX_ML (Testing still to be finalised for all partners databases)

Patch: add TxCurr & TxNew indicators to early retention report

Changes include:

• Updated IM-ER-Report as follows
  • Unchanged
    • IM-ER2
    • IM-ER4
  • Added
    • TxCurr
    • TxNew
• New order of indicators in template is: TxCurr, TxNew, IM-ER2, IM-ER4

Patch: reverted New, Curr and Pvls code improvements

Patch: reverted New, Curr and Pvls code improvements

Changes include:

• Reverted New, Curr and Pvls code improvements. MER report now matches EPTS release v2.0.1 specification.
• Early Retention report is unchanged

Minor release: including new early retention report

Minor release: including new early retention report.

Changes include:

• Added new report: IM-ER-Report
  • Early Retention report
  • Includes 2 indicators
    • IM-ER2 (Early retention 2 months)
    • IM-ER4 (Early retention 4 months)

EPTS TxCurr and TxPVLS Patch

A patch release which updates TxCurr queries and includes some bug fixes for TxPvls.

Changes include:

• TxCurr
  • Update: Lost to Follow Up exclusion assumptions changed
  • Update: Exclusion of Dead/Transferred/Suspended/Stopped/Abandoned changed
  • Update: Order of when Lost to Follow up exclusion is
• TxPvls
  • Bug fix: to include breastfeeding and pregnant patients from 12 month period not just reporting period
  • Bug fix: added missing location parameter breastfeeding subquery
  • Update: Included clinical forms in viral load results lookups

Fix NPE on Calculating Initial ART Start Date

PVLS has 4 criteria for choosing the minimal date for starting ART, if one of the date were null the module was throwing an error.

Changes include:

• Change formatting plugin from compilation to generate-sources phases

Improvement to TxPVLS indicator

The TxPVLS indicator and PEPFAR MER 2.3 Quarterly template have been updated.

Changes include:

• Performance improvements to queries for txPVLS indicator
• Routine queries updated
• PEPFAR MER 2.3 Quarterly template updated
• Tx_Curr Report 2.1 template updated