Data Dictionary - SSR Denmark: Difference between revisions
From Beacon
No edit summary |
m (Update categories.) |
||
| (12 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
<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 || | ! 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: | ||
|} | |} | ||
{| class="wikitable" | {| class="wikitable" | ||
|- | |- | ||
! Variable || Period || | ! 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: | ||
|} | |} | ||
{| class="wikitable" | {| class="wikitable" | ||
|- | |- | ||
! | ! 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_service no || | | c_special || 1990 - || Provider's main specialty | ||
|- | |||
| 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: | ||
|} | |} | ||
{| class="wikitable" | {| class="wikitable" | ||
|- | |- | ||
! Variable || Period || | ! 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: | ||
|} | |} | ||
{| class="wikitable" | {| class="wikitable" | ||
|- | |- | ||
! Variable || Period || | ! 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: | ||
|} | |} | ||
{| class="wikitable" | {| class="wikitable" | ||
|- | |- | ||
! Variable || Period || | ! 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: | ||
|} | |} | ||
{| class="wikitable" | {| class="wikitable" | ||
|- | |- | ||
! Variable || Period || | ! t_ssik<åååå> (contains information about the patient, the provider and the service that was provided under the health insurance) | ||
|- | |||
! Variable || Period || Description | |||
|- | |- | ||
| c_henamt || | | c_henamt || 1990 - || County/region code of referring provider | ||
|- | |- | ||
| c_henynr || | | c_henynr || 1990 - || The reference number of the referring provider | ||
|- | |- | ||
| c_patgrp || | | c_patgrp || 1990 - || The patient's relationship with the provider | ||
|- | |- | ||
| c_practice || | | c_practice || 1990 - || The type of practice where the service is provided | ||
|- | |- | ||
| c_sikgrp || | | c_sikgrp || 1990 - || Health insurance group to which the insured belongs | ||
|- | |- | ||
| c_sikkon || | | c_sikkon || 1990 - || Ensured gender | ||
|- | |- | ||
| c_sikramt || | | c_sikramt || 1990 - || Insured's place of residence/region | ||
|- | |- | ||
| c_sikrcom || | | c_sikrcom || 1990 - || Secreted's municipality of residence | ||
|- | |- | ||
| c_special || | | c_special || 1990 - || Provider's main specialty | ||
|- | |- | ||
| c_timecode || | | c_timecode || 1990 - || Time of performance | ||
|- | |- | ||
| c_yamt || | | c_yamt || 1990 - || Provider's amt/region | ||
|- | |- | ||
| c_service no || | | c_service no || 1990 - || The performance | ||
|- | |- | ||
| c_ykom || | | c_ykom || 1990 - || Provider's municipality | ||
|- | |- | ||
| c_ynr || | | c_ynr || 1990 - || The outside number | ||
|- | |- | ||
| c_ytype || | | c_ytype || 1990 - || Provider's type | ||
|- | |- | ||
| v_afrmdr || | | v_afrmdr || 1990 - || Benefit month | ||
|- | |- | ||
| v_afraar || | | v_afraar || 1990 - || Settlement year | ||
|- | |- | ||
| v_age || | | v_age || 1990 - || Age of insured | ||
|- | |- | ||
| v_antydel || | | v_antydel || 1990 - || Number of benefits | ||
|- | |- | ||
| v_gross || | | 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 || | | v_cpr || 1990 - || Secured social security number | ||
|- | |- | ||
| v_filling || 2000 - || Number of fillings | | v_filling || 2000 - || Number of fillings | ||
|- | |- | ||
| v_honuge || | | v_honuge || 1990 - || Honor week | ||
|- | |- | ||
| v_honaar || | | v_honaar || 1990 - || Honors year | ||
|- | |- | ||
| in_contact || | | in_contact || 1990 - || Physical presence or not | ||
|- | |- | ||
| v_tand || 2000 - || Number of natural teeth | | v_tand || 2000 - || Number of natural teeth | ||
|} | |} | ||
{| class="wikitable" | {| class="wikitable" | ||
|- | |- | ||
! Variable || Period || | ! t_tekst (contains a complete description of benefits paid by the health insurance, broken down by year and quarter) | ||
|- | |||
! Variable || Period || Description | |||
|- | |- | ||
| c_special || | | c_special || 1990 - || Provider's main specialty | ||
|- | |- | ||
| c_service no || | | c_service no || 1990 - || The performance | ||
|- | |- | ||
| v_aar || 2000 and onwards || Update year | | v_aar || 2000 and onwards || Update year | ||
| Line 191: | Line 204: | ||
|} | |} | ||
{| class="wikitable" | {| class="wikitable" | ||
|- | |- | ||
! Variable || Period || | ! 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: | ||
|} | |} | ||
{| class="wikitable" | {| class="wikitable" | ||
|- | |- | ||
! Variable || Period || | ! 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: | ||
|} | |} | ||
{| class="wikitable" | {| class="wikitable" | ||
|- | |- | ||
! Variable || Period || | ! 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 || | | 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 | ||
|} | |} | ||
{| class="wikitable" | {| 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_gross || | | 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 | ||
| Line 284: | Line 301: | ||
| v_filling || 2000 - || Number of fillings | | v_filling || 2000 - || Number of fillings | ||
|- | |- | ||
| v_honuge || | | v_honuge || 1990 - || Honor week | ||
|- | |- | ||
| v_honaar || | | v_honaar || 1990 - || Honors year | ||
|- | |- | ||
| in_contact || | | in_contact || 1990 - || Physical presence or not | ||
|- | |- | ||
| v_tand || 2000 - || Number of natural teeth | | v_tand || 2000 - || Number of natural teeth | ||
|} | |} | ||
{| class="wikitable" | {| class="wikitable" | ||
|- | |- | ||
! | ! t_sikrede (contains relevant information about the insured patient) | ||
! Period | |- | ||
! Variable || Period || Description | |||
|- | |- | ||
| adresse | | adresse | ||
| Line 405: | Line 421: | ||
|} | |} | ||
{| class="wikitable" | {| class="wikitable" | ||
|- | |- | ||
! | ! t_ssr <åååå> (contains information about the patient, the provider and the service that was provided under the health insurance) | ||
! Period | |- | ||
! Variable || Period || Description | |||
|- | |- | ||
| settlement month | | settlement month | ||
| Line 629: | Line 644: | ||
|} | |} | ||
{| class="wikitable" | {| class="wikitable" | ||
|- | |- | ||
! | ! t_sats (contains the rate for the various agreements) | ||
! Period | |- | ||
! Variable || Period || Description | |||
|- | |- | ||
| concept | | concept | ||
| Line 661: | Line 675: | ||
|} | |} | ||
{| class="wikitable" | {| 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) | ||
! Period | |- | ||
! Variable || Period || Description | |||
|- | |- | ||
| characteristic | | characteristic | ||
Latest revision as of 13:27, 2 December 2025
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 |