Data Dictionary - SSR Denmark: Difference between revisions

From Beacon
(Created page with "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="wi...")
 
m (Update categories.)
 
(14 intermediate revisions by 2 users not shown)
Line 1: Line 1:
Table 1: t_patgrp (contains the meaning of the patient group code).
<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"
{| class="wikitable"
|-
|-
! Variable || Period || Contents
! 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
| d_tildto || 1990 onwards || End date of the code's validity period
Line 13: Line 19:
|}
|}


Table 2: t_practice (contains the meaning of the practice type code).
{| class="wikitable"
{| class="wikitable"
|-
|-
! Variable || Period || Contents
! 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
| d_tildto || 1990 onwards || End date of the code's validity period
Line 25: Line 32:
|}
|}


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"
{| class="wikitable"
|-
|-
! Variable || Period || Contents
! 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 || nineteen ninety - || Yder's main specialty
| c_special || 1990 - || Provider's main specialty
|-
|-
| c_service no || nineteen ninety - || The performance
| c_service no || 1990 - || The performance
|-
|-
| c_defect code || 2000 and onwards || Defect code
| c_defect code || 2000 and onwards || Defect code
Line 75: Line 83:
|}
|}


Table 4: t_sikgrp (ontains security group codes and their meaning).
{| class="wikitable"
{| class="wikitable"
|-
|-
! Variable || Period || Contents
! t_sikgrp (contains security group codes and their meaning)
|-
! Variable || Period || Description
|-
|-
| d_tildto || 1990 onwards || End date of the code's validity period
| d_tildto || 1990 onwards || End date of the code's validity period
Line 89: Line 98:
|}
|}


Table 5: t_sikkon (table contains codes for gender and their meaning).
{| class="wikitable"
{| class="wikitable"
|-
|-
! Variable || Period || Contents
! 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
| d_tildto || 1990 onwards || End date of the code's validity period
Line 101: Line 111:
|}
|}


Table 6: t_speciale (contains codes for specialties and their meaning).
{| class="wikitable"
{| class="wikitable"
|-
|-
! Variable || Period || Contents
! 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_fradto || 1990 onwards || Start date of the code's validity period
Line 113: Line 124:
|}
|}


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


Table 9: t_tidskode (contains time codes and their meaning).
{| class="wikitable"
{| class="wikitable"
|-
|-
! Variable || Period || Contents
! t_tidskode (contains time codes and their meaning)
|-
! Variable || Period || Description
|-
|-
| d_tildto || 1990 onwards || End date of the code's validity period
| d_tildto || 1990 onwards || End date of the code's validity period
Line 205: Line 219:
|}
|}


Table 10: t_ydelsesnr (contains a complete description of benefits paid by the health insurance).
{| class="wikitable"
{| class="wikitable"
|-
|-
! Variable || Period || Contents
! 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
| d_tildto || 1990 onwards || End date of the code's validity period
Line 221: Line 236:
|}
|}


Table 11: t_ytype (contains codes for external type and their meaning).
{| class="wikitable"
{| class="wikitable"
|-
|-
! Variable || Period || Contents
! 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
| d_tildto || 1990 onwards || End date of the code's validity period
Line 230: Line 246:
| k_fradto || 1990 onwards || Start 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
| k_ytype || 1990 onwards || Provider's type in code form
|-
|-
| v_meaning || 2000 and onwards || Meaning of code
| 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).
{| 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
|}

Latest revision as of 13:27, 2 December 2025

forresearchers 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
Retrieved from "https://wiki.beaconcancer.org/index.php?title=Data_Dictionary_-_SSR_Denmark&oldid=25940"
Powered by MediaWiki
Powered by Semantic MediaWiki