Data Dictionary: The Medicines Statistics Register (NPR)

From Beacon
Revision as of 19:49, 7 May 2024 by Francine (talk | contribs)

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)