Arrive DtTm field: Difference between revisions

(57 intermediate revisions by 9 users not shown)

Line 1:

~~<onlyinclude>The [[Arrive DtTm field]] contains the date~~ and ~~time that a patient '''physically arrived''' on unit~~ (~~[[Service/Location~~ field~~]])~~.~~</onlyinclude>~~

{{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

|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 ~~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 never does arrive on your unit, then the [[Arrive DtTm]] will be the same time as the [[~~Accept DtTm~~]]

* 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

If the [[~~Accept DtTm~~]] ~~> [[Arrive~~ DtTm~~]], make accept = arrive~~.

This means the {{PAGENAME}} should be equal to the first [[Boarding Loc]] DtTm.

== ~~Data Use~~ ==

== Planned elimination of this field ==

~~Many things, need~~ to ~~pull them together Ttenbergen 12:59~~, ~~2016 March 21 (CDT)~~

see [[Change to replace Accept DtTm with first Service tmp entry, and Arrive DtTm with first Boarding Loc]]

== {{~~CCMDB~~ Data Integrity ~~Checks~~}} ==

~~Implemented:~~

* [[Function Dispo Chronological()]]

* [[Function long LOS()]]

* function ''Panelling_admit_transfer_same(Pat_ID)'': a record is an error if both

** [[Primary Admit Diagnosis]] = [[Panelling or Discharge Planning]] (90601 or 90602)

** ([[Transfer Ready DtTm]]) <> ([[Arrive DtTm]])

* [[Minimal Data Set]]

== 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.

~~For ICU this concept is related~~ to the ~~old~~ [[~~Admit date and 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.

}}

[[Category: 2016 Time and Place changes]]

== Related Articles ==

[[Category: Admit/Discharge]]

[[Category: ~~OverstayProject]]~~

~~[[Category: L_Log table~~]]

[[Category:2016 Time and Place changes]]

[[Category:Admit/Discharge]]

[[Category:Data Collection Guide]]

@@ Line 1: / Line 1: @@
-<onlyinclude>The [[Arrive DtTm field]] contains the date and time that a patient '''physically arrived''' on unit ([[Service/Location field]]).</onlyinclude>
+{{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
+|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 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 never does arrive on your unit, then the [[Arrive DtTm]] will be the same time as the [[Accept DtTm]]
-* 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
-If the [[Accept DtTm]] > [[Arrive DtTm]], make accept = arrive.
+This means the {{PAGENAME}} should be equal to the first [[Boarding Loc]] DtTm.
-== Data Use ==
+== Planned elimination of this field ==
-Many things, need to pull them together Ttenbergen 12:59, 2016 March 21 (CDT)
+see [[Change to replace Accept DtTm with first Service tmp entry, and Arrive DtTm with first Boarding Loc]]
-== {{CCMDB Data Integrity Checks}} ==
+{{Data Integrity Check List}}
-Implemented:
-* [[Function Dispo Chronological()]]
-* [[Function long LOS()]]
-* function ''Panelling_admit_transfer_same(Pat_ID)'': a record is an error if both
-** [[Primary Admit Diagnosis]] = [[Panelling or Discharge Planning]] (90601 or 90602)
-** ([[Transfer Ready DtTm]]) <> ([[Arrive DtTm]])
-* [[Minimal Data Set]]
 == 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.
-For ICU this concept is related to the old [[Admit date and 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.
+}}
-[[Category: 2016 Time and Place changes]]
+== Related Articles ==
-[[Category: Admit/Discharge]]
+{{Related Articles}}
-[[Category: OverstayProject]]
-[[Category: L_Log table]]
+[[Category:2016 Time and Place changes]]
+[[Category:Admit/Discharge]]
+[[Category:Data Collection Guide]]