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 IterationSystem & Solution Demo Recordings

 

PI-31 Solution Demo 

 

PI-30 Solution Demo 

 

PI-29 Solution Demo

 

PI-28 Solution Demo

 

PI-28 Solution Demo

 

PI 27

 

PI 26

 

PI 25

 

PI 24

 

PI 23

 

PI 22

 

PI 21


 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 3Is there a corresponding Version 1 question?Database columnProd ValuesConversionValidation

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_indNo: 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_indNo: 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_idNo: 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_cntWhen 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_idNo: 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.




  • No labels