Beds occupied by transferrable patients (Medicine)

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

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.

since there can now be more than one transfer delay, would it not make more sense to report these based on transfer ready dttm than on admit or dispo?

• SMW

• Cargo

• Categories

Definition and Derivation

• Refer to the definition of Transfer Ready DtTm and Transfer Delay

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

• Per patient Transfer Delay (Critical Care)
  • July 1988 to Sept 2020 : derived from Transfer Ready DtTm field and Dispo DtTm field.
  • Starting Oct 1, 2020: derived from the first transfer ready date and time in the Transfer Ready DtTm tmp entry and Dispo DtTm field .

SAS Program

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

Data Integrity Checks

• Query check long transfer delay

Related articles

Related articles:

Transfer Delay (Medicine) (← links) User:JMojica (← links)