Technical Manual: Analytics
This is the last part of the technical manual of the RDQA Program. You will find all program indicators in this manual plus a general overview of the tables that you can create using this program.
Program indicators allow to generate 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.
Program indicators
| Name |
Aggregation Type/ Analytic Type |
Expression | Filter |
|---|---|---|---|
| 1. 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
|
|
| 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' |
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.
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.
Breakdown
This is performed through the Events Reports App.
Table style: Pivot table
Output type: Event
Table Layout
| 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:
It is worth to mention that no Data Elements, Indicators or Program Indicators are used to create this table.
Breakdown
This is performed through the Events Reports App.
Table style: Pivot table
Output type: Enrollment
Table Layout
| Reporter Filter | Column dimensions | Row dimensions | Value |
|---|---|---|---|
| Organisation units | Periods | [PA] RDQA - Health Area |
Aggregation: Number of events Time field: Event date Org unit field: Event org unit |
Results:
Breakdown
This is performed through the Data Visualizer App.
Table Layout
| Columns | Rows | Filter |
|---|---|---|
| Data | Period | Organisation Unit |
Data elements/Program indicators
| Element | Type |
|---|---|
| 1. Overall Data Quality Score | Program indicator |
| 2. System Assessment Score | Program indicator |
| 3. Overall Data Verification Score | Program indicator |
Results:
Breakdown
This is performed through the Events Reports App.
Table style: Line List
Output type: Enrollment
Table Layout
| Excluded dimensiones | Column dimensions |
|---|---|
| Longitude 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:
Breakdown
This is performed through the Events Reports App.
Table style: Line List
Output type: Enrollment
Table Layout
| Excluded dimensiones | 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:
The Data Visualizer App within DHIS2 is utilized to create the following tables.
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.
Configuration
Table configuration
| Columns | Rows | Filter |
|---|---|---|
| Data | Organisation Unit | Period |
Data elements/Program indicators
| 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:
Configuration
Table configuration
| Columns | Rows | Filter |
|---|---|---|
| Data | Organisation Unit | Period |
Data elements/Program indicators
| 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.
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 oppose 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.
Breakdown
Table Style: Pivot table
Output type: Event
Layout
| Column dimensions | Row dimensions | Value | Aggregation type |
|---|---|---|---|
| Organisation units/ Periods |
[DE] RDQA - Indicator - Indicator | Aggregation: [DE] RDQA - Accuracy - Accuracy |
Average |
Results:
Breakdown
Table Style: Pivot table
Output type: Event
Layout
| Column dimensions | Row dimensions | Value | Aggregation type |
|---|---|---|---|
| Organisation units/ Periods |
[DE] RDQA - Indicator - Indicator | Aggregation: [DE]RDQA - Availability - % of available |
Average |
Results:
Breakdown
Table Style: Pivot table
Output type: Event
Layout
| Column dimensions | Row dimensions | Value | Aggregation type |
|---|---|---|---|
| Organisation units/ Periods |
[DE] RDQA - Indicator - Indicator | Aggregation: [DE]RDQA - Completeness - % of completed docs |
Average |
Results:
Breakdown
Table Style: Pivot table
Output type: Event
Layout
| Column dimensions | Row dimensions | Value | Aggregation type |
|---|---|---|---|
| Organisation units/ Periods |
[DE] RDQA - Indicator - Indicator | Aggregation: [DE]RDQA - Timeliness - ReportsOnTime |
Average |
Results:
Breakdown
Table Style: Pivot table
Output type: Event
Layout
| Column dimensions | Row dimensions | Value | Aggregation type |
|---|---|---|---|
| Organisation units/ Periods |
[DE] RDQA - Indicator - Indicator | Aggregation: [DE]RDQA - Precision - Data |
Average |
Results:
Breakdown
Table Style: Pivot table
Output type: Event
Layout
| Column dimensions | Row dimensions | Value | Aggregation type |
|---|---|---|---|
| Organisation units/ Periods |
[DE] RDQA - Indicator - Indicator | Aggregation: [DE]RDQA - Integrity - Data |
Average |
Results:
We provide the basic on how to set up the RDQA Program, for changes we suggest you to check the following insights:
- If you decide to change the name of any Health Area (coded "HA"), as long as you keep the same code, the program will work as intended.
- If you add a new Health Area, thus a new code, please ensure to add its respective program rule and program indicator. You can always visit our Metadata management guide for instructions.
Now that you are done with the technical manual all that is left is to modify the program in order to meets all of your requirements. To learn more please visit our Metadata management.
Also, to learn how to install the program successfully, please look at our Installation manual.