Lab identification in the DSM data

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

Matching

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.

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.

Updates

The import function 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.