CCMDB Wiki

Bed borrow: Difference between revisions

← Older editNewer edit →
mNo edit summary
m moved Allan's stuff with the Project Borrow Arrive stuff that would implement about half of his idea.
Line 1: Line 1:
== Allan’s Suggestion for Bed Borrow Coding ==
*There are 2 sorts of bed borrowing when a TypeA patient should be in UnitA but is boarded in UnitB
**(1) Patient is in Unit B but still under the care of TeamA -- this is coded in the database as a UnitA patient
**(2) Patient is in Unit B and under the care of TeamB -- this is coded in the database as a UnitB patient
*Here’s what they’re borrowing:
**For ‘1’ the patient is just borrowing a bed
**For ‘2’ the patient is borrowing a bed AND the service, i.e. TeamB
*To capture all of this, we need to create 2 PAIRS of parameters -- that should be coded separately for each day, if applicable.  Each pair comprises a binary Flag combined with FlaggedUnitcode
**(a) Flag1 indicates that on the given day the patient is borrowing a bed -- the FlaggedUnitCode indicates WHERE that bed is. 
**(b) Flag2 indicates that on the given day the patient is borrowing a bed & service -- the FlaggedUnitCode code indicates WHERE that patient would otherwise be located
*Example:  A=ACCU  B=ICMS
**In situation#1, set Flag1=1 and FlaggedUnitCode=ICMS
**In situation#2, set Flag2=1 and FlaggedUnitCode=ACCU
*THUS, here is how the 2 kinds of pieces of data sought by administrators related to bed borrows would each be calculated:
**Administrators for UnitA want to know how many bed-days in a given interval that they had TypeA patients boarding elsewhere.  This number is the sum of the following 2 things:
***#Bed-days in the given interval that patients assigned to UnitA had Flag1=1 +
***#Bed-days in the given interval that patients assigned to any other unit had Flag2=1 AND the FlaggedUnitCode for Flag2 was UnitA
**Administrators for UnitB want to know how many bed-days in a given interval were taken up by boarders from elsewhere.  This number is the sum of the 2 following things:
***#Bed-days in the given interval that patients assigned to UnitB had Flag2=1 +
***#Bed-days in the given interval that patients assigned to any other unit had Flag1=1 AND the FlaggedUnitCode for Flag2 was UnitB
A bed borrow is when a patient is located in one place while admitted under the physician of a different location (the home location).  
A bed borrow is when a patient is located in one place while admitted under the physician of a different location (the home location).  


Line 45: Line 22:
=== [[Project Borrow arrive]] ===
=== [[Project Borrow arrive]] ===
New format of bed borrow tracking that will hopefully replace some of the items on this page.
New format of bed borrow tracking that will hopefully replace some of the items on this page.
==== Allan’s Suggestion for Bed Borrow Coding ====
*There are 2 sorts of bed borrowing when a TypeA patient should be in UnitA but is boarded in UnitB
**(1) Patient is in Unit B but still under the care of TeamA -- this is coded in the database as a UnitA patient
**(2) Patient is in Unit B and under the care of TeamB -- this is coded in the database as a UnitB patient
*Here’s what they’re borrowing:
**For ‘1’ the patient is just borrowing a bed
**For ‘2’ the patient is borrowing a bed AND the service, i.e. TeamB
*To capture all of this, we need to create 2 PAIRS of parameters -- that should be coded separately for each day, if applicable.  Each pair comprises a binary Flag combined with FlaggedUnitcode
**(a) Flag1 indicates that on the given day the patient is borrowing a bed -- the FlaggedUnitCode indicates WHERE that bed is. 
**(b) Flag2 indicates that on the given day the patient is borrowing a bed & service -- the FlaggedUnitCode code indicates WHERE that patient would otherwise be located
*Example:  A=ACCU  B=ICMS
**In situation#1, set Flag1=1 and FlaggedUnitCode=ICMS
**In situation#2, set Flag2=1 and FlaggedUnitCode=ACCU
*THUS, here is how the 2 kinds of pieces of data sought by administrators related to bed borrows would each be calculated:
**Administrators for UnitA want to know how many bed-days in a given interval that they had TypeA patients boarding elsewhere.  This number is the sum of the following 2 things:
***#Bed-days in the given interval that patients assigned to UnitA had Flag1=1 +
***#Bed-days in the given interval that patients assigned to any other unit had Flag2=1 AND the FlaggedUnitCode for Flag2 was UnitA
**Administrators for UnitB want to know how many bed-days in a given interval were taken up by boarders from elsewhere.  This number is the sum of the 2 following things:
***#Bed-days in the given interval that patients assigned to UnitB had Flag2=1 +
***#Bed-days in the given interval that patients assigned to any other unit had Flag1=1 AND the FlaggedUnitCode for Flag2 was UnitB


== Background ==
== Background ==
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Bed_borrow"