Length.xlsx
HHospital identifier
LLocation of the hospital
yYear (most recent year in the SQLape_input.txt file, with at least 10% of records)
nNumber of hospital stays
qLSData quality (warning if all requirements are not met)
sLSNumber of days (DischargeDate-AdmissionDate+1-Vacation hours/24)
eLSNumber of eligible stays
LS1Observed length of stay (average)
LS0Expected length (see prediction models for more details)
LS0minMinimal expected length (see prediction models for more details)
LS0maxMaximal expected length (see prediction models for more details)
RLSRate ratio (LS1 / LS0 )
LS0CHSwiss average in all Swiss hospitals from 2014-2016 satisfying data quality requirement
LS1aAdjusted rate (rate ratio * benchmark average)
vLSResults
A: low rate (LS1 < LS0min)
B: in the standard (LS0min < LS1 < LS0max)
C: high rate (LS1 > LS0max)
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.