Data Dictionary - SSR Denmark: Difference between revisions
From Beacon
No edit summary |
No edit summary |
||
| Line 8: | Line 8: | ||
! t_patgrp (contains the meaning of the patient group code) | ! t_patgrp (contains the meaning of the patient group code) | ||
|- | |- | ||
! Variable || Period || | ! 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 23: | Line 23: | ||
! t_practice (contains the meaning of the practice type code) | ! t_practice (contains the meaning of the practice type code) | ||
|- | |- | ||
! Variable || Period || | ! 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 36: | Line 36: | ||
! 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) | ! 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 || | ! Variable || Period || Description | ||
|- | |- | ||
| c_special || 1990 - || Provider's main specialty | | c_special || 1990 - || Provider's main specialty | ||
| Line 87: | Line 87: | ||
! t_sikgrp (contains security group codes and their meaning) | ! t_sikgrp (contains security group codes and their meaning) | ||
|- | |- | ||
! Variable || Period || | ! 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 102: | Line 102: | ||
! t_sikkon (table contains codes for gender and their meaning) | ! t_sikkon (table contains codes for gender and their meaning) | ||
|- | |- | ||
! Variable || Period || | ! 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 115: | Line 115: | ||
! t_speciale (contains codes for specialties and their meaning) | ! t_speciale (contains codes for specialties and their meaning) | ||
|- | |- | ||
! Variable || Period || | ! 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 128: | Line 128: | ||
! t_ssik<åååå> (contains information about the patient, the provider and the service that was provided under the health insurance) | ! t_ssik<åååå> (contains information about the patient, the provider and the service that was provided under the health insurance) | ||
|- | |- | ||
! Variable || Period || | ! Variable || Period || Description | ||
|- | |- | ||
| c_henamt || 1990 - || County/region code of referring provider | | c_henamt || 1990 - || County/region code of referring provider | ||
| Line 189: | Line 189: | ||
! t_tekst (contains a complete description of benefits paid by the health insurance, broken down by year and quarter) | ! t_tekst (contains a complete description of benefits paid by the health insurance, broken down by year and quarter) | ||
|- | |- | ||
! Variable || Period || | ! Variable || Period || Description | ||
|- | |- | ||
| c_special || 1990 - || Provider's main specialty | | c_special || 1990 - || Provider's main specialty | ||
| Line 208: | Line 208: | ||
! t_tidskode (contains time codes and their meaning) | ! t_tidskode (contains time codes and their meaning) | ||
|- | |- | ||
! Variable || Period || | ! 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 223: | Line 223: | ||
! t_ydelsesnr (contains a complete description of benefits paid by the health insurance) | ! t_ydelsesnr (contains a complete description of benefits paid by the health insurance) | ||
|- | |- | ||
! Variable || Period || | ! 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 240: | Line 240: | ||
! t_ytype (contains codes for external type and their meaning) | ! t_ytype (contains codes for external type and their meaning) | ||
|- | |- | ||
! Variable || Period || | ! 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 255: | Line 255: | ||
! 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) | ! 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 || | ! Variable || Period || Description | ||
|- | |- | ||
| c_henamt || 1990 - || County/region code of referring provider | | c_henamt || 1990 - || County/region code of referring provider | ||
| Line 314: | Line 314: | ||
! t_sikrede (contains relevant information about the insured patient) | ! t_sikrede (contains relevant information about the insured patient) | ||
|- | |- | ||
! Variable || Period || | ! Variable || Period || Description | ||
|- | |- | ||
| adresse | | adresse | ||
| Line 425: | Line 425: | ||
! t_ssr <åååå> (contains information about the patient, the provider and the service that was provided under the health insurance) | ! t_ssr <åååå> (contains information about the patient, the provider and the service that was provided under the health insurance) | ||
|- | |- | ||
! Variable || Period || | ! Variable || Period || Description | ||
|- | |- | ||
| settlement month | | settlement month | ||
| Line 648: | Line 648: | ||
! t_sats (contains the rate for the various agreements) | ! t_sats (contains the rate for the various agreements) | ||
|- | |- | ||
! Variable || Period || | ! Variable || Period || Description | ||
|- | |- | ||
| concept | | concept | ||
| Line 679: | Line 679: | ||
! 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) | ! 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 || | ! Variable || Period || Description | ||
|- | |- | ||
| characteristic | | characteristic | ||
Revision as of 15:30, 3 June 2024
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 |
