Resources and References

We'll post links to important resources and references on this page. Some of those resources are EQRS system demos and notes from the EQRS Program Working Group meetings.

EQRS System & Solution Demos

Date	Iteration	System & Solution Demo Recordings
13 May 2025	PI-31 Solution Demo	PI-31 Solution Demo
15 Apr 2025	PI-30 Solution Demo	PI-30 SOlution Demo (External) video1334541807.mp4
21 Jan 2025	PI-29 Solution Demo	EQRS PI 29 Solution Demo 1.pdf PI-29 Solution Demo video1320421380.mp4
12 Nov 2024	PI-28 Solution Demo	EQRS PI 28 Solution Demo_External.pdf
15 Oct 2024	PI-28 Solution Demo	EQRS PI 28 Solution Demo_External.pdf
23 Jul 2024	PI 27	EQRS - PI 27 Solution Demo
30 Apr 2024	PI 26	EQRS - PI 26 Solution Demo
06 Feb 2024	PI 25	EQRS - PI 25 Solution Demo
14 Nov 2023	PI 24	EQRS - PI 24 Solution Demo
22 Aug 2023	PI 23	EQRS - PI 23 Solution Demo
30 May 2023	PI 22	EQRS - PI 22 Solution Demo
07 Mar 2023	PI 21	EQRS - PI 21 Solution Demo

09 Jul 2025 Peritonitis Infection Mapping Plan:

There are currently about 10,000 rows of data in production. We will convert these rows in place to into the new data model. The table below outlines how this conversion will be done.

Version 3	Is there a corresponding Version 1 question?	Database column	Prod Values	Conversion	Validation
Date of Diagnosis	Yes, but it is called Event Date	infctn_evnt_dt	Not null: 9000 Null: 0	None	31100 - Infection ~~event~~ date of diagnosis is required. 31110 - Infection ~~event~~ date of diagnosis cannot be a future date. 31120 - Infection ~~event~~ date of diagnosis must be on or after patient's Date of Birth. 31130 - Infection ~~event~~ date of diagnosis must be on or before patient's Date of Death.
Was there a catheter exit site infection within 14 days prior to peritonitis diagnosis? (Yes/No)	Question exists but accepts Yes/No/Unknown	cth_exit_st_inf_ind	No: 900 Yes: 100 Unknown: 70 Null: 20	~~How to handle Unknown and Null?~~ Convert them to "No"	New - Was there a catheter exit site infection within 14 days prior to diagnosis is required.
Was there a tunnel infection within 14 days prior to peritonitis diagnosis? (Yes/No)	Question exists but accepts Yes/No/Unknown	tnl_inf_ind	No: 9000 Yes: 40 Unknown: 90 Null: 20	~~How to handle Unknown and Null?~~ Convert Unknown and Null to "No"	New - Was there a tunnel infection within 14 days prior to diagnosis is required.
Was there abdominal pain or was effluent cloudy? (Yes/No)	This is two separate questions in V1 and they both accept Yes/No/Unknown	ab_pain_opt_id eff_cldy_opt_id	Either yes: 8000 Both no: 2000 Other: 60	Create a new column to combine both answers. ~~How to handle Other?~~ Convert Other to "No"	31600 - Was there abdominal pain or was effluent cloudy is required.
Was effluent drawn for cell counts? (Yes/No)	Question exists but accepts Yes/No/Unknown	eff_drwn_opt_id	No: 300 Yes: 9000 Unknown: 100 Null: 20	~~How to handle Unknown and Null?~~ Convert Unknown and Null to "No"	31270 - Was effluent drawn for cell counts is required.
PD Fluid Cell Count (Number/Not Available)	Number field exists, "Not Available" checkbox does not exist	pd_fld_cell_cnt	When eff_drwn_opt_id is "Yes" Not null: 9000 Null: 20	Add new column to track Not Available option. Populate this column for values that currently have Null.	31320 - PD Fluid Cell Count is required if effluent for cell counts is yes ~~was drawn~~. 31330 - PD Fluid Cell Count is not accepted if effluent for cell counts is no ~~was not drawn~~. NEW - PD Fluid Cell Count is not accepted is populated 31340 - PD Fluid Cell Count cannot be less than 0. 31350 - PD Fluid Cell Count cannot exceed 4000. ???
>50% of peritoneal fluid leukocytes (WBCs) were reports as neutrophils (PMN) (Yes/No/Not available)	Number field storing the actual percent, not Yes/No	lkcyts_ntrphls_pct	When eff_drwn_opt_id is "Yes" Null: 30 <= 50: 1000 > 50: 8000	Add two new columns, one to store Yes/No and one to store "Not Available". Convert numbers to Yes/No. ~~How to handle Null values?~~ Convert Null to Not Available	31360 - Greater than peritoneal fluid ~~Percentage of~~ leukocytes that were neutrophils is required if effluent for cell counts is yes ~~was drawn~~. 31370 - Greater than peritoneal fluid ~~Percentage of~~ leukocytes that were neutrophils is not accepted if effluent for cell counts is no ~~was not drawn~~. NEW - Greater than peritoneal fluid leukocytes that were neutrophils is not accepted when not available is populated. 31380 - Greater than peritoneal fluid ~~Percentage of~~ leukocytes that were neutrophils cannot be less than 0. 31390 - Greater than peritoneal fluid ~~Percentage of~~ leukocytes that were neutrophils cannot exceed 100. ???
Was effluent drawn for a culture test? (Yes/No)	Question exists but accepts Yes/No/Unknown	eff_drwn_opt_id	No: 300 Yes: 9000 Unknown: 100 Null: 20	~~How to handle Unknown and Null?~~ Convert Unknown and Null to "No"	New - Was effluent drawn for culture test is required.
Was effluent culture positive or negative (Positive/Negative/Not available)	Yes, "Was the culture test positive? Yes/No/Unknown"	cltr_tst_pos_opt_id	When eff_drwn_opt_id is "Yes" No: 700 Yes: 5000 Unknown: 200 Null: 3000	Add two new columns, one to store Positive/Negative and one to store "Not Available". Convert Yes/No to Positive/Negative. Convert Unknown and Null to "Not Available"	New - Was effluent culture positive or negative is required when effluent drawn for a culture is yes. New - Was effluent culture positive or negative is not accepted when effluent drawn for culture test is no. New - Was effluent culture positive or negative is not accepted when not available is populated.
Were antibiotics administered for peritonitis? (Yes/No)	Question exists but accepts Yes/No/Unknown Question exists but is conditional on culture test positive	antb_admn_opt_id	No: 700 Yes: 5000 Unknown: 20 Null: 4000	~~How to handle Unknown and Null?~~ Convert Unknown and Null to "No"	31450 - 'Were antibiotics administered?' is required ~~if culture test is positive~~.