BedHeldEnd DtTm: Difference between revisions

JMojica (talk | contribs)
m Text replacement - "cross check " to "cross check "
 
(11 intermediate revisions by 3 users not shown)
Line 1: Line 1:
{{Project
{{Project
|ProjectActive=planned
|ProjectActive=active
|ProjectProgram=CC and Med
|ProjectProgram=CC and Med
|ProjectRequestor=???
|ProjectRequestor=internal quality check
|ProjectCollectionStartDate=2023-01-01
|ProjectCollectionStartDate=2023-01-01
|Project={{PAGENAME}}
|Project={{PAGENAME}}
}}
}}
== Data Collection ==
== Data Collection ==
Collect for all patients where beds are held due to '''[[AMA]]''' or procedure at other sites.  
Collect for all patients where beds are held due to '''[[AMA]]''' or procedure at other sites.  
Line 20: Line 19:
** '''AMA (Protocol)''' - when a consent discussion regarding the patient's choice to leave before a recommended time has been done and the patient is being asked to sign a form that he/she understands the risks of such decision ; The date and time for '''AMA (Protocol)''' will be the same as the [[Dispo DtTm]], we are collecting it only for completeness and cross-checks.  
** '''AMA (Protocol)''' - when a consent discussion regarding the patient's choice to leave before a recommended time has been done and the patient is being asked to sign a form that he/she understands the risks of such decision ; The date and time for '''AMA (Protocol)''' will be the same as the [[Dispo DtTm]], we are collecting it only for completeness and cross-checks.  
** '''Procedure''' - patient went elsewhere for proedure and bed was held and patient did not return
** '''Procedure''' - patient went elsewhere for proedure and bed was held and patient did not return
** '''Weird Reason''' - reason not covered above
* Date (field E): Discharge date as per ADT (ie when the bed was released)
* Date (field E): Discharge date as per ADT (ie when the bed was released)
* Time (field M): Discharge time as per ADT (ie when the bed was released)
* Time (field M): Discharge time as per ADT (ie when the bed was released)
* Not used: Integer, Real, Checkbox, Comment
* Not used: Integer, Real, Checkbox, Comment
===Special Scenario ===
* A patient in the ER admitted under medicine service leaves AMA from the ER, A bed on the ward is assigned to the patient (boarding location appears in COGNOS) however the patient never returns to occupy the bed on the ward.  As per the [[Boarding Loc]] instructions, do not enter the second boarding location
This is very rare, but if we do start to notice this happening more frequently we will discuss further. 


==== Sources ====
==== Sources ====
Line 39: Line 44:
*(a) Actual time under care, which is from [[Admit DtTm]]  to the patient's [[Dispo DtTm]] -- we'll call this the patient's length of stay **use for indicators [[LOS Per Record]] or [[LOS Per Service]]
*(a) Actual time under care, which is from [[Admit DtTm]]  to the patient's [[Dispo DtTm]] -- we'll call this the patient's length of stay **use for indicators [[LOS Per Record]] or [[LOS Per Service]]
*(b) What we'll call "Bed Assigned Time", i.e. from [[Admit DtTm]]  to the '''time when the bed is released for reassignment''', which we will call "BedHeldEndTime".  This latter is generally available from Cognos (ADT)
*(b) What we'll call "Bed Assigned Time", i.e. from [[Admit DtTm]]  to the '''time when the bed is released for reassignment''', which we will call "BedHeldEndTime".  This latter is generally available from Cognos (ADT)
===Visit to temporary locations and died===
Follow the guidelines in [[Visits to temporary locations]] for collection of [[Dispo DtTm]] and [[BedHeldEnd DtTm]] in case of a death.


==Collection parameters==
==Collection parameters==
* End Date: planned as continuous collection without an end date
* End Date: planned as continuous collection without an end date
 
==Data Use==
==Data Use==
*[[LOS Per Record]]  
* [[LOS Per Record]]  
*[[LOS Per Service]]
* [[LOS Per Service]]
*[[Bed occupancy]]
* [[Bed occupancy]]
* Total Patient Days based on calendar days
* [[Occupancy For Bed Held]]
 
== Occupancy For Bed Held ==
*Actual extra hours occupying a bed per day for each patient with bed held from [[Dispo DtTm]] to [[BedHeldEnd DtTm]]
**If bed held date is the same as dispo date - calculate the difference between the bed held time and dispo time.
**if bed held date is not the same as dispo date
***for first date - calculate the difference between 2400 and dispo time
***for in between date - consider 1 full day
***for last date -  consider the Bed held Tm
*Extra Bed held Occupancy per day = sum of extra bed occupied by all patients with bed held in a given day
*The Extra Bed held Occupancy will be also reported along with the [[Bed occupancy]]  (Definition 1 derived from  [[Admit DtTm]] to [[Dispo DtTm]] ) which is the sum of patient days or  '''Total Patient Days''' but as a separate entity.


== Consistency Checks ==
== Consistency Checks ==
We will collect this data for a month or so to have an idea what it looks like after that, we might add a cross check for complete and undeleted records such that if AMA is entered for this, [[Dispo]] must be AMA.  
We will collect this data for a month or so to have an idea what it looks like after that, we might add a [[cross check]] for complete and undeleted records such that if AMA is entered for this, [[Dispo]] must be AMA.  


With the current data, the converse is not true in case of AMA who signs out, as BedHeld will not be entered if pt signs out AMA following WRHA process. Once we see data we will decide if we want to add a counterpart so we can cross-check that the entry wasn't just forgotten if there is an AMA entry in [[Dispo]]. We might add an entry like AMA (protocol) to be able to ensure completion. Data for those would either have no dttm, or the same dttm as [[Dispo DtTm ], we'd have to decide.  
With the current data, the converse is not true in case of AMA who signs out, as BedHeld will not be entered if pt signs out AMA following WRHA process. Once we see data we will decide if we want to add a counterpart so we can cross-check that the entry wasn't just forgotten if there is an AMA entry in [[Dispo]]. We might add an entry like AMA (protocol) to be able to ensure completion. Data for those would either have no dttm, or the same dttm as [[Dispo DtTm ], we'd have to decide.  
Line 69: Line 67:
{{Data Integrity Check List|}}
{{Data Integrity Check List|}}


== To do ==
[[Category:End-of-life related data‏‎]]
{{Todo
| who = Tina
| todo_added = 2022-12-08
| todo_action = 2022-12-08
| question = 
* make CCMDB changes
* edit any related AMA content on wiki
* update [[Bed holds]]
}}


== Log ==
== Log ==
* 2023-01-10 Julie identified data problems in preliminary data and defined required checks, see [[Query check tmp BedHeld]]
* 2023-01-25 added "Weird Reason"
* 2023-01-10 Julie identified data problems in preliminary data and defined required checks, see [[Query check_tmp_BedHeld]]
* 2023-01-01 collection start
* 2023-01-01 collection start
* 2022-12-08 made page to validate
* 2022-12-08 made page to validate