Centralized data Vetting Process

From CCMDB Wiki
Jump to navigation Jump to search

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

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. started in centralized front end: See 8a above: VAPinAcqDX_NoVAP_DateinTMPV2
  2. started in centralize front end: see 8b above: 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=36816"