Data ref
Revision as of 14:58, 10 October 2022 by Salkin (talk | contribs) (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...")
Table Description
The data_ref table contains one-per-case referenced data.
Predefined Fields (RooDataServer)
| 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) |
Raw Fields
| 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 |