Editing Data Dictionary - SSR Denmark

Table 1: t_patgrp (contains the meaning of the patient group code).
{| class="wikitable"
|-
! 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).
{| class="wikitable"
|-
! 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).
{| class="wikitable"
|-
! 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).
{| class="wikitable"
|-
! 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).
{| class="wikitable"
|-
! 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).
{| class="wikitable"
|-
! 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).
{| class="wikitable"
|-
! 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).
{| class="wikitable"
|-
! 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).
{| class="wikitable"
|-
! 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).
{| class="wikitable"
|-
! 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).
{| class="wikitable"
|-
! 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).