| Literature DB >> 27563255 |
Maiken Ina Siegismund Kjaersgaard1, Peter Vedsted2, Erik Thorlund Parner1, Bodil Hammer Bech3, Mogens Vestergaard4, Kaare Rud Flarup2, Morten Fenger-Grøn2.
Abstract
BACKGROUND: The patient list system in Denmark assigns virtually all residents to a general practice. Nevertheless, historical information on this link between patient and general practice is not readily available for research purposes.Entities:
Keywords: general practice; medical record linkage; patient list; primary care; registers
Year: 2016 PMID: 27563255 PMCID: PMC4984827 DOI: 10.2147/CLEP.S108307
Source DB: PubMed Journal: Clin Epidemiol ISSN: 1179-1349 Impact factor: 4.790
Outline of the steps in the algorithm linking patients and general practices in Denmark using data from the National Health Service Register and the Civil Registration System
| Step number | Title and description |
|---|---|
| Step 1 | |
| Restrict data from the National Health Service Register and recode time of service as described in the sections on “Selection of services” and “Recoding the time of services.” | |
| Step 2 | |
| Exclude invoices on or after patients’ date of death or emigration until reimmigration, if applicable. | |
| Step 3 | |
| If invoices pertaining to more than one general practice are registered for the same patient within the same week, exclude all the invoices for the patient during that week. | |
| Step 4 | |
| Code preliminary practice time intervals for each patient–general practice relationship, starting from the date of first contact with a practice until the day before contact with another practice or end of follow-up. | |
| Step 5 | |
| If a patient emigrates (including moving to Greenland) or dies within a preliminary practice time interval, recode the end date of the interval to the date of emigration or death, whichever came first. | |
| Step 6 | |
| For each general practice, define the closure date as the last date with registered services, unless the date falls within the last month before end of follow-up. Recode the end date to closure date for all patient intervals concerning this general practice and including this date. If applicable, recode the starting date for the same patient’s subsequent practice time interval to the next day. | |
| Step 7 | |
| For patients moving between municipalities in Denmark (codes 101-861; 275 municipalities) within an interval, recode the end date to the moving date and the subsequent starting date to the following day. For patients moving more than once, use the latest moving date. | |
| Step 8 | |
| Drop patient–general practice intervals shorter than 31 days, unless the interval starts on the first of a month and ends on the last day of a month, and include the time in the preceding interval. | |
| Step 9 | |
| Recode the starting date to the first date of the month. Recode the end date to the last date of the preceding month, unless the interval ends on the date of death or emigration or on the last day of the month. |
Figure 1Coverage by time since January 1, 2002.
Notes: The blue curve depicts the percentage of the total Group-1-insured practice population allocated to a general practice for each month. The red curve depicts the percentage of patients allocated correctly in accordance with the Patient List Database. The straight, solid lines represent coverage within 1 year and 2 years from onset.
Percentage of agreement stratified by age and sex
| Age (years) | Men (%) | Women (%) | Total (%) |
|---|---|---|---|
| 0–17 | 98.6 | 98.6 | 98.6 |
| 18–34 | 96.4 | 97.8 | 97.1 |
| 35–49 | 98.6 | 99.1 | 98.9 |
| 50–64 | 99.2 | 99.3 | 99.2 |
| 65–79 | 99.4 | 99.5 | 99.4 |
| ≥80 | 99.5 | 99.5 | 99.5 |
| Total | 98.4 | 98.8 | 98.6 |
Percentage of agreement stratified by calendar time
| Year | Total (%) |
|---|---|
| 2002 | 99.2 |
| 2003 | 98.8 |
| 2004 | 98.4 |
| 2005 | 98.3 |
| 2006 | 98.4 |
| 2007 | 98.7 |
| Total | 98.6 |
Overview of data sources
| Source | Information | Remarks | Variable name |
|---|---|---|---|
| National Health Service Register | Patient’s identification number | PNR (Encrypted V_CPR) | |
| Provider number | YNR (Encrypted C_YNR) | ||
| Provider speciality | Use only general practice | C_SPECIALE | |
| Services provided in general practice | Use only basic fee services | C_YDELSESNR | |
| Week and year service was provided | V_HONUGE and V_HONAAR | ||
| Month and year service was invoiced | V_AFRMDR and V_AFRAAR | ||
| Time of service during week | Use only Monday–Friday 8 am–4 pm | C_TIDSKODE | |
| Type of patient | Use only own patients | C_PATGRP | |
| Health insurance group | Use only Group-1-insured | C_SIKGRP | |
| Indication for service in child | Exclude children | C_SIKKON | |
| Civil Registration System | Patient’s identification number | PNR (Encrypted V_PNR) | |
| Patient’s date of death | C_STATUS and D_STATUS_HEN_START | ||
| Patient’s migration history | Current and historical information including Greenland | D_UDREJSE_DATO and D_INDREJSE_DATO | |
| Patient’s movement history | Current and historical information | D_TILFLYT_DATO, D_FRAFLYT_DATO, C_ANNKOR and C_KOM |
List of basic fee services for the years 1990–2015 to be used in the algorithm
| Service code |
|---|
Note: The services provided in 2002–2007 are indicated by numbers in bold font.
List of basic fee services with PPV for patient type “own patient (Group-1)”
| Type of service | Service code | No of services | PPV (%) | Type of service | Service code | No of services | PPV (%) |
|---|---|---|---|---|---|---|---|
| Ordinary | 0101 | 102,023,368 | 99.6 | 8140 | 293,705 | 99.7 | |
| consultations | 0102 | 3,179 | 99.3 | Child care | 8210 | 58,780 | 98.3 |
| 0103 | 204,301 | 99.8 | 8211 | 342,186 | 99.6 | ||
| 0104 | 200,364 | 99.9 | 8212 | 360,921 | 99.7 | ||
| 0105 | 1,499,362 | 99.6 | 8213 | 364,182 | 99.7 | ||
| 0106 | 1,260,314 | 99.9 | 8214 | 298,853 | 99.8 | ||
| 0107 | 1,939 | 99.8 | 8215 | 277,045 | 99.8 | ||
| 0108 | 164 | 100 | 8216 | 260,234 | 99.8 | ||
| 0109 | 68 | 100 | 8217 | 339,701 | 99.8 | ||
| Telephone Home visits | 0201 | 81,627,440 | 99.4 | Hepatitis B vaccinations | 8317 | 3,114 | 99.6 |
| 0411 | 1,932,053 | 97.4 | 8318 | 305 | 100 | ||
| 0421 | 427,655 | 97.2 | 8319 | 670 | 99.0 | ||
| 0431 | 221,209 | 96.8 | 8320 | 143 | 100 | ||
| 0441 | 59,181 | 96.0 | 8326 | 133 | 100 | ||
| 0451 | 16,511 | 93.8 | 8327 | 630 | 99.8 | ||
| 0461 | 7,927 | 90.9 | Children’s vaccinations | 8701 | 537,154 | 99.8 | |
| 0491 | 305,516 | 98.7 | 8702 | 24,495 | 99.6 | ||
| Talk therapy | 4003 | 153,172 | 99.7 | 8705 | 19,636 | 99.6 | |
| 4021 | 38,396 | 99.3 | 8706 | 273,386 | 99.6 | ||
| 4022 | 32 | 100 | 8707 | 31,973 | 99.8 | ||
| 4050 | 31,232 | 99.4 | Other vaccinations | 8901 | 1,530 | 99.6 | |
| 4063 | 13,452 | 99.7 | 8920 | 1,185,584 | 99.9 | ||
| 4106 | 50,494 | 99.7 | 8921 | 84,822 | 99.8 | ||
| 6101 | 1,164,460 | 99.6 | 8922 | 20,553 | 99.8 | ||
| Antenatal care | 8110 | 401,744 | 99.5 | 8923 | 1,436 | 99.7 | |
| 8120 | 332,346 | 99.5 | 8924 | 40,430 | 99.8 | ||
| 8130 | 316,516 | 99.5 | 8925 | 1,215 | 100 |
Abbreviaton: PPV, positive predictive value.