Arrive DtTm field: Difference between revisions

← Older edit

@@ 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
+ | 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
+ }}
-The [[Arrive DtTm field]] contains the time a patient changed status from what is documented in [[Previous Service field]] to [[Service/Location field]].
+{{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 ==
+For each patient enter the First non-ER [[Boarding Loc]] date and time as {{PAGENAME}}. Follow the instructions at [[Boarding Loc]].
-== Collection Instruction ==
+This means the {{PAGENAME}} should be equal to the first [[Boarding Loc]] DtTm.
-For each patient enter the date and time the patient physically arrived on the ward.
+== Planned elimination of this field ==
+see [[Change to replace Accept DtTm with first Service tmp entry, and Arrive DtTm with first Boarding Loc]]
-== Feedback about date/time fields ==
+{{Data Integrity Check List}}
-Let's discuss items common to the 4 time fields at [[Accept_DtTm_field#Feedback_about_date.2Ftime_fields]].
-== Data Use ==
+== Legacy ==
- {{discussion}} Many things, need to pull them together Ttenbergen 12:59, 2016 March 21 (CDT)
+{{Collapsable
+| always=Click to see legacy info
+| full=
+*For Medicine this concept is related to old [[ER Wait]] date an time.
-== {{CCMDB Data Integrity Checks}} ==
+*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.
-* 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.
- {{discussion}} Need to pull together existing and implement for new situation
-== Implementation ==
+* For ICU this concept is related to the old [[Admit date and time]]. Resp L_Log.R_AdmDate and L_Log.R_AdmTime.
-no comments
+}}
-== Legacy ==
+== Related Articles ==
-This field is part of the [[2016 Time and Place changes]].
+{{Related Articles}}
-== Legacy ==
-Similar to the old [[Admit date and time]].
-[[Category: 2016 Time and Place changes]]
+[[Category:2016 Time and Place changes]]
-[[Category: Admit/Discharge]]
+[[Category:Admit/Discharge]]
+[[Category:Data Collection Guide]]