# Kanta prescriptions
### Sandbox directory
Kanta prescriptions data file is available as a separate file in the following Sandbox directory:
`/finngen/library-red/finngen_R13/kanta_prescription_1.0/`
Kanta prescriptions for the DF13 release was created by filtereing out FINNGENIDs present in DF13 [service sector longitudinal data](/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/service-sector-data.md).
### Data files
This data is available in the following file:
`data/finngen_R{RELEASE]_kanta_prescription_1.0.txt.gz`
Data is available since 2010.
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. |
| DOC\_TYPE\_CODE | Document type, Prescription=1, Cancellation of prescription=2, Correction of prescription=3 |
| DOC\_VERSION | The version number indicates the sequential number for the different versions of the document. The original prescription document is assigned version number 1 and, for example, a prescription correction based on this document is assigned version number 2. |
| TYPE\_1\_AMOUNT | Prescribed quantity, number of packages for prescription type 1 |
| TYPE\_1\_SIZE | Prescribed quantity, package size in text format for prescription type 1 |
| TYPE\_2\_AMOUNT | Prescribed quantity, total quantity of medicine for prescription type 2 |
| TYPE\_2\_SIZE\_UNIT | Prescribed quantity, unit of packaging size for prescription type 2 |
| TYPE\_3\_TIME | The time for which the medicine is prescribed for prescription type 3 |
| TYPE\_3\_UNIT | Unit in which the time is indicated for recipe type 3 |
| 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\_CODE | The Vnr number, or Nordic product number, is a six-digit code that identifies the pharmaceutical packaging of medicinal products authorised for sale. |
| RESEPTISTATUS | Prescription status: indicates whether the medicine needs a prescription to be supplied, i.e. whether the medicine is a prescription medicine or not. No=0, Yes=1 |
| 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 |
| RENEWAL\_BAN | A prescription has a prescription renewal ban. No=0, Yes=1 |
| MED\_EXCHANGE\_BAN | The prescription contains a prohibition to exchange the medicine for another interchangeable medicine. No=0, Yes=1 |
| DOSE\_DISTRIBUTION | Dose dispensing, i.e. the prescription has a specific agreed schedule and finished doses for the prescribed medicine attached to it by the pharmacy. 1 = Dose dispensing and 0 = no dose dispensing. |
| ORGANIZATION\_OID\_SALATTU | Encrypted unique identifier generated from the OID of the organization |
| ERIKOISALA\_CODE | Specialty/qualification code of the prescriber |
About TYPEs:\
There are three ways a physician can describe the amount of a medicine in Finland (actually 4 but the fourth is so rare so that is ignored in this dataset)\
1: Number and size of packages. Here, the physician is specific about what kind of package she wishes to be delivered, for example 3 items of a package with 28 pills in a package. Here, the total amount would be 3x28 = 84 pills.\
2: Total amount of drug. Here, the physician just writes “300” or “24” and that tells the amount.\
3: Time limit for the drug to be distributed. The amount then depends on the daily dose and the time. Time can be anything from 1 day to 2 years. The amount for example for a pill taken three times a day and the time one year would be 3 x 365 = 1095 pills.\
NB! More important is what an individual has bought! One might have a huge prescription like 600mg ibuprofein three times a day for two years which would result in 2190 pills on the prescription but he might take out only like 30 (or nothing). That is a very common phenomena for drugs that are not in regular, daily use.
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://docs.finngen.fi/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/kanta-prescriptions.md?ask=
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.