LOS per Location: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
 
(4 intermediate revisions by one other user not shown)
Line 10: Line 10:


==Start Dates of collection==
==Start Dates of collection==
*Critical Care: July 19, 2018 - started in project [[Borrow Arrive]] which was moved and continued to project [[Boarding Loc]]   
*Critical Care: July 19, 2018 - started in project "Borrow Arrive" which was moved and continued to project [[Boarding Loc]]   
*Medicine: Sept 20, 2019 [[Boarding Loc]]
*Medicine: Sept 20, 2019 in project [[Boarding Loc]]


==Data Sources==
==Data Sources==
Line 25: Line 25:
===Frequency===
===Frequency===
* Reported when patient had been discharged out of ICU/Medicine.
* Reported when patient had been discharged out of ICU/Medicine.
* Monthly, quarterly, year based on discharged date  
* Monthly, quarterly, year based on discharged date of [[Dispo DtTm]]


==Definition and Derivation==
==Definition and Derivation==
Line 36: Line 36:
*if there is only one location, Start date/time= first location start date/time and End Date/time= [[Dispo_DtTm]]  
*if there is only one location, Start date/time= first location start date/time and End Date/time= [[Dispo_DtTm]]  


 
==Reported as==
* Average ICU LOS (in days to 1 decimal place)
Mean, Median, Sum (in days to 1 decimal place) per physical location per site per time frame
* Median ICU LOS (in days to 1 decimal place)
* Total ICU LOS (in days to 1 decimal place)
===Numerator===
For Average ICU LOS,  the numerator is Sum of Length of ICU stay of all discharges
===Denominator===
For Average ICU LOS, the denominator is Number of discharges
 
==Data Sources==
* [[Admit DtTm]] and [[Dispo DtTm]]
* Can also be taken from the [[Created_Variables_CC table]] of [[CFE]]


==SAS Program==
==SAS Program==
The SAS program to get the LOS is X:\Julie\SAS_CFE\CFE_macros\logphi.sas and datetimes.sas
S:\MED\MED_CCMED\Julie\SAS_CFE\CFE_macros\prep_Tmp_BoardServiceTransfer_15Sept2021.sas
 
S:\MED\MED_CCMED\Julie\SAS_CFE\Med_reports\5_CFE_MedReportPart3_startingJan2021_16Aug2021.sas
==Report Users==
==Report Users==
* Critical Care Directors, Critical Care Unit Managers and WRHA Outcome Improvement Team Committee
* Internal Medicine Directors and Ward Managers
* Shared Health Decision Support Officer for Critical Care Dashboard (HSC only)
This is what we usually mean when we say Length of Stay; see LOS for other uses.
referred to as the Length of Stay (LOS) per record Before Oct 1, 2020 - a record is defined as an admission in specific Internal Medicine ward or Critical Care Unit as shown in Site_and_Location_table
Starting Oct 1, 2020 - a record for Critical Care, see Definition of a Critical Care Laptop Admission and a record for Internal Medicine, see Definition of a Medicine Laptop Admission.
 
LOS is simply calculated as the difference between the End Date/Time (i.e. Dispo DtTm) and Start Date/Time (i.e. first Service tmp entry) of stay. Start Date and time is defined by either of these fields: Accept DtTm
Arrive DtTm
first Service Start DtTm, see Service_tmp_entry and is the same as the Accept DtTm
 
End Date and time is defined by the Dispo DtTm
 
 
For example:
Start Date/Time: 20 May 2008 11:30
End Date/Time: 21 May 2008 17:45
LOS_Record = 1.260 days
What is actually being reported is the mean and median of this value.
 
 
 
 
== Related articles ==  
== Related articles ==  
{{Related Articles}}
{{Related Articles}}


[[Category:Length of stay]]
[[Category:Length of stay]]

Latest revision as of 18:22, 2021 December 15

...

Indicators
Indicator: LOS per Location
Created/Raw: Created
Program: Critical Care and Medicine
Start Date:
End Date:
Reports: Directors Quarterly and Annual Report (Medicine)


  • Cargo


  • SMW:
  • Categories
  • Default form:

Patients occupy bed in different locations during the whole stay under the same service for various reasons. LOS per location is simply the difference between the End Date/Time and Start Date/Time of stay in that physical location.


Start Dates of collection

  • Critical Care: July 19, 2018 - started in project "Borrow Arrive" which was moved and continued to project Boarding Loc
  • Medicine: Sept 20, 2019 in project Boarding Loc

Data Sources

Sampling Plan / Procedure

Inclusion Criteria

Exclusion Criteria

None

Frequency

  • Reported when patient had been discharged out of ICU/Medicine.
  • Monthly, quarterly, year based on discharged date of Dispo DtTm

Definition and Derivation

  • LOS per location is simply calculated as the difference between the End Date/Time and Start Date/Time of stay in that location
  • Depending on the number of locations (n) where the patient stayed, we have n locations and n start date/time
    • Location 1: Start date/time= first location start date/time and End Date/time= second location start date/time
    • Location 2: Start date/time= second location start date/time and End Date/time= third location start date/time
    • Location 3: Start date/time= third location start date/time and End Date/time= fourth location start date/time
    • Location n (last location): Start date/time= nth location start date/time and End Date/time= Dispo_DtTm
  • if there is only one location, Start date/time= first location start date/time and End Date/time= Dispo_DtTm

Reported as

Mean, Median, Sum (in days to 1 decimal place) per physical location per site per time frame

SAS Program

S:\MED\MED_CCMED\Julie\SAS_CFE\CFE_macros\prep_Tmp_BoardServiceTransfer_15Sept2021.sas S:\MED\MED_CCMED\Julie\SAS_CFE\Med_reports\5_CFE_MedReportPart3_startingJan2021_16Aug2021.sas

Report Users

  • Internal Medicine Directors and Ward Managers

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=LOS_per_Location&oldid=153543"