Arrive DtTm field: Difference between revisions

Latest revision as of 16: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

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.

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

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.

none found

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.

@@ Line 2: / Line 2: @@
   | who = Tina
   | todo_added = 2022-06-30
-  | todo_action = 2022-10-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:
@@ Line 9: / Line 9: @@
 ::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