Data Dictionary - Danish National Patient Registry

Table 1: t_adm (Central table with administrative information)

Variable	Period	Contents
c_adiag	1977 -	Contacts action diagnosis
c_dept	1977 -	The patient's main department
c_amt	1977 -	The patient's place of residence
c_andenbeh	1977 - 1986	Planned second treatment
c_block	1994 -	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 -	Referring department
c_henm	1987 -	Method of referral
c_hsgh	2004 -	Referral hospital
c_inform	1977 - 1986	Form of admission
c_indfra	1977 - 1986	Where the patient is admitted from
c_indm	1977 -	Enrollment method
c_kom	1977 -	The patient's municipality of residence
c_counter	1987 -	Contact reason
c_pattype	1977 -	Patient type
c_senstat	1977 - 1986	Planned later inpatient treatment
c_sex	1977 -	Gender of the patient
c_sgh	1977 -	The patient's primary hospital
c_sgamt	1977 -	Hospital administration
c_spec	1977 -	The stem department's main specialty
c_udm	1987 -	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 -	Referral date
d_inddto	1977 -	The contact's start date
d_opdatdto	2005 -	Internal date for updating the contact
d_uddto	1977 -	Contact end date
k_recnum	1977 -	Record number
v_alddg	2001 -	Patient's age in days
v_age	1977 -	Age of the patient
v_aldmdr	2001 -	Patient's age in months
in_behdage	1977 -	Treatment days
v_cpr	1977 -	The patient's social security number
v_indminut	1977 -	The contact's start minute
v_indtime	1977 -	The contact's start time
v_sengdage	1994 -	Treatment days/bed days
v_udtime	1994 -	Contact end time

Table 2: 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 3: 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 4: t_opr (contains information about operations carried out before 1996)

Variable	Period	Contents
c_nation	1977 -	Marker for contiguous operations
c_oafd	1977 -	Producing department
c_opr	1977 -	Operation code
c_osgh	1977 -	Producing hospital
v_recnum	1977 -	Record number

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

Variable	Period	Contents
c_oafd	1996 -	Producing department
c_opr	1996 -	Operation code
c_oprart	1996 -	Operationsart
c_osgh	1996 -	Producing hospital
c_tilopr	1996 -	Additional code for the operation
d_odto	1996 -	Operation date
v_recnum	1996 -	Record number
v_ominut	1998 -	Minute number for operation start
v_otime	1998 -	Hours for start of operation

Table 6: 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 -	Producing department
c_opr	1999 -	Procedure code
c_oprart	1999 -	Indication of supplementary code
c_osgh	1999 -	Producing hospital
c_tilopr	1999 -	Additional code for procedure
d_odto	1999 -	Procedure given
v_recnum	1999 -	Record number
v_ominut	1999 -	Minutes for procedure
v_otime	1999 -	Hours for procedure

Table 7: 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 -	Department to which the patient was discharged
c_udtilsgh	1977 -	Hospital to which the patient has been discharged
v_recnum	1977 -	Record number

Table 8: 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 -	windy state
d_vsldto	2004 -	End date of period with waiting status
d_vstdto	2004 -	Start date of period with waiting status
v_recnum	2004 -	Record number

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

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

Table 10: t_diag ()