CCMDB Wiki

Centralized data Vetting Process: Difference between revisions

← Older editNewer edit →
m →The Basic Steps: index at top will cover this
m u
Line 39: Line 39:
*close PDA_Pending.mdb
*close PDA_Pending.mdb


== Pull data ==
*[["Pull" Centralized data.mdb]]


===prep CFE for use===
==prep CFE for use==
*Double click to open ''Centralized_data_front_end.mdb''
*Double click to open ''Centralized_data_front_end.mdb''
*click Reconnect
*click Reconnect
==== cross-check tables ====
=== cross-check tables ===
*Open Patient List
*Open Patient List
*on the Left side,
*on the Left side,
Line 55: Line 57:
'''**ALL 3 must be the same**'''
'''**ALL 3 must be the same**'''


=== cross-check tracker sheet ===
 
== cross-check tracker sheet ==
Double check these numbers against the tracker sheet, which compares the old to the new combined centralized numbers
Double check these numbers against the tracker sheet, which compares the old to the new combined centralized numbers


Line 63: Line 66:
* {{discussion}} don't think so, we don't use that any more. Ttenbergen 22:27, 2014 September 29 (CDT)
* {{discussion}} don't think so, we don't use that any more. Ttenbergen 22:27, 2014 September 29 (CDT)


===See who Sent===
==See who Sent==
*[["Pull" Centralized data.mdb]]
 
* Queries
* Queries
* P_Count_Of_Sent (double click)
* P_Count_Of_Sent (double click)
Line 93: Line 96:
**say NO
**say NO
**'''When finished viewing, just close, DO NOT 'save''''
**'''When finished viewing, just close, DO NOT 'save''''
=== Option to view-only data ===
see [["Copying" Centralized data.mdb]]


== Make PseudoPHINs ==
== Make PseudoPHINs ==
Line 105: Line 105:
Perform the Queries in this order:
Perform the Queries in this order:


1. [[Orphans in Centralized data.mdb| "NDC_orphans"]]
# [[Orphans in Centralized data.mdb| "NDC_orphans"]]
 
#* should always be zero
should always be zero
# NDC_Chart_9_Digit
 
# NDC_Diff_Phin__SameLN_FN_DOB
 
#* Home, Advanced, Advanced Filter/Sort, LastName (double click or drag & drop), Sort by ''ascending'', Home, Toggle Filter
2. NDC_Chart_9_Digit
# NDC_SameChart_Site_Diff_Phin
 
# NDC_SamePhin_Diff_LN_FN_DOB_Sex
 
#* Home, Advanced, Advanced Filter/sort, Phin (double click or drag & drop), Sort by ''ascending'', Home, Toggle Filter
3. NDC_Phin Fake or Blank
# NDC_SamePHIN_Site_Diff_chart
 
# NDC_CLI_AcqDX_but_NoCLI_DateinTMPV2 (see [[CLI Dx vs Tmp checking]])
Home
# NDC_CLI_No_AcqDX_but_CLI_DateinTMPV2 (see [[CLI Dx vs Tmp checking]])
 
# NDC_CLI_unacceptable_date (see [[CLI Dx vs Tmp checking]])
Advanced
# 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]])
Advanced Filter Sort
# NDC_VAP_unacceptable_date (see [[VAP Dx vs Tmp checking]])
 
# NDC_unvetted
LastName
 
Ascending
 
Toggle Filter
 
(This sorts by LastName)
 
*''' before assigning pseudo phin, make sure to check for the highest number in ''Highest Pseudo Phin'''''
** what do you do with that info? I thought we assing the pseudophin automatically now... Ttenbergen 09:57, 2014 July 31 (CDT) {{discussion}}
 
'''DO NOT''' assign pseudo Phin if a single, or if 'incomplete'
 
If they have previous encounters, we can correct that unassigned phin with the phin from the previous encounter
 
'''See''' 'Make Pseudo Phins'
 
'''Highest Pseudo Phin'''
When you are in NDC_Highest_Pseudo_Phin, you just want to do a quick check to make sure your assigned pseudo phin will be the correct one
 
Click on the first Phin in the Phin column
 
Right click
 
Sort by ''Largest to Smallest''
 
* {{discussion}} have we ever had the automatic process not assign the right next pseudophin? If not this may not be a required check. If we do want to keep doing this then let's fix the NDC query to not have to sort. Ttenbergen 09:59, 2014 July 31 (CDT)
 
Then when you assign a pseudo phin, you will see that the next assigned phin will be the next one after that highest one,  e.g.  highest psuedo phin is 7432, then the next assigned pseudo phin will be 7433
 
 
 
4. NDC_Diff_Phin__SameLN_FN_DOB
 
Home
 
Advanced
 
Advanced Filter/Sort
 
LastName (double click or drag & drop)
 
Sort by ''ascending''
 
Home
 
Toggle Filter
 
 
5. NDC_SameChart_Site_Diff_Phin
 
 
6. NDC_SamePhin_Diff_LN_FN_DOB_Sex
 
Home
 
Advanced
 
Advanced Filter/sort
 
Phin (double click or drag & drop)
 
Sort by ''ascending''
 
Home
 
Toggle Filter
 
7. NDC_SamePHIN_Site_Diff_chart
 
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]])
 
14. NDC_unvetted
 
 
Once every query has been performed, checked, and cleaned
 
then perform the first 7 queries once more, 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'
 
 
For Queries 8-13
 
we are only monitoring ICU
 
look for 2014 ''sent'' and see if it has to be investigated
 


*****For Queries 8-13
******we are only monitoring ICU
*******look for 2014 ''sent'' and see if it has to be investigated
********{{discussion}} what is this about? Do queries need tweaks? Ttenbergen 23:20, 2014 September 29 (CDT)


Once every query has been performed, checked, and cleaned perform the first 7 queries once more, to make sure data is all clean and you did not forget any corrections.




'''still working on this one''' (have not done this one yet)
* '''still working on this one''' (have not done this one yet)
** [[Transfer_Ready_date_and_time #NDC_Missing_TransferDate_w_pivot|NDC_Missing_TransferDate_wPivot]]
*** {{discussion}} what needs doing? Ttenbergen 23:20, 2014 September 29 (CDT)


[[Transfer_Ready_date_and_time #NDC_Missing_TransferDate_w_pivot|NDC_Missing_TransferDate_wPivot]]




[[User:Srusnak|Srusnak]] 12:01, 2014 July 23 (CDT)


== Set record as vetted ==
== Set record as vetted ==
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Centralized_data_Vetting_Process"