Difference between revisions of "Data ref"

From SICDB Doc
Jump to navigation Jump to search
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
==Table Description==
The data_ref table contains one-per-case referenced data.


== Predefined Fields ([[RooDataServer]]) ==
{| class="wikitable"
|+ 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)
== Data Description ==


== Raw Fields ==
{{:Data_Description_Data_Ref}}


{| class="wikitable"
== Predefined Fields ==
|+ 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]] ||


|}
{{:Processed_Referenced_Fields}}

Latest revision as of 08:51, 1 November 2022


Data Description

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

Predefined Fields

Several fields have been preprocessed and added to the database. This includes peprocessed-for-convenience and preprocessed-for-anonymization elements. The data is found in data_ref.csv.gz, the text values are referenced in d_references, where d_references.ReferenceGlobalID relates to data_ref. FieldID and data_ref.RefID.

Fields
Name Type Description
PremedicationBetablocker Referenced Yes/No
PremedicationACEInhibitor Referenced Yes/No
PremedicationStatin Referenced Yes/No
PremedicationDiuretic Referenced Yes/No
PreconditionDiabetes Referenced Any type of diabetes (IDDM or NIDDM)
PreconditionLungDisease Referenced Any kind of lung severe disease (COPD, restrictive lung diseases, ...). Asthma is included when medication is taken daily
PreconditionArtHypertension Referenced Any kind of treated or diagnosed arterial hypertension
PreconditionRenalDysfunction Referenced If stated in admission protocol (omitted due to anonymity issues)
Retrieved from "https://www.sicdb.com/wiki/index.php?title=Data_ref&oldid=235"