Lab identification in the DSM data: Difference between revisions
Ttenbergen (talk | contribs) m →Matching: m |
Ttenbergen (talk | contribs) m explanation how matching is done. |
||
| Line 2: | Line 2: | ||
== Matching == | == Matching == | ||
One labs record is generated for each day. A sum of them can be viewed using query ''L_Labs_Flowsheet_sum''. | |||
=== individual record === | === 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]]. | 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 === | === 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]]. | 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 == | == Updates / new labs == | ||
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. | 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. | ||
[[Category: DSM Labs Extract]] | [[Category: DSM Labs Extract]] | ||
Revision as of 18:17, 25 August 2017
This article describes how labs are identified in the DSM Lab Extract during importing.
Matching
One labs record is generated for each day. A sum of them can be viewed using query L_Labs_Flowsheet_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 labs
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.