Transfer Delay (Medicine): Difference between revisions
Ttenbergen (talk | contribs) m Text replacement - "|created_raw=created" to "|created_raw=Created" |
|||
| (8 intermediate revisions by 2 users not shown) | |||
| Line 2: | Line 2: | ||
|description='''Transfer Delay''' is the difference between [[Dispo_DtTm]] and [[#Time patient is ready for transfer]] in decimal days. | |description='''Transfer Delay''' is the difference between [[Dispo_DtTm]] and [[#Time patient is ready for transfer]] in decimal days. | ||
Other terms use to call it are '''Beds Occupied by transferable patients''', '''Wasted Beds''', '''Avoidable Days'''. | Other terms use to call it are '''Beds Occupied by transferable patients''', '''Wasted Beds''', '''Avoidable Days'''. | ||
|created_raw= | |created_raw=Created | ||
|Program=Medicine | |Program=Medicine | ||
|indicator_start_date=2003-10-01 | |indicator_start_date=2003-10-01 | ||
| Line 25: | Line 25: | ||
*** to a [[Dispo]] location (ie [[Dispo DtTm]]) | *** to a [[Dispo]] location (ie [[Dispo DtTm]]) | ||
*** to a [[Boarding Loc]] with a ''different''(higher or lower) [[Level of care]] (ie the start of that next [[Boarding Loc]]) | *** to a [[Boarding Loc]] with a ''different''(higher or lower) [[Level of care]] (ie the start of that next [[Boarding Loc]]) | ||
**** transfer to another [[Boarding Loc]] at the ''same'' [[Level of care]] does not reset the clock/generate a new delay | |||
{{ex | | {{ex | | ||
| Line 32: | Line 33: | ||
** three is no transfer ready between HOBS2 and home, so no additional delay | ** three is no transfer ready between HOBS2 and home, so no additional delay | ||
}} | }} | ||
== Calculation of Transfer Delay == | == Calculation of Transfer Delay == | ||
*Transfer delay calculation is | * As agreed in JALT meeting March 22, 2023, transfer delays will be reported based on actual delays at each [[Level of care]] with no more allowances of less than n hours. | ||
*In the meeting held Jan 11, 2023, Critical Care agreed to change the calculation of transfer delays which Medicine will do similarly for consistency: (a) ignore such transfer delays < 4 hrs, but (b) for all delays >=4 hrs to use the actual delay time. The process is to be done at each | *Before Jan 2023, Transfer delay calculation is done similarly with the Critical Care calculation which is substracting ''n'' hrs from all actual delay time and for Medicine, ''n'' is 4 hours. | ||
*In the meeting held Jan 11, 2023, Critical Care agreed to change the calculation of transfer delays which Medicine will do similarly for consistency as follows: (a) ignore such transfer delays < 4 hrs, but (b) for all delays >=4 hrs to use the actual delay time. The process is to be done on the transfer delay at each [[Level of care]]. | |||
== Implementation == | == Implementation == | ||
| Line 49: | Line 52: | ||
Start time is first transfer ready per level of care; end is either last of this level of care, or dispo. | Start time is first transfer ready per level of care; end is either last of this level of care, or dispo. | ||
*Before Oct 1, 2020, it is calculated by [[ | *Before Oct 1, 2020, it is calculated by [[Created_Variables_Common_maker_2021 query]] and stored in [[Created_Variables_Common_2021 table]] in [[CFE]]. | ||
*Starting Oct 1, 2020, it will be added but haven't started. | *Starting Oct 1, 2020, it will be added but haven't started. | ||
=== Implementation in CFE === | === Implementation in CFE === | ||
For now, a "Transfer Ready Med testing" button on the main form of CFE needs to be pressed to generate this data. Once we are comfortable with it this generating will be included in the | For now, a "Transfer Ready Med testing" button on the main form of CFE needs to be pressed to generate this data. Once we are comfortable with it this generating will be included in the [[Calc created variables button]]. | ||
[[Sub populate_created_transferDelay()]] loads [[created_TransferReady query]] (which generates transfer ready dates) and [[created_BoardingLoc_plus_historical query]] and writes delays to [[created_transferDelay table]]. | [[Sub populate_created_transferDelay()]] loads [[created_TransferReady query]] (which generates transfer ready dates) and [[created_BoardingLoc_plus_historical query]] and writes delays to [[created_transferDelay table]]. | ||
== Which Transfer Ready DtTm To Use? == | == Which Transfer Ready DtTm To Use? == | ||
This is now implemented in [[Created_TransferReady query]]. | |||
=== [[Admit DtTm]] or [[Dispo DtTm]] < 2020-10-01 00:00 === | === [[Admit DtTm]] or [[Dispo DtTm]] < 2020-10-01 00:00 === | ||
| Line 80: | Line 81: | ||
== SAS Program== | == SAS Program== | ||
*S:\MED\MED_CCMED\Julie\SAS_CFE\CFE_macros\ | *S:\MED\MED_CCMED\Julie\SAS_CFE\CFE_macros\logphi_TR_Jan2023.sas | ||
** %Med_tready | ** %Med_tready | ||
*S:\MED\MED_CCMED\Julie\SAS_CFE\CFE_macros\prep_Tmp_BoardServiceTransfer.sas (macro %boardtransf) | *S:\MED\MED_CCMED\Julie\SAS_CFE\CFE_macros\prep_Tmp_BoardServiceTransfer.sas (macro %boardtransf) | ||