| Literature DB >> 23204870 |
Sigrun Alba Johannesdottir1, Erzsébet Horváth-Puhó, Vera Ehrenstein, Morten Schmidt, Lars Pedersen, Henrik Toft Sørensen.
Abstract
The Danish health care system provides partial reimbursement of most prescription medications in Denmark. The dispensation of prescription medications is registered in administrative databases. Each time a prescription is redeemed at a pharmacy, an electronic record is generated with information related to the user, prescriber, the pharmacy, and the dispensed drug. The National Health Service gathers this information for administration of the drug reimbursement plan. Recently, this information became the basis for the establishment of a new research database, the Danish National Database of Reimbursed Prescriptions (DNDRP). In this paper, we review the content, coverage, quality, linkage, access, and research possibilities of this new database. The database encompasses the reimbursement records of all reimbursed drugs sold in community pharmacies and hospital-based outpatient pharmacies in Denmark since 2004. On average, approximately 3.5 million users are recorded in the database each year. During the coverage period, the number of annual prescription redemptions increased by 15%. Most dispensed prescriptions are in the categories "alimentary tract and metabolism", "cardiovascular system", "nervous system", and "respiratory system". Individuals are identified by the unique central personal registration (CPR) number assigned to all persons born in or immigrating to Denmark. The new database fully complies with Denmark's Act on Processing of Personal Data, while avoiding additional restrictions imposed on data use at the Danish National Prescription Registry, administered by Statistics Denmark. Most importantly, CPR numbers are reversibly encrypted, which allows re-identification of drug users; furthermore, the data access is possible outside the servers of Statistics Denmark. These features open additional opportunities for international collaboration, validation studies, studies on adverse drug effects requiring review of medical records, studies involving contact to general practitioners, and linkage of prescription data to other clinical and research databases. The DNDRP thus is a valuable data source for pharmacoepidemiological research.Entities:
Keywords: Denmark; patient registration; pharmacoepidemiology; registry-based research
Year: 2012 PMID: 23204870 PMCID: PMC3508607 DOI: 10.2147/CLEP.S37587
Source DB: PubMed Journal: Clin Epidemiol ISSN: 1179-1349 Impact factor: 4.790
List of variables included in the Danish National Database of Reimbursed Prescriptions
| Patient details |
| CPR number of patient |
| Birth year |
| Age at dispensing date |
| Gender |
| Municipal and region of residence |
| Dispensing details |
| Product code (Nordic article number) encoding name, form, strength, and pack size |
| Trade name |
| Number of packets or units |
| Pharmaceutical form |
| Anatomical Therapeutic Chemical (ATC) Classification System code |
| Defined Daily Dose (DDD) |
| Dispensing date |
| Generic substitution done at pharmacy (if any) |
| Reiteration number indicating the number of prescription refills |
| Retail price |
| Price forming basis of reimbursement calculation |
| Amount of reimbursement |
| Prescriber details |
| Practice code |
| Pharmacy details |
| Unique pharmacy identifier |
Abbreviations: CPR, central personal registration; ATC, anatomical therapeutic chemical; DDD, defined daily dose.
Distribution of users recorded in the Danish National Database of Reimbursed Prescriptions overall and according to the ATC main groups
| ATC anatomical main group, alphabetically | Number (percent) | |||||||
|---|---|---|---|---|---|---|---|---|
|
| ||||||||
| 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | |
| A | ||||||||
| Alimentary tract and metabolism | 624,610 (18.1) | 644,854 (18.5) | 677,714 (19.2) | 704,363 (19.6) | 734,212 (20.5) | 753,400 (21.0) | 801,716 (22.0) | 820,348 (22.3) |
| B | ||||||||
| Blood and blood forming organs | 380,650 (11.0) | 407,173 (11.7) | 460,373 (13.0) | 482,776 (13.5) | 509,960 (14.2) | 523,472 (14.6) | 538,776 (14.8) | 552,340 (15.0) |
| C | ||||||||
| Cardiovascular system | 930,340 (26.9) | 971,670 (27.9) | 1,028,662 (29.1) | 1,082,851 (30.2) | 1,135,512 (31.6) | 1,162,765 (32.3) | 1,190,876 (32.6) | 1,208,445 (32.8) |
| D | ||||||||
| Dermatologicals | 685,273 (19.8) | 674,093 (19.4) | 680,391 (19.2) | 676,876 (18.9) | 699,611 (19.5) | 703,099 (19.6) | 702,508 (19.2) | 700,754 (19.0) |
| G | ||||||||
| Genito-urinary system and sex hormones | 355,057 (10.3) | 349,379 (10.0) | 356,093 (10.1) | 358,346 (10.0) | 359,062 (10.0) | 356,453 (9.9) | 359,968 (9.9) | 361,112 (9.8) |
| H | ||||||||
| Systemic hormonal preparations, excluding sex hormones and insulins | 291,487 (8.4) | 297,569 (8.5) | 306,419 (8.7) | 313,924 (8.7) | 317,810 (8.9) | 323,263 (9.0) | 324,959 (8.9) | 325,809 (8.8) |
| J | ||||||||
| Anti-infectives for systemic use | 1,669,319 (48.3) | 1,699,680 (48.8) | 1,717,157 (48.6) | 1,776,125 (49.5) | 1,718,311 (47.9) | 1,703,302 (47.4) | 1,771,116 (48.5) | 1,812,957 (49.2) |
| L | ||||||||
| Antineoplastic and immunomodulating agents | 29,810 (0.9) | 31,915 (0.9) | 33,530 (0.9) | 35,388 (1.0) | 36,516 (1.0) | 38,167 (1.1) | 40,205 (1.1) | 41,015 (1.1) |
| M | ||||||||
| Musculo-skeletal system | 972,712 (28.1) | 968,118 (27.8) | 961,829 (27.2) | 948,137 (26.4) | 946,625 (26.4) | 923,983 (25.7) | 926,934 (25.4) | 908,079 (24.6) |
| N | ||||||||
| Nervous system | 901,398 (26.1) | 924,905 (26.6) | 949,119 (26.8) | 973,276 (27.1) | 993,095 (27.7) | 1,016,300 (28.3) | 1,057,397 (29) | 1,065,246 (28.9) |
| P | ||||||||
| Antiparasitic products, insecticides, and repellents | 119,205 (3.4) | 121,340 (3.5) | 122,106 (3.5) | 125,965 (3.5) | 128,729 (3.6) | 133,078 (3.7) | 134,767 (3.7) | 136,087 (3.7) |
| R | ||||||||
| Respiratory system | 805,083 (23.3) | 795,370 (22.8) | 809,077 (22.9) | 827,171 (23.0) | 817,175 (22.8) | 824,144 (22.9) | 831,643 (22.8) | 848,127 (23.0) |
| S | ||||||||
| Sensory organs | 391,293 (11.3) | 388,319 (11.2) | 401,588 (11.4) | 402,555 (11.2) | 401,608 (11.2) | 405,527 (11.3) | 397,916 (10.9) | 399,542 (10.8) |
| V | ||||||||
| Various | 10,835 (0.3) | 10,197 (0.3) | 9,928 (0.3) | 10,143 (0.3) | 10,350 (0.3) | 10,908 (0.3) | 11,023 (0.3) | 11,410 (0.3) |
| Total | 3,456,640 (100.0) | 3,482,083 (100.0) | 3,535,169 (100.0) | 3,589,109 (100.0) | 3,587,753 (100.0) | 3,595,303 (100.0) | 3,651,873 (100.0) | 3,685,520 (100.0) |
| Mean number of prescriptions per user | 9.8 | 9.9 | 10.1 | 10.3 | 10.5 | 10.6 | 10.6 | 10.6 |
Notes: A user is defined as a person with at least one prescription in a given group. Percentages do not add up to 100% since a person may use more than one category.
Abbreviation: ATC, anatomical therapeutic chemical.
Distribution of redeemed prescriptions recorded in the Danish National Database of Reimbursed Prescriptions overall and according to the main ATC groups
| ATC anatomical main group, alphabetically | Number (percent) | |||||||
|---|---|---|---|---|---|---|---|---|
|
| ||||||||
| 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | |
| A | ||||||||
| Alimentary tract and metabolism | 3,264,402 (9.6) | 3,381,465 (9.8) | 3,577,499 (10.0) | 3,720,123 (10.1) | 3,909,147 (10.3) | 3,985,656 (10.5) | 4,212,712 (10.9) | 4,293,425 (11.0) |
| B | ||||||||
| Blood and blood forming organs | 1,463,820 (4.3) | 1,586,248 (4.7) | 1,794,239 (5.0) | 1,945,108 (5.3) | 2,081,685 (5.5) | 2,127,367 (5.6) | 2,160,083 (5.6) | 2,209,637 (5.7) |
| C | ||||||||
| Cardiovascular system | 7,293,131 (21.5) | 7,576,818 (21.9) | 7,993,860 (22.4) | 8,456,255 (22.9) | 8,922,462 (23.6) | 8,987,640 (23.7) | 9,107,921 (23.5) | 9,121,336 (23.4) |
| D | ||||||||
| Dermatologicals | 1,316,773 (3.9) | 1,296,485 (3.7) | 1,292,182 (3.6) | 1,287,161 (3.5) | 1,309,937 (3.5) | 1,315,287 (3.5) | 1,311,512 (3.4) | 1,306,421 (3.3) |
| G | ||||||||
| Genito-urinary system and sex hormones | 1,223,354 (3.6) | 1,241,568 (3.6) | 1,271,131 (3.6) | 1,281,853 (3.5) | 1,286,490 (3.4) | 1,289,222 (3.4) | 1,316,104 (3.4) | 1,323,177 (3.4) |
| H | ||||||||
| Systemic hormonal preparations, excluding sex hormones and insulins | 893,469 (2.6) | 906,641 (2.6) | 924,760 (2.6) | 950,011 (2.6) | 963,552 (2.6) | 972,652 (2.6) | 1,008,675 (2.6) | 1,026,215 (2.6) |
| J | ||||||||
| Anti-infectives for systemic use | 3,183,744 (9.4) | 3,255,075 (9.4) | 3,312,219 (9.3) | 3,464,812 (9.4) | 3,350,631 (8.9) | 3,299,963 (8.7) | 3,478,752 (9.0) | 3,555,367 (9.1) |
| L | ||||||||
| Antineoplastic and immunomodulating agents | 90,676 (0.327) | 96,115 (0.3) | 95,911 (0.3) | 100,068 (0.3) | 105,008 (0.3) | 108,334 (0.3) | 112,697 (0.3) | 114,726 (0.3) |
| M | ||||||||
| Musculo-skeletal system | 2,691,890 (7.9) | 2,648,354 (7.7) | 2,597,139 (7.3) | 2,533,903 (6.9) | 2,519,633 (6.7) | 2,417,428 (6.4) | 2,388,127 (6.2) | 2,310,810 (5.9) |
| N | ||||||||
| Nervous system | 7,016,412 (20.7) | 7,220,883 (20.9) | 7,434,875 (20.8) | 7,720,384 (20.9) | 7,896,890 (20.9) | 8,028,249 (21.1) | 8,284,850 (21.3) | 8,318,380 (21.3) |
| P | ||||||||
| Antiparasitic products, insecticides, and repellents | 215,043 (0.6) | 217,506 (0.6) | 219,681 (0.6) | 224,767 (0.6) | 228,519 (0.6) | 232,616 (0.6) | 237,285 (0.6) | 237,647 (0.6) |
| R | ||||||||
| Respiratory system | 3,996,386 (11.8) | 3,930,538 (11.4) | 3,971,361 (11.1) | 3,991,830 (10.8) | 3,937,406 (10.4) | 3,933,682 (10.4) | 3,931,911 (10.1) | 3,945,161 (10.1) |
| S | ||||||||
| Sensory organs | 1,234,012 (3.6) | 1,219,445 (3.5) | 1,231,742 (3.4) | 1,228,566 (3.3) | 1,244,228 (3.3) | 1,250,921 (3.3) | 1,233,674 (3.2) | 1,242,082 (3.2) |
| V | ||||||||
| Various | 21,732 (0.1) | 20,552 (0.1) | 20,410 (0.1) | 21,025 (0.1) | 21,757 (0.1) | 22,683 (0.1) | 22,891 (0.1) | 24,433 (0.1) |
| Total | 33,904,844 (100.0) | 34,597,693 (100.0) | 35,737,009 (100.0) | 36,925,866 (100.0) | 37,777,345 (100.0) | 37,971,700 (100.0) | 38,807,194 (100.0) | 39,028,817 (100.0) |
Abbreviation: ATC, anatomical therapeutic chemical.
Completeness of the Danish National Database of Reimbursed Prescriptions compared with data from Statistics Denmark, according to main ATC groups, 2011
| ATC main group, alphabetically | Number of users | Completeness | |
|---|---|---|---|
|
| |||
| Statistics Denmark | Danish National Database of Reimbursed Prescriptions | ||
| A | |||
| Alimentary tract and metabolism | 967,662 | 820,348 | 0.84776 |
| B | |||
| Blood and blood forming organs | 630,769 | 552,340 | 0.87566 |
| C | |||
| Cardiovascular system | 1,347,540 | 1,208,445 | 0.89678 |
| D | |||
| Dermatologicals | 1,019,743 | 700,754 | 0.68719 |
| G | |||
| Genito-urinary system and sex hormones | 881,901 | 361,112 | 0.40947 |
| H | |||
| Systemic hormonal preparations, excluding sex hormones and insulins | 331,174 | 325,809 | 0.98380 |
| J | |||
| Anti-infectives for systemic use | 1,914,610 | 1,812,957 | 0.94691 |
| L | |||
| Antineoplastic and immunomodulating agents | 41,402 | 41,015 | 0.99065 |
| M | |||
| Musculo-skeletal system | 972,270 | 908,079 | 0.93398 |
| N | |||
| Nervous system | 1,259,843 | 1,065,246 | 0.84554 |
| P | |||
| Antiparasitic products, insecticides, and repellents | 237,957 | 136,087 | 0.57190 |
| R | |||
| Respiratory system | 971,306 | 848,127 | 0.87318 |
| S | |||
| Sensory organs | 784,011 | 399,542 | 0.50961 |
| V | |||
| Various | 12,317 | 11,410 | 0.92636 |
Abbreviation: ATC, anatomical therapeutic chemical.
Completeness of the Danish National Database of Reimbursed Prescriptions compared with data from Statistics Denmark, according to main ATC groups, 2011
| ATC group, alphabetically | Number of users | Completeness | |
|---|---|---|---|
|
| |||
| Statistics Denmark | Danish National Database of Reimbursed Prescriptions | ||
| A (alimentary tract and metabolism) | 967,662 | 820,348 | 0.84776 |
| A01 (stomatological preparations) | 79,683 | 32,916 | 0.41309 |
| A02 (drugs for acid related disorders) | 522,244 | 474,602 | 0.90877 |
| A03 (drugs for functional gastrointestinal disorders) | 92,807 | 73,783 | 0.79502 |
| A04 (antiemetics and antinauseants) | 8,623 | 1,595 | 0.18497 |
| A06 (laxatives) | 116,005 | 21,759 | 0.18757 |
| A07 (antidiarrheals, intestinal anti-inflammatory/anti-infective agents) | 76,026 | 58,419 | 0.76841 |
| A08 (antiobesity preparations, excluding diet products) | 11,135 | 484 | 0.04347 |
| A09 (digestives, including enzymes) | 3,513 | 3,020 | 0.85966 |
| A10 (drugs used in diabetes) | 213,822 | 210,933 | 0.98649 |
| A11 (vitamins) | 7,563 | 1,870 | 0.24726 |
| A12 (mineral supplements) | 178,394 | 150,890 | 0.84582 |
| A14 (anabolic agents for systemic use) | – | – | – |
| A16 (other alimentary tract and metabolism products) | 36 | 36 | 1.00000 |
| B (blood and blood forming organs) | 630,769 | 552,340 | 0.87566 |
| B01 (antithrombotic agents) | 529,902 | 482,802 | 0.91112 |
| B02 (antihemorrhagics) | 14,071 | 13,858 | 0.98486 |
| B03 (antianemic preparations) | 135,709 | 81,466 | 0.60030 |
| B05 (blood substitutes and perfusion solutions) | 1,468 | 734 | 0.50000 |
| B06 (other hematological agents) | – | – | – |
| C (cardiovascular system) | 1,347,540 | 1,208,445 | 0.89678 |
| C01 (cardiac therapy) | 123,432 | 114,929 | 0.93111 |
| C02 (antihypertensives) | 16,863 | 16,472 | 0.97681 |
| C03 (diuretics) | 498,606 | 480,353 | 0.96339 |
| C04 (peripheral vasodilators) | 218 | 67 | 0.30734 |
| C05 (vasoprotectives) | 162,477 | 1,859 | 0.01144 |
| C07 (beta blocking agents) | 369,616 | 359,072 | 0.97147 |
| C08 (calcium channel blockers) | 386,423 | 374,911 | 0.97021 |
| C09 (agents acting on the renin-angiotensin system) | 663,034 | 637,123 | 0.96092 |
| C10 (lipid modifying agents) | 599,515 | 583,694 | 0.97361 |
| D (dermatologicals) | 1,019,743 | 700,754 | 0.68719 |
| D01 (antifungals for dermatological use) | 328,119 | 164,277 | 0.50066 |
| D02 (emollients and protectives) | 3,610 | 1,930 | 0.53463 |
| D03 (preparations for treatment of wounds and ulcers) | – | – | – |
| D04 (antipruritics, including antihistamines, anesthetics, etc) | 2,470 | 92 | 0.03725 |
| D05 (antipsoriatics) | 34,488 | 31,460 | 0.91220 |
| D06 (antibiotics and chemotherapeutics for dermatological use) | 221,361 | 67,572 | 0.30526 |
| D07 (corticosteroids, dermatological preparations) | 532,753 | 435,394 | 0.81725 |
| D08 (antiseptics and disinfectants) | 100 | 1 | 0.01000 |
| D09 (medicated dressings) | 54 | 16 | 0.29630 |
| D10 (anti-acne preparations) | 77,020 | 75,847 | 0.98477 |
| D11 (other dermatological preparations) | 31,775 | 26,116 | 0.82190 |
| G (genito-urinary system and sex hormones) | 881,901 | 361,112 | 0.40947 |
| G01 (gynecological antiinfectives and antiseptics) | 40,196 | 31,064 | 0.77281 |
| G02 (other gynecologicals) | 51,872 | 15,564 | 0.30005 |
| G03 (sex hormones and modulators of the genital system) | 665,257 | 221,547 | 0.33302 |
| G04 (urologicals) | 168,171 | 109,906 | 0.65354 |
| H (systemic hormonal preparations, excluding sex hormones and insulins) | 331,174 | 325,809 | 0.98380 |
| H01 (pituitary and hypothalamic hormones and analogues) | 20,793 | 20,608 | 0.99110 |
| H02 (corticosteroids for systemic use) | 179,354 | 177,611 | 0.99028 |
| H03 (thyroid therapy) | 138,002 | 134,215 | 0.97256 |
| H04 (pancreatic hormones) | 4,088 | 4,075 | 0.99682 |
| H05 (calcium homeostasis) | 2,290 | 2,227 | 0.97249 |
| J (anti-infectives for systemic use) | 1,914,610 | 1,812,957 | 0.94691 |
| J01 (antibacterials for systemic use) | 1,788,932 | 1,705,151 | 0.95317 |
| J02 (antimycotics for systemic use) | 144,202 | 143,498 | 0.99512 |
| J04 (antimycobacterials) | 1,053 | 1,042 | 0.98955 |
| J05 (antivirals for systemic use) | 91,266 | 88,303 | 0.96753 |
| J06 (immune sera and immunoglobulins) | 278 | 81 | 0.29137 |
| J07 (vaccines) | 41,004 | 1,257 | 0.03066 |
| L (antineoplastic and immunomodulating agents) | 41,402 | 41,015 | 0.99065 |
| L01 (antineoplastic agents) | 606 | 464 | 0.76568 |
| L02 (endocrine therapy) | 5,533 | 5,445 | 0.98410 |
| L03 (immunostimulants) | 4 | 2 | 0.50000 |
| L04 (immunosuppressants) | 35,434 | 35,272 | 0.99543 |
| M (musculo-skeletal system) | 972,270 | 908,079 | 0.93398 |
| M01 (anti-inflammatory and antirheumatic products) | 847,872 | 829,817 | 0.97871 |
| M02 (topical products for joint and muscular pain) | 17,241 | 430 | 0.02494 |
| M03 (muscle relaxants) | 47,794 | 11,514 | 0.24091 |
| M04 (antigout preparations) | 48,135 | 46,710 | 0.97040 |
| M05 (drugs for treatment of bone diseases) | 96,358 | 61,012 | 0.63318 |
| M09 (other drugs for disorders of the musculo-skeletal system) | 1,500 | 1,346 | 0.89733 |
| N (nervous system) | 1,259,843 | 1,065,246 | 0.84554 |
| N01 (anesthetics) | 6,290 | 882 | 0.14022 |
| N02 (analgesics) | 695,944 | 655,803 | 0.94232 |
| N03 (antiepileptics) | 132,667 | 114,548 | 0.86342 |
| N04 (anti-parkinson drugs) | 36,458 | 34,972 | 0.95924 |
| N05 (psycholeptics) | 469,373 | 137,133 | 0.29216 |
| N06 (psychoanaleptics) | 502,320 | 477,523 | 0.95064 |
| N07 (other nervous system drugs) | 70,572 | 33,578 | 0.47580 |
| P (antiparasitic products, insecticides, and repellents) | 237,957 | 136,087 | 0.57190 |
| P01 (antiprotozoals) | 163,470 | 135,859 | 0.83109 |
| P02 (antihelminitics) | 71,406 | 200 | 0.00280 |
| P03 (ectoparasiticides, including scabicides, insecticides and repellents) | 5,299 | 45 | 0.00849 |
| R (respiratory system) | 971,306 | 848,127 | 0.87318 |
| R01 (nasal preparations) | 262,688 | 245,496 | 0.93455 |
| R02 (throat preparations) | 11,197 | 102 | 0.00911 |
| R03 (drugs for obstructive airway diseases) | 456,836 | 454,748 | 0.99543 |
| R05 (cough and cold preparations) | 214,512 | 108,873 | 0.50754 |
| R06 (antihistamines for systemic use) | 274,120 | 232,694 | 0.84888 |
| R07 (other respiratory system products) | – | – | – |
| S (sensory organs) | 784,011 | 399,542 | 0.50961 |
| S01 (ophthalmological) | 678,838 | 306,007 | 0.45078 |
| S02 (otologicals) | 80,416 | 42,870 | 0.53310 |
| S03 (ophthalmological and otological preparations) | 68,512 | 68,215 | 0.99566 |
| V (various) | 12,317 | 11,410 | 0.92636 |
| V01 (allergens) | 10,593 | 10,512 | 0.99235 |
| V03 (all other therapeutic products) | 312 | 80 | 0.25641 |
| V04 (diagnostic agents) | 19 | 4 | 0.21053 |
| V07 (all other non-therapeutic products) | 1,417 | 829 | 0.58504 |
| V08 (contrast media) | – | – | – |
Abbreviation: ATC, anatomical therapeutic chemical.
Figure 1Selected linkage possibilities of Danish medical databases using the central personal registration (CPR) number.
Abbreviation: CPR, central personal registration.