S mapping lab table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
mNo edit summary
m Text replacement - "[[Category: " to "[[Category:"
 
(One intermediate revision by the same user not shown)
Line 13: Line 13:
|-
|-
|| testCode || type ||  value in [[DSM Lab Extract]]
|| testCode || type ||  value in [[DSM Lab Extract]]
|-
|| lastcount || type || count in the first set of data where this was encountered
|-
|-
|| admin || Yes/No||  administrative only, was used during initial decisions which to include  
|| admin || Yes/No||  administrative only, was used during initial decisions which to include  
|-
|-
|| unlikely || Yes/No|| administrative only, was used during initial decisions which to include  
|| unlikely || Yes/No|| administrative only, was used during initial decisions which to include  
|-
|| firstcount || type || count in the first set of data where this was encountered
|-
|-
|| date_listed || Yes/No||  date lab test was first encountered and included in the list
|| date_listed || Yes/No||  date lab test was first encountered and included in the list
|-
|| CBC || Yes/No|| 
|-
|| PT || Yes/No|| 
|-
|| PTT || Yes/No|| 
|-
|| INR || Yes/No|| 
|-
|| Creatinine || Yes/No|| 
|-
|| MG || Yes/No || 
|-
|| SGPT_ALT || Yes/No|| 
|-
|| Troponin || Yes/No|| 
|-
|| ABG || Yes/No||  not used, not consistenly available in DSM data
|-
|| Sputum_CS || Yes/No|| not used, see [[S group table]]
|-
|| Blood_CS || Yes/No||  not used, see [[S group table]]
|-
|| Urine_CS || Yes/No||  not used, see [[S group table]]
|-
|| __APACHE_RELATED__ || text || just a separator for the set of columns
|-
|| AaDO2 || Yes/No|| not used (that would be messy)
|-
|| Arterial_pH || Yes/No||  not used
|-
|| PO2 || Yes/No||  not used
|-
|| SerCO2 || Yes/No||  not used
|-
|| Na || Yes/No||  not used
|-
|| K || Yes/No||  not used
|-
|| CREAT || Yes/No|| Apache Creatinine, likely same as Creatinine
|-
|| HCT || Yes/No|| See CBC above? HCT%...
|-
|| WBC || Yes/No||  not used
|-
|| __Garland__ || text|| separator for the items Dr Garland initially wanted to discuss
|-
|| Lactate || Yes/No || item Dr Garland initially wanted to include
|}
|}




[[Category: Data structure]]
[[Category:Data structure]]
[[Category: DSM Labs Extract]]
[[Category:DSM Labs Extract]]

Latest revision as of 11:05, 30 July 2025

The s_mapping_lab table in DSM Labs Consistency check.accdb contains the possible values of  individual labs as imported from DSM. See Lab identification in the DSM data#individual record for more info how it is used.

Data Structure

field type description
Our_Lab_Name text destination column in L_Labs_DSM table
Their_Lab_Name text value in DSM Lab Extract
testCode type value in DSM Lab Extract
admin Yes/No administrative only, was used during initial decisions which to include
unlikely Yes/No administrative only, was used during initial decisions which to include
firstcount type count in the first set of data where this was encountered
date_listed Yes/No date lab test was first encountered and included in the list
Retrieved from "https://ccmdb.kuality.ca/index.php?title=S_mapping_lab_table&oldid=166878"