Data dictionary: Drugs - DMA: Difference between revisions

Revision as of 13:50, 25 May 2024

Go back to Dutch Institute for Clinical Auditing Databases (DICA) (The Netherlands) page.

This is a summary of the variables available in the database. You can download the complete data dictionary. Click here to learn more.

Table 1: Demographic Information

Variables
Gender
Age as registered in DICA or DBC age at diagnosis
Hospital patient code

Table 2: Diagnosis and Treatment

Variables
Subdiagnosis
Subdiagnosis_description
Diagnosis date from DICA registry
Treatment combination, based on active ingredients with overlapping treatment window
Start date of the treatment combination
Stop date of the treatment combination
Treatment step

Table 3: Hospital and Care Details

Variables
Hospital agb code
Type of hospital
Highest level care activity group
Description on the highest level care activity group
Care activity group
Description of the care activity group
Care activity code
Care activity description

Table 4: Medication and Comorbidity

Variables
All medication definitions
Active ingredient name
Merknaam (Brand name)
ATC 1 code through ATC 5 code
Comorbidity score

Table 5: Mortality and Follow-up

Variables
Date of death
Mortality status
Time from diagnosis date until max activity date
If a patient was treated prior to death

@@ Line 1: / Line 1: @@
+{{forresearchers}}
 Go back to [[Dutch Institute for Clinical Auditing Databases (DICA) (The Netherlands)]] page.
 This is a summary of the variables available in the database. You can download the complete data dictionary. [https://dica.nl/data-aanvragen/ Click here to learn more].
-'''Demographic Information'''
+'''Table 1:''' Demographic Information
-* Gender
+{| class="wikitable"
-* Age as registered in DICA or DBC age at diagnosis
+! Variables
-* Hospital patient code
+|-
+| Gender
+|-
+| Age as registered in DICA or DBC age at diagnosis
+|-
+| Hospital patient code
+|}
+'''Table 2:''' Diagnosis and Treatment
+{| class="wikitable"
+! Variables
+|-
+| Subdiagnosis
+|-
+| Subdiagnosis_description
+|-
+| Diagnosis date from DICA registry
+|-
+| Treatment combination, based on active ingredients with overlapping treatment window
+|-
+| Start date of the treatment combination
+|-
+| Stop date of the treatment combination
+|-
+| Treatment step
+|}
-'''Diagnosis and Treatment'''
+'''Table 3:''' Hospital and Care Details
-* Subdiagnosis
+{| class="wikitable"
-* Subdiagnosis_description
+! Variables
-* Diagnosis date from DICA registry
+|-
-* Treatment combination, based on active ingredients with overlapping treatment window
+| Hospital agb code
-* Start date of the treatment combination
+|-
-* Stop date of the treatment combination
+| Type of hospital
-* Treatment step
+|-
+| Highest level care activity group
+|-
+| Description on the highest level care activity group
+|-
+| Care activity group
+|-
+| Description of the care activity group
+|-
+| Care activity code
+|-
+| Care activity description
+|}
+'''Table 4:''' Medication and Comorbidity
+{| class="wikitable"
+! Variables
+|-
+| All medication definitions
+|-
+| Active ingredient name
+|-
+| Merknaam (Brand name)
+|-
+| ATC 1 code through ATC 5 code
+|-
+| Comorbidity score
+|}
-'''Hospital and Care Details'''
+'''Table 5:''' Mortality and Follow-up
-* Hospital agb code
+{| class="wikitable"
-* Type of hospital
+! Variables
-* Highest level care activity group
+|-
-* Description on the highest level care activity group
+| Date of death
-* Care activity group
+|-
-* Description of the care activity group
+| Mortality status
-* Care activity code
+|-
-* Care activity description
+| Time from diagnosis date until max activity date
+|-
+| If a patient was treated prior to death
-'''Medication and Comorbidity'''
+|}
-* All medication definitions
-* Active ingredient name
-* Merknaam (Brand name)
-* ATC 1 code through ATC 5 code
-* Comorbidity score
-'''Mortality and Follow-up'''
-* Date of death
-* Mortality status
-* Time from diagnosis date until max activity date
-* If a patient was treated prior to death