Kanta medication delivery

Kanta medication delivery data file was introduced in Data Release 12. It contains data about medications that were delivered in Kanta.

Sandbox directory

Kanta medication delivery data file is available as a separate file in the following Sandbox directory:

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

Data files

This data is available in the following file:

data/finngen_R{RELEASE]_kanta_medication_delivery.csv

Kanta medication delivery is not released for DF13 but was created by filtering out FINNGENIDs from DF13 service sector within DF12 kanta medication delivery file.

The file contains the following columns:

Column	Description
FINNGENID	Studyid
EVENT_AGE	Age at the time of event
APPROX_EVENT_DAY	Approximated document creation date. Randomized (within +/- 15 days)
CDA_ID_SALATTU	Unique identifier of the document, unique for each line of the document. Delivered encrypted on a per-document basis.
DOC_GROUP_SALATTU	The identifier is the same as the unique identifier (CDA_ID) of the document in the related prescription on the basis of which the prescription was issued. When a prescription related to a medical prescription is to be found, the CDA_ID of the prescription corresponding to the DOC_GROUP of the medical prescription shall be searched. To be provided encrypted on a per-document basis.
RESIPTISTATUS	The prescription status tells whether the medicine is a prescription medicine or not. 0=No, 1=Yes.
DIS_AMOUNT_CALC_TEXT	The quantity supplied, as declared by the pharmacy, as a clause.
DIS_AMT_VALUE	The quantity supplied, as declared by the pharmacy, in numerical form.
DIS_AMOUNT_TXT	The quantity supplied, as declared by the pharmacy, in text form.
DIS_AMT_UNIT	The unit of quantity supplied, as declared by the pharmacy.
DELIVERY_FEE	The cost of medication, consisting of the price of the drug packages and the pharmacy's delivery fee.
MED_EXCHANGED	In the pharmacy, a medication can be marked as "substituted" in any case where the delivery differes in some way from the original prescription. For example, the VNR code may be different, but the supplied product differ only in terms of packaging type, such as a can being supplied instead of a blister pack. Therefore the delivery may be marked as "Medication substituted" even though medication has not been substituted with a cheaper alternative. The "Medication substituted" label may also appear in cases where the related prescription does not have a VNR code (i.e., the medication has been prescribed by its active ingredeint name). 0 = No, 1 = Yes.
DOSE_DISTRIBUTION	Dose distribution, 0 = No, 1 = Yes.
ATC_CODE	ATC code of the medicine. The ATC classification is the international classification of medicines maintained by the WHO. In Finland, the classification is maintained by Fimea. When selecting or classifying drug purchases based on the ATC code, any changes in the ATC classification must be taken into account.
PREPARATION_TYPE_CODE	Code for the type of preparation 1 Medicinal product with marketing authorisation 2 Basic cream in the pharmaceutical database 3 Clinical nutritional product in the pharmaceutical database 4 Provisionally authorised product 5 Registered medicinal product in the pharmaceutical database 6 Non-registered product 7 Medicinal product prepared in a pharmacy 8 Investigational medicinal product 9 Medicinal product prescribed under the name of an active substance 10 Therapeutic goods 11 Specially authorised medicinal product for a specific patient 12 Product prescribed abroad
PRODUCT_CODE1	VNR-code1, The Vnr number, or Nordic product number, is a six-digit code that identifies the pharmaceutical packaging of medicinal products authorised for sale.
PRODUCT_CODE2	VNR-code2, The Vnr number, or Nordic product number, is a six-digit code that identifies the pharmaceutical packaging of medicinal products authorised for sale.
PRODUCT_CODE3	VNR-code3, The Vnr number, or Nordic product number, is a six-digit code that identifies the pharmaceutical packaging of medicinal products authorised for sale.
LAAKEMUOTOKOODI	Code associated with a specific pharmaceutical form
DRUG_NAME_C	Name of the drug. The prescription may contain either the trade name or the name of the active substance.
DOSE_QUANTITY_TEXT	Drug strength