|
|
| (162 intermediate revisions by 4 users not shown) |
| Line 1: |
Line 1: |
| ''see also [[Query for centralized]] for now.
| | "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]]. |
| '' 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 ''' | | == Instructions == |
| | * [["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]] |
|
| |
|
| need to make sure all in [[Data Appending Process]] is addressed.
| | == Related articles == |
| | {{Related Articles}} |
|
| |
|
| == Pull down data ==
| |
| '''not yet implemented... Ttenbergen 11:43, 2014 February 9 (CST)
| |
|
| |
|
| Before processing run [[Pull_down_centralized_data.bat]] to do backups and move data from the regional server for local processing. This also prevents collectors from sending while data is being processed.
| |
|
| |
| == Make PseudoPHINs ==
| |
| If it is determined that a patient legitimately without PHIN (e.g. out of province) has not been encountered before, generate a [[PseudoPHIN]]:
| |
| # open the patient from the patient list
| |
| # click the '''pseudo''' button to the left of the PHIN field label
| |
| # the program will look up the highest previous PseudoPHIN and enter that + 1 into the PHIN field
| |
|
| |
| == Check for problems ==
| |
| Use [[Centralized data front end.mdb]] "NDC" (New Data Check) queries and fix data as needed:
| |
| # NDC_SamePHIN_Site_Diff_chart - fix
| |
| # NDC_Chart_9_Digit - fix
| |
| # NDC_DiffPhin_SameLN_FN_DOB - ?
| |
| # NDC_SamePhin_Diff_LN_FN_DOB_Sex - ?
| |
| # NDC_SameChart_site_Diff_PHIN
| |
| # NDC_Missing_TransferDate_wPivot
| |
| #a) started: NDC_VAPinAcqDX_NoVAP_DateinTMPV2-Not working.
| |
| #*b)started: ND_sub_VAPinAcqDX_NoVAP_DateinTMPV2_sub_TMPV2_component
| |
| #a) started: NDC_No_VAPinAcqDX_VAP_dateinTMPV2-Not working.
| |
| #*b)started: ND_sub_NoVAPinAcqDX_VAP_DateinTMPV2_sub_had_VAP_acqDX
| |
| #need to create: CLIinAcqDX_NoCLI_DateinTMPV2
| |
| #need to create: No_CLIinAcqDX_CLI_DateinTMPV2
| |
|
| |
| == Set record as vetted ==
| |
| {{discussion}}
| |
| * last: set [[Record Status field]] to ... how does "vetted" sound? if so, get rid of this comment. Ttenbergen 15:01, 2014 January 16 (CST)
| |
| ** How and when do you see Pagasa using this field?
| |
| *** record that with recordstatus = vetted has been processed and cleaned to the level (or better) previously done during appending and Julie-checks. Once the record is set to this Julie knows she can use this with confidence, e.g. for reports. Ttenbergen 14:15, 2014 March 11 (CDT)
| |
|
| |
| == Push up data ==
| |
| '''not yet implemented... Ttenbergen 11:43, 2014 February 9 (CST)
| |
|
| |
| When all processing is done, run [[Push_up_centralized_data.bat]] to return the data to where collectors can add to it.
| |
|
| |
| [[Category:2013 data upgrades]]
| |
| [[Category:Data Processing]] | | [[Category:Data Processing]] |