Arrive DtTm field: Difference between revisions

(23 intermediate revisions by 4 users not shown)

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=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~~ ([[Service/Location field | Service Location]]) ~~'''OR ''' in a '''[[Boarding Loc|Boarding location]]'''~~.

|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 ~~date and time when the patient '''physically arrived''' on the unit ([[Service/Location field | Service Location]]) '''or''' in a~~ [[Boarding Loc~~|Boarding location~~]].

For each patient enter the First non-ER [[Boarding Loc]] date and time as {{PAGENAME}}. Follow the instructions at [[Boarding Loc]].

~~Consider the [[Boarding Loc]] instructions when you enter decide what this field needs to be.~~

~~=== sources for Arrive DtTm ===~~

~~==== EPR Reports ====~~

~~To find the arrive~~ date & time ~~when using EPR Reports:~~

* Go to "transfer Register" and enter all criteria ie. facility site, date parameters, unit/ward parameters, to or from location, filter for between unit transfers only, sort as ~~desired, generate a report, the [[Arrive DtTm]] will be in the Transfer/Date/Time column~~

~~==== First set of vital signs ====~~

The first set of vital signs is used as ArriveDtTm in ICU collection, if it is different from the EPR Admit DtTm. The ADT Unit arrive DtTm will still show up in [[EPR Admit DtTm field]] if the patient was entered using one of the integrators.

{{~~Discuss |~~

* This may still be inconsistent with the ~~dt and tm in~~ [[Boarding Loc]]~~, need to make sure we all use the same instructions. }}~~

~~=== [[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 ==~~

@@ 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=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 ([[Service/Location field | Service Location]]) '''OR ''' in a '''[[Boarding Loc|Boarding location]]'''.
+|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 date and time when the patient '''physically arrived''' on the unit ([[Service/Location field | Service Location]]) '''or''' in a [[Boarding Loc|Boarding location]].
+For each patient enter the First non-ER [[Boarding Loc]] date and time as {{PAGENAME}}. Follow the instructions at [[Boarding Loc]].
-Consider the [[Boarding Loc]] instructions when you enter decide what this field needs to be.
-=== sources for Arrive DtTm ===
-==== EPR Reports ====
-To find the arrive date & time when using EPR Reports:
-* Go to "transfer Register" and enter all criteria ie. facility site, date parameters, unit/ward parameters, to or from location, filter for between unit transfers only, sort as desired, generate a report, the [[Arrive DtTm]] will be in the Transfer/Date/Time column
-==== First set of vital signs ====
-The first set of vital signs is used as ArriveDtTm in ICU collection, if it is different from the EPR Admit DtTm. The ADT Unit arrive DtTm will still show up in [[EPR Admit DtTm field]] if the patient was entered using one of the integrators.
-{{Discuss |
-* This may still be inconsistent with the dt and tm in [[Boarding Loc]], need to make sure we all use the same instructions. }}
-=== [[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}}