Quality Assurance queries in CFE

We have a bunch of Quality Assurance questions in CFE. Most of them currently have a backlog or errors. As the backlog gets eliminated we can add them to Centralized data Vetting Process.

QA checks

1. NDC_missing_Ls (There is one pt with no comorbid and that is correct)
2. NDC_discharged_incomplete (It is ok if there is a list of Incompletes)
3. NDC_Bad_Postal_Code (This is corrected when time available)
4. NDC_Missing_TransferDate_w_pivot (This is done during reports, OK to skip this one)
5. NDC_CLI_AcqDX_but_NoCLI_DateinTMPV2
6. NDC_CLI_No_AcqDX_but_CLI_DateinTMPV2
7. NDC_CLI_unacceptable_date
8. NDC_VAP_AcqDX_but_NoVAP_DateinTMPV2 (see VAP Dx vs Tmp checking)
9. NDC_VAP_No_AcqDX_but_VAP_DateinTMPV2 (see VAP Dx vs Tmp checking)
10. NDC_VAP_unacceptable_date (see VAP Dx vs Tmp checking)

There should be NO CLIs & VAPs

• Do not need to click on NDCs box

• Do you not use the "NDCs button" instead of the individual queries? Ttenbergen 10:34, 2016 August 3 (CDT)
  • individual queries right now, in order to skip over the Postal Code query. Postal codes have been skipped, as list is too long and very time consuming to fix all errors. As per Pagasa. Will be revisiting it this week. -- Aug 23.16.
    • updated query for Postal_code_cross_check - so we can start using this again? Also: please talk to me when this sort of hold-up happens, I could have just taken it out from the list. Ttenbergen 19:45, 2016 August 25 (CDT)

Proceed as instructed in Centralized data Vetting Process.