L Labs DSM table

From CCMDB Wiki
Jump to navigationJump to search

L_Labs_DSM table is a table in DSM Labs Consistency check.accdb that holds the DSM data aggregated from the DSM Lab Extract.

See L_Labs_Flowsheet table for the table that holds the old manually collected data.

Data Structure

column field type description
1 D_ID text(18) D ID field
2 Import_DtTm DtTm Date and time imported
3 Lab_DtTm DtTm Date and time of the test
4 Lab text(20) Our name for the lab
5 TestResult text(10) result of the test
6 DSM_RequestNo text(14) Unique ID per lab request
7 DSM_GrpCode text(10) link to S group table
8 DSM_TestCode Long integer link to S mapping lab table

Related articles

Related articles: