L Labs DSM table: Difference between revisions
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 | 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 |