L Labs DSM table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m Text replacement - "table table" to "table"
No edit summary
Line 1: Line 1:
[[L_Labs_DSM table]] is a table in [[DSM Labs Consistency check.accdb]] that holds the [[DSM data]] aggregated from the [[DSM Lab Extract]].
[[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 table]] for the table that holds the old manually collected data.  
See [[L_Labs_Flowsheet table]] for the table that holds the old manually collected data.  


== Data Structure ==
== Data Structure ==
Line 32: Line 32:
[[Category:Data structure]]
[[Category:Data structure]]
[[Category:L Table]]
[[Category:L Table]]
[[Category:L_Labs_DSM table|*]]

Revision as of 11:32, 30 November 2017

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