Editing Data Dictionary - SSR Denmark

<span style="display:none">forresearchers</span> 
Go back to [[Database: The National Health Insurance Service Register (SSR) (Denmark)]] page

Source: [https://www.esundhed.dk/Dokumentation/DocumentationExtended?id=10 Click here to learn more]

{| class="wikitable"
|-
! t_patgrp (contains the meaning of the patient group code)
|-
! Variable || Period || Description
|-
| 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
|}

{| class="wikitable"
|-
! t_practice (contains the meaning of the practice type code)
|-
! Variable || Period || Description
|-
| 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
|}

{| class="wikitable"
|-
! 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 || Description
|-
| c_special || 1990 - || Provider's main specialty
|-
| c_service no || 1990 - || 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
|}

{| class="wikitable"
|-
! t_sikgrp (contains security group codes and their meaning)
|-
! Variable || Period || Description
|-
| 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
|}

{| class="wikitable"
|-
! t_sikkon (table contains codes for gender and their meaning)
|-
! Variable || Period || Description
|-
| 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
|}

{| class="wikitable"
|-
! t_speciale (contains codes for specialties and their meaning)
|-
! Variable || Period || Description
|-
| 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
|}

{| class="wikitable"
|-
! t_ssik<åååå> (contains information about the patient, the provider and the service that was provided under the health insurance)
|-
! Variable || Period || Description
|-
| c_henamt || 1990 - || County/region code of referring provider
|-
| c_henynr || 1990 - || The reference number of the referring provider
|-
| c_patgrp || 1990 - || The patient's relationship with the provider
|-
| c_practice || 1990 - || The type of practice where the service is provided
|-
| c_sikgrp || 1990 - || Health insurance group to which the insured belongs
|-
| c_sikkon || 1990 - || Ensured gender
|-
| c_sikramt || 1990 - || Insured's place of residence/region
|-
| c_sikrcom || 1990 - || Secreted's municipality of residence
|-
| c_special || 1990 - || Provider's main specialty
|-
| c_timecode || 1990 - || Time of performance
|-
| c_yamt || 1990 - || Provider's amt/region
|-
| c_service no || 1990 - || The performance
|-
| c_ykom || 1990 - || Provider's municipality
|-
| c_ynr || 1990 - || The outside number
|-
| c_ytype || 1990 - || Provider's type
|-
| v_afrmdr || 1990 - || Benefit month
|-
| v_afraar || 1990 - || Settlement year
|-
| v_age || 1990 - || Age of insured
|-
| v_antydel || 1990 - || Number of benefits
|-
| v_gross || 1990 - || Gross fee for the service
|-
| v_caries || 2000 - || Number of cavities in the teeth
|-
| v_cpr || 1990 - || Secured social security number
|-
| v_filling || 2000 - || Number of fillings
|-
| v_honuge || 1990 - || Honor week
|-
| v_honaar || 1990 - || Honors year
|-
| in_contact || 1990 - || Physical presence or not
|-
| v_tand || 2000 - || Number of natural teeth
|}

{| class="wikitable"
|-
! t_tekst (contains a complete description of benefits paid by the health insurance, broken down by year and quarter)
|-
! Variable || Period || Description
|-
| c_special || 1990 - || Provider's main specialty
|-
| c_service no || 1990 - || 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
|}

{| class="wikitable"
|-
! t_tidskode (contains time codes and their meaning)
|-
! Variable || Period || Description
|-
| 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
|}

{| class="wikitable"
|-
! t_ydelsesnr (contains a complete description of benefits paid by the health insurance)
|-
! Variable || Period || Description
|-
| 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
|}

{| class="wikitable"
|-
! t_ytype (contains codes for external type and their meaning)
|-
! Variable || Period || Description
|-
| 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 || Provider's type in code form
|-
| v_meaning || 2000 and onwards || Meaning of code
|}

{| class="wikitable"
|-
! 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 || Description
|-
| c_henamt || 1990 - || County/region code of referring provider
|-
| c_henynr || 1990 - || The reference number of the referring provider
|-
| c_patgrp || 1990 - || The patient's relationship with the provider
|-
| c_practice || 1990 - || The type of practice where the service is provided
|-
| c_sikgrp || 1990 - || Health insurance group to which the insured belongs
|-
| c_sikkon || 1990 - || Ensured gender
|-
| c_sikramt || 1990 - || Insured's place of residence/region
|-
| c_sikrcom || 1990 - || Secrede's municipality of residence
|-
| c_special || 1990 - || Provider's main specialty
|-
| c_timecode || 1990 - || Time of performance
|-
| c_yamt || 1990 - || Provider's amt/region
|-
| c_service no || 1990 - || The performance
|-
| c_ykom || 1990 - || Provider's municipality
|-
| c_ynr || 1990 - || The outside number
|-
| c_ytype || 1990 - || Provider's type
|-
| v_afrmdr || 1990 - || Benefit month
|-
| v_afraar || 1990 - || Settlement year
|-
| v_age || 1990 - || Age of insured
|-
| v_antydel || 1990 - || Number of benefits
|-
| v_gross || 1990 - || Gross fee for the service
|-
| v_caries || 2000 - || Number of cavities in the teeth
|-
| v_filling || 2000 - || Number of fillings
|-
| v_honuge || 1990 - || Honor week
|-
| v_honaar || 1990 - || Honors year
|-
| in_contact || 1990 - || Physical presence or not
|-
| v_tand || 2000 - || Number of natural teeth
|}

{| class="wikitable"
|-
! t_sikrede (contains relevant information about the insured patient)
|-
! Variable || Period || Description
|-
| adresse
| 2014 onwards
| Address of insured
|-
| adressebeskyttelse
| 2014 onwards
| Marker for address protection
|-
| alder
| 2014 onwards
| Age of insured
|-
| bydelsnummer
| 2014 onwards
| District number
|-
| bynavn
| 2014 onwards
| City name of the insured's residence
|-
| civilstand
| 2014 onwards
| Marital status secured
|-
| co_navn
| 2014 onwards
| Insured c/o name
|-
| cprnummer
| 2014 onwards
| Secured CPR number
|-
| etage
| 2014 onwards
| The floor of the insured's residence
|-
| foelgeskabsperson
| 2014 onwards
| Companion of the insured
|-
| fremtidig_sikgrp_ikraftdato
| 2014 onwards
| Effective date for the insured's future insurance group.
|-
| fremtidig_sikgrp_regdato
| 2014 onwards
| Registration date for the insured's future insurance group.
|-
| fremtidig_sikringsgruppe
| 2014 onwards
| Future security group
|-
| fremtidigt_ydernummer
| 2014 onwards
| Future extension number
|-
| fremtidigt_ydernummer_ikraftdato
| 2014 onwards
| Effective date for future external no.
|-
| fremtidigt_ydernummer_regdato
| 2014 onwards
| Registration date for future external no.
|-
| husnummer
| 2014 onwards
| The house number of the insured's residence
|-
| koen
| 2014 onwards
| Ensured gender
|-
| lokalitet
| 2014 onwards
| Secured location
|-
| navn
| 2014 onwards
| Name of insured
|-
| opgoerelsesdato
| 2014 onwards
| Statement date
|-
| postdistrikt
| 2014 onwards
| The postal district of the insured's residence
|-
| postnummer
| 2014 onwards
| Zip code of insured's residence
|-
| sidedoer
| 2014 onwards
| The side door of the insured's residence
|-
| sikredes_kommune
| 2014 onwards
| Secured municipality of residence in code form
|-
| sikredes_kommune_ikraftdato
| 2014 onwards
| Start date for the insured's residence in the municipality
|}

{| class="wikitable"
|-
! t_ssr <åååå> (contains information about the patient, the provider and the service that was provided under the health insurance)
|-
! Variable || Period || Description
|-
| settlement month
| 2014 onwards
| Settlement month
|-
| settlement year
| 2014 onwards
| Settlement year
|-
| request_time
| 2014 onwards
| Request time
|-
| number_of_services
| 2014 onwards
| Number of benefits
|-
| number_of_services_on_the_bill
| 2014 onwards
| Services on the bill
|-
| children_marked
| 2014 onwards
| Marker for the insured's child
|-
| treatment_end date
| 2014 onwards
| Treatment end date
|-
| the treatment_start date
| 2014 onwards
| Treatment start date
|-
| processing_date
| 2014 onwards
| Treatment date
|-
| paying_region
| 2014 onwards
| Paying region
|-
| attachment number
| 2014 onwards
| Attachment number
|-
| bruttohonorar_oere
| 2014 onwards
| Gross fee in øre
|-
| bundle number
| 2014 onwards
| Batch number
|-
| district number
| 2014 onwards
| District number
|-
| data name
| 2014 onwards
| Data Name
|-
| diagnosis code
| 2014 onwards
| Diagnostic code
|-
| electronic_signature
| 2014 onwards
| Electronic_signature
|-
| grundhonorar_oere
| 2014 onwards
| Basic fee in euros
|-
| reference_external no
| 2014 onwards
| Referring provider's external no.
|-
| referral_reason
| 2014 onwards
| Reason for referral
|-
| referral date
| 2014 onwards
| Referral date
|-
| referral type
| 2014 onwards
| Referral type
|-
| referral provider_region
| 2014 onwards
| Referral provider's region
|-
| honoraruge
| 2014 onwards
| Honoraruge
|-
| honorary
| 2014 onwards
| Honorary year
|-
| fee_week
| 2014 onwards
| Fee year_week
|-
| entry date
| 2014 onwards
| Entry date
|-
| contact
| 2014 onwards
| Contact
|-
| settlement date
| 2014 onwards
| Statement date
|-
| settlement time
| 2014 onwards
| Settlement time
|-
| pid
| 2014 onwards
| PID - encrypted CPR no.
|-
| practice municipality
| 2014 onwards
| The municipality of practice in code form
|-
| case handler_account processing
| 2014 onwards
| Case handler's system for bill processing
|-
| insured_age
| 2014 onwards
| Age of insured
|-
| secured_cpr
| 2014 onwards
| Insured's CPR no.
|-
| insured's_municipality
| 2014 onwards
| Secured municipality of residence in code form
|-
| secured_region
| 2014 onwards
| Insured's region of residence
|-
| security group
| 2014 onwards
| Health insurance group
|-
| sorting field
| 2014 onwards
| Sort field
|-
| statistics_information
| 2014 onwards
| Statistics information
|-
| status code
| 2014 onwards
| Status codes
|-
| taender_carierede
| 2014 onwards
| Carious teeth
|-
| teeth_fillings
| 2014 onwards
| Fillings in teeth
|-
| teeth_natural
| 2014 onwards
| Number of natural teeth
|-
| time code
| 2014 onwards
| Time code
|-
| inconvenience code
| 2014 onwards
| Defect code
|-
| service_number
| 2014 onwards
| Performance code
|-
| provider's_amtsydertype
| 2014 onwards
| The provider's county provider type
|-
| the provider's_practice area
| 2014 onwards
| The provider's practice area
|-
| provider_practicetype
| 2014 onwards
| Provider's practice type
|-
| provider_region
| 2014 onwards
| The outer region
|-
| provider's_specialty
| 2014 onwards
| The outsider's specialty
|-
| outsider's_guard area
| 2014 onwards
| The guard area of the outsider
|-
| external number
| 2014 onwards
| External number
|}

{| class="wikitable"
|-
! t_sats (contains the rate for the various agreements)
|-
! Variable || Period || Description
|-
| concept
| 2014 onwards
| Concept
|-
| name
| 2014 onwards
| The name of the batch
|-
| 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
|}

{| class="wikitable"
|-
! t_services (contains the start and end date for the individual benefits, in addition to the name of the benefit, settlement date and collective agreement code)
|-
! Variable || Period || Description
|-
| characteristic
| 2014 onwards
| The feature of the performance
|-
| short text
| 2014 onwards
| Brief description of performance
|-
| quarter
| 2014 onwards
| Update quarter
|-
| long text
| 2014 onwards
| Long description of performance
|-
| 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
|}