Data Dictionary - Danish National Patient Registry: Difference between revisions

From Beacon
No edit summary
m (Update categories.)
 
(20 intermediate revisions by 2 users not shown)
Line 1: Line 1:
Table: t_adm (Central table with administrative information)
<span style="display:none">forresearchers</span> <span style="display:none">denmarkcountry</span>
Go back to [[Database: The Danish National Patient Registry (DNPR) (Denmark)]] page
 
Source: [https://www.esundhed.dk/Dokumentation/DocumentationExtended?id=5 Click here to learn more].


{| class="wikitable"
{| class="wikitable"
! Variable !! Period !! Contents
! t_adm (the main table with administrative information)
|-
! Variable !! Period !! Description
|-
|-
| c_adiag || 1977 - || Contacts action diagnosis  
| c_adiag || 1977 onwards || Contacts action diagnosis  
|-
|-
| c_dept || 1977 - || The patient's main department  
| c_dept || 1977 onwards || The patient's main department  
|-
|-
| c_amt || 1977 - || The patient's place of residence  
| c_amt || 1977 onwards || The patient's place of residence  
|-
|-
| c_andenbeh || 1977 - 1986 || Planned second treatment  
| c_andenbeh || 1977 - 1986 || Planned second treatment  
|-
|-
| c_block || 1994 - || Specialty block  
| c_block || 1994 onwards || Specialty block  
|-
|-
| c_eakt || 1987 - 2003 || Activity in connection with an accident that leads to hospital contact  
| c_eakt || 1987 - 2003 || Activity in connection with an accident that leads to hospital contact  
Line 21: Line 26:
|-
|-
| c_epart || 1995 - 2003 || Mode of transport for those injured in traffic accidents/accidents
| c_epart || 1995 - 2003 || Mode of transport for those injured in traffic accidents/accidents
|-
| c_ested || 1987 - 2003 || Code for accident location  
| c_ested || 1987 - 2003 || Code for accident location  
|-
|-
| c_around || 1987 - 2003 || Traffic accident/accident or not  
| c_around || 1987 - 2003 || Traffic accident/accident or not  
|-
|-
| c_hafd || 2004 - || Referring department  
| c_hafd || 2004 onwards || Referring department  
|-
|-
| c_henm || 1987 - || Method of referral  
| c_henm || 1987 onwards || Method of referral  
|-
|-
| c_hsgh || 2004 - || Referral hospital  
| c_hsgh || 2004 onwards || Referral hospital  
|-
|-
| c_inform || 1977 - 1986 || Form of admission  
| c_inform || 1977 - 1986 || Form of admission  
Line 35: Line 41:
| c_indfra || 1977 - 1986 || Where the patient is admitted from  
| c_indfra || 1977 - 1986 || Where the patient is admitted from  
|-
|-
| c_indm || 1977 - || Enrollment method  
| c_indm || 1977 onwards || Enrollment method  
|-
|-
| c_kom || 1977 - || The patient's municipality of residence  
| c_kom || 1977 onwards || The patient's municipality of residence  
|-
|-
| c_counter || 1987 - || Contact reason  
| c_counter || 1987 onwards || Contact reason  
|-
|-
| c_pattype || 1977 - || Patient type  
| c_pattype || 1977 onwards || Patient type  
|-
|-
| c_senstat || 1977 - 1986 || Planned later inpatient treatment  
| c_senstat || 1977 - 1986 || Planned later inpatient treatment  
|-
|-
| c_sex || 1977 - || Gender of the patient  
| c_sex || 1977 onwards || Gender of the patient  
|-
|-
| c_sgh || 1977 - || The patient's primary hospital  
| c_sgh || 1977 onwards || The patient's primary hospital  
|-
|-
| c_sgamt || 1977 - || Hospital administration  
| c_sgamt || 1977 onwards || Hospital administration  
|-
|-
| c_spec || 1977 - || The stem department's main specialty  
| c_spec || 1977 onwards || The stem department's main specialty  
|-
|-
| c_udm || 1987 - || Termination method  
| c_udm || 1987 onwards || Termination method  
|-
|-
| c_udtil || 1977 - 1986 || To which institution the patient has been discharged  
| c_udtil || 1977 - 1986 || To which institution the patient has been discharged  
Line 60: Line 66:
|-
|-
| d_ebhdto || 1999 - 2003 || Date of final processing  
| d_ebhdto || 1999 - 2003 || Date of final processing  
|-
| d_fusdto || 1994 - 2003 || Date of preliminary investigation  
| d_fusdto || 1994 - 2003 || Date of preliminary investigation  
|-
|-
| d_hendto || 1977 - || Referral date  
| d_hendto || 1977 onwards || Referral date
|-
| d_inddto || 1977 onwards || The contact's start date
|-
| d_opdatdto || 2005 onwards || Internal date for updating the contact
|-
| d_uddto || 1977 onwards || Contact end date
|-
| k_recnum || 1977 onwards || Record number
|-
| v_alddg || 2001 onwards || Patient's age in days
|-
| v_age || 1977 onwards || Age of the patient
|-
| v_aldmdr || 2001 onwards || Patient's age in months
|-
| in_behdage || 1977 onwards || Treatment days
|-
| v_cpr || 1977 onwards || The patient's social security number
|-
| v_indminut || 1977 onwards || The contact's start minute
|-
| v_indtime || 1977 onwards || The contact's start time
|-
| v_sengdage || 1994 onwards || Treatment days/bed days
|-
| v_udtime || 1994 onwards || Contact end time
|}
 
{| class="wikitable"
! t_afl (contains information about procedures that have been planned but were cancelled)
|-
! Variable !! Period !! Description
|-
| c_oafd || 1999 onwards || Producing department
|-
| c_opr || 1999 onwards || Cancellation
|-
| c_oprart || 1999 onwards || Marking whether it is a primary code or an additional code
|-
| c_osgh || 1999 onwards || Producing hospitals
|-
| c_tilopr || 1999 onwards || The canceled procedure
|-
| v_recnum || 1999 onwards || Record number
|}
 
{| class="wikitable"
! t_distkod (contains information about local recording areas, e.g. social districts in large urban municipalities)
|-
! Variable !! Period !! Description
|-
| v_recnum || 1995 - 2000 || Record number
|-
| v_distcode || 1995 - 2000 || District code
|}
 
{| class="wikitable"
! t_optional (contains information about the extended free choice scheme, i.e. whether the patient is a voluntary patient. This table is therefore only relevant for contacts at private hospitals)
|-
! Variable !! Period !! Description
|-
| c_optional || 2004 onwards || Marker that the patient is covered by the extended free choice scheme.
|-
| v_recnum || 2004 onwards || Record number
|}
 
{| class="wikitable"
! t_opdatdto (contains the date of the last update of each hospital contact)
|-
! Variable !! Period !! Description
|-
| v_recnum || 2000 - 2004 || Record number
|-
| d_opdatdto || 2000 - 2004 || Internal update date
|}
 
{| class="wikitable"
! t_opr (contains information about operations that ocurred before 1996)
|-
! Variable !! Period !! Description
|-
| c_nation || 1977 onwards || Marker for contiguous operations
|-
|-
| d_inddto || 1977 - || The contact's start date
| c_oafd || 1977 onwards || Producing department
|-
|-
| d_opdatdto || 2005 - || Internal date for updating the contact
| c_opr || 1977 onwards  || Operation code
|-
|-
| d_uddto || 1977 - || Contact end date
| c_osgh || 1977 onwards || Producing hospital
|-
|-
| k_recnum || 1977 - || Record number  
| v_recnum || 1977 onwards || Record number
|}
 
{| class="wikitable"
! t_pers (contains information on dates for outpatient visits to psychiatric departments)
|-
|-
| v_alddg || 2001 - || Patient's age in days
! Variable !! Period !! Description
|-
| c_read1 || 1995 onwards || Staff involved in psychiatric visits
|-
| c_read2 || 1995 onwards || Staff involved in psychiatric visits
|-
| c_read3 || 1995 onwards || Staff involved in psychiatric visits
|-
| c_psykyd || 1995 onwards || Outpatient psychiatric service
|-
| c_ydsted || 1995 onwards || Place of outpatient psychiatric service
|-
| d_ambdto || 1995 onwards || Date of outpatient psychiatric visit
|-
| v_recnum || 1995 onwards || Record number
|}
 
{| class="wikitable"
! t_psykio (contains information on admission conditions/starting conditions for psychiatric patients)
|-
! Variable !! Period !! Description
|-
| c_indfra || 1995 onwards || Where the psychiatric patient is admitted from
|-
| c_in which || 1995 onwards || Admission conditions for psychiatric patients
|-
| c_udtil || 1995 onwards || Where the psychiatric patient is discharged to
|-
| v_recnum || 1995 onwards || Record number
|}
 
{| class="wikitable"
! t_sksopr (contains information on all operations carried out after 1 January 1996)
|-
! Variable !! Period !! Description
|-
| c_oafd || 1996 onwards || Producing department
|-
| c_opr || 1996 onwards || Operation code
|-
| c_oprart || 1996 onwards || Operationsart
|-
| c_osgh || 1996 onwards || Producing hospital
|-
| c_tilopr || 1996 onwards || Additional code for the operation
|-
| d_odto || 1996 onwards || Operation date
|-
| v_recnum || 1996 onwards || Record number
|-
| v_ominut || 1998 onwards || Minute number for operation start
|-
| v_otime || 1998 onwards || Hours for start of operation
|}
 
{| class="wikitable"
! _sksube (ontains information on all investigations, non-surgical treatments and administrative matters recorded on each patient contact. Thus, the table includes all classification codes that are not a diagnosis or operation)
|-
! Variable !! Period !! Description
|-
| c_oafd || 1999 onwards || Producing department
|-
| c_opr || 1999 onwards || Procedure code
|-
| c_oprart || 1999 onwards || Indication of supplementary code
|-
| c_osgh || 1999 onwards  || Producing hospital
|-
| c_tilopr || 1999 onwards  || Additional code for procedure
|-
| d_odto || 1999 onwards || Procedure given
|-
| v_recnum || 1999 onwards || Record number
|-
| v_ominut || 1999 onwards || Minutes for procedure
|-
| v_otime || 1999 onwards || Hours for procedure
|}
 
{| class="wikitable"
! t_stedf (contains information on the geographical location of accidents that lead to hospital contact)
|-
! Variable !! Period !! Description
|-
| c_precision || 2009 onwards || Degree of precision for accident detection
|-
| c_utm || 2009 onwards || UTM map projection
|-
| v_recnum || 2009 onwards || Record number
|-
| v_xcoord || 2009 onwards || x-coordinate when detecting an accident
|-
| v_ykoord || 2009 onwards || y-coordinate when detecting an accident
|}
 
{| class="wikitable"
! t_udtilsgh (contains information on which hospital department the patient was discharged to for those patients who were discharged to another hospital department)
|-
! Variable !! Period !! Description
|-
| c_udtilafd || 1977 onwards || Department to which the patient was discharged
|-
| c_udtilsgh || 1977 onwards || Hospital to which the patient has been discharged
|-
| v_recnum || 1977 onwards || Record number
|}
 
{| class="wikitable"
! t_ulyk (contains information about accidents in the form of accident codes)
|-
! Variable !! Period !! Description
|-
| c_art || 2000 onwards || Additional code indicator
|-
| c_tilulych || 2000 onwards || Additional code for accident code
|-
| c_accident || 2000 onwards || Accident code
|-
| v_recnum || 2000 onwards || Record number
|}
 
{| class="wikitable"
! t_sale (contains information on waiting periods for all contacts who have been in one or more waiting periods)
|-
! Variable !! Period !! Description
|-
| c_vstatus || 2004 onwards || windy state
|-
| d_vsldto || 2004 onwards || End date of period with waiting status
|-
| d_vstdto || 2004 onwards || Start date of period with waiting status
|-
| v_recnum || 2004 onwards || Record number
|}
 
{| class="wikitable"
! t_bes (contains dates for visits linked to somatic outpatient and part-time contacts)
|-
! Variable !! Period !! Description
|-
| d_ambdto || 1994 onwards || Date of outpatient visit
|-
| v_recnum || 1994 onwards || Record number
|}
 
{| class="wikitable"
! t_diag (contains information on all diagnoses linked to each contact, both the diagnosis codes themselves and the type of diagnoses, as well as any additional codes for each diagnosis)
|-
! Variable !! Period !! Description
|-
| c_diag || 1977 onwards || Diagnostic information
|-
| c_diagmod || 1977 - 1993 || diagnostic modification
|-
| c_diagtype || 1977 onwards || Diagnosetype
|-
| c_tildiag || 1995 onwards || Additional code for the diagnosis code
|-
| v_recnum || 1977 onwards || Record number
|}
 
{| class="wikitable"
! t_foedsler (contains certain information regarding births. For the mother, this is information about the history of the pregnancy, while for the child, it is about length, weight and number in the case of multiple births)
|-
! Variable !! Period !! Description
|-
| d_smdto || 1995 - 2003 || Date of last menstrual period
|-
| v_recnum || 1995 onwards || Record number
|-
| v_flernr || 1995 onwards || The child's number in the order of multiple births
|-
| v_jmbes || 1995 onwards || The number of visits to the midwife
|-
| v_langde || 1995 onwards || Child's length
|-
| v_lbes || 1995 onwards || Number of visits to own doctor
|-
| v_parity || 1995 onwards || Number of completed pregnancies
|-
| v_spbes || 1995 onwards || Number of visits to a specialist
|-
| v_guard || 1995 onwards || The child's weight
|}
 
{| class="wikitable"
! t_not (contains information on passive waiting periods and on whether the patient has refused an offer of treatment in another hospital department)
|-
|-
| v_age || 1977 - || Age of the patient
! Variable !! Period !! Description
|-
|-
| v_aldmdr || 2001 - || Patient's age in months
| c_tilbafd || 2002 onwards || department to which the refused treatment offer was given
|-
|-
| in_behdage || 1977 - || Treatment days
| c_tilbsgh || 2002 onwards || hospital to which the refused treatment offer was given
|-
|-
| v_cpr || 1977 - || The patient's social security number
| d_passldto || 1999 - 2003 || End date of passive waiting period
|-
|-
| v_indminut || 1977 - || The contact's start minute
| d_passtdto || 1999 - 2003 || Start date of passive waiting period
|-
|-
| v_indtime || 1977 - || The contact's start time
| d_tilbdto || 1999 onwards || Date when offer is rejected
|-
|-
| v_sengdage || 1994 - || Treatment days/bed days
| v_recnum || 1999 onwards || Record number
|-
|-
| v_udtime || 1994 - || Contact end time
| c_passarsag || 1999 onwards || Reason for passive waiting
|}
|}

Latest revision as of 13:27, 2 December 2025

forresearchers denmarkcountry Go back to Database: The Danish National Patient Registry (DNPR) (Denmark) page

Source: Click here to learn more.

t_adm (the main table with administrative information)
Variable Period Description
c_adiag 1977 onwards Contacts action diagnosis
c_dept 1977 onwards The patient's main department
c_amt 1977 onwards The patient's place of residence
c_andenbeh 1977 - 1986 Planned second treatment
c_block 1994 onwards Specialty block
c_eakt 1987 - 2003 Activity in connection with an accident that leads to hospital contact
c_labor 1987 - 2003 Accident mechanism
c_emodpart 1995 - 2003 Mode of transport for the other party in the event of an accident
c_epart 1995 - 2003 Mode of transport for those injured in traffic accidents/accidents
c_ested 1987 - 2003 Code for accident location
c_around 1987 - 2003 Traffic accident/accident or not
c_hafd 2004 onwards Referring department
c_henm 1987 onwards Method of referral
c_hsgh 2004 onwards Referral hospital
c_inform 1977 - 1986 Form of admission
c_indfra 1977 - 1986 Where the patient is admitted from
c_indm 1977 onwards Enrollment method
c_kom 1977 onwards The patient's municipality of residence
c_counter 1987 onwards Contact reason
c_pattype 1977 onwards Patient type
c_senstat 1977 - 1986 Planned later inpatient treatment
c_sex 1977 onwards Gender of the patient
c_sgh 1977 onwards The patient's primary hospital
c_sgamt 1977 onwards Hospital administration
c_spec 1977 onwards The stem department's main specialty
c_udm 1987 onwards Termination method
c_udtil 1977 - 1986 To which institution the patient has been discharged
c_accident 1977 - 1986 Accident code
d_ebhdto 1999 - 2003 Date of final processing
d_fusdto 1994 - 2003 Date of preliminary investigation
d_hendto 1977 onwards Referral date
d_inddto 1977 onwards The contact's start date
d_opdatdto 2005 onwards Internal date for updating the contact
d_uddto 1977 onwards Contact end date
k_recnum 1977 onwards Record number
v_alddg 2001 onwards Patient's age in days
v_age 1977 onwards Age of the patient
v_aldmdr 2001 onwards Patient's age in months
in_behdage 1977 onwards Treatment days
v_cpr 1977 onwards The patient's social security number
v_indminut 1977 onwards The contact's start minute
v_indtime 1977 onwards The contact's start time
v_sengdage 1994 onwards Treatment days/bed days
v_udtime 1994 onwards Contact end time
t_afl (contains information about procedures that have been planned but were cancelled)
Variable Period Description
c_oafd 1999 onwards Producing department
c_opr 1999 onwards Cancellation
c_oprart 1999 onwards Marking whether it is a primary code or an additional code
c_osgh 1999 onwards Producing hospitals
c_tilopr 1999 onwards The canceled procedure
v_recnum 1999 onwards Record number
t_distkod (contains information about local recording areas, e.g. social districts in large urban municipalities)
Variable Period Description
v_recnum 1995 - 2000 Record number
v_distcode 1995 - 2000 District code
t_optional (contains information about the extended free choice scheme, i.e. whether the patient is a voluntary patient. This table is therefore only relevant for contacts at private hospitals)
Variable Period Description
c_optional 2004 onwards Marker that the patient is covered by the extended free choice scheme.
v_recnum 2004 onwards Record number
t_opdatdto (contains the date of the last update of each hospital contact)
Variable Period Description
v_recnum 2000 - 2004 Record number
d_opdatdto 2000 - 2004 Internal update date
t_opr (contains information about operations that ocurred before 1996)
Variable Period Description
c_nation 1977 onwards Marker for contiguous operations
c_oafd 1977 onwards Producing department
c_opr 1977 onwards Operation code
c_osgh 1977 onwards Producing hospital
v_recnum 1977 onwards Record number
t_pers (contains information on dates for outpatient visits to psychiatric departments)
Variable Period Description
c_read1 1995 onwards Staff involved in psychiatric visits
c_read2 1995 onwards Staff involved in psychiatric visits
c_read3 1995 onwards Staff involved in psychiatric visits
c_psykyd 1995 onwards Outpatient psychiatric service
c_ydsted 1995 onwards Place of outpatient psychiatric service
d_ambdto 1995 onwards Date of outpatient psychiatric visit
v_recnum 1995 onwards Record number
t_psykio (contains information on admission conditions/starting conditions for psychiatric patients)
Variable Period Description
c_indfra 1995 onwards Where the psychiatric patient is admitted from
c_in which 1995 onwards Admission conditions for psychiatric patients
c_udtil 1995 onwards Where the psychiatric patient is discharged to
v_recnum 1995 onwards Record number
t_sksopr (contains information on all operations carried out after 1 January 1996)
Variable Period Description
c_oafd 1996 onwards Producing department
c_opr 1996 onwards Operation code
c_oprart 1996 onwards Operationsart
c_osgh 1996 onwards Producing hospital
c_tilopr 1996 onwards Additional code for the operation
d_odto 1996 onwards Operation date
v_recnum 1996 onwards Record number
v_ominut 1998 onwards Minute number for operation start
v_otime 1998 onwards Hours for start of operation
_sksube (ontains information on all investigations, non-surgical treatments and administrative matters recorded on each patient contact. Thus, the table includes all classification codes that are not a diagnosis or operation)
Variable Period Description
c_oafd 1999 onwards Producing department
c_opr 1999 onwards Procedure code
c_oprart 1999 onwards Indication of supplementary code
c_osgh 1999 onwards Producing hospital
c_tilopr 1999 onwards Additional code for procedure
d_odto 1999 onwards Procedure given
v_recnum 1999 onwards Record number
v_ominut 1999 onwards Minutes for procedure
v_otime 1999 onwards Hours for procedure
t_stedf (contains information on the geographical location of accidents that lead to hospital contact)
Variable Period Description
c_precision 2009 onwards Degree of precision for accident detection
c_utm 2009 onwards UTM map projection
v_recnum 2009 onwards Record number
v_xcoord 2009 onwards x-coordinate when detecting an accident
v_ykoord 2009 onwards y-coordinate when detecting an accident
t_udtilsgh (contains information on which hospital department the patient was discharged to for those patients who were discharged to another hospital department)
Variable Period Description
c_udtilafd 1977 onwards Department to which the patient was discharged
c_udtilsgh 1977 onwards Hospital to which the patient has been discharged
v_recnum 1977 onwards Record number
t_ulyk (contains information about accidents in the form of accident codes)
Variable Period Description
c_art 2000 onwards Additional code indicator
c_tilulych 2000 onwards Additional code for accident code
c_accident 2000 onwards Accident code
v_recnum 2000 onwards Record number
t_sale (contains information on waiting periods for all contacts who have been in one or more waiting periods)
Variable Period Description
c_vstatus 2004 onwards windy state
d_vsldto 2004 onwards End date of period with waiting status
d_vstdto 2004 onwards Start date of period with waiting status
v_recnum 2004 onwards Record number
t_bes (contains dates for visits linked to somatic outpatient and part-time contacts)
Variable Period Description
d_ambdto 1994 onwards Date of outpatient visit
v_recnum 1994 onwards Record number
t_diag (contains information on all diagnoses linked to each contact, both the diagnosis codes themselves and the type of diagnoses, as well as any additional codes for each diagnosis)
Variable Period Description
c_diag 1977 onwards Diagnostic information
c_diagmod 1977 - 1993 diagnostic modification
c_diagtype 1977 onwards Diagnosetype
c_tildiag 1995 onwards Additional code for the diagnosis code
v_recnum 1977 onwards Record number
t_foedsler (contains certain information regarding births. For the mother, this is information about the history of the pregnancy, while for the child, it is about length, weight and number in the case of multiple births)
Variable Period Description
d_smdto 1995 - 2003 Date of last menstrual period
v_recnum 1995 onwards Record number
v_flernr 1995 onwards The child's number in the order of multiple births
v_jmbes 1995 onwards The number of visits to the midwife
v_langde 1995 onwards Child's length
v_lbes 1995 onwards Number of visits to own doctor
v_parity 1995 onwards Number of completed pregnancies
v_spbes 1995 onwards Number of visits to a specialist
v_guard 1995 onwards The child's weight
t_not (contains information on passive waiting periods and on whether the patient has refused an offer of treatment in another hospital department)
Variable Period Description
c_tilbafd 2002 onwards department to which the refused treatment offer was given
c_tilbsgh 2002 onwards hospital to which the refused treatment offer was given
d_passldto 1999 - 2003 End date of passive waiting period
d_passtdto 1999 - 2003 Start date of passive waiting period
d_tilbdto 1999 onwards Date when offer is rejected
v_recnum 1999 onwards Record number
c_passarsag 1999 onwards Reason for passive waiting
Retrieved from "https://wiki.beaconcancer.org/index.php?title=Data_Dictionary_-_Danish_National_Patient_Registry&oldid=25935"
Powered by MediaWiki
Powered by Semantic MediaWiki