Lab identification in the DSM data

This article describes how labs are identified in the DSM Lab Extract during importing.

Matching

Each lab is imported with a value.

Lab_DtTm

The field Lab_DtTm in L_Labs_DSM table is generated as follows from the inconsistenly populated fields in the export:

• LabDtTm_str = "CDate(Nz([COLLECTEDDATE], [arriveddate])) + CDate(Nz([CollectedTime], [LabarrivedTime]))"
  • ie use collected dttm if available, else use arrived dttm

Start of date range

The Lab_DtTm is compared to the admit time of the patient as follows:

• " WHERE ([Arrive_DtTm]<=" & LabDtTm_str & ") AND (" & LabDtTm_str & "<=nz([Dispo_DtTm],now())) "
  • ie we start the range with the Arrive_DtTm, not the Accept_DtTm

We should change this; however, do we only change it going forward or do we also re-import back data? Julie is about to re-import back data until 2019-01-01, so maybe we should reimport back data for all that far? shouldn't it be Accept_DtTm and use Arrive_DtTm if Accept_DtTm is blank. We have discussed that in the Project Boarding Loc, we can still determine the counts in between Accept_DtTm and Arrive_DtTm if needed. --JMojica 10:25, 2019 December 10 (CST) That is pretty much what I mean, it should be as you say. Do we want to do this going back in data as you re-import, or just going forward for future imports? Ttenbergen 09:41, 2019 December 11 (CST)

• SMW

• Cargo

• Categories

counts

We originally did labs as counts. A count of them can be viewed using query L_Labs_Flowsheet_DSM_sum.

individual record

Most of the lab tests we count are one DSM line per lab done, and the best way to identify them was based on the TESTCODE column in the DSM Lab Extract. hat column is compared to table s_mapping_lab by query 2_D_counts_test_appender to populate table L_Labs_Flowsheet_DSM.

group of records

Some other lab tests lead to multiple results and are reported as a group of lines per lab done. The best way to identify them was based on the GRPTEST column in the DSM Lab Extract. That column is compared to table s_group by query 2_D_counts_group_appender to populate table L_Labs_Flowsheet_DSM.

Updates / new lab Name or Labels in DSM

The import process checks for values not previously seen on each import. If there are new ones it adds them to the list and alerts the user to decide if they should count toward one of the labs we collect.