Data ref

From SICDB Doc
Revision as of 14:59, 10 October 2022 by Salkin (talk | contribs)
Jump to navigation Jump to search

Table Description

The data_ref table contains one-per-case referenced data.

Predefined Fields (RooDataServer)

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)

Raw 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