Difference between revisions of "Data ref"

Revision as of 08:45, 1 November 2022

data_ref.csv.gz contains referenced (nominal) data and is unique per icu admission.

data_ref.csv.gz
Name	Type	Description	Comment
id	Integer	Primary Key
CaseID	Integer	Case identifier
FieldID	Reference	Refers to the name of the field	i.e. PreconditionDiabetes
RefID	Reference

Fields
Name	Description	Comment	Type
PremedicationBetablocker	Yes/No
PremedicationACEInhibitor	Yes/No
PremedicationStatin	Yes/No
PremedicationDiuretic	Yes/No
PreconditionDiabetes	Any type of diabetes (IDDM or NIDDM)
PreconditionLungDisease	Any kind of lung severe disease (COPD, restrictive lung diseases, ...). Asthma is included when medication is taken daily
PreconditionArtHypertension
PreconditionRenalDysfunction	If stated in admission protocol (omitted due to anonymity issues)

(These predefined fields can be used as raw data too)

@@ Line 1: / Line 1: @@
-==Table Description==
-The data_ref table contains one-per-case referenced data.
+== Data Description ==
+{{:Data_Description_Data_Ref}}
 == Predefined Fields ([[RooDataServer]]) ==
@@ Line 26: / Line 29: @@
 (These predefined fields can be used as raw data too)
-== Raw Fields ==
-{| class="wikitable"
-|+ Caption d_references
-|-
-! Name !! Description !! Comment
-|-
-| id || Primary Key ||
-|-
-| CaseID ||  ||
-|-
-| RefID|| Refer to d_references for value (d_reference.ReferenceGlobalID = data_ref.RefID  || i.e. "sex"
-|-
-| CustomFieldID || Internally used ([[RooDataServer]] ||
-|}