Data Dictionary: Estonian Health Insurance Fund (EHIF) Database: Difference between revisions

From Beacon
No edit summary
No edit summary
 
(5 intermediate revisions by 3 users not shown)
Line 1: Line 1:
Go back to [[Estonia]] page
<span style="display:none">forresearchers</span> <span style="display:none">estoniacountry</span>
Go back to [[Database: Estonian Health Insurance Fund (EHIF) Database (Estonia)]] page


'''Core patient data:'''
{| class="wikitable"
|-
! Core Patient Data
|-
| ID number
|-
| Name
|-
| Date of birth
|-
| Date of death
|-
| Sex
|-
| Address
|}


*ID number
{| class="wikitable"
*Name
|-
*Date of birth
! Medical contacts data
*Date of death
|-
*Sex
| Healthcare provider information
*Address
|-
| Doctor information
|-
| Type of healthcare
|-
| Main and co-diagnoses
|-
| Date of admission
|-
| Date of discharge
|-
| Regular procedures
|-
| Surgical procedures
|-
| Date of procedures
|-
| Amount of procedures
|-
| Diagnosis Related Groups (DRGs) for inpatient care
|}


{| class="wikitable"
|-
! Outpatient Care Data
|-
| Date of admission
|-
| Date of discharge
|-
| Dispensing pharmacy information
|-
| Diagnoses
|-
| Discount rate
|-
| Date of dispensing
|-
| Date of purchase
|-
| Active substance code
|-
| Dispensed ATC Codes
|-
| Dispensed dosages
|-
| Level of content
|-
| Total dispensed amount of medicine
|-
| Number of packages
|-
| Price of medicine
|-
| Paid price
|-
| Discount price
|-
| Medical reason for prescription limitations
|}


'''Medical contacts data:'''
{| class="wikitable"
|-
! Incapacity to Work Data
|-
| Company where patient works
|-
| Salary
|-
| Start and end date of incapacity to work
|-
| Reason for incapacity to work
|-
| Type of incapacity
|}


*Healthcare provider information
{| class="wikitable"
*Doctor information
|-
*Type of healthcare
! Diagnostic Data
*Main and co-diagnoses
|-
*Date of admission
| ICD-10 codes for diagnoses
*Date of discharge
|-
*Regular procedures
| Anatomical Therapeutic Chemical (ATC) Classification System codes for active substance of medicine
*Surgical procedures
|-
*Date of procedures
| NOMESCO Classification of Surgical Procedures codes for surgical procedures
*Amount of procedures
|}
*Diagnosis Related Groups (DRGs) for inpatient care


 
{| class="wikitable"
'''Outpatient care data:'''
|-
 
! Miscellaneous Data
*Date of admission
|-
*Date of discharge
| Dates and frequencies of procedures and laboratory tests
*Dispensing pharmacy information
|-
*Diagnoses
| Insurance status
*Discount rate
|-
*Date of dispensing
| Obesity and alcohol abuse codes as diagnoses
*Date of purchase
|-
*Active substance code
| Patient's contact data (i.e., address, telephone number, etc.) from Population Registry
*Dispensed ATC Codes
|-
*Dispensed dosages
| Healthcare provider information from Business Register
*Level of content
|-
*Total dispensed amount of medicine
| Insurance status information from Employment Registry
*Number of packages
|-
*Price of medicine
| No information on vaccinations, laboratory results, and physical examination results.
*Paid price
|}
*Discount price
*Medical reason for prescription limitations
 
 
'''Incapacity to work data:'''
 
*Company where patient works
*Salary
*Start and end date of incapacity to work
*Reason for incapacity to work
*Type of incapacity
 
 
'''Diagnostic data:'''
 
*International Classification of Diseases, version 10 (ICD-10) codes for diagnoses
*Anatomical Therapeutic Chemical (ATC) Classification System codes for active substance of medicine
*NOMESCO Classification of Surgical Procedures codes for surgical procedures
 
 
'''Miscellaneous data:'''
 
*Dates and frequencies of procedures and laboratory tests
*Insurance status
*Obesity and alcohol abuse codes as diagnoses
*Patient's contact data (i.e., address, telephone number, etc.) from Population Registry
*Healthcare provider information from Business Register
*Insurance status information from Employment Registry
*No information on vaccinations, laboratory results, and physical examination results.

Latest revision as of 16:36, 2 December 2025

forresearchers estoniacountry Go back to Database: Estonian Health Insurance Fund (EHIF) Database (Estonia) page

Core Patient Data
ID number
Name
Date of birth
Date of death
Sex
Address
Medical contacts data
Healthcare provider information
Doctor information
Type of healthcare
Main and co-diagnoses
Date of admission
Date of discharge
Regular procedures
Surgical procedures
Date of procedures
Amount of procedures
Diagnosis Related Groups (DRGs) for inpatient care
Outpatient Care Data
Date of admission
Date of discharge
Dispensing pharmacy information
Diagnoses
Discount rate
Date of dispensing
Date of purchase
Active substance code
Dispensed ATC Codes
Dispensed dosages
Level of content
Total dispensed amount of medicine
Number of packages
Price of medicine
Paid price
Discount price
Medical reason for prescription limitations
Incapacity to Work Data
Company where patient works
Salary
Start and end date of incapacity to work
Reason for incapacity to work
Type of incapacity
Diagnostic Data
ICD-10 codes for diagnoses
Anatomical Therapeutic Chemical (ATC) Classification System codes for active substance of medicine
NOMESCO Classification of Surgical Procedures codes for surgical procedures
Miscellaneous Data
Dates and frequencies of procedures and laboratory tests
Insurance status
Obesity and alcohol abuse codes as diagnoses
Patient's contact data (i.e., address, telephone number, etc.) from Population Registry
Healthcare provider information from Business Register
Insurance status information from Employment Registry
No information on vaccinations, laboratory results, and physical examination results.