Centralized data Vetting Process: Difference between revisions
| Line 35: | Line 35: | ||
== Check for problems == | == Check for problems == | ||
Use [[Centralized data front end.mdb]] "NDC" (New Data Check) queries and fix data as needed; if a patient shows up in one of the queries fix if possible; if question to collector is required, set '''[[Record Status field]] to "questioned"''' | Use [[Centralized data front end.mdb]] "NDC" (''New Data Check'') queries and fix data as needed; if a patient shows up in one of the queries fix if possible; if question to collector is required, set '''[[Record Status field]] to "questioned"''' | ||
Perform the Queries in this order: | Perform the Queries in this order: | ||
| Line 42: | Line 42: | ||
should always be zero | should always be zero | ||
2. NDC_Chart_9_Digit | 2. NDC_Chart_9_Digit | ||
| Line 59: | Line 60: | ||
Toggle Filter | Toggle Filter | ||
This sorts by LastName | (This sorts by LastName) | ||
'''**''' before assigning phin, make sure to check for the highest number in ''Highest Pseudo Phin'' | '''**''' before assigning phin, make sure to check for the highest number in ''Highest Pseudo Phin'' | ||
Right click | |||
sort by highest to lowest | |||
'''DO NOT''' assign pseudo Phin if a single, or if 'incomplete' | '''DO NOT''' assign pseudo Phin if a single, or if 'incomplete' | ||
If they have previous encounters, we can assign a phin | If they have previous encounters, we can assign a phin | ||
4. NDC_Diff_Phin_Same_LN | 4. NDC_Diff_Phin_Same_LN | ||
| Line 73: | Line 79: | ||
Advanced | Advanced | ||
LastName | Advanced Filter/Sort | ||
LastName (double click or drag & drop) | |||
Sort by ''ascending'' | |||
Home | |||
Toggle Filter | |||
5. NDC_SameChart_Site_Diff_Phin | |||
6. | 6. NDC_SamePhin_Diff_LN_FN_DOB_Sex | ||
Home | Home | ||
| Line 87: | Line 99: | ||
Advanced | Advanced | ||
Phin | Advanced Filter/sort | ||
Phin (double click or drag & drop) | |||
Sort by ''ascending'' | |||
Home | Home | ||
| Line 97: | Line 113: | ||
8. NDC_CLI_AcqDX_but_NoCLI_DateinTMPV2 (see [[CLI Dx vs Tmp checking]]) | 8. NDC_CLI_AcqDX_but_NoCLI_DateinTMPV2 (see [[CLI Dx vs Tmp checking]]) | ||
9. NDC_CLI_No_AcqDX_but_CLI_DateinTMPV2 (see [[CLI Dx vs Tmp checking]]) | |||
10. NDC_CLI_unacceptable_date (see [[CLI Dx vs Tmp checking]]) | |||
11. NDC_VAP_AcqDX_but_NoVAP_DateinTMPV2 (see [[VAP Dx vs Tmp checking]]) | |||
12. NDC_VAP_No_AcqDX_but_VAP_DateinTMPV2 (see [[VAP Dx vs Tmp checking]]) | |||
13. NDC_VAP_unacceptable_date (see [[VAP Dx vs Tmp checking]]) | |||
''Vet All Sent'' | 14. NDC_unvetted | ||
Once every query has been performed, checked, and cleaned | |||
then perform the first 7 queries to make sure data is all clean and you did not forget any corrections | |||
then ''Vet All Sent'' | |||
This changes the record status 'sent' to 'vetted' | This changes the record status 'sent' to 'vetted' | ||
For Queries 8-13 | |||
we are only monitoring ICU | |||
look for 2014 ''sent'' and see if it has to be investigated | |||
| Line 110: | Line 145: | ||
'''still working on sorting these ones out''' | '''still working on sorting these ones out''' | ||
# NDC_DiffPhin_SameLN_FN_DOB - ? | # NDC_DiffPhin_SameLN_FN_DOB - ? | ||
[[Transfer_Ready_date_and_time#NDC_Missing_TransferDate_w_pivot|NDC_Missing_TransferDate_wPivot]] | |||
[[User: | [[User:Srusnak|Srusnak]] 12:39, 2014 July 17 (CDT) | ||
== Set record as vetted == | == Set record as vetted == | ||