Check equipment use logged by the model

[sakshimohan]

PR #1341 allowed for the logging of equipment used for service delivery in the model. The healthsystem.summary logger now records by Facility_ID which pieces of equipment are called upon my modules to run HSIs. Based on an unconstrained 10-year run (100,000 population) from 11 July 2024, 50 pieces of equipment were logged across different levels of care - see .csv file below. This issue requests disease module leads to verify whether this log makes sense, i.e. whether they would like to incorporate the use of any further pieces of equipment at any level or remove any.

tlo_equipment_log_summary.csv
(File updated at 11:27 24 July following corrections listed here)

[sakshimohan]

Easily readable version of .csv below
(Table updated at 11:27 24 July following corrections listed here)

<style> </style>

Equipment_name	Item_code	1a	0	2	3	Alternative_name
Height Pole (Stadiometer)	0	TRUE	-	TRUE	-	'Length Boards with ruler, headpiece and foot piece', 'Hieght boards sets'
Weighing scale	1	TRUE	-	TRUE	-	'Salter weighing scale', 'Waeighing Scale'
Autoclave	2	-	-	TRUE	-	'High pressure cooker sterilizer, complete with stove', 'Sterilization drums, medium', 'Sterilization drum', 'Sterilization buckets', 'Sterilization buckets (decontamination buckets)', 'Sterilization Buckets', 'Decontamination drums', 'Dressing drum medium', 'Dressing drum large', 'Dressing drum  small'
Blood pressure machine	6	TRUE	-	TRUE	-	0
Thermometer	7	TRUE	-	TRUE	-	'Thermometers, digital'
Stethoscope	13	-	-	TRUE	-	'Stethoscopes'
Glucometer	15	TRUE	-	-	-	0
Haemoglobinometer	17	-	-	TRUE	-	'Haemacue (Haemoglobinometer)', 'Hemoglobinometer'
Ultrasound, combined 2/4 pole interferential with vacuum and dual frequency 1-3MHZ	279	TRUE	-	-	-	'Combined 2/4 pole interferential with vacuum and dual frequency 1-3MHZ ultrasound'
MUAC tape	24	TRUE	-	-	-	0
Sputum Collection box	30	TRUE	-	TRUE	-	'Sputum container'
Ordinary Microscope	31	TRUE	-	TRUE	TRUE	'Microscopy'
Bed, adult	35	-	-	TRUE	-	'Bed labour', 'Bed, postnatal', 'Beds', 'Beds, low'
Resuscitaire	293	TRUE	-	TRUE	-	0
Nasal Prongs	294	TRUE	-	TRUE	-	0
Bucket, 10L	40	-	-	TRUE	-	'10 L buckets'
Lamp, Anglepoise	41	-	-	TRUE	-	'Angle poised lamp', 'Angle poise lamp'
Tray, emergency	43	TRUE	-	TRUE	-	'Emergency tray packs', 'Emergency tray'
Suction machine	62	TRUE	-	TRUE	-	0
Drip stand	68	TRUE	-	TRUE	-	'Intravenous drip stands'
Stool, adjustable height	69	-	-	TRUE	-	'Stool, surgeon's, adjustable height', 'Height stool, adjustable'
Sponge Holding Forceps	70	TRUE	-	-	-	0
Oxygen cylinder, with regulator	365	TRUE	-	TRUE	-	'Oxygen cylinder'
Patient monitor	111	-	-	TRUE	-	'Patient monitors'
Trolley, patient	113	-	-	TRUE	-	'Patient trolley', 'Recovery trolley'
Casting chairs	115	-	-	TRUE	-	0
Sphygmomanometer	372	TRUE	-	TRUE	-	'Syphygmomanometer', 'Sphygmomamometer'
Measuring tapes	117	TRUE	-	-	-	'Height Measuring Tape', 'Tape measure'
X-ray viewer	119	-	-	TRUE	-	'Xray field viewer'
Casting platform	123	-	-	TRUE	-	0
Analyser, Combined Chemistry and Electrolytes	125	-	-	TRUE	-	'Combined Chemistry and Electolytes analyser',
Electrocardiogram	403	-	-	TRUE	-	0
Ultrasound scanning machine	161	-	-	-	TRUE	'Mobile Ultrasound scanning general with printer', 'Obstetric Ultrasound scan with doppler', 'Ultrasound scanning portable', 'Detector, foetal heart, ultrasonic, portable, Doppler'
Computed Tomography (CT machine)	164	-	-	TRUE	-	0
CT scanner accessories	165	-	-	TRUE	-	0
Infusion pump	170	TRUE	-	TRUE	-	0
Trolley, emergency	171	-	-	TRUE	-	'Emergency trolley'
Cusco’s/ bivalved Speculum (small, medium, large)	172	TRUE	-	TRUE	-	'Speculums', 'Speculum', 'Cuscos/ bivalve Speculum (small, medium, large)'
Oxygen concentrator	179	TRUE	-	-	-	0
Delivery set	184	TRUE	-	TRUE	-	'Hollow ware', 'Hollow ware, set, delivery room', 'Hollow ware set, ward, duty station', 'Instrument set', 'Episiotomy set'
Stethoscope, foetal, monaural, Pinard, plastic	188	TRUE	-	TRUE	-	0
X-ray machine	202	-	-	TRUE	-	'X ray machine', 'Static digital x-ray machine'
Laparotomy Set	212	-	-	TRUE	TRUE	'Laparatomy Set'
Hysterectomy set	213	-	-	TRUE	-	'Total Abdominal Hysterectomy set', 'Vaginal Hysterectomy Set', 'Radical Hysterectomy set'
Bipolar Diathermy Machine	214	-	-	TRUE	-	0
Suction Curettage machine	218	-	-	TRUE	-	'Suction Curettage  machine'
Analyser, Haematology	221	TRUE	-	TRUE	-	'Haematology analyser Auto', 'Haematology analyser Semi'
Pulse oximeter	243	TRUE	TRUE	TRUE	-	0

