s_dispo.meanLOS3STD
Jump to navigation
Jump to search
| 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