Data Dictionary - SSR Denmark

Table 1: t_patgrp (contains the meaning of the patient group code).

Variable	Period	Contents
d_tildto	1990 onwards	End date of the code's validity period
k_fradto	1990 onwards	Start date of the code's validity period
k_patgrp	1990 onwards	The patient group in code form
v_meaning	2000 and onwards	Meaning of code

Table 2: t_practice (contains the meaning of the practice type code).

Variable	Period	Contents
d_tildto	1990 onwards	End date of the code's validity period
k_practice	1990 onwards	Practice type in code form
v_meaning	2000 and onwards	Meaning of code

Table 3: t_pris (contains a complete description of the basic fee and gross fee for the services paid for by the health insurance register, broken down by year and quarter).

Variable	Period	Contents
c_special	nineteen ninety -	Yder's main specialty
c_service no	nineteen ninety -	The performance
c_defect code	2000 and onwards	Defect code
v_aar	2000 and onwards	Update year
v_afrfraaar	2000 and onwards	The starting year for settlement of benefits
v_afrframdr	2000 and onwards	Start month for settlement of benefits
v_afrtilaar	2000 and onwards	Final year for settlement of benefits
v_afrtilmdr	2000 and onwards	Final month for settlement of benefits
v_bruthon1	2000 and onwards	Gross fee for service
v_bruthon2	2000 and onwards	Gross fee for service
v_fraaar	2000 and onwards	Starting year for fees
v_frauge	2000 and onwards	Start week for fee
v_grundhon	2000 and onwards	Basic fee, before regulation
v_kvartal	2000 and onwards	Update quarter
v_tilaar	2000 and onwards	Final year for fees
v_tiluge	2000 and onwards	Final week for fees
basic fee_in_oere	2014 onwards	Basic fee in euros
settlement date	2014 onwards	Statement date
collective agreement code	2014 onwards	Agreement code
period_from	2014 onwards	Start date
period_to	2014 onwards	End date
regulated_honorar_in_oere	2014 onwards	Regulated fee in ears

Table 4: t_sikgrp (ontains security group codes and their meaning).

Variable	Period	Contents
d_tildto	1990 onwards	End date of the code's validity period
k_fradto	1990 onwards	Start date of the code's validity period
k_sikgrp	1990 onwards	Security group in code form
v_meaning	2000 and onwards	Meaning of code

Table 5: t_sikkon (table contains codes for gender and their meaning).

Variable	Period	Contents
d_tildto	1990 onwards	End date of the code's validity period
k_sikkon	1990 onwards	Secured gender in code form
v_meaning	2000 and onwards	Meaning of code

Table 6: t_speciale (contains codes for specialties and their meaning).

Variable	Period	Contents
k_fradto	1990 onwards	Start date of the code's validity period
k_special	1990 onwards	External specialty in code form
v_meaning	2000 and onwards	Meaning of code

Table 7: t_ssik<åååå> (contains information about the patient, the provider and the service that was provided under the health insurance).

Variable	Period	Contents
c_henamt	nineteen ninety -	County/region code of referring provider
c_henynr	nineteen ninety -	The reference number of the referring provider
c_patgrp	nineteen ninety -	The patient's relationship with the provider
c_practice	nineteen ninety -	The type of practice where the service is provided
c_sikgrp	nineteen ninety -	Health insurance group to which the insured belongs
c_sikkon	nineteen ninety -	Ensured gender
c_sikramt	nineteen ninety -	Insured's place of residence/region
c_sikrcom	nineteen ninety -	Secreted's municipality of residence
c_special	nineteen ninety -	Yder's main specialty
c_timecode	nineteen ninety -	Time of performance
c_yamt	nineteen ninety -	Yders amt/region
c_service no	nineteen ninety -	The performance
c_ykom	nineteen ninety -	Yders municipality
c_ynr	nineteen ninety -	The outside number
c_ytype	nineteen ninety -	Ydertypen
v_afrmdr	nineteen ninety -	Benefit month
v_afraar	nineteen ninety -	Settlement year
v_age	nineteen ninety -	Age of insured
v_antydel	nineteen ninety -	Number of benefits
v_gross	nineteen ninety -	Gross fee for the service
v_caries	2000 -	Number of cavities in the teeth
v_cpr	nineteen ninety -	Secured social security number
v_filling	2000 -	Number of fillings
v_honuge	nineteen ninety -	Honor week
v_honaar	nineteen ninety -	Honors year
in_contact	nineteen ninety -	Physical presence or not
v_tand	2000 -	Number of natural teeth

