LOS per Location: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
JMojica (talk | contribs)
CCMDB_legit, admin, approved, Administrators
2,813 edits
No edit summary
m Text replacement - "Definition of a Medicine Laptop Admission" to "Definition of a Medicine Program Admission"
 
(11 intermediate revisions by 2 users not shown)
Line 6: Line 6:
| indicator_start_date =  
| indicator_start_date =  
}}
}}
The difference between the End Date/Time in a physical location and Start Date/Time of stay in a physical location under the same service. Patients are sometimes physically occupying bed in different locations during the whole stay under the same service for various reasons.
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==
==Start Dates of collection==
*Critical Care: July 19, 2018 - started in project [[Borrow Arrive]] 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==
* the physical location(s) and start dttm (arrival date and time) on each location are taken from  Project  [[Boarding Loc]]
* The physical location(s) and start dttm (arrival date and time) on each location are taken from  Project  [[Boarding Loc]]
* [[Admit DtTm]] and [[Dispo DtTm]]
* [[Admit DtTm]] and [[Dispo DtTm]]


==Sampling Plan / Procedure==
==Sampling Plan / Procedure==
===Inclusion Criteria===
===Inclusion Criteria===
*All ICU admissions  - see  [[Definition of a Critical Care Laptop Admission]]  and  
*All ICU admissions  - see  [[Definition of a Critical Care Program Admission]]  and  
*All Medicine admissions  - see  [[Definition of a Medicine Laptop Admission]]
*All Medicine admissions  - see  [[Definition of a Medicine Program Admission]]
===Exclusion Criteria===
===Exclusion Criteria===
None
None
===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==
*LOS per location is simply calculated as the difference between the End Date/Time and Start Date/Time of stay in that location
*LOS per location is simply calculated as the difference between the End Date/Time and Start Date/Time of stay in that location
* First location:  Start date/time= first location = ICU discharge date/time – ICU admit date/time (expressed in days) where ICU discharge date/time = [[Dispo_DtTm]] and ICU admit date/time = [[Admit DtTm]]
*Depending on the number of locations (''n'') where the patient stayed, we have ''n'' locations and ''n'' start date/time
* Average ICU LOS (in days to 1 decimal place)
**Location 1:  Start date/time= first location start date/time and End Date/time= second location start date/time
* Median ICU LOS (in days to 1 decimal place)
**Location 2: Start date/time= second location start date/time and End Date/time= third location start date/time
* Total ICU LOS (in days to 1 decimal place)
**Location 3: Start date/time= third location start date/time and End Date/time= fourth location start date/time
===Numerator===
**Location ''n'' (last location): Start date/time= ''n''th  location start date/time and End Date/time= [[Dispo_DtTm]]
For Average ICU LOS, the numerator is Sum of Length of ICU stay of all discharges
*if there is only one location, Start date/time= first location start date/time and End Date/time= [[Dispo_DtTm]]
===Denominator===
For Average ICU LOS, the denominator is Number of discharges


==Data Sources==
==Reported as==
* [[Admit DtTm]] and [[Dispo DtTm]]
Mean, Median, Sum (in days to 1 decimal place) per physical location per site per time frame
* 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 09:41, 7 March 2025

...

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


  • Cargo


  • Helper template:
  • Cargo


  • Categories

none

  • 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=162732"