Arrive DtTm field: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
(→‎Collection Instruction: moved discussion from Admit date and time (instructions for old field) since these are really for the new field.)
mNo edit summary
 
(71 intermediate revisions by 10 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 [[Arrive DtTm field]] contains the date and time that a patient '''physically arrived''' on unit ([[Service/Location field]]).  
| todo_added = 2022-06-30
| todo_action = 2023-05-04
  | question = _after
* 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=Arrive_DtTm
|CCMDB_label=Arrive DtTm
|CCMDB_tab=Dispo
|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=45
|element_description=First non-ER [[Boarding Loc|Boarding location]] date and time, or start of ([[Service/Location field | Service Location]]) for legacy records.
}}
== Collection Instruction ==
== Collection Instruction ==
For each patient enter the date and time when the patient '''physically arrived''' on the ward.
For each patient enter the First non-ER [[Boarding Loc]] date and time as {{PAGENAME}}. Follow the instructions at [[Boarding Loc]].


If the [[Accept DtTm field|Accept DtTm]] > [[Arrive DtTm field|Arrive DtTm]], make accept = arrive.
This means the {{PAGENAME}} should be equal to the first [[Boarding Loc]] DtTm.


=== patient who stays off unit for entire stay ===
== Planned elimination of this field ==
{{discussion}}
see [[Change to replace Accept DtTm with first Service tmp entry, and Arrive DtTm with first Boarding Loc]]
* Has there been a decision about the arrive date/time for ICU patients who overflow outside their units?--[[User:Jpeterson|Jpeterson]] 10:20, 2016 June 13 (CDT)
**This is my understanding: If the patient never does arrive on your unit, then the arrive date and time will be the same time as the accept date and time. If the patient does arrive on your unit, then the arrive time will be the physical arrival on the unit, while the accept time will be when the service accepted care of the patient.-[[User:Mlagadi|Mlagadi]] 15:18, 2016 June 14 (CDT)


ICU
{{Data Integrity Check List}}
*I often have patients who are in PACU when accepted by SICU but have to stay in PACU as overflow.  I had been told when oriented to consider the time accepted by SICU as the admit time & [[Arrive DtTm field]] in these cases.  Should I be changing my practice to the time the patient actually comes to SICU, this sometimes never occurs as the bed space may never be found before the patient is discharged to the ward.--[[User:Jpeterson|Jpeterson]] 11:19, 2012 December 10 (EST)
**There apparently is a discrepancy between some of the data collectors for the discharge/admit time of a patient who has a code on the ward and then admitted to the ICU. After a discussion with Trish, the time of admission to the ICU should be when the patient arrives in the ICU after the code.--[[User:Jpeterson|Jpeterson]] 13:03, 2016 May 13 (CDT)
***That is the way I have always done it, usually first vital signs unless clear charting otherwise.[[User:GHall|GHall]] 13:44, 2016 May 13 (CDT)
****now that we have an [[Accept DtTm field]], in the EPR, if you are able to find documentation when an ICU service accepted the patient prior to arrival to your unit, then you can fill in this field.  If there is no clear ICU acceptance date/time ''OR'' the patient stayed for example: in the PACU under ICU physican's care, but never moved into the ICU, then the '''Admit Data and time field''' + ([[Accept DtTm field]] + [[Arrive DtTm field]] will all be the SAME.--[[User:TOstryzniuk|Trish Ostryzniuk]] 14:57, 2016 May 13 (CDT)
*****great input everyone![[User:TOstryzniuk|Trish Ostryzniuk]] 14:57, 2016 May 13 (CDT)


== Data Use ==
== Legacy ==
Many things, need to pull them together Ttenbergen 12:59, 2016 March 21 (CDT)
{{Collapsable
 
| always=Click to see legacy info
== {{CCMDB Data Integrity Checks}} ==
| full=
* Function ''[[Dispo Chronological]]''
*For Medicine this concept is related to old [[ER Wait]] date an time.
* paneling; which of these actually runs?
** query ''check_panelled_primary_but_adm_NE_tr'' admit and transfer ready dttm must be same
** function Panelling_admit_transfer_same(Pat_ID)
* [[Minimal Data Set]] - or at least the date part is, will need instructions for that.
* [[Dispo Chronological]]


== Implementation ==
*From '''June 1, 2011 to June 30, 2016''', the Arrive_DtTm in Medicine was in the Tmp project [[ER Wait]] and was migrated into the  Arrive_DtTm field.
no comments


== Legacy ==
* For ICU this concept is related to the old [[Admit date and time]]. Resp L_Log.R_AdmDate and L_Log.R_AdmTime.
For Medicine this concept is related to old [[ER Wait]] date an time.
}}


For ICU this concept is related to the old [[Admit date and time]].
== Related Articles ==
{{Related Articles}}




[[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:18, 2023 May 4

_after

  • 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: Arrive_DtTm
CCMDB Label: Arrive DtTm
CCMDB tab: Dispo
Table: N/A
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: 45

First non-ER Boarding location date and time, or start of ( Service Location) for legacy records.

  • SMW

Legacy implementation right in the table

  • Cargo


  • Categories
  • Forms


Collection Instruction

For each patient enter the First non-ER Boarding Loc date and time as Arrive DtTm field. Follow the instructions at Boarding Loc.

This means the Arrive DtTm field should be equal to the first Boarding Loc DtTm.

Planned elimination of this field

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

Data Integrity Checks (automatic list)

none found

Legacy

Click to see legacy info   
  • For Medicine this concept is related to old ER Wait date an time.
  • From June 1, 2011 to June 30, 2016, the Arrive_DtTm in Medicine was in the Tmp project ER Wait and was migrated into the Arrive_DtTm field.
  • For ICU this concept is related to the old Admit date and time. Resp L_Log.R_AdmDate and L_Log.R_AdmTime.

Related Articles

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