Laboratory Data

From SICDB Doc
Revision as of 08:59, 1 November 2022 by Salkin (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Data Description laboratory.csv.gz

The laboratory table contains all available lab data, in many cases including the pre-admission labs.

Like all "Reference" fields additional data like name and unit of measurement is found in d_references. See SQL Examples to learn how to connect them using a relational database system.

To simplify lookup for labs of previous stays PatientID was added to this table.


laboratory.csv.gz
Name Type Description Comment
id Integer Primary Key
CaseID Integer Case identifier
PatientID Integer Patient identifier
DrugID Reference
Offset Integer Time in seconds after admission
LaboratoryValue Float Value Unity of measurement can be found in d_references
LaboratoryType Reference Used for special laboratory types, i.e. arterial blood gas.


Predefined Fields (RooDataServer)

Generic Signal
Name Description Comment Type
LaboratoryCount Amount of results of selected laboratory type in given offset O D
LaboratoryAvg Average laboratory value of selected laboratory type in given offset O D
LaboratoryMin Minimum laboratory value of selected laboratory type in given offset O D
LaboratoryMax Maximum laboratory value of selected laboratory type in given offset O D
LaboratoryFirstInOffset First laboratory value of selected laboratory type in given offset O D
LaboratoryXInOffset X (0=first, 1=second,...) laboratory value of selected laboratory type in given offset O D
LaboratoryXInOffset Time (offset) of x laboratory value of selected laboratory type in given offset O D
SignalStd Standard deviation of average hourly values of selected signal O D