Difference between revisions of "Processed Referenced Fields"

From SICDB Doc
Jump to navigation Jump to search
Line 18: Line 18:
| PreconditionLungDisease || Any kind of lung severe disease (COPD, restrictive lung diseases, ...). Asthma is included when medication is taken daily  || ||  
| PreconditionLungDisease || Any kind of lung severe disease (COPD, restrictive lung diseases, ...). Asthma is included when medication is taken daily  || ||  
|-  
|-  
| PreconditionArtHypertension || || ||  
| PreconditionArtHypertension || Any kind of treated or diagnosed arterial hypertension || ||  
|-  
|-  
| PreconditionRenalDysfunction || If stated in admission protocol (omitted due to anonymity issues) || ||
| PreconditionRenalDysfunction || If stated in admission protocol (omitted due to anonymity issues) || ||
|}
|}

Revision as of 08:51, 1 November 2022

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.

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 Any kind of treated or diagnosed arterial hypertension
PreconditionRenalDysfunction If stated in admission protocol (omitted due to anonymity issues)