| Analysis.txt | |
|---|---|
| #Case | Identifier of the stay |
| Analysis | Context of the stay (only one: G>F>E>D>C>H>B>A). |
| A: Back to home, without further potentially avoidable readmission, justified stay | |
| B: Idem, more or less justified stay | |
| C: Back to home, with a further potentially avoidable readmission | |
| D: Death | |
| E: Transfer to another hospital (variable 1.5.V03 “Stay after discharge” = 4,5,6,44,55,66). If this variable is not specified (value = 9), the stay is allocated to this category if the patient was transferred to another hospital for another stay. | |
| F: Waiting for nursing home bed (variable 1.2.V02 “Stay before admission” different than 3 and 4; variable 1.5:V03 “Stay after discharge” = 2 or 3) | |
| G: Candidate for one day surgery | |
| H: Unjustified stay | |
| #Hospital | Hospital identifier |
| #Site | Location of the hospital |
| Year | Year (most recent year in the SQLape_input.txt file, with > 10% of records) |
| Age | Age at admission (in years) |
| Gender | 1 = male, 2 = female |
| Entry | 0: Birth (variable 1.2.V03 “admission mode” = 3) |
| 1: Admitted by transfer (variable 1.2.V02 “Stay before admission” = 5,6,55,66) | |
| 2: Other | |
| End | 0: Death (variable 1.5.V02 “Discharge decision” = 5) |
| 1: Discharged by transfer in another hospital (variable 1.5.V03 “Stay after discharge” = 4,5,6,44,55,66) | |
| Specialty | Medical specialty (Specialties), deduced from the variable “Category” below (Categories). |
| Mission | Hospital missions (Missions), deduced from the variable “Category” below (Categories). |
| Category | Main SQLape® categories (the diagnosis or operation category, with the lowest hierarchy value in Categories. |
| Risk-LS-CO | Risk strata used to compute length and cost expected values |
| LS1 | Observed length of stay |
| LS0 | Expected length of stay |
| CO1 | Observed cost |
| CO0 | Expected cost |
| Surgery | Surgery stay (1 = eligible for surgery complications; 0 = not eligible) |
| Obstetrics | Obstetrical stay (1 = eligible for obstetrical complications; 0 = not eligible) |
| NewBorn | New born stay (1 = eligible for new born complications; 0 = not eligible) |
| Risk-CP | Risk strata used to compute complications’ expected values |
| CP | Main complication |
| CP1 | Observed global complication score |
| CP0 | Expected global complication score |
| SH1 | Observed shock score |
| SH0 | Expected shock score |
| SI1 | Observed surgical infection score |
| SI0 | Expected surgical infection score |
| NB1 | Observed newborn complication score |
| NB0 | Expected newborn complication score |
| OB1 | Observed obstetrical score |
| OB0 | Expected obstetrical score |
| HE1 | Observed hemorrhage score |
| HE0 | Expected hemorrhage score |
| TE1 | Observed thromboembolic score |
| TE0 | Expected thromboembolic score |
| SU1 | Observed other surgical complication score |
| SU0 | Expected other surgical complication score |
| UL1 | Observed pressure ulcer score |
| UL0 | Expected pressure ulcer score |
| OI1 | Observed other nosocomial infection score |
| OI0 | Expected other nosocomial infection score |
| AN1 | Observed anesthetic complication score |
| AN0 | Expected anesthetic complication score |
| DR1 | Observed drug complication score |
| DR0 | Expected drug complication score |
| HC1 | Observed other health care score |
| HC0 | Expected other health care score |
| Comments: | - the specialty corresponds to the medical competence mainly involved; - the mission corresponds to the type of hospital care: academic (university hospital), specialized (intensive care, interventional medicine, specialized surgery, current or ambulatory care, split by specialty; - specialties and missions are not always the same depending on the age (<16 years old for pediatrics for instance). |