Table 8: t_tekst (contains a complete description of benefits paid by the health insurance, broken down by year and quarter).

Variable	Period	Contents
c_special	nineteen ninety -	Yder's main specialty
c_service no	nineteen ninety -	The performance
v_aar	2000 and onwards	Update year
v_short text	2000 and onwards	Brief description of performance
v_kvartal	2000 and onwards	Update quarter
v_longtext	2000 and onwards	Long description of performance

Table 9: t_tidskode (contains time codes and their meaning).

Variable	Period	Contents
d_tildto	1990 onwards	End date of the code's validity period
k_fradto	1990 onwards	Start date of the code's validity period
k_time code	1990 onwards	Time in code form
v_meaning	2000 and onwards	Meaning of code

Table 10: t_ydelsesnr (contains a complete description of benefits paid by the health insurance).

Variable	Period	Contents
d_tildto	1990 onwards	End date of the code's validity period
k_fradto	1990 onwards	Start date of the code's validity period
k_special	1990 onwards	External specialty in code form
k_service no	1990 onwards	Service no. in code form
v_meaning	2000 and onwards	Meaning of code

Table 11: t_ytype (contains codes for external type and their meaning).

Variable	Period	Contents
d_tildto	1990 onwards	End date of the code's validity period
k_fradto	1990 onwards	Start date of the code's validity period
k_ytype	1990 onwards	Ydertype i kodeform
v_meaning	2000 and onwards	Meaning of code

Table 12: v_ssik<åååå> (contains information about the patient, the provider and the service that was provided under the health insurance. Same as t_ssik, except for the CPR number, that is not contained in the present table).

Variable	Period	Contents
c_henamt	nineteen ninety -	County/region code of referring provider
c_henynr	nineteen ninety -	The reference number of the referring provider
c_patgrp	nineteen ninety -	The patient's relationship with the provider
c_practice	nineteen ninety -	The type of practice where the service is provided
c_sikgrp	nineteen ninety -	Health insurance group to which the insured belongs
c_sikkon	nineteen ninety -	Ensured gender
c_sikramt	nineteen ninety -	Insured's place of residence/region
c_sikrcom	nineteen ninety -	Secrede's municipality of residence
c_special	nineteen ninety -	Yder's main specialty
c_timecode	nineteen ninety -	Time of performance
c_yamt	nineteen ninety -	Yders amt/region
c_service no	nineteen ninety -	The performance
c_ykom	nineteen ninety -	Yders municipality
c_ynr	nineteen ninety -	The outside number
c_ytype	nineteen ninety -	Ydertypen
v_afrmdr	nineteen ninety -	Benefit month
v_afraar	nineteen ninety -	Settlement year
v_age	nineteen ninety -	Age of insured
v_antydel	nineteen ninety -	Number of benefits
v_gross	nineteen ninety -	Gross fee for the service
v_caries	2000 -	Number of cavities in the teeth
v_filling	2000 -	Number of fillings
v_honuge	nineteen ninety -	Honor week
v_honaar	nineteen ninety -	Honors year
in_contact	nineteen ninety -	Physical presence or not
v_tand	2000 -	Number of natural teeth

Table 13: t_sikrede (contains relevant information about the insured patient).

Table 14: