CCMDB Wiki

Centralized data Vetting Process

Revision as of 12:50, 13 March 2014 by Ttenbergen (talk | contribs) (→changes needing to be implemented: moved CCMDB change requests to Requested_CCMDB_changes_for_the_next_version)

see also Query for centralized for now. 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.

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:

  1. open the patient from the patient list
  2. click the pseudo button to the left of the PHIN field label
  3. 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:

  1. NDC_SamePHIN_Site_Diff_chart - fix
  2. NDC_Chart_9_Digit - fix
  3. NDC_DiffPhin_SameLN_FN_DOB - ?
  4. NDC_SamePhin_Diff_LN_FN_DOB_Sex - ?
  5. NDC_SameChart_site_Diff_PHIN
  6. NDC_Missing_TransferDate_wPivot
  7. a) started: NDC_VAPinAcqDX_NoVAP_DateinTMPV2
    • b)started: ND_sub_VAPinAcqDX_NoVAP_DateinTMPV2_sub_TMPV2_component
  8. a) started: NDC_No_VAPinAcqDX_VAP_dateinTMPV2
    • b)started: ND_sub_NoVAPinAcqDX_VAP_DateinTMPV2_sub_had_VAP_acqDX
  9. need to create: CLIinAcqDX_NoCLI_DateinTMPV2
  10. need to create: No_CLIinAcqDX_CLI_DateinTMPV2

Set record as vetted

Template: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.

Retrieved from "https://ccmdb.kuality.ca/index.php?title=Centralized_data_Vetting_Process&oldid=37553"