Validating new types of DSM results

From CCMDB Wiki
Jump to navigation Jump to search

Occasionally new types of lab results are encountered in the DSM data in the process of Instructions for importing a batch of DSM Data. This page explains what to do when these arrive, and logs the state of what we are doing.

Process

Find out if they need to be added

  • open the following queries (they are based on labs imported within the last hour, so do this right away)
    • s_group, sort by "added_dt" and review today's only
    • s_mapping_lab, sort by "date_listed" and review today's only
  • email a list of the new result names to Lisa and Allan. Include something like the following in the email:
The below labs started showing up in the most recent DSM extract. We need to ensure that (a) they don't need to be included to be counted toward https://ccmdb.kuality.ca/index.php?title=DSM_data, and (b) they don't include anything we want to start collecting now. Could you please review the list and inform Tina, Julie and Pagasa if action is required. 
<paste list>

Confirm this would not result in double-counting

If new listings appear related to what we count, we need to find out how they relate to the existing coding. Some labs generate multiple results lines, so we need to make sure that we use the most representative results lines to count toward our labs. That is, we may already count a given lab even without adding the newly found one, and adding it could lead to double-counting.

We can review the data to see if other results show up in the same batch of samples sent that appear to do this, but we really should contact the DSM / Labs data people to find out how to interpret this.

Email Dr. Allan Garland who will contact DSM.

Add if needed

If we identify them as something we need to add, then we need to update the following to start counting them:

Log

JALT

  • There is a long-outstanding request to Allan to map the new labs that have come in in the last few months. I emailed a list this evening to get this done. This is currently on the agenda for the Task meeting as well. Ttenbergen 22:11, 2022 April 20 (CDT)
    • Discussed at JALT, Allan has heard back and meeting is being booked. Ttenbergen 10:01, 2022 August 24 (CDT)
    • Discussed at Task, meeting was booked for week after Sept 28. Ttenbergen 10:27, 2022 October 19 (CDT)
  • SMW


  • Cargo


  • Categories

Related articles

Related articles: