Arrive DtTm field: Difference between revisions

← Older edit

@@ Line 1: / Line 1: @@
+{{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
+ }}
 {{Data element
 |field_name=Arrive_DtTm
 |CCMDB_label=Arrive DtTm
-|CCMDB_tab=Top Row
+|CCMDB_tab=Dispo
-|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=45
-|element_description=Date and time when the patient '''physically arrived''' on unit.
+|element_description=First non-ER [[Boarding Loc|Boarding location]] date and time, or start of ([[Service/Location field | Service Location]]) for legacy records.
 }}
-As in, arrived at ([[Service/Location field]]).
 == 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]].
-For [[off ward field|off ward]] patients,
-* if the patient does arrive on your unit, then the [[Arrive DtTm]] will be the physical arrival on the unit, while the [[Accept DtTm]] will be when the service accepted care of the patient
-=== sources for Arrive DtTm ===
-==== EPR ====
-To find the arrive date & time when using electronic patient record (epr):
-* clicking on Registration (on top left bar)
-* then Visit Location, then Location History
-* A new Location History window will pop up that will tell you the date & time that the patient arrived at a particular location.
-==== First set of vital signs ====
-The first set of vital signs can be used as ArriveDtTm if data in EPR is not good.
-=== [[Accept DtTm]] > [[Arrive DtTm]] ===
-If the [[Accept DtTm]] > [[Arrive DtTm]], make accept = arrive.
-=== pt never arrives on your unit ===
-* if the patient never does arrive on your unit, then the [[Arrive DtTm]] will be the same time as the [[Accept DtTm]]
-== Data Use ==
+This means the {{PAGENAME}} should be equal to the first [[Boarding Loc]] DtTm.
-Many things, need to pull them together Ttenbergen 12:59, 2016 March 21 (CDT)
-{{Guideline Minimal Data Set}}
+== 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 ==
 {{Data Integrity Check List}}
 == Legacy ==
-For Medicine this concept is related to old [[ER Wait]] date an time.
+{{Collapsable
+| always=Click to see legacy info
+| full=
+*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.
+* 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 ==
@@ Line 53: / Line 53: @@
 [[Category:2016 Time and Place changes]]
 [[Category:Admit/Discharge]]
-[[Category:OverstayProject]]
+[[Category:Data Collection Guide]]