INPATIENT COSTS – OUTPUT FILES

Cost.xlsx
H	Hospital identifier
L	Location of the hospital
y	Year (most recent year in the SQLape_input.txt file, with at least 10% of records)
n	Number of hospital stays
q_CO	Data quality (warning if all requirements are not met)
s_CO	Number of days (DischargeDate-AdmissionDate+1-Vacation hours/24)
e_CO	Number of eligible stays
CO₁	Observed length of stay (average)
CO₀	Expected length (see prediction models for more details)
CO_0min	Minimal expected length (see prediction models for more details)
CO_0max	Maximal expected length (see prediction models for more details)
R_CO	Rate ratio (LS₁ / LS₀ )
CO_0CH	Swiss average in all Swiss hospitals from 2018-2020 satisfying data quality requirement
CO_1a	Adjusted rate (rate ratio * benchmark average)
v_CO	Results
	A: low rate (LS₁ < LS_0min)
	B: in the standard (LS_0min < LS₁ < LS_0max)
	C: high rate (LS₁ > LS_0max)

These results are given globally in “Length” Excel tab. They are given in separate Excel files for each site of the hospital, split according to the context of the stay: back to home with or without a potentially avoidable readmission, waiting for nursing home bed, medical justification of the stay, transfer, etc.