Accept DtTm field: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
(→‎Questions: accept to service date and time is not in the EPR)
mNo edit summary
 
(164 intermediate revisions by 19 users not shown)
Line 1: Line 1:
  ''This field is currently being implemented, please check the instructions and put a discussion for anything that isn't clear. ''
{{Todo
 
| who = Tina
The [[Accept DtTm field]] contains the date and time when the attending accepts a patient, i.e. the date/time a patient changes status from what is documented in [[Previous Service field]] to [[Service/Location field]].
| todo_added = 2022-06-30
  | todo_action = 2023-05-04
| question =  _ccmdb_dev
* Field is legacy; once no longer used, remove it from sending and then from ccmdb_data. Query to check:
::SELECT L_Log.D_ID, L_Log.RecordStatus, L_Log.Accept_DtTm, L_Log.Arrive_DtTm
::FROM L_Log
::WHERE (((L_Log.RecordStatus)="incomplete") AND ((L_Log.Accept_DtTm) Is Not Null) AND ((L_Log.Arrive_DtTm) Is Not Null));
* 98 left as of 2022-08-04
* None left as of 2023-05-04, field can be removed...  
** remove from sending
** remove from CCMDB_data
}}


{{Data element
|field_name=Accept DtTm
|CCMDB_label=Accept DtTm
|in_table=L_Log table
|data_type=date
|program_collecting=Med and CC
|created_raw=Raw
|data_element_start_date=2016-07-01
|data_element_end_date=2022-04-22
|data_element_sort_index=43
|element_description=First [[Service tmp entry]] DtTm for pts who came from the '''ER department''' only
}}
== Collection Instruction ==
== Collection Instruction ==
For all critical care and medicine patients enter the date that the service physician accepted the patient.  
For each patient, enter First [[Service tmp entry]] DtTm for pts who came from the same hospital's the '''ER department''' only (i.e. who had an initial [[Boarding Loc]] of ER). Follow the instructions at [[Service tmp entry]].


If the patient is accepted and arrives at the same time, enter the [[Arrive_DtTm field]] and then click the "set accept_DtTm to Arrive_DtTm" button to copy the DtTm across.  
This means the {{PAGENAME}} should be equal to the first [[Service tmp entry]] DtTm if it is entered at all.


== Questions ==
== Planned elimination of this field ==
*the accept date/time by Medicine/ICU Service Physician for admission to ward/unit is not entered into the EPR, but is found on the admission/separation registers 
see [[Change to replace Accept DtTm with first Service tmp entry, and Arrive DtTm with first Boarding Loc]]


== Data Use ==
[[Patient flow]]
* medicine program: to monitor delays to move patient from ER to Med ward bed
* as of July 2016 onward - ICU same purpose
Accept DtTm is used as part of the formula to calculate delay in the transfer of patient from ER bed to Med ward or ICU bed - see [[ER Delay]]. This measures the amount of time for the patient already accepted in Medicine or Critical Care service but still using the ER bed and resources.


A. Question - Patient X:
{{Data Integrity Check List}}
**came to Vic Hospital April 1/16 @0826 to ER triage.
**was admitted from ER to Urology N2 April/1/16 @ 1338 from home (lived in house)
**went to N2 (UROLOGY-surgical service) April 1/16@1605
**was put on transfer to Medicine April 21/16@ 1530. 
**went from N2 to S4:  April 22/16@ 1945.--OK Please fill in for me Trish/Tina/Julie


#Pre-Acute living situation: '''house'''
== Legacy ==
#Pre-admit Inpatient institution: '''not applicable''' (only applicable if comes from a temporary location, and to find out if pt was an inpatient somewhere prior to temp location)
{{Collapsable
#Previous Location: '''Vic ward'''  (N2 surgical ward)
| always=Click to see legacy info
#Arrive DtTM:  '''April 22, 2016 @ 1945'''
| full=
#Accept DtTM: '''April 21, 2016 @ 1530'''
* related info: [[Change to start collection at accept rather than arrive time]]
#Previous Service: '''surgery'''
* 2017_January:  also enter lines in TMP for all [[AcceptDateSource]]s.
#Visit Admit DtTm: '''April 1 2016 @0826'''  
#Transfer ready:
#Dispo dttm: 
#Dispo:
 
If you could please fill this out I can use as a guide line Thanks


*Ok. I need more clarification I am confused!!This was a surgical patient who was made a medicine pt and was transferred to my unit and is still there so there isn't a transfer ready time for medicine yet ?Laura this isn't an ICU patient this is a medicine pt who was a surgical pt and transferred from urology to medicine.
* The source for gathering the accept date/time may vary from site to site see [[#Possible documentation locations]]


*Shirley, I filled this out for you.--[[User:LKolesar|LKolesar]] 12:49, 2016 April 26 (CDT)
*This field is part of the [[2016 Time and Place changes]].
**Hi guys.  thanks everyone.  I have re-cobbled the answers, as I have gotten clarification about where this patient came and went from at VIC.  N2 urology (surgical service) not from S2.  S2 is used a overflow for medicine (code purple) when medicine is over census.--[[User:TOstryzniuk|Trish Ostryzniuk]] 15:01, 2016 April 26 (CDT)
**For '''medicine''' this concept is ''related'' to [[admit date and time]] (when pt is from ER). It does not simply replace the field, so this value still needs to be entered for patients not from ER. Resp. field L_Log.R_AdmDate and L_Log.R_AdmTime
 
**For '''critical care''' this concept is related to [[Service Sending to ICU]]. (There is no comparable field in ICU for this in the old system).
B.Question: How do I know the Accept DtTm when a pt is transferred from VICU to Vic ward. No notes stating when ward medicine has accepted patient just a VICU note stating when pt is transfer ready in ICU.  What do you use ?  Do you want us to use the transfer ready time( written by VICU doctors that the patient is ready to go to a medicine ward ) or do you use the same date and time as the Arrive DtTm ( the actual time the pt comes physically to the ward.) Looking forward to the staff meeting to clarify the dispo fields  Shirley  Please let me know about this. [[Shirley Kiesman]]
}}
date/time
* When a pt goes from ICU to a medicine ward, just make the accept time the same as the arrival time because the medicine doctors do not start looking after the patient until the patient arrives on the ward, even if they have agreed to accept them earlier.  In ER, when they accept, then they start looking after the patient at that time, so that is why the accept time is important for medicine in order to determine the amount of time spent in ER before actual arrival. --[[User:LKolesar|LKolesar]] 06:33, 2016 April 27 (CDT)
 
== Feedback about date/time fields ==
Anything else? Ttenbergen 17:32, 2016 April 18 (CDT)
 
== Data Use ==
Many things, need to pull them together Ttenbergen 12:59, 2016 March 21 (CDT)
 
== {{CCMDB Data Integrity Checks}} ==
* Function ''ADT_Chronological()''
 
== Legacy ==
This field is part of the [[2016 Time and Place changes]].


For '''medicine''' this concept is ''related'' to admit date and time (when pt is from ER). It does not simply replace the field, so this value still needs to be entered for patients not from ER.
== Related articles ==
{{Related Articles}}


For '''critical care''' this concept is related to [[Service Sending to ICU]]. (There is no comparable field in ICU for this in the old system).


[[Category: 2016 Time and Place changes]]
[[Category:2016 Time and Place changes]]
[[Category: Admit/Discharge]]
[[Category:Admit/Discharge]]
[[Category:Data Collection Guide]]

Latest revision as of 17:16, 2023 May 4

_ccmdb_dev

  • Field is legacy; once no longer used, remove it from sending and then from ccmdb_data. Query to check:
SELECT L_Log.D_ID, L_Log.RecordStatus, L_Log.Accept_DtTm, L_Log.Arrive_DtTm
FROM L_Log
WHERE (((L_Log.RecordStatus)="incomplete") AND ((L_Log.Accept_DtTm) Is Not Null) AND ((L_Log.Arrive_DtTm) Is Not Null));
  • 98 left as of 2022-08-04
  • None left as of 2023-05-04, field can be removed...
    • remove from sending
    • remove from CCMDB_data
  • added: 2022-06-30
  • action: 2023-05-04
  • Cargo


  • Categories


 
 
 
 

Legacy Content

This page contains Legacy Content.
  • Explanation: This is a legacy data field, its DataElementEndDate is in the past.
  • Successor: No successor was entered

Click Expand to show legacy content.

Data Element (edit)
Field Name: Accept DtTm
CCMDB Label: Accept DtTm
CCMDB tab: not stated
Table: L_Log table
Data type: date
Length: not stated
Program: Med and CC
Created/Raw: Raw
Start Date: 2016-07-01
End Date: 2022-04-22
Sort Index: 43

First Service tmp entry DtTm for pts who came from the ER department only

  • SMW

Legacy implementation right in the table

  • Cargo


  • Categories
  • Forms


Collection Instruction

For each patient, enter First Service tmp entry DtTm for pts who came from the same hospital's the ER department only (i.e. who had an initial Boarding Loc of ER). Follow the instructions at Service tmp entry.

This means the Accept DtTm field should be equal to the first Service tmp entry DtTm if it is entered at all.

Planned elimination of this field

see Change to replace Accept DtTm with first Service tmp entry, and Arrive DtTm with first Boarding Loc

Data Use

Patient flow

  • medicine program: to monitor delays to move patient from ER to Med ward bed
  • as of July 2016 onward - ICU same purpose

Accept DtTm is used as part of the formula to calculate delay in the transfer of patient from ER bed to Med ward or ICU bed - see ER Delay. This measures the amount of time for the patient already accepted in Medicine or Critical Care service but still using the ER bed and resources.

Data Integrity Checks (automatic list)

none found

Legacy

Click to see legacy info   
  • This field is part of the 2016 Time and Place changes.
    • For medicine this concept is related to admit date and time (when pt is from ER). It does not simply replace the field, so this value still needs to be entered for patients not from ER. Resp. field L_Log.R_AdmDate and L_Log.R_AdmTime
    • For critical care this concept is related to Service Sending to ICU. (There is no comparable field in ICU for this in the old system).

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Accept_DtTm_field&oldid=159262"