Centralized import from Ed.mdb: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
Line 33: | Line 33: | ||
== Change Log == | == Change Log == | ||
=== ver 2013-12-23 === | === ver 2013-12-23 === | ||
* automated running of query "x_Infection_pathogen_fix" upon import. Ttenbergen 14:20, 2013 December 23 (CST) | |||
=== ver 2013-11-18 === | === ver 2013-11-18 === |
Revision as of 15:20, 2013 December 23
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
- automate running of phathogen fixer
- add code to import the current "other .mdbs"
- import and make sure the translation and scoring is right
- ADLs (ADL General Collection Information)
- GCS
- ensure that Study numbers 99999 is accomodated properly
- confirm pharmacy and labs is right now
Change Log
ver 2013-12-23
- automated running of query "x_Infection_pathogen_fix" upon import. Ttenbergen 14:20, 2013 December 23 (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.