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 |
---|---|---|
| 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 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 | None | 31100 - Infection 31110 - Infection 31120 - Infection 31130 - Infection |
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 |
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 |
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. 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 |
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 31330 - PD Fluid Cell Count is not accepted if effluent for cell counts is no 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 | Add two new columns, one to store Yes/No and one to store "Not Available". Convert numbers to Yes/No.
Convert Null to Not Available | 31360 - Greater than peritoneal fluid 31370 - Greater than peritoneal fluid NEW - Greater than peritoneal fluid leukocytes that were neutrophils is not accepted when not available is populated. 31380 - Greater than peritoneal fluid 31390 - Greater than peritoneal fluid |
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 |
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 | 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 | antb_admn_opt_id | No: 700 |
Convert Unknown and Null to "No" | 31450 - 'Were antibiotics administered?' is required |