Data Dictionary - SSR Denmark

From Beacon
Revision as of 13:51, 2 October 2023 by Francine (talk | contribs)

Go back to Denmark page

Source: [1]

Table 1: t_patgrp (contains the meaning of the patient group code).

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).

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).

Variable Period Contents
c_special 1990 - Yder'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

Table 4: t_sikgrp (ontains security group codes and their meaning).

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).

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).

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).

Variable Period Contents
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 - Yder's main specialty
c_timecode 1990 - Time of performance
c_yamt 1990 - Yders amt/region
c_service no 1990 - The performance
c_ykom 1990 - Yders municipality
c_ynr 1990 - The outside number
c_ytype 1990 - Ydertypen
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

Table 8: t_tekst (contains a complete description of benefits paid by the health insurance, broken down by year and quarter).

Variable Period Contents
c_special 1990 - Yder'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

Table 9: t_tidskode (contains time codes and their meaning).

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).

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).

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 in code form
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).

Variable Period Contents
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 - Yder's main specialty
c_timecode 1990 - Time of performance
c_yamt 1990 - Yders amt/region
c_service no 1990 - The performance
c_ykom 1990 - Yders municipality
c_ynr 1990 - The outside number
c_ytype 1990 - Ydertypen
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

Table 13: t_sikrede (contains relevant information about the insured patient).

Variable Period Contents
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

Table 14: t_ssr <åååå> (contains information about the patient, the provider and the service that was provided under the health insurance).

Variable Period Contents
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

Table 15: t_sats (contains the rate for the various agreements).

Variable Period Contents
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

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).

Variable Period Contents
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=5945"
Powered by MediaWiki
Powered by Semantic MediaWiki