Data Dictionary - SSR Denmark: Difference between revisions

From Beacon
No edit summary
m (Update categories.)
 
(9 intermediate revisions by 2 users not shown)
Line 1: Line 1:
Go back to [[Denmark]] page
<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]
Source: [https://www.esundhed.dk/Dokumentation/DocumentationExtended?id=10 Click here to learn more]


'''Table 1''': t_patgrp (contains the meaning of the patient group code).
{| 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 17: 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 29: 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 || 1990 - || Yder's main specialty
| c_special || 1990 - || Provider's main specialty
|-
|-
| c_service no || 1990 - || The performance
| c_service no || 1990 - || The performance
Line 79: 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 93: 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 105: 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 117: 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)
|-
! Variable || Period || Description
|-
|-
| c_henamt || 1990 - || County/region code of referring provider
| c_henamt || 1990 - || County/region code of referring provider
Line 138: Line 146:
| c_sikrcom || 1990 - || Secreted's municipality of residence
| c_sikrcom || 1990 - || Secreted's municipality of residence
|-
|-
| c_special || 1990 - || Yder's main specialty
| c_special || 1990 - || Provider's main specialty
|-
|-
| c_timecode || 1990 - || Time of performance
| c_timecode || 1990 - || Time of performance
|-
|-
| c_yamt || 1990 - || Yders amt/region
| c_yamt || 1990 - || Provider's amt/region
|-
|-
| c_service no || 1990 - || The performance
| c_service no || 1990 - || The performance
|-
|-
| c_ykom || 1990 - || Yders municipality
| c_ykom || 1990 - || Provider's municipality
|-
|-
| c_ynr || 1990 - || The outside number
| c_ynr || 1990 - || The outside number
|-
|-
| c_ytype || 1990 - || Ydertypen
| c_ytype || 1990 - || Provider's type
|-
|-
| v_afrmdr || 1990 - || Benefit month
| v_afrmdr || 1990 - || Benefit month
Line 177: Line 185:
|}
|}


'''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 || 1990 - || Yder's main specialty
| c_special || 1990 - || Provider's main specialty
|-
|-
| c_service no || 1990 - || The performance
| c_service no || 1990 - || The performance
Line 195: 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 209: 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 225: 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 234: 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"
{| class="wikitable"
|-
|-
! Variable || Period || Contents
! 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_henamt || 1990 - || County/region code of referring provider
Line 260: Line 273:
| c_sikrcom || 1990 - || Secrede's municipality of residence
| c_sikrcom || 1990 - || Secrede's municipality of residence
|-
|-
| c_special || 1990 - || Yder's main specialty
| c_special || 1990 - || Provider's main specialty
|-
|-
| c_timecode || 1990 - || Time of performance
| c_timecode || 1990 - || Time of performance
|-
|-
| c_yamt || 1990 - || Yders amt/region
| c_yamt || 1990 - || Provider's amt/region
|-
|-
| c_service no || 1990 - || The performance
| c_service no || 1990 - || The performance
|-
|-
| c_ykom || 1990 - || Yders municipality
| c_ykom || 1990 - || Provider's municipality
|-
|-
| c_ynr || 1990 - || The outside number
| c_ynr || 1990 - || The outside number
|-
|-
| c_ytype || 1990 - || Ydertypen
| c_ytype || 1990 - || Provider's type
|-
|-
| v_afrmdr || 1990 - || Benefit month
| v_afrmdr || 1990 - || Benefit month
Line 297: Line 310:
|}
|}


'''Table 13''': t_sikrede (contains relevant information about the insured patient).
{| class="wikitable"
{| class="wikitable"
|-
|-
! Variable
! t_sikrede (contains relevant information about the insured patient)
! Period
|-
! Contents
! Variable || Period || Description
|-
|-
| adresse
| adresse
Line 409: Line 421:
|}
|}


'''Table 14''': t_ssr <åååå> (contains information about the patient, the provider and the service that was provided under the health insurance).
{| class="wikitable"
{| class="wikitable"
|-
|-
! Variable
! t_ssr <åååå> (contains information about the patient, the provider and the service that was provided under the health insurance)
! Period
|-
! Contents
! Variable || Period || Description
|-
|-
| settlement month
| settlement month
Line 633: Line 644:
|}
|}


'''Table 15''': t_sats (contains the rate for the various agreements).
{| class="wikitable"
{| class="wikitable"
|-
|-
! Variable
! t_sats (contains the rate for the various agreements)
! Period
|-
! Contents
! Variable || Period || Description
|-
|-
| concept
| concept
Line 665: Line 675:
|}
|}


'''Table 16''': 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).
{| class="wikitable"
{| class="wikitable"
|-
|-
! Variable
! 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)
! Period
|-
! Contents
! Variable || Period || Description
|-
|-
| characteristic
| characteristic

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