|
|
| (114 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.mdb]] |
| | * 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.mdb]] to return data to [[Regional Server]] so [[Data collector]]s can [[send]] |
|
| |
|
| Deadline for collectors to send is Thursday at 1pm.
| | == Related articles == |
| | {{Related Articles}} |
|
| |
|
| When you 'pull'
| |
|
| |
|
| ''centralized.mdb''
| |
|
| |
| and ''phi.mdb''
| |
|
| |
| It goes into the desktop ''centralized_on_c'' (folder icon)
| |
|
| |
| from the ''RegionalWRHA'' (wreath icon)
| |
|
| |
| Pull is for the data processor to do edits, etc.
| |
|
| |
| Push is for everyone else to see the data
| |
|
| |
| '''**''' Before going home
| |
|
| |
| '''ALWAYS''' make sure you are in the 'push' mode
| |
|
| |
| [[User:Srusnak|Srusnak]] 12:46, 2014 July 17 (CDT)
| |
|
| |
| ==clean ups==
| |
| === do ONLY once when we import Ed's to centralized.mdb ===
| |
| * ''1use_only_update_3000_transfer_dates_to_null''
| |
|
| |
| == 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
| |
|
| |
|
| |
| When you are in
| |
|
| |
| NDC_Phin Fake or Blank
| |
|
| |
| sort 'RecStatus' by ZtoA
| |
|
| |
| sort by LastName
| |
|
| |
|
| |
|
| |
| Check the 'cat' first to make sure if a single encounter or a multiple encounter
| |
|
| |
| If a multiple encounter, then copy & paste the already assigned Phin
| |
|
| |
|
| |
| To change the Phin
| |
|
| |
| Go on the 'binoculars' for that patient
| |
|
| |
| delete the erroneous Phin, or the zero
| |
|
| |
| click on the 'pseudo' button, and it will automatically asign a Phin
| |
|
| |
| then it will prompt 'Do you want to ...'
| |
|
| |
| say 'yes'
| |
|
| |
| == 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"'''
| |
|
| |
| Perform the Queries in this order:
| |
|
| |
| 1. [[Orphans in Centralized data.mdb| "NDC_orphans"]]
| |
|
| |
| should always be zero
| |
|
| |
|
| |
| 2. NDC_Chart_9_Digit
| |
|
| |
|
| |
| 3. NDC_Phin Fake or Blank
| |
|
| |
| Home
| |
|
| |
| Advanced
| |
|
| |
| Advanced Filter Sort
| |
|
| |
| LastName
| |
|
| |
| Ascending
| |
|
| |
| Toggle Filter
| |
|
| |
| (This sorts by LastName)
| |
|
| |
| '''**''' before assigning phin, make sure to check for the highest number in ''Highest Pseudo Phin''
| |
|
| |
| Right click
| |
|
| |
| sort by highest to lowest
| |
|
| |
| '''DO NOT''' assign pseudo Phin if a single, or if 'incomplete'
| |
|
| |
| If they have previous encounters, we can assign a phin
| |
|
| |
|
| |
| 4. NDC_Diff_Phin__SameLN_FN_DOB
| |
|
| |
| Home
| |
|
| |
| Advanced
| |
|
| |
| Advanced Filter/Sort
| |
|
| |
| LastName (double click or drag & drop)
| |
|
| |
| Sort by ''ascending''
| |
|
| |
| Home
| |
|
| |
| Toggle Filter
| |
|
| |
|
| |
| 5. NDC_SameChart_Site_Diff_Phin
| |
|
| |
|
| |
| 6. NDC_SamePhin_Diff_LN_FN_DOB_Sex
| |
|
| |
| Home
| |
|
| |
| Advanced
| |
|
| |
| Advanced Filter/sort
| |
|
| |
| Phin (double click or drag & drop)
| |
|
| |
| Sort by ''ascending''
| |
|
| |
| Home
| |
|
| |
| Toggle Filter
| |
|
| |
| 7. NDC_SamePHIN_Site_Diff_chart
| |
|
| |
| 8. NDC_CLI_AcqDX_but_NoCLI_DateinTMPV2 (see [[CLI Dx vs Tmp checking]])
| |
|
| |
| 9. NDC_CLI_No_AcqDX_but_CLI_DateinTMPV2 (see [[CLI Dx vs Tmp checking]])
| |
|
| |
| 10. NDC_CLI_unacceptable_date (see [[CLI Dx vs Tmp checking]])
| |
|
| |
| 11. NDC_VAP_AcqDX_but_NoVAP_DateinTMPV2 (see [[VAP Dx vs Tmp checking]])
| |
|
| |
| 12. NDC_VAP_No_AcqDX_but_VAP_DateinTMPV2 (see [[VAP Dx vs Tmp checking]])
| |
|
| |
| 13. NDC_VAP_unacceptable_date (see [[VAP Dx vs Tmp checking]])
| |
|
| |
| 14. NDC_unvetted
| |
|
| |
|
| |
| Once every query has been performed, checked, and cleaned
| |
|
| |
| then perform the first 7 queries once more, to make sure data is all clean and you did not forget any corrections
| |
|
| |
| then ''Vet All Sent''
| |
|
| |
| This changes the record status 'sent' to 'vetted'
| |
|
| |
|
| |
| For Queries 8-13
| |
|
| |
| we are only monitoring ICU
| |
|
| |
| look for 2014 ''sent'' and see if it has to be investigated
| |
|
| |
|
| |
|
| |
| '''still working on this one''' (have not done this one yet)
| |
|
| |
| [[Transfer_Ready_date_and_time #NDC_Missing_TransferDate_w_pivot|NDC_Missing_TransferDate_wPivot]]
| |
|
| |
| [[User:Srusnak|Srusnak]] 13:01, 2014 July 17 (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.
| |
|
| |
| Once all data is clean, then we can ''Vet All Sent''
| |
|
| |
| To Push data
| |
|
| |
| Go to Centalized_CCMDB folder
| |
|
| |
| Push_up_centralized_data.vbs
| |
|
| |
| prompts 'do you want to ...'
| |
|
| |
| click 'yes'
| |
|
| |
| when it is done, it will prompt 'finished'
| |
|
| |
| click 'ok'
| |
|
| |
| [[User:Srusnak|Srusnak]] 13:10, 2014 July 17 (CDT)
| |
|
| |
| == 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]] |
|
| |
| At the end of the day, before going home,
| |
|
| |
| '''ALWAYS''' make sure you are in the ''push'' mode
| |
|
| |
| and
| |
| make sure to perform a ''Back Up''
| |
|
| |
| BACK UP PROCEDURE
| |
|
| |
| Click on
| |
|
| |
| ''Pagasa's Desktop'' (folder icon)
| |
|
| |
| ''CCMIS Batch_Files''
| |
|
| |
| ''1BackUp.bat''
| |
|
| |
| press ''any key to continue''
| |
|
| |
| enter
| |
|
| |
| wait for it to do the back up
| |
|
| |
| then it will say
| |
|
| |
| ''processing complete''
| |
|
| |
| press any key to continue
| |
|
| |
| [[User:Srusnak|Srusnak]] 11:56, 2014 July 17 (CDT)
| |