Quality Assurance queries in CFE

We have a bunch of Quality Assurance queries in CFE that are done as part of the Centralized data Vetting Process. Ideally all should be empty, if they are not the data needs to be fixed (see Processing errors in patient data).

The easiest way to check these is to click the NDCs button. It will check every query but only display those where problems were found.

If any false positives are found that are unique special cases or if there are errors that we deliberately decide not to correct for some reasons, set them as Known data errors so they no longer show up in queries.

NDC queries / CFE Data Integrity Checks

These checks can be run in any order.

1. query NDC_CLI_AcqDX_but_NoCLI_DateinTMPV2
2. query NDC_CLI_vs_DX_but_no_TISS17_CentralLine
3. query NDC_CLI_No_AcqDX_but_CLI_DateinTMPV2
4. query NDC_CLI_unacceptable_date
5. query NDC_VAP_AcqDX_but_NoVAP_DateinTMPV2
6. query NDC_VAP_No_AcqDX_but_VAP_DateinTMPV2
7. query NDC_VAP_unacceptable_date
8. query NDC_Bad_Postal_Code

Where on this list would fit: query NDC VAP no TISS query NDC Pacemaker acquired vs TISS query NDC TISS Extubation only on TISS Intubated days query NDC_cardioversion_dx_vs_TISS query NDC_Dialysis_TISS_CCI query NDC_Dxs_vs_TISS_Dialysis query NDC_HD_TISS_CCI query NDC_PD_TISS_CCI query NDC_TISS_CCI_endoscopic query NDC_TISS_Spontaneous_vs_ETT_Trach query NDC_Trach_Dx_TISS query NDC_zCRRT_TISS_no_tmp query NDC_zCRRT_tmp_no_TISS

• SMW

• Cargo

• Categories

SMW List

	DICStatus
Query NDC Bad Postal Code	implemented
Query NDC CLI unacceptable date	retired
Query NDC Pacemaker acquired vs TISS	retired
Query NDC Postal Code over time	implemented
Query NDC TISS CCI endoscopic	retired
Query NDC Trach Dx TISS	retired
Query NDC VAP AcqDX but NoVAP DateinTMPV2	retired
Query NDC VAP No AcqDX but VAP DateinTMPV2	retired
Query NDC VAP unacceptable date	retired
Query NDC cardioversion dx vs TISS	retired
Query NDC dx implying death across encounters	implemented
Query NDC zCRRT CCI Px but no TISS	retired
Query NDC zCRRT TISS but no CCI Px	retired
Query NDC zCRRT TISS no tmp	retired
Query NDC zCRRT tmp no TISS	retired