eicu-code
eicu-code copied to clipboard
`lab` table - understanding the difference between 'labmeasurenameinterface' and 'labmeasurenamesystem'
Hi,
I'm struggling to understand the difference in meaning between labmeasurenameinterface and labmeasurenamesystem. If I look at a labname like CRP or CRP-hs, there doesn't seem to be a consistent pattern between their units (in terms of either mg/L or mg/dL).
To give an example using the following sampled table, I am struggling to figure out the actual unit for the value in labresult and also why labresult and labresulttext will sometimes (but not always) differ by a factor of 10.
For the latter issue - as far as I can tell, this only happens when labmeasurenameinterface is mg/L, but not all the time, and not with any correlation to labmeasurenamesystem. Any insights here?
| patientunitstayid | labresultoffset | labname | labresult | labresulttext | labmeasurenameinterface | labmeasurenamesystem |
|---|---|---|---|---|---|---|
| 244649 | -104 | CRP | 4.0 | 4.0 | mg/dL | mg/dL |
| 254358 | -3787 | CRP-hs | 41.66 | 41.66 | mg/dL | mg/L |
| 254358 | 4973 | CRP-hs | 1.7 | 1.70 | mg/dL | mg/L |
| 257301 | 25879 | CRP | 25.0 | 25.0 | mg/dL | mg/dL |
| 263285 | -1 | CRP | 13.0 | 1.3 | mg/L | mg/dL |
| 264849 | 41 | CRP | 4535.0 | 453.5 | mg/L | mg/dL |
| 266128 | 1207 | CRP | 454.0 | 45.4 | mg/L | mg/dL |
| 276487 | 7050 | CRP-hs | 1.97 | 1.97 | mg/dL | mg/L |
| 284593 | -1192 | CRP | 22.0 | 2.2 | mg/L | mg/dL |
| 3125720 | -2534 | CRP-hs | 172.0 | 172.0 | mg/L | mg/L |
| 3132008 | -10291 | CRP | 241.0 | 241.0 | mg/L | mg/dL |