Centralized import from Ed.mdb

From CCMDB Wiki
Jump to navigation Jump to search

The Access file Creating Centralized import from Ed.mdb contains the code needed to import Ed's old data into centralized_data.mdb.

It is stored on x:\ccmdb\Centralized import from Ed

Use

Open Modules, make sure paths in public constants on top are correct, run Public Sub Import().

resolutions for differences between ed's and centralized

serials for early CC data

Early CC records don't have serial numbers. I assigned negative numbers arbitrarily to these to be able to generate D_IDs.

duplicates

turned out there were a few duplicates in ed's where a serial was used twice for the same hospital/location. These were resolved in Ed's data and should not be a problem for the final import.

legacy labs

Confirming with Julie that it is OK not to import the legacy ones we are no longer collecting. Ttenbergen

Apache, LOS, etc

Importing these into a table "L_Aux".

extra data

Is there more?

Change Requests

  • add code to import the current "other .mdbs" (or do once, manually... may be no need to code this, it's pretty straightforward)
  • confirm pharmacy is right now
    • can't find the data in orig_tables... emailed Julie to find out more. Ttenbergen 13:05, 2013 December 30 (CST)
  • import tasks from tasks.mdb for consistency Ttenbergen 16:29, 2013 December 30 (CST)

Change Log

ver 2014-01-09

on my desk only for now Ttenbergen 10:08, 2014 January 9 (CST)

  • AP_Chronic to ap_chronic: IIf([orig_cc_apa].[CH]="N","9No CH","0HasChronic") Ttenbergen 10:36, 2014 January 10 (CST)
  • AP_AdmitType: IIf([surgical]=False,"Medical",IIf([ES]="N","Elect.Surg","Surg.Emerg")) Ttenbergen 10:36, 2014 January 10 (CST)

ver 2013-12-23

  • automated running of query "x_Infection_pathogen_fix" upon import. Ttenbergen 14:20, 2013 December 23 (CST)
  • Added MedTMS exported ADL import, table was not being processed before Ttenbergen 17:13, 2013 December 23 (CST)
  • ADLs (ADL General Collection Information)
    • imported table s_ADLOptions to resolve entries needed for l_log.adl_* fields Ttenbergen (2013 December 23)
    • updated query orig_cc_to_L_Log to include ADLs Ttenbergen (2013 December 23)
  • link to s_GCS in centralized.mdb Ttenbergen 12:44, 2013 December 30 (CST)
  • updated query orig_cc_to_L_Log to use s_GCS to populate with values used in CCMDB rather than scores from TMSX Ttenbergen 12:44, 2013 December 30 (CST)
  • changed study 99999 fix to only delete if ((orig_cc_reg.STUDY)=99999 and (orig_cc_reg.CHART)=999999999);" Ttenbergen 12:49, 2013 December 30 (CST)
  • confirmed that L_Labs_Flowsheet has values, ready for validation Ttenbergen 12:55, 2013 December 30 (CST)
  • linked in L_Pharm_Flowsheet Ttenbergen 12:56, 2013 December 30 (CST)
  • added code to import pharmacy from pharmacy.mdb Ttenbergen 14:47, 2013 December 30 (CST)

ver 2013-11-18

This is not the date it was made, but the date documenting started. after I lost and had to find the file. :-)

  • fixed lab importing
  • moved L_aux into centralized db and including in import and linking.
  • set the record_Status to complete for all imported
  • added query "x_Infection_pathogen_fix" to put dx code and pathogen number into their respective places.
  • fixed PHI import query for medicine, it was excluding names and DOB for some reason.
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Centralized_import_from_Ed.mdb&oldid=36412"