|
|
| (180 intermediate revisions by 4 users not shown) |
| Line 1: |
Line 1: |
| | "Vetting" is our name for the initial quality control our data goes through after [[Data collector]]s finish [[sending]] it. It is one of the main responsibilities of the [[Data Processor]]. |
|
| |
|
| {{Discussion}}
| | == Instructions == |
| 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. [[User:TOstryzniuk|Trish Ostryzniuk]] 15:29, 2014 January 24 (CST)
| | * [["Pull" Centralized_data.accdb]] |
| | * Double click to open ''Centralized_data_front_end.mdb'' |
| | * [[Reconnect CFE and initial error checks]] |
| | * [[Pre-linking checks]] (PL checks) |
| | * [[Populate linking_pairs]] |
| | * [[Correcting suspect links]] |
| | * [[Quality Assurance queries in CFE]] - NDC Queries |
| | ** as part of any of those, there might be [[Questioning data back to collectors]] |
| | * [["Vet all sent" button]] |
| | * [[Generate Person IDs]] |
| | * [["Push" Centralized_data.accdb]] to return data to [[Regional Server]] so [[Data collector]]s can [[send]] |
|
| |
|
| '' see [[Basic Analysis Capabilities]] for functionality not related to vetting new data
| | == Related articles == |
| | {{Related Articles}} |
|
| |
|
| '''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:
| |
| # NDC_PHIN_Fake_Blank
| |
| # NDC_Highest_PseudoPhin
| |
| # NDC_SamePHIN_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_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 ==
| |
| #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)''
| |
| #need to create: VAPinAcqDX_NoVAP_DateinTMPV2
| |
| #need to create: No_VAPinAcqDX_VAP_dateinTMPV2
| |
| #need to create: CLIinAcqDX_NoCLI_DateinTMPV2
| |
| #need to create: No_CLIinAcqDX_CLI_DateinTMPV2
| |
|
| |
| == Make PseudoPHINs ==
| |
| # NDC_PHIN_Blank (renamed for consistency)
| |
| # NDC_Highest_PseudoPHIN
| |
|
| |
| == any other checks after pseudoPhin? ==
| |
| {{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) {{discussion}}
| |
| **How and when do you see Pagasa using this field?
| |
|
| |
|
| |
|
| |
| [[Category:2013 data upgrades]]
| |
| [[Category: Data Processing]]
| |
| [[Category:Data Processing]] | | [[Category:Data Processing]] |