Data Dictionary: AIM-IMA Échantillon Permantent(e) Steekproef (EPS): Difference between revisions
From Beacon
No edit summary |
No edit summary |
||
| Line 502: | Line 502: | ||
| STAY_NR || Year/Continuation number of admissions/stays | | STAY_NR || Year/Continuation number of admissions/stays | ||
|} | |} | ||
'''Table 5:''' Patient data (contains data on healthcare utilization and healthcare-related expenditures). | '''Table 5:''' Patient data (contains data on healthcare utilization and healthcare-related expenditures). | ||
| Line 633: | Line 634: | ||
| ZORGTRAJECT1 || Diabetes care journey | | ZORGTRAJECT1 || Diabetes care journey | ||
|} | |} | ||
'''Table 6:''' General practitioner patients (contains information on consultations and visits of general practitioners, on the practices of general practitioners (solo or group organization) and on the DMG (Global Medical File) registered with mutual insurance companies in Belgium). | '''Table 6:''' General practitioner patients (contains information on consultations and visits of general practitioners, on the practices of general practitioners (solo or group organization) and on the DMG (Global Medical File) registered with mutual insurance companies in Belgium). | ||
Revision as of 17:48, 28 May 2024
Go back to Belgium page
Source: Click here to learn more
Table 1: Population database (contains demographic, socio-economic and health data on the members of the seven mutual societies in Belgium).
| Variable | Description |
|---|---|
| AGE00_YN | Birth |
| AGE05_CAT | Age categories by 5 years |
| AGE10_CAT | Age categories by 10 years |
| AGE65_YN | 65 years or older |
| DISTRICT | District |
| CHRONICAL_YN | Chronic illness |
| DECEASED_YN | Death |
| FAM_SIZE | Household composition |
| INCAPACITY_YN | Incapacity for work |
| INVALIDITY_YN | Invalidity |
| MAJOR_BENEFIT_YN | VIPO Status |
| MAJOR_COVERAGE_YN | Increased intervention |
| MAJOR_INVALIDITY_YN | Invalid or handicapped person |
| MAJOR_RISK_CAT | Status of the insured |
| MINOR_RISK_CAT | Insured for small risks |
| PP0010 | Person identification code |
| PP0015 | Date of birth |
| PP0020 | Sex |
| PP0025 | Home |
| PP0030 | Holder code 1 |
| PP0035 | Holder code 2 |
| PP0040 | Date of death |
| PP0045 | Holder identification code |
| PP0055 | Statistical sector |
| PP1002 | Recipient/dependent |
| PP1003 | Social status of the holder |
| PP1004 | Type of unemployment benefit |
| PP1005 | Insurability start date |
| PP1006 | Insurability end date |
| PP1008 | Nature of income |
| PP1009 | Origin of recognition as a disabled person |
| PP1010 | Condition of the right to increased intervention |
| PP2001 | Package B for nursing care |
| PP2002 | Package C for nursing care |
| PP2003 | Physiotherapy E or physiotherapy |
| PP2004 | Additional family allowances |
| PP2005 | Integration allowance for disabled people |
| PP2006 | Allowance for assistance to the elderly |
| PP2007 | Allowance for third-party assistance – old regime 1 |
| PP2008 | Allowance for third-party assistance – old regime 2 |
| PP2009 | Allowance for third-party assistance |
| PP2010 | Hospitalization 120 days |
| PP2011 | Six hospitalizations |
| PP3001 | Right to MAF - household |
| PP3002 | MAF household category |
| PP3003 | Right to MAF - individual |
| PP3004 | Reimbursement and MAF ceiling - household |
| PP3005 | Reimbursement and MAF ceiling – individual or part of the household |
| PP3006 | First MAF reimbursement date |
| PP3007 | Single or compound household |
| PP3008 | MAF Household Type |
| PP3009 | MAF head of household identification code |
| PP3010 | Right to guaranteed income for the elderly, guaranteed income for the elderly or social integration income |
| PP3011 | Right to allowances for disabled people |
| PP3012 | More than 12 months of unemployment benefits |
| PP3013 | Right to assistance from a CPAS |
| PP3014 | Law MAF with chronic patients |
| PP3015 | Chronic illness status – financial criterion |
| PP3016 | Chronic illness status – package for chronically ill patients |
| PP3017 | Chronic illness status – rare disease |
| PP4001 | Number of days of unemployment |
| PP4002 | Number of days of incapacity for work |
| PP4003 | Number of days of disability |
| PP4004 | Degree of autonomy |
| PP4005 | Pillar 1 of the medico-social scale for disabled children |
| PP4006 | Pillar 2 of the medico-social scale for disabled children |
| PP4007 | Pillar 3 of the medico-social scale for disabled children |
| PP4008 | Single-parent family |
| PROVINCE | Province |
| RECOGNITION_YN | Disabled person |
| SOCIAL_CAT | Social security system |
| TITULAR_YN | Holder or dependent |
| UNEMPLOYMENT_YN | Unemployment |
| URB_CAT | Urbanization category |
Table 2: Health care database (contains administrative and accounting data on the health care provided to members of the seven mutual societies in Belgium within the framework of compulsory health insurance).
| Variable | Description |
|---|---|
| ATC_ANAT_L | ATC code level 1 |
| ATC_CHEM_L | ATC code level 4 |
| ATC_PHAR_L | ATC code level 3 |
| ATC_PROD_L | ATC code level 5 |
| ATC_THER_L | ATC code level 2 |
| ACCOUNTABLE_21 | Accounted within 21 accounting months |
| C_RANK | Chronological continuation number of the day of service |
| INSTITUTION_CAT | Type of institution of stay |
| INSTITUTION_QUAL | Qualification of the residence institution |
| INSTITUTION_SITE_CAT | Type of place of service |
| INSTITUTION_SITE_QUAL | Qualification of the location of the service |
| NWE_YN | At night, during the weekend or on a public holiday |
| PRACTITIONER_CAT | Care provider profession code |
| PRESCRIBER_CAT | Prescriber profession code |
| PRESCRIPTION_MM | Month of prescription |
| PRESCRIPTION_YYYYWW | Year and week of prescription |
| PRESCRIPTION_YYYY | Year of prescription |
| PROCEDURE_AH_CAT | Outpatient or hospitalized |
| PROCEDURE_CAT | Detailed nomenclature group |
| PROCEDURE_DETAIL | BOM group subclass |
| PROCEDURE_GROUP | Nomenclature group |
| PROCEDURE_MM | Month of service |
| PROCEDURE_YYYYWW | Week of the benefit |
| PROCEDURE_YYYY | Year of service |
| SS00010 | Person Identification Code |
| SS00015 | Start date of service |
| SS00020 | Nomenclature code |
| SS00025A | Accounting year |
| SS00025B | Accounting month |
| SS00030 | Skill |
| SS00045 | Accounting code doc N |
| SS00050 | Number of cases |
| SS00055 | Number of days |
| SS00060_100P | Price of the hospitalization day at 100% |
| SS00060 | AMI amount |
| SS00065A | Healthcare provider identification number |
| SS00065B | Care provider qualification |
| SS00070A | Prescriber identification number |
| SS00070B | Prescriber qualification |
| SS00075 | Institution identification number |
| SS00080 | Service code |
| SS00085 | Place of performance |
| SS00090 | Expense Operator |
| SS00095 | Holder code 1 (CT1) |
| SS00100 | Holder code 2 (CT2) |
| SS00105A | Third party identification number |
| SS00105B | Third party qualification |
| SS00110 | Date of admission |
| SS00115 | Release date |
| SS00120 | Invoice type |
| SS00125 | Last service date |
| SS00130 | Related benefit |
| SS00135 | CNK Code |
| SS00140 | Service standard |
| SS00145 | Night, weekend or public holiday |
| SS00150 | Invoiced nomenclature code |
| SS00155 | Prescription date |
| SS00160 | Moderator ticket |
| SS00165 | Supplement |
| SS00170 | Implant code |
| SS00175 | Third-party payment system |
| SS00235 | Date receipt of invoice |
| SS00255 | Billing Type |
| SS00260 | Origin of payment |
| SS00265 | Comprehensive medical file |
| SS00270A | Ancillary provider identification number |
| SS00270B | Qualification of the auxiliary service provider |
| SS00275 | Ceiling standard |
| SS00280 | Treated tooth |
| SS00285 | Member treated |
| SS00290 | Tariffing office identification number |
| SS00295A | Pharmacist identification number |
| SS00295B | Pharmacist qualification |
| SS00300 | Type of maintenance day count |
| SS00310 | Time of admission |
| SS00315 | Departure time |
| SS00340 | Provider standard |
| SS00345 | Prescriber Standard |
| SS00350 | Third party payment exception |
| SS00355 | Genical form of the compounded preparation |
| SS00360 | Hour of service |
| SS00385 | Regularization reason |
| THIRD_YN | Billed via a third party |
Table 3: Pharmanet database (contains information on reimbursed medicines and medical devices dispensed in public pharmacies).
| Variable | Description |
|---|---|
| ATC_ANAT_L | ATC code level 1 |
| ATC_CHEM_L | ATC code level 4 |
| ATC_PHAR_L | ATC code level 3 |
| ATC_PROD_L | ATC code level 5 |
| ATC_THER_L | ATC code level 2 |
| ACCOUNTABLE_21 | Accounted within 21 accounting months |
| C_RANK | Chronological continuation number of the day of service |
| FILE_MEDCON | Presence of the authorization number of the medical advisor |
| INSTITUTION_CAT | Type of institution of stay |
| INSTITUTION_QUAL | Qualification of the residence institution |
| INVOICE_MM | Billing month |
| INVOICE_YYYY | Invoicing year |
| PRESCRIBER_CAT | Prescriber profession code |
| PROCEDURE_AH_CAT | Outpatient or hospitalized |
| PROCEDURE_CAT | Detailed nomenclature group |
| PROCEDURE_DETAIL | BOM group subclass |
| PROCEDURE_GROUP | Nomenclature group |
| PROCEDURE_MM | Month of issue |
| PROCEDURE_YYYYWW | Year and week of issue |
| PROCEDURE_YYYY | Year of issue |
| SS00010 | Person Identification Code |
| SS00015 | Issuance date |
| SS00020 | Drug category code |
| SS00025A | Accounting year |
| SS00025B | Accounting month |
| SS00045 | Accounting code doc N |
| SS00050 | Quantity |
| SS00060 | AMI amount |
| SS00065A | Pharmacist identification number |
| SS00065B | Pharmacist qualification |
| SS00070A | Prescriber identification number |
| SS00070B | Prescriber qualification |
| SS00075 | Institution identification number |
| SS00080 | Genical form of the compounded preparation |
| SS00085 | Pharmacy number |
| SS00095 | Holder code 1 (CT1) |
| SS00100 | Holder code 2 (CT2) |
| SS00105A | Rating Office Identification Number |
| SS00110 | Billing year and month |
| SS00120 | Invoice type |
| SS00125 | Issuance date |
| SS00130 | Master preparation key |
| SS00135 | CNK Code |
| SS00140 | 1st unit position |
| SS00145 | 2nd unit position |
| SS00155 | Prescription date |
| SS00160 | Moderator ticket |
| SS00165 | Decrease in refund amount |
| SS00170 | Barcode |
| SS00175 | Delayed delivery |
| SS00185 | Indication International nonproprietary name (INN) |
| SS00195 | Pharmacist fees |
| SS00200 | Honorary coding |
| SS00205 | First delivery indication |
| SS00210 | Supplement |
| SS00215 | Preparation of individual medication |
| SS00220 | Single and occasional delivery |
| SS00225 | Indication of pricing exemption per unit |
| SS00230 | Personal intervention billing code |
| SS00235 | Date receipt of invoice |
| SS00255 | Billing Type |
| SS00260 | Origin of payment |
| SS00380 | Electronic prescription indication |
| SS00385 | Regularization reason |
| SS00395 | Advising physician authorization number |
| SS00430 | Pharmacist’s fees (AMI) |
| SS00435 | Pharmacist (patient) fees |
| UNIT | Unit in which the quantity is indicated |
Table 4: Hospitalizations database (contains data on hospital stays that have been registered with mutual insurance companies in Belgium).
| Variable | Description |
|---|---|
| ADMISSION | Date of admission |
| DISCHARGE | Hospital discharge date |
| FIRST_PREST | First billed day of year Y for the stay |
| HOSP_ADM | Hospital stay |
| HOSP_TRANS | Transfer Hospital |
| LAST_PREST | Last billed day of year Y for the stay |
| LOS | Length of stay |
| LOS_YYYY | Length of stay in year |
| SERV_ADM | Admission Service |
| SERV_DIS | Output Service |
| SS00010 | Person Identification Code |
| STAY_CAT | Type of admission/stay |
| STAY_NR | Year/Continuation number of admissions/stays |
Table 5: Patient data (contains data on healthcare utilization and healthcare-related expenditures).
| Variables | Description |
|---|---|
| .ALL | All variables Patient data |
| ATC_DDD_TOTAL | Number of DDDs per ATC level 5 code |
| ATC_RG_TOTAL | Total co-payment by ATC level 5 code |
| ATC_SUP_TOTAL | Total surcharges per ATC level 5 code |
| ATC_ZIV_TOTAL | Total AMI amount by ATC level 5 code |
| BARIA | Bariatric surgery |
| CANCER_CHEMO | Cancer chemotherapy |
| CANCER_MOC | COM Cancer |
| CANCER_RT | Cancer radiotherapy |
| CONTRACEPTIVE_IMPL | Contraceptives - implant |
| CONTRACEPTIVE_OCYP | Anti-androgen and estrogen-based contraceptives |
| CONTRACEPTIVE_OPRO | Estrogen-progestogen-based contraceptives |
| CONTRACEPTIVE_PRO | Progestin-based contraceptives |
| CONTRACEPTIVE_SPICU | Contraceptives – copper IUD |
| CONTRACEPTIVE_SPIHO | Contraceptives – hormonal IUD |
| CONTRACEPTIVE_URG | Contraceptives – morning after pill |
| CS_CARDIO_N | Number of cardiologist consultations |
| CS_CHIRURG_N | Number of general surgery specialist consultations |
| CS_DERMA_N | Number of dermato-venerologist consultations |
| CS_GASTRO_N | Number of gastroenterologist consultations |
| CS_GYNAE_N | Number of gynecologist consultations |
| CS_INTERN_N | Number of internist consultations |
| CS_NEURO_N | Number of neurologist consultations |
| CS_OFTAL_N | Number of ophthalmologist consultations |
| CS_ORL_N | Number of ENT doctor consultations |
| CS_ORTHO_N | Number of orthopedic consultations |
| CS_PEDIA_N | Number of pediatrician consultations |
| CS_PHYSIC_N | Number of physical doctor consultations |
| CS_PNEUMO_N | Number of pulmonologist consultations |
| CS_PSYCH_N | Number of psychiatrist consultations |
| CS_SPECALL_N | Number of specialist doctor consultations |
| CS_URO_N | Number of urologist consultations |
| DENT_EARLYORTHODONTIST_N | Number of first-line orthodontic services |
| DENT_ORTHODONTIST_N | Number of orthodontic services |
| DENT_PREVENTION_N | Number of preventive dental care services |
| DENT_VISIT_N | Number of dental care services |
| DIABETES_CONVENTIE | Diabetes Convention |
| DIABETES_EDUCATIE | Diabetes education |
| DIABETES_PASPOORT | Diabetes monitoring |
| FKG_XXX | Pharmaceutical Charge Groups (FKG) XXX |
| IMAG_ALL_N | Number of medical imaging exams |
| IMAG_CBCT_N | Number of cone beam CTs |
| IMAG_CONV_N | Number of conventional radiographs |
| IMAG_CT_N | Number of CT-scans |
| IMAG_DENTAL_N | Number of dental x-rays |
| IMAG_DENTIST_N | Number of medical imaging examinations by a dentist |
| IMAG_DIAG_N | Number of interventional diagnostic medical imaging exams |
| IMAG_ECHO_N | Number of ultrasounds |
| IMAG_MRI_N | Number of MRIs |
| IMAG_RADIO_N | Number of medical imaging examinations by a radiologist |
| IMAG_RXTHORAX_N | Number of chest x-rays |
| IMAG_SCINTI_N | Number of scans |
| IMAG_SPEC_N | Number of medical imaging examinations by a specialist doctor |
| IMAG_THERA_N | Number of therapeutic interventional medical imaging examinations |
| IN_FARU | Registered in Pharmanet |
| IN_GZSS | Registered in Healthcare |
| IN_POPU | Registered in Population |
| MON_RG_TOTAL | Total co-payment |
| MON_SUP_TOTAL | Total supplements |
| MON_ZIV_TOTAL | Total AMI expenses |
| SS00010 | Person Identification Code |
| ZORGFACK | Chronic illness package |
| ZORGTRAJECT1 | Diabetes care journey |
Table 6: General practitioner patients (contains information on consultations and visits of general practitioners, on the practices of general practitioners (solo or group organization) and on the DMG (Global Medical File) registered with mutual insurance companies in Belgium).
| Variables | Description |
|---|---|
| ADVIES | Number of advisory services |
| AMBU | Number of contacts during which the general practitioner provides medical assistance by ambulance |
| BEZARTS | Number of home visits requested by a doctor |
| BEZAVOND_AH | Number of home visits (same trip for several patients) in the evening |
| BEZAVOND | Number of home visits (individual) in the evening |
| BEZNACHT_AH | Number of home visits (same trip for several patients) at night |
| BEZNACHT | Number of home visits (individual) at night |
| BEZOEKIND | Number of home visits (individual) |
| BEZOEK | Number of home visits (same trip for several patients) |
| BEZWEFE_AH | Number of home visits (same trip for several patients) on weekends or public holidays |
| BEZWEFE | Number of home visits (individual) on weekends or public holidays |
| CONTACT | Number of contacts |
| DIAPAS | Diabetes monitoring in a general practitioner's office |
| DIAPAS_MH | Diabetes monitoring in medical center |
| DIGICONT | Number of online contacts |
| DIGICONT_NR | Number of online contacts during on-call service |
| FF_MH | Number of medical home packages |
| FLAGMHMM | Doctor in a medical home billing services individually |
| FLAG_MISSING_REFRIZ | Doctor “Missing” in INAMI reference file |
| GMD_PLUS | Number of services 'prevention module within the framework of the DMG' |
| HCI_TYPE | Type Health Care Institution (HCI) |
| HOSP | Number of Hospital Visits |
| INSTEL | Number of visits to institutions with collective stay |
| OPVOLGPLAN | Number of unusual consultations or home visits |
| PAT_ATTRIB | Assigned to a GP practice |
| PAT_CZ | Chronic condition status |
| PAT_GMD | Global medical file |
| PERMANENTITY | Number of consultations with additional permanence |
| RAADPLBEZ | Number of consultations and home visits |
| RAADPL | Number of office consultations |
| RANACHT_AH | Number of night consultations at the office |
| RAWEFE_AH | Number of office consultations on weekends or public holidays |
| REGCONTACT | Number of regular contacts |
| RIZIV_HCI | INAMI Health Care Institution (HCI) identification number |
| RIZIV_ID | INAMI service provider identification number |
| RIZIV_SPEC | General practitioner competency code |
| SS00010 | Person Identification Code |
| WACHT | Number of consultations with extra on-call |
| ZT_DIAB | Number of diabetes care journey services |
| ZT_NIER | Number of chronic kidney failure care journey services |
