CCMDB Wiki

Arrive DtTm field: Difference between revisions

← Older edit
→Collection Instruction: If the Accept DtTm > Arrive DtTm, make accept = arrive.
mNo edit summary
 
(73 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.


== Feedback about date/time fields ==
== Planned elimination of this field ==
Let's discuss items common to the 4 time fields at [[Accept_DtTm_field#Feedback_about_date.2Ftime_fields]].
see [[Change to replace Accept DtTm with first Service tmp entry, and Arrive DtTm with first Boarding Loc]]


== Data Use ==
{{Data Integrity Check List}}
Many things, need to pull them together Ttenbergen 12:59, 2016 March 21 (CDT)


== {{CCMDB Data Integrity Checks}} ==
== Legacy ==
* Function ''[[Dispo Chronological]]''
{{Collapsable
* paneling; which of these actually runs?
| always=Click to see legacy info
** query ''check_panelled_primary_but_adm_NE_tr'' admit and transfer ready dttm must be same
| full=
** function Panelling_admit_transfer_same(Pat_ID)
*For Medicine this concept is related to old [[ER Wait]] date an time.
* [[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]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Arrive_DtTm_field"