/
RDQA Technical Manual: Analytics
  • Ready for review

    • ✍ External Public Page ✍

    RDQA Technical Manual: Analytics

    Owned by Henry Lopez (Unlicensed)
    Last updated: Jul 05, 2023 by Henry Lopez
    8 min read

    Program indicators

    Program indicators allow generating calculated fields which can then be used to visualize data within DHIS2. We do not suggest you to modify program indicators to ensure the program operability, however, if you are in need of adding new health areas, please ensure that you also add its respective program indicator.

    Name

    Aggregation Type/
    Analytic Type

    Expression

    Filter

    Name

    Aggregation Type/
    Analytic Type

    Expression

    Filter

    1. Overall Data Quality Score

    Average/Event

    (((((#{vKV40XCuno0.SZ2rOnqWHRl} + #{vKV40XCuno0.RLZAabjkJuH} + #{vKV40XCuno0.LMeJ75Bjffa})
    /3)+(#{vKV40XCuno0.QHms8PT9aH6}) +
    (#{vKV40XCuno0.sOi40s2JqKB}) +
    (#{vKV40XCuno0.Sg6B9cSGTfO}*100) +
    (#{vKV40XCuno0.jJcDCaPqZwH}*100) +
    (#{vKV40XCuno0.CzfIL9uW9EH}*100) +
    #{vKV40XCuno0.jWWgAo2rkHo})/7) +
    ((((d2:zing(#{NzAJsKJKDhU.oBxLFCHv7lZ}))+(d2:zing(#{NzAJsKJKDhU.vb1ihS1Gqki}))+(d2:zing(#{NzAJsKJKDhU.a2gNg7bAdHP}))+(d2:zing(#{NzAJsKJKDhU.kVsZd50zVxT}))+(d2:zing(#{NzAJsKJKDhU.RHueZwfjJcq}))+(d2:zing(#{NzAJsKJKDhU.RdgEJJ99xlV}))+(d2:zing(#{NzAJsKJKDhU.tpVfAOmf1fw}))+(d2:zing(#{NzAJsKJKDhU.jVMJnEvKBed}))+(d2:zing(#{NzAJsKJKDhU.H6AQcCopXSx}))+(d2:zing(#{NzAJsKJKDhU.ChO5Q7SxRV9}))+(d2:zing(#{NzAJsKJKDhU.zumApDhgflJ}))+(d2:zing(#{NzAJsKJKDhU.IaMtr6EhTt5}))+(d2:zing(#{NzAJsKJKDhU.AGG1bjLUfaF}))+(d2:zing(#{NzAJsKJKDhU.yPrkCOwPN34}))+(d2:zing(#{NzAJsKJKDhU.mfdzfMjp5qK}))+(d2:zing(#{NzAJsKJKDhU.T5nBUYHFjdK}))+(d2:zing({NzAJsKJKDhU.aTc2qJNg9Ln})))/(d2:zpvc(#{NzAJsKJKDhU.oBxLFCHv7lZ},#{NzAJsKJKDhU.vb1ihS1Gqki},#{NzAJsKJKDhU.a2gNg7bAdHP},#{NzAJsKJKDhU.kVsZd50zVxT},#{NzAJsKJKDhU.RHueZwfjJcq},#{NzAJsKJKDhU.RdgEJJ99xlV},#{NzAJsKJKDhU.tpVfAOmf1fw},#{NzAJsKJKDhU.jVMJnEvKBed},#{NzAJsKJKDhU.H6AQcCopXSx},#{NzAJsKJKDhU.ChO5Q7SxRV9},#{NzAJsKJKDhU.zumApDhgflJ},#{NzAJsKJKDhU.IaMtr6EhTt5},#{NzAJsKJKDhU.AGG1bjLUfaF},#{NzAJsKJKDhU.yPrkCOwPN34},#{NzAJsKJKDhU.mfdzfMjp5qK},#{NzAJsKJKDhU.T5nBUYHFjdK},#{NzAJsKJKDhU.aTc2qJNg9Ln})))*100))/(1 + A{WCUd72sd7bo})

     

    2. System Assessment Score

    Average/Event

    (((d2:zing(#{NzAJsKJKDhU.oBxLFCHv7lZ}))+(d2:zing(#{NzAJsKJKDhU.vb1ihS1Gqki}))+(d2:zing(#{NzAJsKJKDhU.a2gNg7bAdHP}))+(d2:zing(#{NzAJsKJKDhU.kVsZd50zVxT}))+(d2:zing(#{NzAJsKJKDhU.RHueZwfjJcq}))+(d2:zing(#{NzAJsKJKDhU.RdgEJJ99xlV}))+(d2:zing(#{NzAJsKJKDhU.tpVfAOmf1fw}))+(d2:zing(#{NzAJsKJKDhU.jVMJnEvKBed}))+(d2:zing(#{NzAJsKJKDhU.H6AQcCopXSx}))+(d2:zing(#{NzAJsKJKDhU.ChO5Q7SxRV9}))+(d2:zing(#{NzAJsKJKDhU.zumApDhgflJ}))+(d2:zing(#{NzAJsKJKDhU.IaMtr6EhTt5}))+(d2:zing(#{NzAJsKJKDhU.AGG1bjLUfaF}))+(d2:zing(#{NzAJsKJKDhU.yPrkCOwPN34}))+(d2:zing(#{NzAJsKJKDhU.mfdzfMjp5qK}))+(d2:zing(#{NzAJsKJKDhU.T5nBUYHFjdK}))+(d2:zing(#{NzAJsKJKDhU.aTc2qJNg9Ln})))
    /(d2:zpvc(#{NzAJsKJKDhU.oBxLFCHv7lZ},#{NzAJsKJKDhU.vb1ihS1Gqki},#{NzAJsKJKDhU.a2gNg7bAdHP},#{NzAJsKJKDhU.kVsZd50zVxT},#{NzAJsKJKDhU.RHueZwfjJcq},#{NzAJsKJKDhU.RdgEJJ99xlV},#{NzAJsKJKDhU.tpVfAOmf1fw},#{NzAJsKJKDhU.jVMJnEvKBed},#{NzAJsKJKDhU.H6AQcCopXSx},#{NzAJsKJKDhU.ChO5Q7SxRV9},#{NzAJsKJKDhU.zumApDhgflJ},#{NzAJsKJKDhU.IaMtr6EhTt5},#{NzAJsKJKDhU.AGG1bjLUfaF},#{NzAJsKJKDhU.yPrkCOwPN34},#{NzAJsKJKDhU.mfdzfMjp5qK},#{NzAJsKJKDhU.T5nBUYHFjdK},#{NzAJsKJKDhU.aTc2qJNg9Ln})))*100

     

    3. Overall Data Verification Score

    Average/Event

    (((#{vKV40XCuno0.SZ2OrnqWHRl} + #{vKV40XCuno0.RLZAabjkJuH} + #{vKV40XCuno0.LMeJ75Bjffa})/3)+(#{vKV40XCuno0.QHms8PT9aH6}) +(#{vKV40XCuno0.sOi40s2JqKB}) +(#{vKV40XCuno0.Sg6B9cSGTfO}*100) +(#{vKV40XCuno0.jJcDCaPqZwH}*100) +(#{vKV40XCuno0.CzfIL9uW9EH}*100) +#{vKV40XCuno0.jWWgAo2rkHo})/7

     

    3.1 Availability

    Average/Event

    #{vKV40XCuno0.QHms8PT9aH6}

     

    3.2 Completeness

    Average/Event

    #{vKV40XCuno0.sOi40s2JqKB}

     

    3.3 Timeliness

    Average/Event

    #{vKV40XCuno0.jWWgAo2rkHo}

     

    3.4 Integrity

    Average/Event

    #{vKV40XCuno0.jJcDCaPqZwH} * 100

     

    3.5 Confidentiality

    Average/Event

    #{vKV40XCuno0.Sg6B9cSGTfO}*100

     

    3.6 Precision

    Average/Event

    #{vKV40XCuno0.CzfIL9uW9EH} * 100

     

    3.7 Accuracy

    Average/Event

    (#{vKV40XCuno0.RLZAabjkJuH}+#{vKV40XCuno0.SZ2OrnqWHRl}+#{vKV40XCuno0.LMeJ75Bjffa}) / V{value_count}

     

    3.7.1 Source vs. Summary

    Average/Event

    #{vKV40XCuno0.RLZAabjkJuH}

     

    3.7.2 Source vs. MIS or donor

    Average/Event

    #{vKV40XCuno0.SZ2OrnqWHRl}

     

    3.7.3 Summary vs. MIS or donor

    Average/Event

    #{vKV40XCuno0.LMeJ75Bjffa}

     

    PI 1- Number of Assessments conducted

    Count/Enrollment

    V{enrollment_count}

     

    PI1.1- Number of Assessments conducted HA2

    Count/Enrollment

    V{enrollment_count}

    A{FHZRRuX1lyN} == 'HA2'

    PI1.2- Number of Assessments conducted HA8

    Count/Enrollment

    V{enrollment_count}

    A{FHZRRuX1lyN} == 'HA8'

    PI1.3- Number of Assessments conducted HA1

    Count/Enrollment

    V{enrollment_count}

    A{FHZRRuX1lyN} == 'HA1'

    PI1.4- Number of Assessments conducted HA4

    Count/Enrollment

    V{enrollment_count}

    A{FHZRRuX1lyN} == 'HA4'

    PI1.5- Number of Assessments conducted HA6

    Count/Enrollment

    V{enrollment_count}

    A{FHZRRuX1lyN} == 'HA6'

    PI1.6- Number of Assessments conducted HA7

    Count/Enrollment

    V{enrollment_count}

    A{FHZRRuX1lyN} == 'HA7'

    PI1.7- Number of Assessments conducted HA3

    Count/Enrollment

    V{enrollment_count}

    A{FHZRRuX1lyN} == 'HA3'

    PI1.8- Number of Assessments conducted HA5

    Count/Enrollment

    V{enrollment_count}

    A{FHZRRuX1lyN} == 'HA8'

    PI2.1 HA2 Overall Data Quality Score

    Average/Event

    (((((#{vKV40XCuno0.SZ2OrnqWHRl} + #{vKV40XCuno0.RLZAabjkJuH} + #{vKV40XCuno0.LMeJ75Bjffa})/3)+(#{vKV40XCuno0.QHms8PT9aH6}) +(#{vKV40XCuno0.sOi40s2JqKB}) +(#{vKV40XCuno0.Sg6B9cSGTfO}*100) +(#{vKV40XCuno0.jJcDCaPqZwH}*100) +(#{vKV40XCuno0.CzfIL9uW9EH}*100) +#{vKV40XCuno0.jWWgAo2rkHo})/7) + ((((d2:zing(#{NzAJsKJKDhU.oBxLFCHv7lZ}))+(d2:zing(#{NzAJsKJKDhU.vb1ihS1Gqki}))+(d2:zing(#{NzAJsKJKDhU.a2gNg7bAdHP}))+(d2:zing(#{NzAJsKJKDhU.kVsZd50zVxT}))+(d2:zing(#{NzAJsKJKDhU.RHueZwfjJcq}))+(d2:zing(#{NzAJsKJKDhU.RdgEJJ99xlV}))+(d2:zing(#{NzAJsKJKDhU.tpVfAOmf1fw}))+(d2:zing(#{NzAJsKJKDhU.jVMJnEvKBed}))+(d2:zing(#{NzAJsKJKDhU.H6AQcCopXSx}))+(d2:zing(#{NzAJsKJKDhU.ChO5Q7SxRV9}))+(d2:zing(#{NzAJsKJKDhU.zumApDhgflJ}))+(d2:zing(#{NzAJsKJKDhU.IaMtr6EhTt5}))+(d2:zing(#{NzAJsKJKDhU.AGG1bjLUfaF}))+(d2:zing(#{NzAJsKJKDhU.yPrkCOwPN34}))+(d2:zing(#{NzAJsKJKDhU.mfdzfMjp5qK}))+(d2:zing(#{NzAJsKJKDhU.T5nBUYHFjdK}))+(d2:zing(#{NzAJsKJKDhU.aTc2qJNg9Ln})))/(d2:zpvc(#{NzAJsKJKDhU.oBxLFCHv7lZ},#{NzAJsKJKDhU.vb1ihS1Gqki},#{NzAJsKJKDhU.a2gNg7bAdHP},#{NzAJsKJKDhU.kVsZd50zVxT},#{NzAJsKJKDhU.RHueZwfjJcq},#{NzAJsKJKDhU.RdgEJJ99xlV},#{NzAJsKJKDhU.tpVfAOmf1fw},#{NzAJsKJKDhU.jVMJnEvKBed},#{NzAJsKJKDhU.H6AQcCopXSx},#{NzAJsKJKDhU.ChO5Q7SxRV9},#{NzAJsKJKDhU.zumApDhgflJ},#{NzAJsKJKDhU.IaMtr6EhTt5},#{NzAJsKJKDhU.AGG1bjLUfaF},#{NzAJsKJKDhU.yPrkCOwPN34},#{NzAJsKJKDhU.mfdzfMjp5qK},#{NzAJsKJKDhU.T5nBUYHFjdK},#{NzAJsKJKDhU.aTc2qJNg9Ln})))*100))/2

    A{FHZRRuX1lyN} == 'HA2'

    PI2.2 HA8 Overall Data Quality Score

    Average/Event

    (((((#{vKV40XCuno0.SZ2OrnqWHRl} + #{vKV40XCuno0.RLZAabjkJuH} + #{vKV40XCuno0.LMeJ75Bjffa})/3)+(#{vKV40XCuno0.QHms8PT9aH6}) +(#{vKV40XCuno0.sOi40s2JqKB}) +(#{vKV40XCuno0.Sg6B9cSGTfO}*100) +(#{vKV40XCuno0.jJcDCaPqZwH}*100) +(#{vKV40XCuno0.CzfIL9uW9EH}*100) +#{vKV40XCuno0.jWWgAo2rkHo})/7) + ((((d2:zing(#{NzAJsKJKDhU.oBxLFCHv7lZ}))+(d2:zing(#{NzAJsKJKDhU.vb1ihS1Gqki}))+(d2:zing(#{NzAJsKJKDhU.a2gNg7bAdHP}))+(d2:zing(#{NzAJsKJKDhU.kVsZd50zVxT}))+(d2:zing(#{NzAJsKJKDhU.RHueZwfjJcq}))+(d2:zing(#{NzAJsKJKDhU.RdgEJJ99xlV}))+(d2:zing(#{NzAJsKJKDhU.tpVfAOmf1fw}))+(d2:zing(#{NzAJsKJKDhU.jVMJnEvKBed}))+(d2:zing(#{NzAJsKJKDhU.H6AQcCopXSx}))+(d2:zing(#{NzAJsKJKDhU.ChO5Q7SxRV9}))+(d2:zing(#{NzAJsKJKDhU.zumApDhgflJ}))+(d2:zing(#{NzAJsKJKDhU.IaMtr6EhTt5}))+(d2:zing(#{NzAJsKJKDhU.AGG1bjLUfaF}))+(d2:zing(#{NzAJsKJKDhU.yPrkCOwPN34}))+(d2:zing(#{NzAJsKJKDhU.mfdzfMjp5qK}))+(d2:zing(#{NzAJsKJKDhU.T5nBUYHFjdK}))+(d2:zing(#{NzAJsKJKDhU.aTc2qJNg9Ln})))/(d2:zpvc(#{NzAJsKJKDhU.oBxLFCHv7lZ},#{NzAJsKJKDhU.vb1ihS1Gqki},#{NzAJsKJKDhU.a2gNg7bAdHP},#{NzAJsKJKDhU.kVsZd50zVxT},#{NzAJsKJKDhU.RHueZwfjJcq},#{NzAJsKJKDhU.RdgEJJ99xlV},#{NzAJsKJKDhU.tpVfAOmf1fw},#{NzAJsKJKDhU.jVMJnEvKBed},#{NzAJsKJKDhU.H6AQcCopXSx},#{NzAJsKJKDhU.ChO5Q7SxRV9},#{NzAJsKJKDhU.zumApDhgflJ},#{NzAJsKJKDhU.IaMtr6EhTt5},#{NzAJsKJKDhU.AGG1bjLUfaF},#{NzAJsKJKDhU.yPrkCOwPN34},#{NzAJsKJKDhU.mfdzfMjp5qK},#{NzAJsKJKDhU.T5nBUYHFjdK},#{NzAJsKJKDhU.aTc2qJNg9Ln})))*100))/2

    A{FHZRRuX1lyN} == 'HA8'

    PI2.3 HA1 Overall Data Quality Score

    Average/Event

    (((((#{vKV40XCuno0.SZ2OrnqWHRl} + #{vKV40XCuno0.RLZAabjkJuH} + #{vKV40XCuno0.LMeJ75Bjffa})/3)+(#{vKV40XCuno0.QHms8PT9aH6}) +(#{vKV40XCuno0.sOi40s2JqKB}) +(#{vKV40XCuno0.Sg6B9cSGTfO}*100) +(#{vKV40XCuno0.jJcDCaPqZwH}*100) +(#{vKV40XCuno0.CzfIL9uW9EH}*100) +#{vKV40XCuno0.jWWgAo2rkHo})/7) + ((((d2:zing(#{NzAJsKJKDhU.oBxLFCHv7lZ}))+(d2:zing(#{NzAJsKJKDhU.vb1ihS1Gqki}))+(d2:zing(#{NzAJsKJKDhU.a2gNg7bAdHP}))+(d2:zing(#{NzAJsKJKDhU.kVsZd50zVxT}))+(d2:zing(#{NzAJsKJKDhU.RHueZwfjJcq}))+(d2:zing(#{NzAJsKJKDhU.RdgEJJ99xlV}))+(d2:zing(#{NzAJsKJKDhU.tpVfAOmf1fw}))+(d2:zing(#{NzAJsKJKDhU.jVMJnEvKBed}))+(d2:zing(#{NzAJsKJKDhU.H6AQcCopXSx}))+(d2:zing(#{NzAJsKJKDhU.ChO5Q7SxRV9}))+(d2:zing(#{NzAJsKJKDhU.zumApDhgflJ}))+(d2:zing(#{NzAJsKJKDhU.IaMtr6EhTt5}))+(d2:zing(#{NzAJsKJKDhU.AGG1bjLUfaF}))+(d2:zing(#{NzAJsKJKDhU.yPrkCOwPN34}))+(d2:zing(#{NzAJsKJKDhU.mfdzfMjp5qK}))+(d2:zing(#{NzAJsKJKDhU.T5nBUYHFjdK}))+(d2:zing(#{NzAJsKJKDhU.aTc2qJNg9Ln})))/(d2:zpvc(#{NzAJsKJKDhU.oBxLFCHv7lZ},#{NzAJsKJKDhU.vb1ihS1Gqki},#{NzAJsKJKDhU.a2gNg7bAdHP},#{NzAJsKJKDhU.kVsZd50zVxT},#{NzAJsKJKDhU.RHueZwfjJcq},#{NzAJsKJKDhU.RdgEJJ99xlV},#{NzAJsKJKDhU.tpVfAOmf1fw},#{NzAJsKJKDhU.jVMJnEvKBed},#{NzAJsKJKDhU.H6AQcCopXSx},#{NzAJsKJKDhU.ChO5Q7SxRV9},#{NzAJsKJKDhU.zumApDhgflJ},#{NzAJsKJKDhU.IaMtr6EhTt5},#{NzAJsKJKDhU.AGG1bjLUfaF},#{NzAJsKJKDhU.yPrkCOwPN34},#{NzAJsKJKDhU.mfdzfMjp5qK},#{NzAJsKJKDhU.T5nBUYHFjdK},#{NzAJsKJKDhU.aTc2qJNg9Ln})))*100))/2

    A{FHZRRuX1lyN} == 'HA1'

    PI2.4 HA4 Overall Data Quality Score

    Average/Event

    (((((#{vKV40XCuno0.SZ2OrnqWHRl} + #{vKV40XCuno0.RLZAabjkJuH} + #{vKV40XCuno0.LMeJ75Bjffa})/3)+(#{vKV40XCuno0.QHms8PT9aH6}) +(#{vKV40XCuno0.sOi40s2JqKB}) +(#{vKV40XCuno0.Sg6B9cSGTfO}*100) +(#{vKV40XCuno0.jJcDCaPqZwH}*100) +(#{vKV40XCuno0.CzfIL9uW9EH}*100) +#{vKV40XCuno0.jWWgAo2rkHo})/7) + ((((d2:zing(#{NzAJsKJKDhU.oBxLFCHv7lZ}))+(d2:zing(#{NzAJsKJKDhU.vb1ihS1Gqki}))+(d2:zing(#{NzAJsKJKDhU.a2gNg7bAdHP}))+(d2:zing(#{NzAJsKJKDhU.kVsZd50zVxT}))+(d2:zing(#{NzAJsKJKDhU.RHueZwfjJcq}))+(d2:zing(#{NzAJsKJKDhU.RdgEJJ99xlV}))+(d2:zing(#{NzAJsKJKDhU.tpVfAOmf1fw}))+(d2:zing(#{NzAJsKJKDhU.jVMJnEvKBed}))+(d2:zing(#{NzAJsKJKDhU.H6AQcCopXSx}))+(d2:zing(#{NzAJsKJKDhU.ChO5Q7SxRV9}))+(d2:zing(#{NzAJsKJKDhU.zumApDhgflJ}))+(d2:zing(#{NzAJsKJKDhU.IaMtr6EhTt5}))+(d2:zing(#{NzAJsKJKDhU.AGG1bjLUfaF}))+(d2:zing(#{NzAJsKJKDhU.yPrkCOwPN34}))+(d2:zing(#{NzAJsKJKDhU.mfdzfMjp5qK}))+(d2:zing(#{NzAJsKJKDhU.T5nBUYHFjdK}))+(d2:zing(#{NzAJsKJKDhU.aTc2qJNg9Ln})))/(d2:zpvc(#{NzAJsKJKDhU.oBxLFCHv7lZ},#{NzAJsKJKDhU.vb1ihS1Gqki},#{NzAJsKJKDhU.a2gNg7bAdHP},#{NzAJsKJKDhU.kVsZd50zVxT},#{NzAJsKJKDhU.RHueZwfjJcq},#{NzAJsKJKDhU.RdgEJJ99xlV},#{NzAJsKJKDhU.tpVfAOmf1fw},#{NzAJsKJKDhU.jVMJnEvKBed},#{NzAJsKJKDhU.H6AQcCopXSx},#{NzAJsKJKDhU.ChO5Q7SxRV9},#{NzAJsKJKDhU.zumApDhgflJ},#{NzAJsKJKDhU.IaMtr6EhTt5},#{NzAJsKJKDhU.AGG1bjLUfaF},#{NzAJsKJKDhU.yPrkCOwPN34},#{NzAJsKJKDhU.mfdzfMjp5qK},#{NzAJsKJKDhU.T5nBUYHFjdK},#{NzAJsKJKDhU.aTc2qJNg9Ln})))*100))/2

    A{FHZRRuX1lyN} == 'HA4'

    PI2.5 HA6 Overall Data Quality Score

    Average/Event

    (((((#{vKV40XCuno0.SZ2OrnqWHRl} + #{vKV40XCuno0.RLZAabjkJuH} + #{vKV40XCuno0.LMeJ75Bjffa})/3)+(#{vKV40XCuno0.QHms8PT9aH6}) +(#{vKV40XCuno0.sOi40s2JqKB}) +(#{vKV40XCuno0.Sg6B9cSGTfO}*100) +(#{vKV40XCuno0.jJcDCaPqZwH}*100) +(#{vKV40XCuno0.CzfIL9uW9EH}*100) +#{vKV40XCuno0.jWWgAo2rkHo})/7) + ((((d2:zing(#{NzAJsKJKDhU.oBxLFCHv7lZ}))+(d2:zing(#{NzAJsKJKDhU.vb1ihS1Gqki}))+(d2:zing(#{NzAJsKJKDhU.a2gNg7bAdHP}))+(d2:zing(#{NzAJsKJKDhU.kVsZd50zVxT}))+(d2:zing(#{NzAJsKJKDhU.RHueZwfjJcq}))+(d2:zing(#{NzAJsKJKDhU.RdgEJJ99xlV}))+(d2:zing(#{NzAJsKJKDhU.tpVfAOmf1fw}))+(d2:zing(#{NzAJsKJKDhU.jVMJnEvKBed}))+(d2:zing(#{NzAJsKJKDhU.H6AQcCopXSx}))+(d2:zing(#{NzAJsKJKDhU.ChO5Q7SxRV9}))+(d2:zing(#{NzAJsKJKDhU.zumApDhgflJ}))+(d2:zing(#{NzAJsKJKDhU.IaMtr6EhTt5}))+(d2:zing(#{NzAJsKJKDhU.AGG1bjLUfaF}))+(d2:zing(#{NzAJsKJKDhU.yPrkCOwPN34}))+(d2:zing(#{NzAJsKJKDhU.mfdzfMjp5qK}))+(d2:zing(#{NzAJsKJKDhU.T5nBUYHFjdK}))+(d2:zing(#{NzAJsKJKDhU.aTc2qJNg9Ln})))/(d2:zpvc(#{NzAJsKJKDhU.oBxLFCHv7lZ},#{NzAJsKJKDhU.vb1ihS1Gqki},#{NzAJsKJKDhU.a2gNg7bAdHP},#{NzAJsKJKDhU.kVsZd50zVxT},#{NzAJsKJKDhU.RHueZwfjJcq},#{NzAJsKJKDhU.RdgEJJ99xlV},#{NzAJsKJKDhU.tpVfAOmf1fw},#{NzAJsKJKDhU.jVMJnEvKBed},#{NzAJsKJKDhU.H6AQcCopXSx},#{NzAJsKJKDhU.ChO5Q7SxRV9},#{NzAJsKJKDhU.zumApDhgflJ},#{NzAJsKJKDhU.IaMtr6EhTt5},#{NzAJsKJKDhU.AGG1bjLUfaF},#{NzAJsKJKDhU.yPrkCOwPN34},#{NzAJsKJKDhU.mfdzfMjp5qK},#{NzAJsKJKDhU.T5nBUYHFjdK},#{NzAJsKJKDhU.aTc2qJNg9Ln})))*100))/2

    A{FHZRRuX1lyN} == 'HA6'

    PI2.6 HA7 Overall Data Quality Score

    Average/Event

    (((((#{vKV40XCuno0.SZ2OrnqWHRl} + #{vKV40XCuno0.RLZAabjkJuH} + #{vKV40XCuno0.LMeJ75Bjffa})/3)+(#{vKV40XCuno0.QHms8PT9aH6}) +(#{vKV40XCuno0.sOi40s2JqKB}) +(#{vKV40XCuno0.Sg6B9cSGTfO}*100) +(#{vKV40XCuno0.jJcDCaPqZwH}*100) +(#{vKV40XCuno0.CzfIL9uW9EH}*100) +#{vKV40XCuno0.jWWgAo2rkHo})/7) + ((((d2:zing(#{NzAJsKJKDhU.oBxLFCHv7lZ}))+(d2:zing(#{NzAJsKJKDhU.vb1ihS1Gqki}))+(d2:zing(#{NzAJsKJKDhU.a2gNg7bAdHP}))+(d2:zing(#{NzAJsKJKDhU.kVsZd50zVxT}))+(d2:zing(#{NzAJsKJKDhU.RHueZwfjJcq}))+(d2:zing(#{NzAJsKJKDhU.RdgEJJ99xlV}))+(d2:zing(#{NzAJsKJKDhU.tpVfAOmf1fw}))+(d2:zing(#{NzAJsKJKDhU.jVMJnEvKBed}))+(d2:zing(#{NzAJsKJKDhU.H6AQcCopXSx}))+(d2:zing(#{NzAJsKJKDhU.ChO5Q7SxRV9}))+(d2:zing(#{NzAJsKJKDhU.zumApDhgflJ}))+(d2:zing(#{NzAJsKJKDhU.IaMtr6EhTt5}))+(d2:zing(#{NzAJsKJKDhU.AGG1bjLUfaF}))+(d2:zing(#{NzAJsKJKDhU.yPrkCOwPN34}))+(d2:zing(#{NzAJsKJKDhU.mfdzfMjp5qK}))+(d2:zing(#{NzAJsKJKDhU.T5nBUYHFjdK}))+(d2:zing(#{NzAJsKJKDhU.aTc2qJNg9Ln})))/(d2:zpvc(#{NzAJsKJKDhU.oBxLFCHv7lZ},#{NzAJsKJKDhU.vb1ihS1Gqki},#{NzAJsKJKDhU.a2gNg7bAdHP},#{NzAJsKJKDhU.kVsZd50zVxT},#{NzAJsKJKDhU.RHueZwfjJcq},#{NzAJsKJKDhU.RdgEJJ99xlV},#{NzAJsKJKDhU.tpVfAOmf1fw},#{NzAJsKJKDhU.jVMJnEvKBed},#{NzAJsKJKDhU.H6AQcCopXSx},#{NzAJsKJKDhU.ChO5Q7SxRV9},#{NzAJsKJKDhU.zumApDhgflJ},#{NzAJsKJKDhU.IaMtr6EhTt5},#{NzAJsKJKDhU.AGG1bjLUfaF},#{NzAJsKJKDhU.yPrkCOwPN34},#{NzAJsKJKDhU.mfdzfMjp5qK},#{NzAJsKJKDhU.T5nBUYHFjdK},#{NzAJsKJKDhU.aTc2qJNg9Ln})))*100))/2

    A{FHZRRuX1lyN} == 'HA7'

    PI2.7 HA3 Overall Data Quality Score

    Average/Event

    (((((#{vKV40XCuno0.SZ2OrnqWHRl} + #{vKV40XCuno0.RLZAabjkJuH} + #{vKV40XCuno0.LMeJ75Bjffa})/3)+(#{vKV40XCuno0.QHms8PT9aH6}) +(#{vKV40XCuno0.sOi40s2JqKB}) +(#{vKV40XCuno0.Sg6B9cSGTfO}*100) +(#{vKV40XCuno0.jJcDCaPqZwH}*100) +(#{vKV40XCuno0.CzfIL9uW9EH}*100) +#{vKV40XCuno0.jWWgAo2rkHo})/7) + ((((d2:zing(#{NzAJsKJKDhU.oBxLFCHv7lZ}))+(d2:zing(#{NzAJsKJKDhU.vb1ihS1Gqki}))+(d2:zing(#{NzAJsKJKDhU.a2gNg7bAdHP}))+(d2:zing(#{NzAJsKJKDhU.kVsZd50zVxT}))+(d2:zing(#{NzAJsKJKDhU.RHueZwfjJcq}))+(d2:zing(#{NzAJsKJKDhU.RdgEJJ99xlV}))+(d2:zing(#{NzAJsKJKDhU.tpVfAOmf1fw}))+(d2:zing(#{NzAJsKJKDhU.jVMJnEvKBed}))+(d2:zing(#{NzAJsKJKDhU.H6AQcCopXSx}))+(d2:zing(#{NzAJsKJKDhU.ChO5Q7SxRV9}))+(d2:zing(#{NzAJsKJKDhU.zumApDhgflJ}))+(d2:zing(#{NzAJsKJKDhU.IaMtr6EhTt5}))+(d2:zing(#{NzAJsKJKDhU.AGG1bjLUfaF}))+(d2:zing(#{NzAJsKJKDhU.yPrkCOwPN34}))+(d2:zing(#{NzAJsKJKDhU.mfdzfMjp5qK}))+(d2:zing(#{NzAJsKJKDhU.T5nBUYHFjdK}))+(d2:zing(#{NzAJsKJKDhU.aTc2qJNg9Ln})))/(d2:zpvc(#{NzAJsKJKDhU.oBxLFCHv7lZ},#{NzAJsKJKDhU.vb1ihS1Gqki},#{NzAJsKJKDhU.a2gNg7bAdHP},#{NzAJsKJKDhU.kVsZd50zVxT},#{NzAJsKJKDhU.RHueZwfjJcq},#{NzAJsKJKDhU.RdgEJJ99xlV},#{NzAJsKJKDhU.tpVfAOmf1fw},#{NzAJsKJKDhU.jVMJnEvKBed},#{NzAJsKJKDhU.H6AQcCopXSx},#{NzAJsKJKDhU.ChO5Q7SxRV9},#{NzAJsKJKDhU.zumApDhgflJ},#{NzAJsKJKDhU.IaMtr6EhTt5},#{NzAJsKJKDhU.AGG1bjLUfaF},#{NzAJsKJKDhU.yPrkCOwPN34},#{NzAJsKJKDhU.mfdzfMjp5qK},#{NzAJsKJKDhU.T5nBUYHFjdK},#{NzAJsKJKDhU.aTc2qJNg9Ln})))*100))/2

    A{FHZRRuX1lyN} == 'HA3'

    PI2.8 HA5 Overall Data Quality Score

    Average/Event

    (((((#{vKV40XCuno0.SZ2OrnqWHRl} + #{vKV40XCuno0.RLZAabjkJuH} + #{vKV40XCuno0.LMeJ75Bjffa})/3)+(#{vKV40XCuno0.QHms8PT9aH6}) +(#{vKV40XCuno0.sOi40s2JqKB}) +(#{vKV40XCuno0.Sg6B9cSGTfO}*100) +(#{vKV40XCuno0.jJcDCaPqZwH}*100) +(#{vKV40XCuno0.CzfIL9uW9EH}*100) +#{vKV40XCuno0.jWWgAo2rkHo})/7) + ((((d2:zing(#{NzAJsKJKDhU.oBxLFCHv7lZ}))+(d2:zing(#{NzAJsKJKDhU.vb1ihS1Gqki}))+(d2:zing(#{NzAJsKJKDhU.a2gNg7bAdHP}))+(d2:zing(#{NzAJsKJKDhU.kVsZd50zVxT}))+(d2:zing(#{NzAJsKJKDhU.RHueZwfjJcq}))+(d2:zing(#{NzAJsKJKDhU.RdgEJJ99xlV}))+(d2:zing(#{NzAJsKJKDhU.tpVfAOmf1fw}))+(d2:zing(#{NzAJsKJKDhU.jVMJnEvKBed}))+(d2:zing(#{NzAJsKJKDhU.H6AQcCopXSx}))+(d2:zing(#{NzAJsKJKDhU.ChO5Q7SxRV9}))+(d2:zing(#{NzAJsKJKDhU.zumApDhgflJ}))+(d2:zing(#{NzAJsKJKDhU.IaMtr6EhTt5}))+(d2:zing(#{NzAJsKJKDhU.AGG1bjLUfaF}))+(d2:zing(#{NzAJsKJKDhU.yPrkCOwPN34}))+(d2:zing(#{NzAJsKJKDhU.mfdzfMjp5qK}))+(d2:zing(#{NzAJsKJKDhU.T5nBUYHFjdK}))+(d2:zing(#{NzAJsKJKDhU.aTc2qJNg9Ln})))/(d2:zpvc(#{NzAJsKJKDhU.oBxLFCHv7lZ},#{NzAJsKJKDhU.vb1ihS1Gqki},#{NzAJsKJKDhU.a2gNg7bAdHP},#{NzAJsKJKDhU.kVsZd50zVxT},#{NzAJsKJKDhU.RHueZwfjJcq},#{NzAJsKJKDhU.RdgEJJ99xlV},#{NzAJsKJKDhU.tpVfAOmf1fw},#{NzAJsKJKDhU.jVMJnEvKBed},#{NzAJsKJKDhU.H6AQcCopXSx},#{NzAJsKJKDhU.ChO5Q7SxRV9},#{NzAJsKJKDhU.zumApDhgflJ},#{NzAJsKJKDhU.IaMtr6EhTt5},#{NzAJsKJKDhU.AGG1bjLUfaF},#{NzAJsKJKDhU.yPrkCOwPN34},#{NzAJsKJKDhU.mfdzfMjp5qK},#{NzAJsKJKDhU.T5nBUYHFjdK},#{NzAJsKJKDhU.aTc2qJNg9Ln})))*100))/2

    A{FHZRRuX1lyN} == 'HA5'

    PI3.1 HA2 System Assessment Score

    Average/Event

    (((d2:zing(#{NzAJsKJKDhU.oBxLFCHv7lZ}))+(d2:zing(#{NzAJsKJKDhU.vb1ihS1Gqki}))+(d2:zing(#{NzAJsKJKDhU.a2gNg7bAdHP}))+(d2:zing(#{NzAJsKJKDhU.kVsZd50zVxT}))+(d2:zing(#{NzAJsKJKDhU.RHueZwfjJcq}))+(d2:zing(#{NzAJsKJKDhU.RdgEJJ99xlV}))+(d2:zing(#{NzAJsKJKDhU.tpVfAOmf1fw}))+(d2:zing(#{NzAJsKJKDhU.jVMJnEvKBed}))+(d2:zing(#{NzAJsKJKDhU.H6AQcCopXSx}))+(d2:zing(#{NzAJsKJKDhU.ChO5Q7SxRV9}))+(d2:zing(#{NzAJsKJKDhU.zumApDhgflJ}))+(d2:zing(#{NzAJsKJKDhU.IaMtr6EhTt5}))+(d2:zing(#{NzAJsKJKDhU.AGG1bjLUfaF}))+(d2:zing(#{NzAJsKJKDhU.yPrkCOwPN34}))+(d2:zing(#{NzAJsKJKDhU.mfdzfMjp5qK}))+(d2:zing(#{NzAJsKJKDhU.T5nBUYHFjdK}))+(d2:zing(#{NzAJsKJKDhU.aTc2qJNg9Ln})))/(d2:zpvc(#{NzAJsKJKDhU.oBxLFCHv7lZ},#{NzAJsKJKDhU.vb1ihS1Gqki},#{NzAJsKJKDhU.a2gNg7bAdHP},#{NzAJsKJKDhU.kVsZd50zVxT},#{NzAJsKJKDhU.RHueZwfjJcq},#{NzAJsKJKDhU.RdgEJJ99xlV},#{NzAJsKJKDhU.tpVfAOmf1fw},#{NzAJsKJKDhU.jVMJnEvKBed},#{NzAJsKJKDhU.H6AQcCopXSx},#{NzAJsKJKDhU.ChO5Q7SxRV9},#{NzAJsKJKDhU.zumApDhgflJ},#{NzAJsKJKDhU.IaMtr6EhTt5},#{NzAJsKJKDhU.AGG1bjLUfaF},#{NzAJsKJKDhU.yPrkCOwPN34},#{NzAJsKJKDhU.mfdzfMjp5qK},#{NzAJsKJKDhU.T5nBUYHFjdK},#{NzAJsKJKDhU.aTc2qJNg9Ln})))*100

    A{FHZRRuX1lyN} == 'HA2'

    PI3.2 HA8 System Assessment Score

    Average/Event

    (((d2:zing(#{NzAJsKJKDhU.oBxLFCHv7lZ}))+(d2:zing(#{NzAJsKJKDhU.vb1ihS1Gqki}))+(d2:zing(#{NzAJsKJKDhU.a2gNg7bAdHP}))+(d2:zing(#{NzAJsKJKDhU.kVsZd50zVxT}))+(d2:zing(#{NzAJsKJKDhU.RHueZwfjJcq}))+(d2:zing(#{NzAJsKJKDhU.RdgEJJ99xlV}))+(d2:zing(#{NzAJsKJKDhU.tpVfAOmf1fw}))+(d2:zing(#{NzAJsKJKDhU.jVMJnEvKBed}))+(d2:zing(#{NzAJsKJKDhU.H6AQcCopXSx}))+(d2:zing(#{NzAJsKJKDhU.ChO5Q7SxRV9}))+(d2:zing(#{NzAJsKJKDhU.zumApDhgflJ}))+(d2:zing(#{NzAJsKJKDhU.IaMtr6EhTt5}))+(d2:zing(#{NzAJsKJKDhU.AGG1bjLUfaF}))+(d2:zing(#{NzAJsKJKDhU.yPrkCOwPN34}))+(d2:zing(#{NzAJsKJKDhU.mfdzfMjp5qK}))+(d2:zing(#{NzAJsKJKDhU.T5nBUYHFjdK}))+(d2:zing(#{NzAJsKJKDhU.aTc2qJNg9Ln})))/(d2:zpvc(#{NzAJsKJKDhU.oBxLFCHv7lZ},#{NzAJsKJKDhU.vb1ihS1Gqki},#{NzAJsKJKDhU.a2gNg7bAdHP},#{NzAJsKJKDhU.kVsZd50zVxT},#{NzAJsKJKDhU.RHueZwfjJcq},#{NzAJsKJKDhU.RdgEJJ99xlV},#{NzAJsKJKDhU.tpVfAOmf1fw},#{NzAJsKJKDhU.jVMJnEvKBed},#{NzAJsKJKDhU.H6AQcCopXSx},#{NzAJsKJKDhU.ChO5Q7SxRV9},#{NzAJsKJKDhU.zumApDhgflJ},#{NzAJsKJKDhU.IaMtr6EhTt5},#{NzAJsKJKDhU.AGG1bjLUfaF},#{NzAJsKJKDhU.yPrkCOwPN34},#{NzAJsKJKDhU.mfdzfMjp5qK},#{NzAJsKJKDhU.T5nBUYHFjdK},#{NzAJsKJKDhU.aTc2qJNg9Ln})))*100

    A{FHZRRuX1lyN} == 'HA8'

    PI3.3 HA1 System Assessment Score

    Average/Event

    (((d2:zing(#{NzAJsKJKDhU.oBxLFCHv7lZ}))+(d2:zing(#{NzAJsKJKDhU.vb1ihS1Gqki}))+(d2:zing(#{NzAJsKJKDhU.a2gNg7bAdHP}))+(d2:zing(#{NzAJsKJKDhU.kVsZd50zVxT}))+(d2:zing(#{NzAJsKJKDhU.RHueZwfjJcq}))+(d2:zing(#{NzAJsKJKDhU.RdgEJJ99xlV}))+(d2:zing(#{NzAJsKJKDhU.tpVfAOmf1fw}))+(d2:zing(#{NzAJsKJKDhU.jVMJnEvKBed}))+(d2:zing(#{NzAJsKJKDhU.H6AQcCopXSx}))+(d2:zing(#{NzAJsKJKDhU.ChO5Q7SxRV9}))+(d2:zing(#{NzAJsKJKDhU.zumApDhgflJ}))+(d2:zing(#{NzAJsKJKDhU.IaMtr6EhTt5}))+(d2:zing(#{NzAJsKJKDhU.AGG1bjLUfaF}))+(d2:zing(#{NzAJsKJKDhU.yPrkCOwPN34}))+(d2:zing(#{NzAJsKJKDhU.mfdzfMjp5qK}))+(d2:zing(#{NzAJsKJKDhU.T5nBUYHFjdK}))+(d2:zing(#{NzAJsKJKDhU.aTc2qJNg9Ln})))/(d2:zpvc(#{NzAJsKJKDhU.oBxLFCHv7lZ},#{NzAJsKJKDhU.vb1ihS1Gqki},#{NzAJsKJKDhU.a2gNg7bAdHP},#{NzAJsKJKDhU.kVsZd50zVxT},#{NzAJsKJKDhU.RHueZwfjJcq},#{NzAJsKJKDhU.RdgEJJ99xlV},#{NzAJsKJKDhU.tpVfAOmf1fw},#{NzAJsKJKDhU.jVMJnEvKBed},#{NzAJsKJKDhU.H6AQcCopXSx},#{NzAJsKJKDhU.ChO5Q7SxRV9},#{NzAJsKJKDhU.zumApDhgflJ},#{NzAJsKJKDhU.IaMtr6EhTt5},#{NzAJsKJKDhU.AGG1bjLUfaF},#{NzAJsKJKDhU.yPrkCOwPN34},#{NzAJsKJKDhU.mfdzfMjp5qK},#{NzAJsKJKDhU.T5nBUYHFjdK},#{NzAJsKJKDhU.aTc2qJNg9Ln})))*100

    A{FHZRRuX1lyN} == 'HA1'

    PI3.4 HA4 System Assessment Score

    Average/Event

    (((d2:zing(#{NzAJsKJKDhU.oBxLFCHv7lZ}))+(d2:zing(#{NzAJsKJKDhU.vb1ihS1Gqki}))+(d2:zing(#{NzAJsKJKDhU.a2gNg7bAdHP}))+(d2:zing(#{NzAJsKJKDhU.kVsZd50zVxT}))+(d2:zing(#{NzAJsKJKDhU.RHueZwfjJcq}))+(d2:zing(#{NzAJsKJKDhU.RdgEJJ99xlV}))+(d2:zing(#{NzAJsKJKDhU.tpVfAOmf1fw}))+(d2:zing(#{NzAJsKJKDhU.jVMJnEvKBed}))+(d2:zing(#{NzAJsKJKDhU.H6AQcCopXSx}))+(d2:zing(#{NzAJsKJKDhU.ChO5Q7SxRV9}))+(d2:zing(#{NzAJsKJKDhU.zumApDhgflJ}))+(d2:zing(#{NzAJsKJKDhU.IaMtr6EhTt5}))+(d2:zing(#{NzAJsKJKDhU.AGG1bjLUfaF}))+(d2:zing(#{NzAJsKJKDhU.yPrkCOwPN34}))+(d2:zing(#{NzAJsKJKDhU.mfdzfMjp5qK}))+(d2:zing(#{NzAJsKJKDhU.T5nBUYHFjdK}))+(d2:zing(#{NzAJsKJKDhU.aTc2qJNg9Ln})))/(d2:zpvc(#{NzAJsKJKDhU.oBxLFCHv7lZ},#{NzAJsKJKDhU.vb1ihS1Gqki},#{NzAJsKJKDhU.a2gNg7bAdHP},#{NzAJsKJKDhU.kVsZd50zVxT},#{NzAJsKJKDhU.RHueZwfjJcq},#{NzAJsKJKDhU.RdgEJJ99xlV},#{NzAJsKJKDhU.tpVfAOmf1fw},#{NzAJsKJKDhU.jVMJnEvKBed},#{NzAJsKJKDhU.H6AQcCopXSx},#{NzAJsKJKDhU.ChO5Q7SxRV9},#{NzAJsKJKDhU.zumApDhgflJ},#{NzAJsKJKDhU.IaMtr6EhTt5},#{NzAJsKJKDhU.AGG1bjLUfaF},#{NzAJsKJKDhU.yPrkCOwPN34},#{NzAJsKJKDhU.mfdzfMjp5qK},#{NzAJsKJKDhU.T5nBUYHFjdK},#{NzAJsKJKDhU.aTc2qJNg9Ln})))*100

    A{FHZRRuX1lyN} == 'HA4'

    PI3.5 HA6 System Assessment Score

    Average/Event

    (((d2:zing(#{NzAJsKJKDhU.oBxLFCHv7lZ}))+(d2:zing(#{NzAJsKJKDhU.vb1ihS1Gqki}))+(d2:zing(#{NzAJsKJKDhU.a2gNg7bAdHP}))+(d2:zing(#{NzAJsKJKDhU.kVsZd50zVxT}))+(d2:zing(#{NzAJsKJKDhU.RHueZwfjJcq}))+(d2:zing(#{NzAJsKJKDhU.RdgEJJ99xlV}))+(d2:zing(#{NzAJsKJKDhU.tpVfAOmf1fw}))+(d2:zing(#{NzAJsKJKDhU.jVMJnEvKBed}))+(d2:zing(#{NzAJsKJKDhU.H6AQcCopXSx}))+(d2:zing(#{NzAJsKJKDhU.ChO5Q7SxRV9}))+(d2:zing(#{NzAJsKJKDhU.zumApDhgflJ}))+(d2:zing(#{NzAJsKJKDhU.IaMtr6EhTt5}))+(d2:zing(#{NzAJsKJKDhU.AGG1bjLUfaF}))+(d2:zing(#{NzAJsKJKDhU.yPrkCOwPN34}))+(d2:zing(#{NzAJsKJKDhU.mfdzfMjp5qK}))+(d2:zing(#{NzAJsKJKDhU.T5nBUYHFjdK}))+(d2:zing(#{NzAJsKJKDhU.aTc2qJNg9Ln})))/(d2:zpvc(#{NzAJsKJKDhU.oBxLFCHv7lZ},#{NzAJsKJKDhU.vb1ihS1Gqki},#{NzAJsKJKDhU.a2gNg7bAdHP},#{NzAJsKJKDhU.kVsZd50zVxT},#{NzAJsKJKDhU.RHueZwfjJcq},#{NzAJsKJKDhU.RdgEJJ99xlV},#{NzAJsKJKDhU.tpVfAOmf1fw},#{NzAJsKJKDhU.jVMJnEvKBed},#{NzAJsKJKDhU.H6AQcCopXSx},#{NzAJsKJKDhU.ChO5Q7SxRV9},#{NzAJsKJKDhU.zumApDhgflJ},#{NzAJsKJKDhU.IaMtr6EhTt5},#{NzAJsKJKDhU.AGG1bjLUfaF},#{NzAJsKJKDhU.yPrkCOwPN34},#{NzAJsKJKDhU.mfdzfMjp5qK},#{NzAJsKJKDhU.T5nBUYHFjdK},#{NzAJsKJKDhU.aTc2qJNg9Ln})))*100

    A{FHZRRuX1lyN} == 'HA6'

    PI3.6 HA7 System Assessment Score

    Average/Event

    (((d2:zing(#{NzAJsKJKDhU.oBxLFCHv7lZ}))+(d2:zing(#{NzAJsKJKDhU.vb1ihS1Gqki}))+(d2:zing(#{NzAJsKJKDhU.a2gNg7bAdHP}))+(d2:zing(#{NzAJsKJKDhU.kVsZd50zVxT}))+(d2:zing(#{NzAJsKJKDhU.RHueZwfjJcq}))+(d2:zing(#{NzAJsKJKDhU.RdgEJJ99xlV}))+(d2:zing(#{NzAJsKJKDhU.tpVfAOmf1fw}))+(d2:zing(#{NzAJsKJKDhU.jVMJnEvKBed}))+(d2:zing(#{NzAJsKJKDhU.H6AQcCopXSx}))+(d2:zing(#{NzAJsKJKDhU.ChO5Q7SxRV9}))+(d2:zing(#{NzAJsKJKDhU.zumApDhgflJ}))+(d2:zing(#{NzAJsKJKDhU.IaMtr6EhTt5}))+(d2:zing(#{NzAJsKJKDhU.AGG1bjLUfaF}))+(d2:zing(#{NzAJsKJKDhU.yPrkCOwPN34}))+(d2:zing(#{NzAJsKJKDhU.mfdzfMjp5qK}))+(d2:zing(#{NzAJsKJKDhU.T5nBUYHFjdK}))+(d2:zing(#{NzAJsKJKDhU.aTc2qJNg9Ln})))/(d2:zpvc(#{NzAJsKJKDhU.oBxLFCHv7lZ},#{NzAJsKJKDhU.vb1ihS1Gqki},#{NzAJsKJKDhU.a2gNg7bAdHP},#{NzAJsKJKDhU.kVsZd50zVxT},#{NzAJsKJKDhU.RHueZwfjJcq},#{NzAJsKJKDhU.RdgEJJ99xlV},#{NzAJsKJKDhU.tpVfAOmf1fw},#{NzAJsKJKDhU.jVMJnEvKBed},#{NzAJsKJKDhU.H6AQcCopXSx},#{NzAJsKJKDhU.ChO5Q7SxRV9},#{NzAJsKJKDhU.zumApDhgflJ},#{NzAJsKJKDhU.IaMtr6EhTt5},#{NzAJsKJKDhU.AGG1bjLUfaF},#{NzAJsKJKDhU.yPrkCOwPN34},#{NzAJsKJKDhU.mfdzfMjp5qK},#{NzAJsKJKDhU.T5nBUYHFjdK},#{NzAJsKJKDhU.aTc2qJNg9Ln})))*100

    A{FHZRRuX1lyN} == 'HA7'

    PI3.7 HA3 System Assessment Score

    Average/Event

    (((d2:zing(#{NzAJsKJKDhU.oBxLFCHv7lZ}))+(d2:zing(#{NzAJsKJKDhU.vb1ihS1Gqki}))+(d2:zing(#{NzAJsKJKDhU.a2gNg7bAdHP}))+(d2:zing(#{NzAJsKJKDhU.kVsZd50zVxT}))+(d2:zing(#{NzAJsKJKDhU.RHueZwfjJcq}))+(d2:zing(#{NzAJsKJKDhU.RdgEJJ99xlV}))+(d2:zing(#{NzAJsKJKDhU.tpVfAOmf1fw}))+(d2:zing(#{NzAJsKJKDhU.jVMJnEvKBed}))+(d2:zing(#{NzAJsKJKDhU.H6AQcCopXSx}))+(d2:zing(#{NzAJsKJKDhU.ChO5Q7SxRV9}))+(d2:zing(#{NzAJsKJKDhU.zumApDhgflJ}))+(d2:zing(#{NzAJsKJKDhU.IaMtr6EhTt5}))+(d2:zing(#{NzAJsKJKDhU.AGG1bjLUfaF}))+(d2:zing(#{NzAJsKJKDhU.yPrkCOwPN34}))+(d2:zing(#{NzAJsKJKDhU.mfdzfMjp5qK}))+(d2:zing(#{NzAJsKJKDhU.T5nBUYHFjdK}))+(d2:zing(#{NzAJsKJKDhU.aTc2qJNg9Ln})))/(d2:zpvc(#{NzAJsKJKDhU.oBxLFCHv7lZ},#{NzAJsKJKDhU.vb1ihS1Gqki},#{NzAJsKJKDhU.a2gNg7bAdHP},#{NzAJsKJKDhU.kVsZd50zVxT},#{NzAJsKJKDhU.RHueZwfjJcq},#{NzAJsKJKDhU.RdgEJJ99xlV},#{NzAJsKJKDhU.tpVfAOmf1fw},#{NzAJsKJKDhU.jVMJnEvKBed},#{NzAJsKJKDhU.H6AQcCopXSx},#{NzAJsKJKDhU.ChO5Q7SxRV9},#{NzAJsKJKDhU.zumApDhgflJ},#{NzAJsKJKDhU.IaMtr6EhTt5},#{NzAJsKJKDhU.AGG1bjLUfaF},#{NzAJsKJKDhU.yPrkCOwPN34},#{NzAJsKJKDhU.mfdzfMjp5qK},#{NzAJsKJKDhU.T5nBUYHFjdK},#{NzAJsKJKDhU.aTc2qJNg9Ln})))*100

    A{FHZRRuX1lyN} == 'HA3'

    PI3.8 HA5 System Assessment Score

    Average/Event

    (((d2:zing(#{NzAJsKJKDhU.oBxLFCHv7lZ}))+(d2:zing(#{NzAJsKJKDhU.vb1ihS1Gqki}))+(d2:zing(#{NzAJsKJKDhU.a2gNg7bAdHP}))+(d2:zing(#{NzAJsKJKDhU.kVsZd50zVxT}))+(d2:zing(#{NzAJsKJKDhU.RHueZwfjJcq}))+(d2:zing(#{NzAJsKJKDhU.RdgEJJ99xlV}))+(d2:zing(#{NzAJsKJKDhU.tpVfAOmf1fw}))+(d2:zing(#{NzAJsKJKDhU.jVMJnEvKBed}))+(d2:zing(#{NzAJsKJKDhU.H6AQcCopXSx}))+(d2:zing(#{NzAJsKJKDhU.ChO5Q7SxRV9}))+(d2:zing(#{NzAJsKJKDhU.zumApDhgflJ}))+(d2:zing(#{NzAJsKJKDhU.IaMtr6EhTt5}))+(d2:zing(#{NzAJsKJKDhU.AGG1bjLUfaF}))+(d2:zing(#{NzAJsKJKDhU.yPrkCOwPN34}))+(d2:zing(#{NzAJsKJKDhU.mfdzfMjp5qK}))+(d2:zing(#{NzAJsKJKDhU.T5nBUYHFjdK}))+(d2:zing(#{NzAJsKJKDhU.aTc2qJNg9Ln})))/(d2:zpvc(#{NzAJsKJKDhU.oBxLFCHv7lZ},#{NzAJsKJKDhU.vb1ihS1Gqki},#{NzAJsKJKDhU.a2gNg7bAdHP},#{NzAJsKJKDhU.kVsZd50zVxT},#{NzAJsKJKDhU.RHueZwfjJcq},#{NzAJsKJKDhU.RdgEJJ99xlV},#{NzAJsKJKDhU.tpVfAOmf1fw},#{NzAJsKJKDhU.jVMJnEvKBed},#{NzAJsKJKDhU.H6AQcCopXSx},#{NzAJsKJKDhU.ChO5Q7SxRV9},#{NzAJsKJKDhU.zumApDhgflJ},#{NzAJsKJKDhU.IaMtr6EhTt5},#{NzAJsKJKDhU.AGG1bjLUfaF},#{NzAJsKJKDhU.yPrkCOwPN34},#{NzAJsKJKDhU.mfdzfMjp5qK},#{NzAJsKJKDhU.T5nBUYHFjdK},#{NzAJsKJKDhU.aTc2qJNg9Ln})))*100

    A{FHZRRuX1lyN} == 'HA7'

    PI4.1 HA2 Overall Data Verification Score

    Average/Event

    (((#{vKV40XCuno0.SZ2OrnqWHRl} + #{vKV40XCuno0.RLZAabjkJuH}
    + #{vKV40XCuno0.LMeJ75Bjffa})/3)+(#{vKV40XCuno0.QHms8PT9aH6})
    +(#{vKV40XCuno0.sOi40s2JqKB}) +(#{vKV40XCuno0.Sg6B9cSGTfO}*100)
    +(#{vKV40XCuno0.jJcDCaPqZwH}*100) +(#{vKV40XCuno0.CzfIL9uW9EH}*100)
    +#{vKV40XCuno0.jWWgAo2rkHo})/7

    A{FHZRRuX1lyN} == 'HA2'

    PI4.2 HA8 Overall Data Verification Score

    Average/Event

    (((#{vKV40XCuno0.SZ2OrnqWHRl} + #{vKV40XCuno0.RLZAabjkJuH}
    + #{vKV40XCuno0.LMeJ75Bjffa})/3)+(#{vKV40XCuno0.QHms8PT9aH6})
    +(#{vKV40XCuno0.sOi40s2JqKB}) +(#{vKV40XCuno0.Sg6B9cSGTfO}*100)
    +(#{vKV40XCuno0.jJcDCaPqZwH}*100) +(#{vKV40XCuno0.CzfIL9uW9EH}*100)
    +#{vKV40XCuno0.jWWgAo2rkHo})/7

    A{FHZRRuX1lyN} == 'HA8'

    PI4.3 HA1 Overall Data Verification Score

    Average/Event

    (((#{vKV40XCuno0.SZ2OrnqWHRl} + #{vKV40XCuno0.RLZAabjkJuH}
    + #{vKV40XCuno0.LMeJ75Bjffa})/3)+(#{vKV40XCuno0.QHms8PT9aH6})
    +(#{vKV40XCuno0.sOi40s2JqKB}) +(#{vKV40XCuno0.Sg6B9cSGTfO}*100)
    +(#{vKV40XCuno0.jJcDCaPqZwH}*100) +(#{vKV40XCuno0.CzfIL9uW9EH}*100)
    +#{vKV40XCuno0.jWWgAo2rkHo})/7

    A{FHZRRuX1lyN} == 'HA1'

    PI4.4 HA4 Overall Data Verification Score

    Average/Event

    (((#{vKV40XCuno0.SZ2OrnqWHRl} + #{vKV40XCuno0.RLZAabjkJuH}
    + #{vKV40XCuno0.LMeJ75Bjffa})/3)+(#{vKV40XCuno0.QHms8PT9aH6})
    +(#{vKV40XCuno0.sOi40s2JqKB}) +(#{vKV40XCuno0.Sg6B9cSGTfO}*100)
    +(#{vKV40XCuno0.jJcDCaPqZwH}*100) +(#{vKV40XCuno0.CzfIL9uW9EH}*100)
    +#{vKV40XCuno0.jWWgAo2rkHo})/7

    A{FHZRRuX1lyN} == 'HA4'

    PI4.5 HA6 Overall Data Verification Score

    Average/Event

    (((#{vKV40XCuno0.SZ2OrnqWHRl} + #{vKV40XCuno0.RLZAabjkJuH}
    + #{vKV40XCuno0.LMeJ75Bjffa})/3)+(#{vKV40XCuno0.QHms8PT9aH6})
    +(#{vKV40XCuno0.sOi40s2JqKB}) +(#{vKV40XCuno0.Sg6B9cSGTfO}*100)
    +(#{vKV40XCuno0.jJcDCaPqZwH}*100) +(#{vKV40XCuno0.CzfIL9uW9EH}*100)
    +#{vKV40XCuno0.jWWgAo2rkHo})/7

    A{FHZRRuX1lyN} == 'HA6'

    PI4.6 HA7 Overall Data Verification Score

    Average/Event

    (((#{vKV40XCuno0.SZ2OrnqWHRl} + #{vKV40XCuno0.RLZAabjkJuH}
    + #{vKV40XCuno0.LMeJ75Bjffa})/3)+(#{vKV40XCuno0.QHms8PT9aH6})
    +(#{vKV40XCuno0.sOi40s2JqKB}) +(#{vKV40XCuno0.Sg6B9cSGTfO}*100)
    +(#{vKV40XCuno0.jJcDCaPqZwH}*100) +(#{vKV40XCuno0.CzfIL9uW9EH}*100)
    +#{vKV40XCuno0.jWWgAo2rkHo})/7

    A{FHZRRuX1lyN} == 'HA7'

    PI4.7 HA3 Overall Data Verification Score

    Average/Event

    (((#{vKV40XCuno0.SZ2OrnqWHRl} + #{vKV40XCuno0.RLZAabjkJuH}
    + #{vKV40XCuno0.LMeJ75Bjffa})/3)+(#{vKV40XCuno0.QHms8PT9aH6})
    +(#{vKV40XCuno0.sOi40s2JqKB}) +(#{vKV40XCuno0.Sg6B9cSGTfO}*100)
    +(#{vKV40XCuno0.jJcDCaPqZwH}*100) +(#{vKV40XCuno0.CzfIL9uW9EH}*100)
    +#{vKV40XCuno0.jWWgAo2rkHo})/7

    A{FHZRRuX1lyN} == 'HA3'

    PI4.8 HA5 Overall Data Verification Score

    Average/Event

    (((#{vKV40XCuno0.SZ2OrnqWHRl} + #{vKV40XCuno0.RLZAabjkJuH}
    + #{vKV40XCuno0.LMeJ75Bjffa})/3)+(#{vKV40XCuno0.QHms8PT9aH6})
    +(#{vKV40XCuno0.sOi40s2JqKB}) +(#{vKV40XCuno0.Sg6B9cSGTfO}*100)
    +(#{vKV40XCuno0.jJcDCaPqZwH}*100) +(#{vKV40XCuno0.CzfIL9uW9EH}*100)
    +#{vKV40XCuno0.jWWgAo2rkHo})/7

    A{FHZRRuX1lyN} == 'HA5'

    Indicators

    In DHIS2, data analysis revolves around the fundamental concept of indicators. Indicators serve as calculated formulas that rely on a combination of data elements, category options, constants, and a factor. They come in two forms: those with a denominator and those without. Indicators without denominators are typically calculated totals comprising multiple data elements. On the other hand, coverage indicators such as ratios and percentages consist of two formulas: one for the numerator and another for the denominator.

    Indicator

    Indicator type

    Numerator

    Denominator

    Indicator

    Indicator type

    Numerator

    Denominator

    1. Overall Data Quality Score

    1 - Atomic (number)

    I{pG8suQU4II7} + I{sPU0rBR7um9}

    2

     

     

    Dashboards

    This section includes pivot tables that you need to create your own dashboard. To perform these dashboards we created new organisation units intended to work as examples, for real projects, please use your own organisation units.

    RDQA Dashboard

    Within this RDQA Dashboard section, you will find a quick overview of the number of assessments performed during a time period, disaggregated by location, health area, projects and donors. The following pivot tables were constructed using the Events Reports App and The Data Visualizer App within DHIS2. We will indicate which one was used.

    Also, it is worth to mention that the time periods are modified depending on the period the data was acquired, on this technical manual, we have included randomized data during the periods of June and July of 2021. Also, organisation units were created along the way to serve as examples, please consider using your own organisation units to ensure data appears within DHIS2 accordingly.

    RDQA - Number of assessment conducted per country

    • This is perfomed through the events reports app.

    • Table style: Pivot table

    • Output type: Event

    Table layout:

    Reporter filter

    Column dimensions

    Row dimensions

    Value

    Reporter filter

    Column dimensions

    Row dimensions

    Value

    None

    Periods

    Organisation units

    Aggregation: Number of events
    Time field: Event date
    Org unit field: Event org unit

    Results:

    RDQA - Number of assessment conducted per health area

    • This is perfomed throught the events reports app.

    • Table style: Pivot table

    • Output type: Enrollment

    Table layout:

    Reporter filter

    Column dimensions

    Row dimension

    Value

    Reporter filter

    Column dimensions

    Row dimension

    Value

    Organisation units

    Periods

    [PA] RDQA - Health Area

    Aggregation: Number of events
    Time field: Event date
    Org unit field: Event org unit

    Results:

    RDQA - Overall Data Quality, Data verification & System Assessment Score

    • This is perfomed through the data visualizer App.

    Table layout:

    Columns

    Rows

    Filter

    Columns

    Rows

    Filter

    Data

    Period

    Organisation unit

    Data elements/Program indicators:

    Element

    Type

    Element

    Type

    1. Overall Data Quality Score

    Program indicator

    2. System Assessment Score

    Program indicator

    3. Overall Data Verification Score

    Program indicator

    Results:

    RDQA - Overall Data quality score per health area

    • This is perfomed through the events reports app.

    • Table style: Line list

    • Output type: Enrollment

    Table layout:

    Excluded dimensions

    Colum dimensions

    Excluded dimensions

    Colum dimensions

    Longuited

    Latitude

    Event date
    Organisation unit
    [PA] RDQA - Health Area
    [PI] 1. Overall Data Quality Score
    [PI] 2. System Assessment Score
    [PI] 3. Overall Data Verification Score

    Results:

    RDQA - Data verification score per indicator and Donor

    Excluded dimensions

    Column dimensions

    Excluded dimensions

    Column dimensions

    Longitude
    Latitude

    Event date
    Organisation unit
    [DE] RDQA - Accuracy - Accuracy
    [DE] RDQA - Availability - % of available docs
    [DE] RDQA - Completeness - % of completed docs
    [DE] RDQA - Timeliness - ReportsOnTime
    [DE] RDQA - Integrity - Data
    [DE] RDQA - Confidentiality - Data
    [DE] RDQA - Precision - Data
    [DE] RDQA - Precision - Data
    [DE] RDQA - Indicator - Indicator
    [DE] RDQA - Donor List

    Results:

    RDQA Data Quality Score, Data verification & M&E Systems Assessment

    The data visualizer app within DHIS2 is utilized to create the following tables.

    RDQA - Health Area Scores

    The Health Area Scores provide a quick overview of the data quality, system assessment and data verification score calculated within the RDQA Program while capturing the data and completing each event.

    RDQA - Health area 1 Scores

    Table configuration:

    Columns

    Rows

    Filter

    Columns

    Rows

    Filter

    Data

    Organisation Unit

    Period

    Data elements/Program indicators:

    Element

    Type

    Element

    Type

    HA1 Overall Data Quality Score

    Indicator

    PI3.3 HA1 System Assessment Score

    Program indicator

    PI4.3 HA1 Overall Data Verification Score

    Program indicator

    Results:

    RDQA - Health area 2 Scores

    Table configuration:

    Columns

    Rows

    Filter

    Columns

    Rows

    Filter

    Data

    Organisation Unit

    Period

    Data elements/Program indicators:

    Element

    Type

    Element

    Type

    HA2 Overall Data Quality Score

    Indicator

    PI3.1 HA2 System Assessment Score

    Program indicator

    PI4.1 HA2 Overall Data Verification Score

    Program indicator

    Results:

    All other Health Area Score are built using the same configuration, however, it is important to change the Element based in the Health Area you are going to work with.

    RDQA - Health Area Data Verification Score by indicator

    In this section of the RDQA Dashboard, you find the verification score divided on all the areas the RDQA program grades. This includes accuracy, availability, completeness and other of the data within your organisation.

    As opposed to the Health Area Scores which utilize the Data Visualizer App, the verification score by indicator utilizes the Event Reports. For projects of your own, modify your Organisation Units and Health Areas based on your needs.

    RDQA - Accuracy by indicator

    • Table style: Pivot table

    • Output type: Event

    Layout table:

    Column dimensions

    Row dimensions

    Value

    Aggregation type

    Column dimensions

    Row dimensions

    Value

    Aggregation type

    Organisation units/
    Periods

    [DE] RDQA - Indicator - Indicator

    Aggregation:
    [DE] RDQA - Accuracy - Accuracy

    Average

    Results:

    RDQA - Availability by indicator

    • Table style: Pivot table

    • Output type: Event

    Layout:

    Column dimensions

    Row dimensions

    Value

    Aggregation type

    Column dimensions

    Row dimensions

    Value

    Aggregation type

    Organisation units/
    Periods

    [DE] RDQA - Indicator - Indicator

    Aggregation:
    [DE]RDQA - Availability - % of available

    Average

    Results:

    RDQA - Completeness by indicator

    • Table style: Pivot table

    • Output type: Event

    Layout:

    Column dimensions

    Row dimensions

    Value

    Aggregation type

    Column dimensions

    Row dimensions

    Value

    Aggregation type

    Organisation units/
    Periods

    [DE] RDQA - Indicator - Indicator

    Aggregation:
    [DE]RDQA - Completeness - % of completed docs

    Average

    Results:

    RDQA - Completeness by indicator

    • Table Style: Pivot table

    • Output type: Event

    Layout:

    Column dimensions

    Row dimensions

    Value

    Aggregation type

    Column dimensions

    Row dimensions

    Value

    Aggregation type

    Organisation units/
    Periods

    [DE] RDQA - Indicator - Indicator

    Aggregation:
    [DE]RDQA - Precision - Data

    Average

    Results:

    RDQA - Integrity by indicator

    • Table Style: Pivot table

    • Output type: Event

    Layout:

    Column dimension

    Row dimensions

    Value

    Aggregation type

    Column dimension

    Row dimensions

    Value

    Aggregation type

    Organisation units/
    Periods

    [DE] RDQA - Indicator - Indicator

    Aggregation:
    [DE]RDQA - Integrity - Data

    Average

    Results:

     

    Related content

    RDQA Technical Manual: Attributes
    RDQA Technical Manual: Attributes
    Routine Data Quality Assurance (RDQA)
    More like this
    RDQA DHIS2 Metadata Package Description
    RDQA DHIS2 Metadata Package Description
    Routine Data Quality Assurance (RDQA)
    More like this
    RDQA License and source code
    RDQA License and source code
    Routine Data Quality Assurance (RDQA)
    Read with this
    RDQA Technical Manual: Analytics (FR)
    RDQA Technical Manual: Analytics (FR)
    Routine Data Quality Assurance (RDQA)
    More like this
    RDQA Release Notes
    RDQA Release Notes
    Routine Data Quality Assurance (RDQA)
    Read with this
    RDQA Technical Manual: Programs
    RDQA Technical Manual: Programs
    Routine Data Quality Assurance (RDQA)
    More like this

    ✍ External Public Page ✍
    "RDQA Metadata Package" by Population Services International is in the Public Domain.