Mapping labevents table from tabular version to FHIR version

[leyldy]

Hello team,

I'm trying to create a mapping between the sqllite table rows in MIMIC-IV Clinical Database demo (will abbreviate as vTable), to the FHIR resource IDs in MIMIC-IV Clinical Database demo on FHIR (will abbreviate as vFHIR). In doing so, I noticed two potential issues I'd like to get thoughts on:

1. Are the labevents table in vTable not mapping properly to the corresponding resource in vFHIR? For example, I believe the row in vTable where labevent_id = 242151 maps to the FHIR resource in vFHIR Observation/c40df2d3-550c-5bca-8286-5bec8418776d] (see screenshot attached).

However, the FHIR resource shows identifier with value 254612, which should be the labevent_id as indicated by the FHIR mapping documentation and corresponding code. There seems to be a mismatch between the labevent_ids here.

2. Separately, I believe that the FHIR resource ID conversion does not work, even with the “true” ObservationLabevents identifier labevent_id. With the same example as above, when I run the UUID5 conversion with the "true" labevent_id identifier value (which is 254612) attached to the FHIR Resource, I get cf777986-04c0-5ef5-ad16-56ce0e0fbbd9, not the FHIR ID that maps to it: c40df2d3-550c-5bca-8286-5bec8418776d. I have double checked and am closely following the method in this code with uuid_generate_v5 function with correct namespaces (ObservationLabevents, labevent_id), and it still does not map the same way.

This has been a problem specific with the labevents table so I'd like pointers here as to 1) why the labevent_ids do not match between the vTable and vFHIR version, and 2) even when using the "true" labevent_id 254612, why the UUID5 conversion does not match the one mapped to the FHIR resource in vFHIR.

Thank you!