[sakshimohan]

@EvaJanouskova do you know what item_code 403 is?

[EvaJanouskova]

@EvaJanouskova do you know what item_code 403 is?

It's one of the latest added items 402=Endoscope, 403=Electrocardiogram.

[joehcollins]

Hi @sakshimohan (@tbhallett @EvaJanouskova). I went through all the modules quickly and checked to see if there was equipment in the code that hadn't been logged in this output. Following are missing:

• Analyser, heamotology used in NCDs but not on list
• Trolley, patient used in HIV but not on list
• Delivery forceps or Vacuum extractor used in Labour not on the list - effect of small numbers
• Analyser, heamotology used in Labour but not on list
• Tray, emergency used in Labour but not on list
• Gene Expert (16 Module) in Tb but not on list

A few other comments we could maybe discuss:

• Some of the items above seem to be a combination of multiple items - I've checked with the original
• Delivery Trolley doesnt appear to be called anywhere in the code...dont know how it made the list
• Why is hysterectomy set listed but not used?
• In the original spreadsheet there are some repeats of equipment with the same codes? (oxygen concentrator/patient monitor). Is this a combination?
• Why is the microscope being use at level 1a...

[joehcollins]

Also just to say in the list here some of these items have been combined (i.e. a regular stethoscope and feotal stethoscope). Just checking now with the original

[sakshimohan]

Hi @sakshimohan (@tbhallett @EvaJanouskova). I went through all the modules quickly and checked to see if there was equipment in the code that hadn't been logged in this output. Following are missing:

Hi @joehcollins Many thanks for taking a look at this. This is very helpful. Looking through the latest Equipment catalogue in master I realised that some of the item_code to equipment_name mapping might have updated since I put together the costing database. I have now remapped the equipment names in the table above (in bold). You'll notice that 7 pieces of equipment are different now. This addresses some of your points (checked below)-

• Analyser, heamotology used in NCDs but not on list - now used at levels 1a and 2
• Trolley, patient used in HIV but not on list - used at level 2
• Delivery forceps or Vacuum extractor used in Labour not on the list - effect of small numbers
• Analyser, heamotology used in Labour but not on list
• Tray, emergency used in Labour but not on list - ** used at 1a and 2**
• Gene Expert (16 Module) in Tb but not on list
  A few other comments we could maybe discuss:
• Some of the items above seem to be a combination of multiple items - I've checked with the original
• Delivery Trolley doesnt appear to be called anywhere in the code...dont know how it made the list - Item_code 171 was incorrectly mapped to this name
• Why is hysterectomy set listed but not used? - It seems that this got missed because it is only being used by level 2 in one district (Dowa). The data I had previously provided was only from one district because I had assumed that all districts would have the same list of equipment used by level. This is now updated in the table above.
• In the original spreadsheet there are some repeats of equipment with the same codes? (oxygen concentrator/patient monitor). Is this a combination? - Oxygen concentrator and Patient monitor were incorrectly mapped to two Item_codes
• Why is the microscope being use at level 1a...

[EvaJanouskova]

• Why is the microscope being use at level 1a...

It could be because of HSI_Tb_ScreeningAndRefer.

[EvaJanouskova]

I've gone through the catalogue and found a few additional items missing from your list beyond those Joe identified:

• Cystoscope ... used in bladder_cancer, level 1b
• Endoscope ... used in oesophagealcancer, level 1b

Btw, a few items have some name issues:

• Cusco‚Äôs/ bivalved Speculum (small, medium, large) You could probably remove the apostrophe if you like so it won't create any issues. It was without the apostrophe in the original data anyway. Now I do know why.
• item 363, the name is 'exer' and alternative name 'Thin mattress' (Obviously smt went wrong there. From the original data I would say that the item name should be 'Thin mattress', and alternative name 'thin mattres'---the alternative is the name from the original data which includes a typo.)

I have also looked up the cancer modules and find a few items which are in your list but not in the fac. level for which the equipment is called. Maybe HSI can be redirected to another level? I haven't dive into this in the model yet, hence cannot say if that's so.

• Ultrasound scanning machine ... is called from bladder_cancer, other_adult_cancers and prostate_cancer, level 1b
• Blood pressure machine ... Major surgery pkg, that includes this item, is called from bladder_cancer, breast_cancer, oesophagealcancer, other_adult_cancers and prostate_cancer, level 3

The items called from contraception module seem to be logged correctly. There is no equipment in stunting and wasting.