Centralized data Vetting Process: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older editNewer edit →
No edit summary
TOstryzniuk (talk | contribs)
CCMDB_legit, approved, Bureaucrats, Administrators
27,522 edits
Line 11: Line 11:
== Check for problems ==
== Check for problems ==
Use [[Centralized data front end.mdb]] "NDC" (New Data Check) queries and fix data as needed:  
Use [[Centralized data front end.mdb]] "NDC" (New Data Check) queries and fix data as needed:  
# NDC_PHIN_Fake_Blank
# NDC_Highest_PseudoPhin
# NDC_Highest_PseudoPhin
# NDC_PHIN_Fake_Blank
# NDC_SamePHIN_Site_Diff_chart - fix
# NDC_SamePHIN_Site_Diff_chart - fix
# NDC_Chart_9_Digit - 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_DiffPhin_SameLN_FN_DOB - confirm correct (do we have a list for false positives?), fix if needs
# NDC_SamePhin_Diff_LN_FN_DOB_Sex - confirm correct (do we have a list for false positives?), fix if needs
# NDC_SamePhin_Diff_LN_FN_DOB_Sex - confirm correct (do we have a list for false positives?), fix if needs
#NDC_SameChart_site_Diff_PHIN
#a) started: NDC_VAPinAcqDX_NoVAP_DateinTMPV2
#*b)started: ND_sub_VAPinAcqDX_NoVAP_DateinTMPV2_sub_TMPV2
#Started: NDC_No_VAPinAcqDX_VAP_dateinTMPV2
#need to create: CLIinAcqDX_NoCLI_DateinTMPV2
#need to create: No_CLIinAcqDX_CLI_DateinTMPV2


== changes needing to be implemented ==
== changes needing to be implemented ==

Revision as of 12:39, 7 February 2014

Template:Discussion Where is the article that listed the 6 QA checks and the Pivot article? I need to show Pagasa how is was transcribe into this here. Trish Ostryzniuk 15:29, 2014 January 24 (CST)

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 make sure all in Data Appending Process is addressed.

Check for problems

Use Centralized data front end.mdb "NDC" (New Data Check) queries and fix data as needed:

  1. NDC_PHIN_Fake_Blank
  2. NDC_Highest_PseudoPhin
  3. NDC_SamePHIN_Site_Diff_chart - fix
  4. NDC_Chart_9_Digit - fix
  5. NDC_DiffPhin_SameLN_FN_DOB - confirm correct (do we have a list for false positives?), fix if needs
  6. NDC_SamePhin_Diff_LN_FN_DOB_Sex - confirm correct (do we have a list for false positives?), fix if needs
  7. NDC_SameChart_site_Diff_PHIN
  8. a) started: NDC_VAPinAcqDX_NoVAP_DateinTMPV2
    • b)started: ND_sub_VAPinAcqDX_NoVAP_DateinTMPV2_sub_TMPV2
  9. Started: NDC_No_VAPinAcqDX_VAP_dateinTMPV2
  10. need to create: CLIinAcqDX_NoCLI_DateinTMPV2
  11. need to create: No_CLIinAcqDX_CLI_DateinTMPV2

changes needing to be implemented

  1. need to create: NDC_SameChart_site_Diff_PHIN

CCMDB changes

the following could be done in CCMDB.mdb since all data is already available at collection; still can also do them in front end, should implement them so they translate easily... Ttenbergen 11:22, 2014 February 5 (CST)

  1. need to create: VAPinAcqDX_NoVAP_DateinTMPV2
  2. need to create: No_VAPinAcqDX_VAP_dateinTMPV2
  3. need to create: CLIinAcqDX_NoCLI_DateinTMPV2
  4. need to create: No_CLIinAcqDX_CLI_DateinTMPV2

Make PseudoPHINs

  1. NDC_PHIN_Blank (renamed for consistency)
  2. NDC_Highest_PseudoPHIN

any other checks after pseudoPhin?

Template:Discussion

Set record as vetted

  • last: set Record Status field to ... how does "vetted" sound? if so, get rid of this comment. Ttenbergen 15:01, 2014 January 16 (CST) Template:Discussion
    • How and when do you see Pagasa using this field?
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Centralized_data_Vetting_Process&oldid=36813"