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)
 
(8 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]]


==Significance==
==Significance==
Beds Occupied by Transferable Patients  is  the  average number of  Medicine beds occupied per day by patients no longer requiring the intensity of care provided in a Medicine setting. It can identify and quantify issues around flow out of the Internal Medicine Program.
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==
==Sampling Plan / Procedure==
Line 27: Line 20:
** when patient at High Obs ward went to regular ward
** 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
** when patient went to home, to other facility in the region and out of the region, rehab, PCH and those who died


===Exclusion Criteria===
===Exclusion Criteria===
Line 34: Line 25:
===Frequency===
===Frequency===
* Recorded [[Transfer Delay (Medicine)|Transfer Delay]]  per patient
* Recorded [[Transfer Delay (Medicine)|Transfer Delay]]  per patient
* Monthly, quarterly or yearly basis based on either Medicine Admission Dates or Medicine Discharge Dates.
* Monthly, quarterly or yearly basis based on either Medicine [[Admit DtTm]] (Admission Datesor Medicine [[Dispo DtTm]] (Discharge Dates).
* For the Director reports, the discharge dates are used as the time of reference.
* For the Director reports, the Medicine [[Dispo DtTm]] (Discharge Dates) are used as the time of reference.


==Definition and Derivation==
==Definition and Derivation==
Line 49: 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= 200 days
*Total Transfer Delays for patients who went to Ward/Home= 1798 days
*Beds Occupied by Transferable Patients  to Ward/Home = 200 / 90 = 2.22 beds
*Beds Occupied by Transferable Patients  to Ward/Home = 1798 / 90 = 20.0 beds
*Total Transfer Delays for patients who went to IICU or H6 = 50 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 = 50 / 90 = 0.55 beds
*Beds Occupied by Transferable Patients  to Ward/Home = 113 / 90 = 1.3 beds


==Data Sources==
==Data Sources==
Line 60: 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: