|
|
| (147 intermediate revisions by 4 users not shown) |
| Line 1: |
Line 1: |
| *'''need to make sure all in [[Data Appending Process]] is addressed.'''
| | "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]]. |
|
| |
|
| == Pull down data == | | == Instructions == |
| Before processing run [[Pull_down_centralized_data.vbs]] to do backups and move data from the regional server for local processing. This also prevents collectors from sending while data is being processed.
| | * [["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]] |
|
| |
|
| == Make PseudoPHINs == | | == Related articles == |
| If it is determined that a patient legitimately without PHIN (e.g. out of province) has not been encountered before, generate a [[PseudoPHIN]]:
| | {{Related Articles}} |
| # 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; if a patient shows up in one of the queries fix if possible; if question to collector is required, set '''[[Record Status field]] to "questioned"'''.
| |
| # 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 ([[Transfer_Ready_date_and_time]])
| |
| # NDC_VAPinAcqDX_NoVAP_DateinTMPV2
| |
| #* records for which a complication 3900 exists and for which a corresponding tmp entry with item "VAP" and datevar <> null does not exist
| |
| #* uses subquery "ND_Sub_VAPinAcqDX_NoVAP_DateinTMPV2_Sub_TMPV2_Component"
| |
| # NDC_No_VAPinAcqDX_VAP_dateinTMPV2
| |
| #* records that have a tmp entry with item "VAP" for which a l_dxs complication entry with code 3900 does not exist
| |
| #* uses query ND_sub_NoVAPinAcqDX_VAP_DateinTMPV2_sub_had_VAP_acqDX
| |
| # NDC_CLIinAcqDX_NoCLI_DateinTMPV2
| |
| #* records for which a complication 8600 exists and for which a corresponding tmp entry with item "CLI" and datevar <> null does not exist
| |
| #* uses subquery "ND_sub_CLI_DateinTMPV2"
| |
| # NDC_No_CLIinAcqDX_CLI_DateinTMPV2
| |
| #* records that have a tmp entry with item "CLI" for which a l_dxs complication entry with code 8600 does not exist
| |
| #* uses subquery "ND_sub_has_dx8600"
| |
|
| |
|
| {{discussion}} where in here does [[Orphans in Centralized data.mdb| "NDC_orphans"]] best fit? Ttenbergen 20:19, 2014 May 1 (CDT)
| |
|
| |
| == Set record as vetted ==
| |
| At this point all records with problems will have had the [[Record Status field]] set to "questioned" so the remaining ones that are set to "sent" are clean and can be set to "vetted". Press the "vet all sent" button. This will change all records currently set to "sent" to "vetted".
| |
|
| |
| == Push up data ==
| |
| When all processing is done, run [[Push_up_centralized_data.vbs]] to return the data to where collectors can add to it.
| |
|
| |
| == Confirm data backups ==
| |
| Until we are comfortable with the process working, check that the backups for centralized are being created as they should be b [[Pull down centralized data.vbs]] and [[Push up centralized data.vbs]]. Once we are confident I would recommend a monthly Outlook task to check, with the link to the directory included. Ttenbergen 16:43, 2014 April 30 (CDT)
| |
|
| |
| As per Trish, moved from [[1Backup.bat]], the [[Data Processor]] must regularly (at least once per week) check if backup went to location expected or not. In the past main office has experienced backup batch files that for some reason stopped working. Because no one did regular checks we had long period with with no backup![[User:TOstryzniuk|Trish Ostryzniuk]] 18:54, 2014 April 29 (CDT)
| |
|
| |
| [[Category:2013 data upgrades]]
| |
| [[Category:Data Processing]] | | [[Category:Data Processing]] |