Data Dictionary: The Medicines Statistics Register (NPR): Difference between revisions
From Beacon
(Created page with "Go back to Denmark page Source: [https://www.esundhed.dk/Dokumentation?rid=14&tid=63&vid=317] {| class="wikitable" ! Variables !! Field description |- | aref || Reimbursement schemes that cannot be fitted under the other fields (for shipments from pharmacies where other subsidies have been paid) |- | abc || code for the price of the drug relative to the others in the substitution group |- | aip || The pharmacy's purchase price for one pack at the time of valuation...") |
No edit summary |
||
| Line 8: | Line 8: | ||
| aref || Reimbursement schemes that cannot be fitted under the other fields (for shipments from pharmacies where other subsidies have been paid) | | aref || Reimbursement schemes that cannot be fitted under the other fields (for shipments from pharmacies where other subsidies have been paid) | ||
|- | |- | ||
| abc || | | abc || Code for the price of the drug relative to the others in the substitution group | ||
|- | |- | ||
| aip || The pharmacy's purchase price for one pack at the time of valuation | | aip || The pharmacy's purchase price for one pack at the time of valuation | ||
| Line 16: | Line 16: | ||
| algp || Age group of animals (in the case of medicines prescribed by a veterinarian) | | algp || Age group of animals (in the case of medicines prescribed by a veterinarian) | ||
|- | |- | ||
| aok || | | aok || Number of packages or number of units sold | ||
|- | |- | ||
| atc || ATC code for the drug | | atc || ATC code for the drug | ||
| Line 24: | Line 24: | ||
| bald || Code for the child's age | | bald || Code for the child's age | ||
|- | |- | ||
| cpr_kom || | | cpr_kom || Municipality in which the citizen resided when the medicine was purchased | ||
|- | |- | ||
| cpr_reg || | | cpr_reg || Which region the citizen was resident in when the medicine was purchased | ||
|- | |- | ||
| dart || | | dart || Animal species in the case of medicines prescribed by a veterinarian | ||
|- | |- | ||
| dgid || Internal serial number in the Danish Health Authority's Medicines Register (KAT), which defines a specific medicine/marketing authorisation | | dgid || Internal serial number in the Danish Health Authority's Medicines Register (KAT), which defines a specific medicine/marketing authorisation | ||
|- | |- | ||
| dosform || | | dosform || Medicine's dispensing form in code | ||
|- | |- | ||
| doso || | | doso || Dosage | ||
|- | |- | ||
| ejs || Code for opting out of substitution when selling prescription drugs | | ejs || Code for opting out of substitution when selling prescription drugs | ||
| Line 56: | Line 56: | ||
| indo || Indication code for the prescribed medicine | | indo || Indication code for the prescribed medicine | ||
|- | |- | ||
| itype || | | itype || Who has reported the data in question | ||
|- | |- | ||
| kcpr || Encrypted social security number for the recipient of the medicine | | kcpr || Encrypted social security number for the recipient of the medicine | ||
| Line 74: | Line 74: | ||
| ordg || Code for prescription group for medicines prescribed by a veterinarian | | ordg || Code for prescription group for medicines prescribed by a veterinarian | ||
|- | |- | ||
| ovnr || | | ovnr || Doctor's prescribed item number | ||
|- | |- | ||
| packtext || The package size of the drug | | packtext || The package size of the drug | ||
| Line 86: | Line 86: | ||
| ppps || Code for the dispensing determination of the drug package at the time of dispensing | | ppps || Code for the dispensing determination of the drug package at the time of dispensing | ||
|- | |- | ||
| produkttype || | | produkttype || Approximation of whether a drug is original, parallel import or generic | ||
|- | |- | ||
| ptp || The patient's/recipient's payment in kroner incl. VAT. | | ptp || The patient's/recipient's payment in kroner incl. VAT. | ||
| Line 92: | Line 92: | ||
| ptyp || Type of amount of parenteral service products | | ptyp || Type of amount of parenteral service products | ||
|- | |- | ||
| ramt || | | ramt || Number of the reimbursing region for prescription sales of subsidized medicinal products to individuals | ||
|- | |- | ||
| reca || Authorization code for prescription issuer - The doctor's authorization ID | | reca || Authorization code for prescription issuer - The doctor's authorization ID | ||
| Line 112: | Line 112: | ||
| rimb || Code indicating whether the medicinal package is eligible for subsidy or not and what type of subsidy is given | | rimb || Code indicating whether the medicinal package is eligible for subsidy or not and what type of subsidy is given | ||
|- | |- | ||
| rinr || | | rinr || Number that indicates the time a prescription has been dispensed | ||
|- | |- | ||
| streng || The strength in clear text of the active ingredient(s) included in the medicine (e.g. "500 mg") | | streng || The strength in clear text of the active ingredient(s) included in the medicine (e.g. "500 mg") | ||
| Line 136: | Line 136: | ||
| vnr || Item number. A unique identification of the specific drug package dispensed | | vnr || Item number. A unique identification of the specific drug package dispensed | ||
|- | |- | ||
| voltypecode || | | voltypecode || Specifies a code for a drug packaging unit for the variable VOLUME | ||
|- | |- | ||
| voltypetxt || | | voltypetxt || Specifies a drug package unit for the variable VOLUME | ||
|- | |- | ||
| volume || | | volume || Indicates the numerical volume (quantity) of one drug package | ||
|- | |- | ||
| pname || The trade name of the medicine | | pname || The trade name of the medicine | ||
Revision as of 05:35, 30 November 2023
Go back to Denmark page
Source: [1]
| Variables | Field description |
|---|---|
| aref | Reimbursement schemes that cannot be fitted under the other fields (for shipments from pharmacies where other subsidies have been paid) |
| abc | Code for the price of the drug relative to the others in the substitution group |
| aip | The pharmacy's purchase price for one pack at the time of valuation |
| aldr | Age of the patient at the time of purchase |
| algp | Age group of animals (in the case of medicines prescribed by a veterinarian) |
| aok | Number of packages or number of units sold |
| atc | ATC code for the drug |
| aup | The pharmacy's retail price |
| bald | Code for the child's age |
| cpr_kom | Municipality in which the citizen resided when the medicine was purchased |
| cpr_reg | Which region the citizen was resident in when the medicine was purchased |
| dart | Animal species in the case of medicines prescribed by a veterinarian |
| dgid | Internal serial number in the Danish Health Authority's Medicines Register (KAT), which defines a specific medicine/marketing authorisation |
| dosform | Medicine's dispensing form in code |
| doso | Dosage |
| ejs | Code for opting out of substitution when selling prescription drugs |
| eksd | Date of completed cash transaction/debit |
| eksn | Dispatch number for the individual dispatch at the pharmacy |
| eksp | The total price of the expedition in DKK |
| ekst | Code for type of expedition |
| etid | Indicates the time when the checkout transaction/debit was completed |
| faar | Patient's year of birth |
| ibgp | The amount that is the basis for calculating the regional medicine subsidy |
| ibnr | The reporting person's number |
| indo | Indication code for the prescribed medicine |
| itype | Who has reported the data in question |
| kcpr | Encrypted social security number for the recipient of the medicine |
| koen | Patient's gender |
| kom | The number of the municipality issuing the refund |
| korr | Correction code |
| lkcpr | The doctor's encrypted CPR number |
| lnr | In case of reuse of an item number (VNR), an increasing serial number is assigned |
| nce_s | Code indicating whether the medicinal package is parallel imported or not |
| ordg | Code for prescription group for medicines prescribed by a veterinarian |
| ovnr | Doctor's prescribed item number |
| packtext | The package size of the drug |
| pksubgr | Internal serial number in KAT, which defines which drug packages are mutually substitutable |
| patt | Code for patient type when dispensing medicines where the patient is entitled to a subsidy |
| pnr | Identification of the point of sale by the number for the production unit (P-number) according to the Central Business Register |
| ppps | Code for the dispensing determination of the drug package at the time of dispensing |
| produkttype | Approximation of whether a drug is original, parallel import or generic |
| ptp | The patient's/recipient's payment in kroner incl. VAT. |
| ptyp | Type of amount of parenteral service products |
| ramt | Number of the reimbursing region for prescription sales of subsidized medicinal products to individuals |
| reca | Authorization code for prescription issuer - The doctor's authorization ID |
| recl | Prescription serial number |
| recu | Code for identification of prescription issuers for prescription sales of medicinal products |
| reg_name | The name of the pharmaceutical company that holds the marketing authorization. |
| regsit_p | The status of the medicinal product packaging with regard to marketing |
| rgl1 | Rule number according to which the municipality has granted subsidy no. 1 |
| rgl2 | Rule number under which the municipality has granted subsidy no. 2 |
| rgla | The rule number according to which the patient is entitled to a medicine subsidy from the region |
| rimb | Code indicating whether the medicinal package is eligible for subsidy or not and what type of subsidy is given |
| rinr | Number that indicates the time a prescription has been dispensed |
| streng | The strength in clear text of the active ingredient(s) included in the medicine (e.g. "500 mg") |
| strunut | For medicinal products consisting of several active ingredients (combination preparations) no unit for numerical strength is specified |
| tard | Date for setting the price and any subsidized price of pharmaceutical shipment |
| takd | First date in a tariff period. A tariff period is a 14-day period during which prices and assortment apply |
| tilpris | Indicates the amount from which a possible subsidy can be calculated |
| tsk1 | Municipal subsidy no. 1. The field must be filled in for expeditions from pharmacies, after which the municipality has provided a subsidy |
| tsk2 | Municipal subsidy no. 2 in kroner incl. VAT. The field must be filled in for expeditions from pharmacies, after which the municipality has granted subsidy no. 2 |
| tsk3 | Other grants are listed in kroner incl. VAT. The field must be filled in for expeditions from pharmacies, after which other reimbursements have been given |
| tska | The regional medicine subsidy in kroner incl. VAT on prescription sales of subsidized medicines |
| udlv | The field should be filled in when selling medicines from a pharmacy |
| vnr | Item number. A unique identification of the specific drug package dispensed |
| voltypecode | Specifies a code for a drug packaging unit for the variable VOLUME |
| voltypetxt | Specifies a drug package unit for the variable VOLUME |
| volume | Indicates the numerical volume (quantity) of one drug package |
| pname | The trade name of the medicine |
| strnum | Strength. For medicinal products consisting of several active ingredients (combination preparations) |