Centralized data Vetting Process: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 1: Line 1:
'' see [[Basic Analysis Capabilities]] for functionality not related to vetting new data
'' see [[Basic Analysis Capabilities]] for functionality not related to vetting new data


Need to resolve all http://ccmdb.kuality.ca/index.php/Special:WhatLinksHere/Centralized_data_Vetting_Process  
'''Need to resolve all http://ccmdb.kuality.ca/index.php/Special:WhatLinksHere/Centralized_data_Vetting_Process '''
# check for any PHIN problems with queries prepared by Trish
 
# find blank PHINs and create PseudoPHIN (use pseudo button on patient viewer)
== Check for problems ==
#* this is likely also the right spot to identify [[Multiple Encounter]] etc, since the step is required anyways
Use [[Centralized_Front_End.mdb]] queries and fix data as needed:
#* this may be also the time to identify continuous admission
*'''need content re. correcting actions. chances are those are already in Pagasa's current append instructions... Ttenbergen 15:01, 2014 January 16 (CST){{discussion}}
# NDC_PHIN_Fake (renamed for consistency)
# NDC_SamePT_Site_Diff_chart - fix
# NDC_Chart_9_Digit - fix
# NDC_DiffPhin_SameLN_FN_DOB - confirm correct (do we have a list for false positives?), fix if needs
# NDC_SamePhinDiff_LN_FN_DOB_Sex - confirm correct (do we have a list for false positives?), fix if needs
 
== Make PseudoPHINs ==
# NDC_PHIN_Blank (renamed for consistency)
# NDC_Highest_PseudoPHIN
 
#[[Query for centralized]]
#[[Query for centralized]]
#* should have a list here as we identify and implement, incl the best order to do this in
#* should have a list here as we identify and implement, incl the best order to do this in




* last: set [[Record Status field]] to "<what?>"
* last: set [[Record Status field]] to "<what?>" {{discussion}}
** how does "vetted" sound? Ttenbergen 15:01, 2014 January 16 (CST)


[[Category:2013 data upgrades]]
[[Category:2013 data upgrades]]
[[Category:Data Processing]]
[[Category:Data Processing]]

Revision as of 15:01, 16 January 2014

see Basic Analysis Capabilities for functionality not related to vetting new data

Need to resolve all http://ccmdb.kuality.ca/index.php/Special:WhatLinksHere/Centralized_data_Vetting_Process

Check for problems

Use Centralized_Front_End.mdb queries and fix data as needed:

  • need content re. correcting actions. chances are those are already in Pagasa's current append instructions... Ttenbergen 15:01, 2014 January 16 (CST)Template:Discussion
  1. NDC_PHIN_Fake (renamed for consistency)
  2. NDC_SamePT_Site_Diff_chart - fix
  3. NDC_Chart_9_Digit - fix
  4. NDC_DiffPhin_SameLN_FN_DOB - confirm correct (do we have a list for false positives?), fix if needs
  5. NDC_SamePhinDiff_LN_FN_DOB_Sex - confirm correct (do we have a list for false positives?), fix if needs

Make PseudoPHINs

  1. NDC_PHIN_Blank (renamed for consistency)
  2. NDC_Highest_PseudoPHIN
  1. Query for centralized
    • should have a list here as we identify and implement, incl the best order to do this in