Data Dictionary: The Medicines Statistics Register (NPR): Difference between revisions
From Beacon
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
Go back to [[Denmark]] page | Go back to [[Database: The Medicines Statistics Register (NPR) (Denmark)]] page | ||
Source: [https://www.esundhed.dk/Dokumentation?rid=14&tid=63&vid=317] | Source: [https://www.esundhed.dk/Dokumentation?rid=14&tid=63&vid=317 Click here to learn more] | ||
{| class="wikitable" | {| class="wikitable" | ||
Revision as of 19:49, 7 May 2024
Go back to Database: The Medicines Statistics Register (NPR) (Denmark) page
Source: Click here to learn more
| 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) |