General requirements: Insured, insurance and providers’ identifiers should be coherent through the four files.
Missing values must be empty (no character)
Observations of one year. If you want to analyze several years, calculate the results separately.
Use semi-column (;) to separate the fields. CR (“carriage return”) at the end of each record (as usual in windows applications)
The first line contents the fields names listed on the left in table below
Insured.txt: All insured covered during the year of insurance
| Fields | Nomenclature | Formats | |
|---|---|---|---|
| #Insured | Insured identifier | text | |
| #Insurance | Insurance company | text | |
| Year | Year of insurance coverage | YYYY | |
| Gender | 1=male, 2 = female | number | Integer |
| Age | Number of years | number | Integer |
| Deductible | Amount of deductible | number | Integer |
| Canton | Swiss cantons (two chararacters) or missing if the residence is abroad | text | 2 |
| End | 0= death, 2= others | number | real |
| #Provider | Creditors' register (Sasis-RCC) | text | |
| from the reference’s physician (gate-keeper) |
Bills.txt: All bills with an End date in the year
| Fields | Nomenclature | Formats | |
|---|---|---|---|
| #Insured | Insured identifier | text | |
| #Insurance | Insurance company | text | |
| #Provider | Creditors' register (Sasis-RCC) | text | |
| #Nature | Nature of the delivered services | text | |
| DI Dialysis | |||
| DR Drug | |||
| HC Home care | |||
| HJ Day hospitalization | |||
| HO Somatic hospitalization | |||
| HP Psychiatric hospitalization | |||
| IM Imagery | |||
| LA Laboratory | |||
| MD Medical doctor | |||
| MW Midwife | |||
| NH Nursing home | |||
| OT Other | |||
| PH Physiotherapy | |||
| PR Prevention | |||
| StartDate | Start date of delivery | YYYYMMDD | (text) |
| Enddate | End date of delivery | YYYYMMDD | (text) |
| Maternity | 1=yes, 0 = no | number | integer |
| Amount | Swiss francs | number | real |
Drugs.txt: All drugs delivered during the year
| Fields | Nomenclature | Formats | |
|---|---|---|---|
| #Insured | Insured identifier | text | |
| #Insurance | Insurance company | text | |
| #Provider | Creditors' register (Sasis-RCC) | text | |
| Date | Date of drugs’ delivery | YYYYMMDD | (text) |
| #Drugs | BarCodes | text | |
| Quantity | Number of packaging | number | integer |
| Amount | Swiss francs | number | real |
Providers.txt: Update this file every year
| Fields | Nomenclature | Formats | |
|---|---|---|---|
| #Provider | Creditors' register (Sasis-RCC) | text | |
| #Specialty | ANE Anesthesiology | text | 3 |
| CAR Cardiology | |||
| CHR Chiropractician | |||
| DEN Dentist | |||
| DER Dermatologist | |||
| DIE Dietetics | |||
| END Endocrinology | |||
| ENT ENT | |||
| ERG Ergotherapy | |||
| GAS Gastroenterology | |||
| GYN Gynecology and obstetrics | |||
| HEM Hematology and oncology | |||
| HOM Home care | |||
| HOS Hospitals | |||
| INT Internal medicine and generalists | |||
| LAB Laboratory | |||
| LOG Logopedy | |||
| MSO Maisons de cure | |||
| MWI Midwifes | |||
| NHO Nursing home | |||
| NLG Neurology | |||
| NSU Neurosurgery | |||
| NUR Nurses | |||
| OPH Ophtalmology | |||
| ORT Orthopedics | |||
| OSP Prevention and public health | |||
| OTH Other | |||
| PED Pediatrics | |||
| PHA Pharmacy | |||
| PHY Physiotherapy | |||
| PNE Pneumology | |||
| PRO Other professionnals | |||
| PRO Centre de fitness | |||
| PSY Psychiatry | |||
| RAD Radiology, radio- oncology and imagery | |||
| RHE Rhumatology | |||
| SUR Surgery | |||
| THE Thermal | |||
| TRP Transport | |||
| UNS Unspecified | |||
| URO Urology | |||
| Canton | Swiss cantons (two chararacters) or missing if the residence is abroad | text | 2 |