Data Dictionary: AIM-IMA Échantillon Permantent(e) Steekproef (EPS): Difference between revisions
From Beacon
No edit summary |
No edit summary |
||
| Line 156: | Line 156: | ||
| URB_CAT || Urbanization category | | URB_CAT || Urbanization category | ||
|} | |} | ||
'''Table 2:''' Health care database. | '''Table 2:''' Health care database. | ||
| Line 327: | Line 328: | ||
| THIRD_YN || Billed via a third party | | THIRD_YN || Billed via a third party | ||
|} | |} | ||
'''Table 3:''' Pharmanet database. | '''Table 3:''' Pharmanet database. | ||
| Line 468: | Line 470: | ||
| UNIT || Unit in which the quantity is indicated | | UNIT || Unit in which the quantity is indicated | ||
|} | |} | ||
'''Table 4:''' Hospitalizations database. | '''Table 4:''' Hospitalizations database. | ||
Revision as of 13:57, 28 May 2024
Go back to Belgium page
Source: Click here to learn more
Table 1: Population database.
| 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.
| 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.
| 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.
| 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 |
