The DHS Program User Forum: Service Provision Assessment (SPA)

Home » Topics » Service Provision Assessment (SPA) » Replicating table (SPA survey)

Show: Today's Messages :: Show Polls :: Message Navigator

Re: Replicating table [message #29469 is a reply to message #29340]

Mon, 24 June 2024 09:51

Janet-DHS
Messages: 878
Registered: April 2022

Senior Member

Following is a response from Senior Data Processing Specialist, Claudia Marchena:
Here is how to calculate to match the final report the "equipment for high-level disinfection".

Q201 in 1,2 & (

               ( Q501A(4)=1 & Q501B(4)=1) or (Q501A(5)=1 & Q501A(6)=1 & Q501B(6)=1) or (Q501A(9)=1 & Q502G(5) in 3,4,5,6)

              )

Below in bold font is the footnote #2 on the table referring to the calculation of "equipment for high-level disinfection". I am breaking the code as per the footnote. The only chemical that was not listed in the footnote was Cidex that is included in the code, I added it in red in the text below to denote it is not in the footnote.
Facility reports that some instruments are processed in the facility and Q201 in 1,2 &

the facility has an electric pot (( Q501A(4)=1 & Q501B(4)=1)

or other pot with heat source for high-level disinfection by boiling or high-level disinfection by steaming, or (Q501A(5)=1 & Q501A(6)=1 & Q501B(6)=1)

Below are screenshots from "Processing of instruments section" on Tanzania SPA 2014-15. I have highlighted the items that matches the footnote.

or else facility has chlorine, cidex, formaldehyde, or glutaraldehyde for chemical high level disinfection available somewhere in the facility on the day of the survey.

or (Q501A(9)=1 & Q502G(5) in 3,4,5,6)

Below are screenshots from "Processing of instruments section" on Tanzania SPA 2014-15. I have highlighted the items that matches the footnote.
/index.php?t=getfile&id=2336&private=0