s_dispo.meanLOS3STD

Data Element (edit)
Field Name:	program
CCMDB Label:	not stated
CCMDB tab:	not stated
Table:	s_dispo table
Data type:
Length:
Program:	Med and CC
Created/Raw:	Raw
Start Date:	2016-07-01
End Date:	2300-01-01
Sort Index:	17
Data Dependencies(Reports/Indicators/Data Elements):	No results

mean LOS plus 3*STD for the location used by Function long LOS() for soft-check on long LOS admissions.

Use

See Function long LOS() for how the values are used.

Values

The values are generated on occasion from actual LOS data for that location.

SQL for CFE

SELECT s_dispo.location_name, Count(L_Log.D_ID) AS CountOfD_ID, Avg([dispo_dttm]-[dttm]) AS LOS_avg, StDev([dispo_dttm]-[dttm]) AS LOS_sd, [LOS_avg]+3*[LOS_sd] AS LOS_Avg_3SD, Avg(s_dispo.meanLOS3STD) AS old, s_dispo.Site

FROM (L_Log INNER JOIN s_dispo ON L_Log.Service_Location = s_dispo.dispo_ID) INNER JOIN created_FirstLocation ON L_Log.D_ID = created_FirstLocation.D_ID
WHERE (((L_Log.Dispo_DtTm)>Now()-(365*2)) AND ((L_Log.RecordStatus)="vetted"))
GROUP BY s_dispo.location_name, s_dispo.Site
HAVING (((s_dispo.Site) In ("GRA","HSC","STB")));

Log

2025-09-28 - updated with newest values derived from above query
2022-04-21 - updated s_dispo table.meanLOS3STD with data from Julie
2019-03-20 - updated s_dispo table.meanLOS3STD with new values from Julie