Edit data element info: S dispo.meanLOS3STD

Are you logged on?

You do not have permission to edit this page, for the following reason:

The action you have requested is limited to users in the group: CCMDB_legit.

Field Name:
CCMDB Label:
CCMDB tab:
Table:
Data Type:
Length (single, double, byte, integer, long integer, or the string size):
Program:
Created/Raw:
Start Date:
End Date:
Sort Index:
Element Description:

unstructured part of page:

{{DISPLAYTITLE:s_dispo.meanLOS3STD}} == 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. {{Collapsable | always=SQL for [[CFE]] | full=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

Explain your edit, if you think it needs explanation (e.g. "as discussed with ...", or "content moved to ...", or "duplicate content, see ..."):

This is a minor edit

Watch this page

Cancel

Created_Variables_CC_2021 table
Created_Variables_Common_2021 table
L Como table
L Dxs table
L ICD10 table
L Labs Flowsheet table
L Log table
L PCH table
L Person table
L PHI table
L TISS Form table
L TISS Item table
L TmpV2 table
L_CCI_Component table
L_CCI_Picklist table
L_Como table
L_Dxs table
L_ICD10 table
L_Labs_DSM table
L_Labs_Flowsheet table
L_Log table
L_PCH table
L_Pharm_Flowsheet table
L_PHI table
L_TISS_Form table
L_TISS_Item table
L_TISS76 table
L_TmpV2 table
s_dispo table
s_ICD10 table