Difference between revisions of "Processed Referenced Fields"

From SICDB Doc
Jump to navigation Jump to search
 
(2 intermediate revisions 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 !! Description !! Comment !! Type
! 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 || || ||
| 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.

Fields
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)