Accept DtTm field: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
No edit summary
mNo edit summary
 
(37 intermediate revisions by 6 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 table
| 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
}}
}}
== 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]].
 
*For admissions '''arriving via the ER''' the '''Accept DtTm''' is found on the '''transfer register report'''.
*If the pt is previous location [[EMIP]], Julie still wants the accept dttm for these patients.  --[[User:LKolesar|LKolesar]] 12:35, 2017 May 31 (CDT)
 
*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 > [[Arrive DtTm field|Arrive DtTm]], make accept = arrive
 
{{Discuss|Cognos is populating accept time for all patients, so this instruction will have to be updated once everything is finalized. --[[User:Jvelasco|Jvelasco]] 13:55, 2020 July 7 (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 visit ID date and time for the {{PAGENAME}} as it is clearly marked in the EPR.


===Source (everyone to use SAME source) ===
This means the {{PAGENAME}} should be equal to the first [[Service tmp entry]] DtTm if it is entered at all.
* If from ER use the [[EPR Reports]] - [[Transfer Register]]  


*(STB to no longer get this info from Orders ).--[[User:TOstryzniuk|Trish Ostryzniuk]] 16:36, 2020 May 14 (CDT)
== Planned elimination of this field ==
 
see [[Change to replace Accept DtTm with first Service tmp entry, and Arrive DtTm with first Boarding Loc]]
=== 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.


== Is there a reason NOT to just enter these from Cognos for all? ==
{{DiscussTask |
* The [[Cognos Admitter]] will populate this field automatically with the service accept dtm. Deciding when ''not'' to add the time is actually a bit of a curve ball. Is there any reason to not just let it populate this field for all? Ttenbergen 15:10, 2020 June 3 (CDT)
**what is Cognos definition of Accept DtTm - is it the time of physical transition of service  or verbal agreement only from the sending service to the receiving service?  if the latter, it has an effect on occupancy.  you can still automatically populate it but when using it, I will be selective. --[[User:JMojica|JMojica]] 15:43, 2020 June 3 (CDT)
*** I am not sure what you mean here - transition of service isn't really a physical thing, and it would be whenever someone enters it into the record (since the computer would not record when something verbal happened). If you will be selective about it we should put under [[#Data Use]] below what that means. I will put this on the list for the next task meeting to hash out details now that it seems like this is a likely change to make. Ttenbergen 08:53, 2020 June 4 (CDT)
**** by selective, I mean case to case where the patient is coming from.  if the patient is direct admit from other sites to this site, the physical arrival is the logical date-time to use as Service Accept_Dttm.  if patient moves from one service to another service within the same site, the service accept dtm is appropriate.  }}
== Data Use==
== Data Integrity Checks ==
{{Data Integrity Check List}}
{{Data Integrity Check List}}


== Legacy ==
== Legacy ==
{{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.
* 2017_January:  also enter lines in TMP for all [[AcceptDateSource]]s.


Line 62: Line 54:
**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 '''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 '''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 ==  
Line 69: Line 62:
[[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"