Data Dictionary: The Medicines Statistics Register (NPR) - Revision history

Lucas: Update categories.

2025-12-02T13:27:06Z

Update categories.

← Older revision		Revision as of 13:27, 2 December 2025
Line 1:		Line 1:
	{{forresearchers}}		<span style="display:none">forresearchers</span>
	Go back to [[Database: The Medicines Statistics Register (NPR) (Denmark)]] page		Go back to [[Database: The Medicines Statistics Register (NPR) (Denmark)]] page

Francine at 16:13, 3 June 2024

2024-06-03T16:13:13Z

← Older revision		Revision as of 16:13, 3 June 2024
Line 7:		Line 7:
	! Variables !! Field description		! Variables !! Field description
	\|-		\|-
	\| ~~aref~~ \|\| Reimbursement schemes that cannot be fitted under the other fields (for shipments from pharmacies where other subsidies have been paid)		\| are \|\| 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		\| abc \|\| Code for the price of the drug relative to the others in the substitution group

Francine at 13:23, 27 May 2024

2024-05-27T13:23:22Z

← Older revision		Revision as of 13:23, 27 May 2024
Line 1:		Line 1:
			{{forresearchers}}
	Go back to [[Database: The Medicines Statistics Register (NPR) (Denmark)]] page		Go back to [[Database: The Medicines Statistics Register (NPR) (Denmark)]] page

Francine at 19:49, 7 May 2024

2024-05-07T19:49:59Z

← Older revision		Revision as of 19:49, 7 May 2024
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"

Larysse at 05:35, 30 November 2023

2023-11-30T05:35:00Z

Larysse: 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..."

2023-11-29T17:59:05Z

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..."

New page

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
|-
| 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)
|}

← Older revision		Revision as of 05:35, 30 November 2023
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 \|\| ~~code~~ for the price of the drug relative to the others in the substitution group		\| 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 \|\| ~~number~~ of packages or number of units sold		\| 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 \|\| ~~municipality~~ in which the citizen resided when the medicine was purchased		\| 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		\| 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		\| 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 \|\| ~~medicine~~'s dispensing form in code		\| dosform \|\| Medicine's dispensing form in code
	\|-		\|-
	\| doso \|\| ~~dosage~~		\| 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 \|\| ~~who~~ has reported the data in question		\| 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 \|\| ~~doctor~~'s prescribed item number		\| 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 \|\| ~~approximation~~ of whether a drug is original, parallel import or generic		\| 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 \|\| ~~number~~ of the reimbursing region for prescription sales of subsidized medicinal products to individuals		\| 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 \|\| ~~number~~ that indicates the time a prescription has been dispensed		\| 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 \|\| ~~specifies~~ a code for a drug packaging unit for the variable VOLUME		\| voltypecode \|\| Specifies a code for a drug packaging unit for the variable VOLUME
	\|-		\|-
	\| voltypetxt \|\| ~~specifies~~ a drug package 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		\| volume \|\| Indicates the numerical volume (quantity) of one drug package
	\|-		\|-
	\| pname \|\| The trade name of the medicine		\| pname \|\| The trade name of the medicine