Drug Events

Drug events table is a combined table of drug events from Kela Purchase, Kanta Medication delivery and Kanta Prescription registries.

Details

Drug events from Kela drug PURCH registry, Kanta medication delivery registry and Kanta prescription registry were combined into single table. Kanta prescription and medication delivery registries are connected using prescription ids. Kanta medication delivery is then connected to Kela PURCH registry was done using FINNGENID, EVENT_AGE, APPROX_EVENT_DAY and ATC code.

Sandbox directory

Drug events data file is available as a separate file in the following Sandbox directory:

/finngen/library-red/finngen_R13/drug_events_v2.0/

Data files

This data is available in the following file:

data/finngen_R{RELEASE]_drug_events_2.0.csv

The file contains the following columns:

Column	Description
FINNGENID	Studyid
PRESCRIPTION_ID	Prescription id information needed to track.
PRESCRIPTION_APPROX_EVENT_DAY	Date of the prescription.
PRESCRIPTION_AGE	Age of the patient at the time of the prescription.
PRESCRIPTION_ATC	ATC code of the prescription.
PRESCRIPTION_VNR	VNR code of the prescription.
MEDICATION_APPROX_EVENT_DAY	Date of the medication. This date comes from Kela PURCH or Kanta Medication delivery registries.
MEDICATION_AGE	Age of the patient at the time of the medication.
MEDICATION_ATC	ATC code of the medication.
MEDICATION_VNR	VNR code of the medication.
DRUG_MAPPING_SOURCE	'PRESCRIPTION' - Only Prescription events 'DELIVERY' - Only Delivery events 'KELA' - Only PURCH events 'PRESCRIPTION_DELIVERY' - Events present in both Kanta prescription and medication delivery registries only. 'DELIVERY_KELA' - Events present in both Kanta medication delivery and Kela PURCH registries only. 'PRESCRIPTION_DELIVERY_KELA' - Events present in all three registries
INDEX	INDEX from the Kela PURCH registry