Go back to Database: The National Health Insurance Service Register (SSR) (Denmark) page
Source: Click here to learn more
| 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
|
| 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
|
| 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
|
| 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
|
| 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
|
| 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
|
| 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
|
| 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
|
| 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
|
| 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
|
| 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
|
| 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
|
| 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
|
| 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
|
| 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
|
| 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
|
