Difference between revisions of "Data ref"

From SICDB Doc
Jump to navigation Jump to search
(Created page with "==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) || || |- | Preconditi...")
 
Line 24: Line 24:
| PreconditionRenalDysfunction || If stated in admission protocol (omitted due to anonymity issues) || ||
| PreconditionRenalDysfunction || If stated in admission protocol (omitted due to anonymity issues) || ||
|}
|}
(These predefined fields can be used as raw data too)


== Raw Fields ==
== Raw Fields ==

Revision as of 14:59, 10 October 2022

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