L Labs DSM table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m (changed heading so it works better when transcluded in Data dictionary) |
Ttenbergen (talk | contribs) mNo edit summary |
||
Line 27: | Line 27: | ||
||8 || '''DSM_TestCode''' || Long integer || link to [[S mapping lab table]] | ||8 || '''DSM_TestCode''' || Long integer || link to [[S mapping lab table]] | ||
|} | |} | ||
== Related articles == | |||
{{Related Articles}} | |||
Revision as of 14:34, 2020 May 14
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: |
|