Quality Assurance queries in CFE: Difference between revisions
Ttenbergen (talk | contribs) m (Text replacement - "Check VAP vs TISS ventilated" to "query NDC_VAP_no_TISS") |
Ttenbergen (talk | contribs) m (→NDC queries / CFE Data Integrity Checks: cleared out stuff that is no longer done) |
||
| Line 10: | Line 10: | ||
# [[PL missing L Tables content]] | # [[PL missing L Tables content]] | ||
# [[query NDC_discharged_incomplete]] (It is ok if there is a list of Incompletes) | # [[query NDC_discharged_incomplete]] (It is ok if there is a list of Incompletes) | ||
# [[query NDC_CLI_AcqDX_but_NoCLI_DateinTMPV2]] | # [[query NDC_CLI_AcqDX_but_NoCLI_DateinTMPV2]] | ||
# [[NDC CLI vs DX but no TISS17 CentralLine]] | # [[query NDC CLI vs DX but no TISS17 CentralLine]] | ||
# [[NDC_CLI_No_AcqDX_but_CLI_DateinTMPV2]] | # [[query NDC_CLI_No_AcqDX_but_CLI_DateinTMPV2]] | ||
# [[NDC_CLI_unacceptable_date]] | # [[query NDC_CLI_unacceptable_date]] | ||
# [[ | # [[query NDC_VAP_AcqDX_but_NoVAP_DateinTMPV2]] | ||
# [[NDC_VAP_No_AcqDX_but_VAP_DateinTMPV2]] | # [[query NDC_VAP_No_AcqDX_but_VAP_DateinTMPV2]] | ||
# [[query NDC_VAP_unacceptable_date]] | # [[query NDC_VAP_unacceptable_date]] | ||
# [[query NDC_Bad_Postal_Code]](This is corrected when time available) | |||
{{discussion}} Where on this list would fit: | {{discussion}} Where on this list would fit: | ||
* [[query | * [[query NDC VAP no TISS]] | ||
* [[query NDC Pacemaker acquired vs TISS]] | * [[query NDC Pacemaker acquired vs TISS]] | ||
Revision as of 09:09, 2019 February 7
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.
|
This manually generated list is now out of date and will be hard to keep up to date. An automatic one exists at CFE Data Integrity Checks but it is in no priority order. Are these? Can we use the automatic list instead? |
NDC queries / CFE Data Integrity Checks
- PL missing L Tables content
- query NDC_discharged_incomplete (It is ok if there is a list of Incompletes)
- query NDC_CLI_AcqDX_but_NoCLI_DateinTMPV2
- query NDC CLI vs DX but no TISS17 CentralLine
- query NDC_CLI_No_AcqDX_but_CLI_DateinTMPV2
- query NDC_CLI_unacceptable_date
- query NDC_VAP_AcqDX_but_NoVAP_DateinTMPV2
- query NDC_VAP_No_AcqDX_but_VAP_DateinTMPV2
- query NDC_VAP_unacceptable_date
- query NDC_Bad_Postal_Code(This is corrected when time available)
Template:Discussion Where on this list would fit:
|
|
|