Accept DtTm field: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
 
(69 intermediate revisions by 12 users not shown)
Line 1: Line 1:
{{Data_element
{{Todo
| field_name = Accept DtTm
| who = Tina
| CCMDB_label = Accept DtTm
| todo_added = 2022-06-30
| element_description = The date and time when the patient is accepted from the '''ER department ONLY'''.
| todo_action = 2023-05-04
| in_table = L_Log
| question =  _ccmdb_dev
| data_type = date
* Field is legacy; once no longer used, remove it from sending and then from ccmdb_data. Query to check:
| program_collecting = Med and CC
::SELECT L_Log.D_ID, L_Log.RecordStatus, L_Log.Accept_DtTm, L_Log.Arrive_DtTm
| created_raw = Raw
::FROM L_Log
| data_element_start_date = 2016-07-01
::WHERE (((L_Log.RecordStatus)="incomplete") AND ((L_Log.Accept_DtTm) Is Not Null) AND ((L_Log.Arrive_DtTm) Is Not Null));
| data_element_sort_index = 43
* 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
}}
}}
2017 Jan: also see: [[AcceptDateSource]]
== Collection Instruction ==
== Collection Instruction ==
'''Only for patients admitted from your own ER department ''' enter the date/time that the service physician accepted the patient, leave blank for all others.
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 there is '''no clear record''' of the accept date/time, leave the [[Accept_DtTm field]] blank and '''check''' [[Accept DtTm missing field]] check box.
*If there is an accept date but '''no time''' documented,  entered the Accept Date, and enter the time as: '''00:00'''
*If the [[Accept DtTm field|Accept DtTm]] > [[Arrive DtTm field|Arrive DtTm]], make accept = arrive
* 2017_January:  also enter lines in TMP for all [[AcceptDateSource]]s.
* The source for gathering the accept date/time may vary from site to site see [[#Possible documentation locations]]


{{Discussion}}
This means the {{PAGENAME}} should be equal to the first [[Service tmp entry]] DtTm if it is entered at all.
*The ICU standing orders at the Concordia are always written after the patient arrives.If I use those orders as the accept DtTm because no other time prior to this exists, then the accept would=arrive?[[User:GHall|GHall]] 08:00, 2016 October 31 (CDT)
** Is there a different source you could use that would give better information? See [[#Possible documentation locations]] for ideas and update there if necessary. Ttenbergen 10:37, 2016 October 31 (CDT)
*I would use a different [[[AcceptDateSource]] like prior orders,consult sheet, progress note documentation except it rarely exists at the concordia[[User:GHall|GHall]] 10:55, 2016 October 31 (CDT)
*Do you want us to use the time on the inpatient demographic sheet for the accept date and time even if this doesn't specify an ICU admission? ie presumed accept time?
** Because we are only collecting this for patients admitted from your own ER department, the inpatient demographic sheet admit time should always reflect the current admission to either medicine or ICU. [[User:Lkaita|Lisa Kaita]] 10:45, 2017 May 4 (CDT)
***Gail has pointed out that at her site, where we do not collect medicine, a patient could be initially accepted under medicine in the ER and then deteriorate and are then accepted and transferred to the ICU.  The previous location would indicate ER (at sites where medicine is collected this would indicate EMIP) , the previous service would be medicine,  would Gail still enter an accept time? or is this an exception to the rule since they were accepted under another service first while in ER?  Patients could also potentially be accepted by other services in the ER, eg. surgery, and then switch to medicine or ICU, so is an accept time required for these patients? [[User:Lkaita|Lisa Kaita]] 10:43, 2017 May 9 (CDT)
**** the rule will still holds for any patient who spent time in ER whether under ER service or other services prior to acceptance to Medicine or Critical Care service. --[[User:JMojica|JMojica]] 11:37, 2017 May 10 (CDT)
*****so just to be clear, if a patient in ER admitted under medicine, deteriorates and then goes to ICU, previous location =EMIP, previous service =medicine and we should enter an accept time for the ICU admission?  [[User:Lkaita|Lisa Kaita]] 09:54, 2017 May 30 (CDT)
*****If there is a waiting time before arrival to ICU, then enter the Accept DtTm. If there is no waiting time, you may enter Accept time the same as Arrival time.  Note that the waiting time is calculated only if the previous location is your own ER.  For this case, previous location = CON ER, previous service = Medicine and Inpt location = CON EMIP but CON _EMIP is not in our list. So either we add it or simply put CON ER so we don't need to do any changes which may no longer be applicable later with the ongoing changes in the health system. I think the second one (CON ER) is just OK --[[User:JMojica|JMojica]] 11:11, 2017 May 31 (CDT)
=== Direct Admissions/Transfers ===
For patients who have been accepted from another hospital '''but have a wait time in ER''' (who used to be called Direct Admissions/Parked in ER), use the triage date and time for the Accept Date and Time as it is clearly marked on the triage sheet. The Visit Date and Time (found in EPR) may actually be later than the accept date and time, so don't use it as your Accept DtTm.


===Possible documentation locations===
== Planned elimination of this field ==
* admission/separation registers
see [[Change to replace Accept DtTm with first Service tmp entry, and Arrive DtTm with first Boarding Loc]]
* EPR
* use the date and time from the "accepted to service" on the [[EPR]] orders. i.e. in the epr, click on orders, then highlight the order that says "admit to inpatient-medicine-medical service". Right click on that order. Scroll down to view, then across to history, then across to status. Click on status. Use the date and time as listed in the top "new" order. This is the date and time the patient is accepted to medical service.
* Physician Order sheet
* the IPN (integrated progress note) which is a hand written admission note by the nurse. We at HSC in medicine use this.--[[User:CMarks|CMarks]] 08:10, 26 January 2012 (CST)
* consult sheet
*history and physical
 
=== When does collection start? ===
see
* [[Definition of an ICU admission]]
* [[Definition of a Medicine Service admission]]


== Data Use ==
== Data Use ==
Patient flow
[[Patient flow]]
* medicine program: to monitor delays to move patient from ER to Med ward bed
* medicine program: to monitor delays to move patient from ER to Med ward bed
* as of July 2016 onward - ICU same purpose
* 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.
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.


== {{CCMDB Data Integrity Checks}} ==
{{Data Integrity Check List}}
* either [[Accept DtTm field]] must have content or [[Accept DtTm missing field]] must be checked.
* [[Function Dispo Chronological()]]
* [[Function long LOS()]]


== Legacy ==
== Legacy ==
This field is part of the [[2016 Time and Place changes]].
{{Collapsable
| always=Click to see legacy info
| full=
* related info: [[Change to start collection at accept rather than arrive time]]
* 2017_January:  also enter lines in TMP for all [[AcceptDateSource]]s.
 
* The source for gathering the accept date/time may vary from site to site see [[#Possible documentation locations]]
 
*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).
}}


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
== 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: OverstayProject]]
[[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"