DSM Lab Extract: Difference between revisions
Ttenbergen (talk | contribs) m →Log: requested a new output from Alun because missing time for "arrived" means comparisons will always be off |
Ttenbergen (talk | contribs) m →Outstanding Issues: m |
||
| Line 3: | Line 3: | ||
== Outstanding Issues == | == Outstanding Issues == | ||
=== additional labs === | === additional labs === | ||
we want at least NA, K, Lactate but Allan Garland is consulting with colleagues to find out if we need additional | *we want at least NA, K, Lactate but Allan Garland is consulting with colleagues to find out if we need additional | ||
** Lactacte, NA and K are included with current output. | |||
| Line 12: | Line 12: | ||
When DSM sent the original batch of data they were not sure yet about how to extract cultures. We discussed this on the phone on our meeting on Aug 14 but I have not followed this up with an email and will not right now because the data looks so bad I don't know if we will want to pursue this. | When DSM sent the original batch of data they were not sure yet about how to extract cultures. We discussed this on the phone on our meeting on Aug 14 but I have not followed this up with an email and will not right now because the data looks so bad I don't know if we will want to pursue this. | ||
==== Blood ==== | |||
==== Sputum ==== | |||
Site = Sputum? There are a lot | |||
==== Urine ==== | |||
Site = Urine? There are a handful 18 | |||
=== missing PHINs === | === missing PHINs === | ||
| Line 29: | Line 33: | ||
She said they have "arrival time" - presumably they always have an entry for that, so it might be better. Are there circumstances where the diff between these would be so great to make arrival time useless? Maybe get both and use arrival time if collected time is blank? | She said they have "arrival time" - presumably they always have an entry for that, so it might be better. Are there circumstances where the diff between these would be so great to make arrival time useless? Maybe get both and use arrival time if collected time is blank? | ||
=== Special Cases in results === | |||
What is | |||
: *&DEL | |||
=== duplicate records === | |||
There were 1,865,570 records in the export. | |||
There were 1,863,373 unique records. | |||
Why the duplicates? | |||
== Requesting data == | == Requesting data == | ||