Quality Assurance queries in CFE: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 5: | Line 5: | ||
== NDC queries / [[CFE Data Integrity Checks]]== | == NDC queries / [[CFE Data Integrity Checks]]== | ||
#[[Query NDC missing L Tables content | NDC_missing_L_Tables_content]] | #[[Query NDC missing L Tables content | NDC_missing_L_Tables_content]] | ||
# NDC_discharged_incomplete (It is ok if there is a list of Incompletes) | # [[NDC_discharged_incomplete]] (It is ok if there is a list of Incompletes) | ||
# [[Postal_code_cross_check|NDC_Bad_Postal_Code]] (This is corrected when time available) | # [[Postal_code_cross_check|NDC_Bad_Postal_Code]] ([[Postal_code_cross_check]])(This is corrected when time available) | ||
# NDC_Missing_TransferDate_w_pivot (This is done during reports, OK to skip this one) | # [[NDC_Missing_TransferDate_w_pivot]] (This is done during reports, OK to skip this one) | ||
# NDC_CLI_AcqDX_but_NoCLI_DateinTMPV2 | # [[NDC_CLI_AcqDX_but_NoCLI_DateinTMPV2]] | ||
# NDC_CLI_vs_NO_TISS17 | # [[NDC_CLI_vs_NO_TISS17]] | ||
# NDC_CLI_No_AcqDX_but_CLI_DateinTMPV2 | # [[NDC_CLI_No_AcqDX_but_CLI_DateinTMPV2]] | ||
# NDC_CLI_unacceptable_date | # [[NDC_CLI_unacceptable_date]] | ||
# NDC_VAP_AcqDX_but_NoVAP_DateinTMPV2 (see [[VAP Dx vs Tmp checking]]) | # [[NDC_VAP_AcqDX_but_NoVAP_DateinTMPV2]] (see [[VAP Dx vs Tmp checking]]) | ||
# NDC_VAP_No_AcqDX_but_VAP_DateinTMPV2 (see [[VAP Dx vs Tmp checking]]) | # [[NDC_VAP_No_AcqDX_but_VAP_DateinTMPV2]] (see [[VAP Dx vs Tmp checking]]) | ||
# NDC_VAP_unacceptable_date (see [[VAP Dx vs Tmp checking]]) | # [[NDC_VAP_unacceptable_date]] (see [[VAP Dx vs Tmp checking]]) | ||
[[Category:Data Processing]] | [[Category:Data Processing]] | ||
[[Category:Postal Codes]] | [[Category:Postal Codes]] | ||
Revision as of 00:29, 27 October 2018
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.
NDC queries / CFE Data Integrity Checks
- NDC_missing_L_Tables_content
- NDC_discharged_incomplete (It is ok if there is a list of Incompletes)
- NDC_Bad_Postal_Code (Postal_code_cross_check)(This is corrected when time available)
- NDC_Missing_TransferDate_w_pivot (This is done during reports, OK to skip this one)
- NDC_CLI_AcqDX_but_NoCLI_DateinTMPV2
- NDC_CLI_vs_NO_TISS17
- NDC_CLI_No_AcqDX_but_CLI_DateinTMPV2
- NDC_CLI_unacceptable_date
- NDC_VAP_AcqDX_but_NoVAP_DateinTMPV2 (see VAP Dx vs Tmp checking)
- NDC_VAP_No_AcqDX_but_VAP_DateinTMPV2 (see VAP Dx vs Tmp checking)
- NDC_VAP_unacceptable_date (see VAP Dx vs Tmp checking)