Difference between revisions of "Processed Referenced Fields"
Jump to navigation
Jump to search
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
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.RefID. | 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. | ||
{| class="wikitable" | {| class="wikitable" | ||
|+ Fields | |+ Fields | ||
|- | |- | ||
! Name !! | ! Name !! Type !! Description | ||
|- | |- | ||
| PremedicationBetablocker || Yes/No | | PremedicationBetablocker || Referenced || Yes/No | ||
|- | |- | ||
| PremedicationACEInhibitor || Yes/No | | PremedicationACEInhibitor || Referenced|| Yes/No | ||
|- | |- | ||
| PremedicationStatin || Yes/No | | PremedicationStatin || Referenced|| Yes/No | ||
|- | |- | ||
| PremedicationDiuretic || Yes/No | | PremedicationDiuretic || Referenced|| Yes/No | ||
|- | |- | ||
| PreconditionDiabetes || Any type of diabetes (IDDM or NIDDM) | | PreconditionDiabetes || Referenced|| 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 | | PreconditionLungDisease || Referenced|| Any kind of lung severe disease (COPD, restrictive lung diseases, ...). Asthma is included when medication is taken daily | ||
|- | |- | ||
| PreconditionArtHypertension || Any kind of treated or diagnosed arterial hypertension | | PreconditionArtHypertension || Referenced|| Any kind of treated or diagnosed arterial hypertension | ||
|- | |- | ||
| PreconditionRenalDysfunction || If stated in admission protocol (omitted due to anonymity issues) | | PreconditionRenalDysfunction|| Referenced || If stated in admission protocol (omitted due to anonymity issues) | ||
|} | |} | ||
Latest revision as of 15:25, 24 May 2023
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.
| 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) |