Analysis.txt
#CaseIdentifier of the stay
AnalysisContext 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)
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
#HospitalHospital identifier
#SiteLocation of the hospital
YearYear (most recent year in the SQLape_input.txt file, with > 10% of records)
AgeAge at admission (in years)
Gender1 = male, 2 = female
Entry0: 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
End0: 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)
SpecialtyMedical specialty (Specialties), deduced from the variable “Category” below (Categories).
MissionHospital missions (Missions), deduced from the variable “Category” below (Categories).
CategoryMain SQLape® categories (the diagnosis or operation category, with the lowest hierarchy value in Categories.
Risk-LS-CORisk strata used to compute length and cost expected values
LS1Observed length of stay
LS0Expected length of stay
CO1Observed cost
CO0Expected cost
SurgerySurgery stay (1 = eligible for surgery complications; 0 = not eligible)
ObstetricsObstetrical stay (1 = eligible for obstetrical complications; 0 = not eligible)
NewBornNew born stay (1 = eligible for new born complications; 0 = not eligible)
Risk-CPRisk strata used to compute complications’ expected values
CPMain complication
CP1Observed global complication score
CP0Expected global complication score
SH1Observed shock score
SH0Expected shock score
SI1Observed surgical infection score
SI0Expected surgical infection score
NB1Observed newborn complication score
NB0Expected newborn complication score
OB1Observed obstetrical score
OB0Expected obstetrical score
HE1Observed hemorrhage score
HE0Expected hemorrhage score
TE1Observed thromboembolic score
TE0Expected thromboembolic score
SU1Observed other surgical complication score
SU0Expected other surgical complication score
UL1Observed pressure ulcer score
UL0Expected pressure ulcer score
OI1Observed other nosocomial infection score
OI0Expected other nosocomial infection score
AN1Observed anesthetic complication score
AN0Expected anesthetic complication score
DR1Observed drug complication score
DR0Expected drug complication score
HC1Observed other health care score
HC0Expected 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).