Beds occupied by transferrable patients (Medicine): Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
JMojica (talk | contribs)
No edit summary
JMojica (talk | contribs)
 
(7 intermediate revisions by 2 users not shown)
Line 7: Line 7:
| indicator_end_date =  
| indicator_end_date =  
}}
}}
 
Usually used in aggregate form as "per location" and/or "per timeframe", e.g. by month/quarter/year x Ward/Unit x Hospital.  
==Reported as==
{{DJ | 1
* Needs detail. }}
 
{{DJ | 1
* confirm distinction to [[Transfer Delay (Medicine)]]. }}
 
==QI domain==
==QI domain==
* [[QualityDomain::Efficient]]
* [[QualityDomain::Efficient]]
Line 47: Line 40:
===Example===
===Example===
*Time Reference: Discharge Dates from Jan 1, 2021 to March 31, 2021
*Time Reference: Discharge Dates from Jan 1, 2021 to March 31, 2021
*Total Transfer Delays for patients who went to Ward/Home= 1810 days
*Total Transfer Delays for patients who went to Ward/Home= 1798 days
*Beds Occupied by Transferable Patients  to Ward/Home = 1810 / 90 = 20.1 beds
*Beds Occupied by Transferable Patients  to Ward/Home = 1798 / 90 = 20.0 beds
*Total Transfer Delays for patients are at High Obs ward and who went to regular ward= 120 days
*Total Transfer Delays for patients at High Obs ward and who went to regular ward= 113 days
*Beds Occupied by Transferable Patients  to Ward/Home = 120 / 90 = 1.3 beds
*Beds Occupied by Transferable Patients  to Ward/Home = 113 / 90 = 1.3 beds


==Data Sources==
==Data Sources==
Line 58: Line 51:


==SAS Program==
==SAS Program==
*S:\MED\MED_CCMED\Julie\SAS_CFE\CFE_macros\logphi.sas
*S:\MED\MED_CCMED\Julie\SAS_CFE\CFE_macros\logphi_TR_Jan2023.sas
*S:\MED\MED_CCMED\Julie\SAS_CFE\CFE_macros\prep_Tmp_BoardServiceTransfer_15Sept2021.sas
*S:\MED\MED_CCMED\Julie\SAS_CFE\CFE_macros\prep_Tmp_BoardServiceTransfer_15Sept2021.sas


== Data Integrity Checks ==
== Data Integrity Checks ==
* [[Query check long transfer delay]]
* [[Query check long transfer delay]]
==Report Users==
 
*[[Directors Annual Report (Medicine)|Directors Annual Report]]
*[[Directors Quarterly Report (Medicine)|Directors Quarterly Report]]
== Related articles ==  
== Related articles ==  
{{Related Articles}}
{{Related Articles}}

Latest revision as of 16:48, 17 January 2023

Medicine beds occupied by transferrable patients

Indicators
Indicator: Beds occupied by transferrable patients (Medicine)
Created/Raw: Created
Program: Medicine
Start Date:
End Date:
Reports: Directors Quarterly and Annual Report (Medicine)


  • Cargo


  • SMW:
  • Categories
  • Default form:

Usually used in aggregate form as "per location" and/or "per timeframe", e.g. by month/quarter/year x Ward/Unit x Hospital.

QI domain

  • Efficient

Significance

Beds Occupied by Transferable Patients is the average number of Medicine beds occupied per day by patients no longer requiring the level of care provided in a Medicine setting. It can identify and quantify issues around flow out of the Internal Medicine Program.

Sampling Plan / Procedure

Inclusion Criteria

100% of all patients physically present in a ward bed awaiting transfer out of the Medicine and having a date value on the Transfer Ready DtTm field

  • two transfer delay calculation
    • when patient at High Obs ward went to regular ward
    • when patient went to home, to other facility in the region and out of the region, rehab, PCH and those who died

Exclusion Criteria

Frequency

  • Recorded Transfer Delay per patient
  • Monthly, quarterly or yearly basis based on either Medicine Admit DtTm (Admission Dates) or Medicine Dispo DtTm (Discharge Dates).
  • For the Director reports, the Medicine Dispo DtTm (Discharge Dates) are used as the time of reference.

Definition and Derivation

Numerator

Num = Total Transfer Delay a given time frame

Denominator

Denom =number of calendar days in a given time

Formula

Beds Occupied by transferable patient = Num / Denom

Example

  • Time Reference: Discharge Dates from Jan 1, 2021 to March 31, 2021
  • Total Transfer Delays for patients who went to Ward/Home= 1798 days
  • Beds Occupied by Transferable Patients to Ward/Home = 1798 / 90 = 20.0 beds
  • Total Transfer Delays for patients at High Obs ward and who went to regular ward= 113 days
  • Beds Occupied by Transferable Patients to Ward/Home = 113 / 90 = 1.3 beds

Data Sources

SAS Program

  • S:\MED\MED_CCMED\Julie\SAS_CFE\CFE_macros\logphi_TR_Jan2023.sas
  • S:\MED\MED_CCMED\Julie\SAS_CFE\CFE_macros\prep_Tmp_BoardServiceTransfer_15Sept2021.sas

Data Integrity Checks

Related articles

Related articles: