Data Dictionary - Danish National Patient Registry

Go back to Denmark page

More detailed information about the datasets [1].

Table 1: t_adm (the main table with administrative information).

Variable	Period	Contents
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

Table 2: t_afl (contains information about procedures that have been planned but were cancelled).

Variable	Period	Contents
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

Table 3: t_distkod (contains information about local recording areas, e.g. social districts in large urban municipalities).

Variable	Period	Contents
v_recnum	1995 - 2000	Record number
v_distcode	1995 - 2000	District code

Table 4: 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	Contents
c_optional	2004 onwards	Marker that the patient is covered by the extended free choice scheme.
v_recnum	2004 onwards	Record number

Table 5: t_opdatdto (contains the date of the last update of each hospital contact).

Variable	Period	Contents
v_recnum	2000 - 2004	Record number
d_opdatdto	2000 - 2004	Internal update date

Table 6: t_opr (contains information about operations that ocurred before 1996).

Variable	Period	Contents
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

Table 7: t_pers (contains information on dates for outpatient visits to psychiatric departments).

Variable	Period	Contents
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

Table 8: t_psykio (contains information on admission conditions/starting conditions for psychiatric patients).

Variable	Period	Contents
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

Table 9: t_sksopr (contains information on all operations carried out after 1 January 1996).

Variable	Period	Contents
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

Table 10: t_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	Contents
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

Table 11: t_stedf (contains information on the geographical location of accidents that lead to hospital contact).

Variable	Period	Contents
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

Table 12: 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	Contents
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

Table 13: t_ulyk (contains information about accidents in the form of accident codes).

Variable	Period	Contents
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

Table 14: t_sale (contains information on waiting periods for all contacts who have been in one or more waiting periods).

Variable	Period	Contents
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

Table 15: t_bes (contains dates for visits linked to somatic outpatient and part-time contacts).

Variable	Period	Contents
d_ambdto	1994 onwards	Date of outpatient visit
v_recnum	1994 onwards	Record number

Table 16: 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	Contents
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

Table 17: 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	Contents
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

Table 18: 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	Contents
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