Centralized import from Ed.mdb: Difference between revisions

No edit summary
No edit summary
Line 12: Line 12:
=== duplicates ===
=== 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.
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 ===
=== extra data ===
Ed's program stores a bunch of extra data such as apache scores and legacy info.
  Is there more?
  Need to address...


== Fixes still needed ==
== Fixes still needed ==
* labs
** split labs into legacy and regular labs; in legacy, name the fields something like CBC_L38
* acquired pathogen is not going into centralized properly... (says my note; I think this is about the sent ones, not the imported ones)
* acquired pathogen is not going into centralized properly... (says my note; I think this is about the sent ones, not the imported ones)