Arrive DtTm field: Difference between revisions

(63 intermediate revisions by 10 users not shown)

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

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

| 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,~~

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

* 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.~~

== Planned elimination of this field ==

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

== Data ~~Use ==~~

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

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

== Legacy ==

~~Implemented:~~

{{Collapsable

* function ''[[Dispo Chronological]]''

| always=Click to see legacy info

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

| full=

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

*For Medicine this concept is related to old [[ER Wait]] date an time.

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

* [[~~Minimal Data Set~~]] ~~- or at least~~ the ~~date part is, will need instructions for that. {{discussion}} how shall we handle this? Ttenbergen 11:30, 2016 June 27 (CDT)~~

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

* Discussed with Trish, we'll allow 00:00 for minimal data set but time has to be not 00:00 to finalize. ~~Ttenbergen 12:36, 2016 June 27 (CDT)~~

~~== Legacy ==~~

* For ICU this concept is related to the old [[Admit date and time]]. Resp L_Log.R_AdmDate and L_Log.R_AdmTime.

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]].~~

== Related Articles ==

[[Category: 2016 Time and Place changes]]

[[Category:2016 Time and Place changes]]

[[Category: Admit/Discharge]]

[[Category:Admit/Discharge]]

[[Category:Data Collection Guide]]

@@ 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
-The [[Arrive DtTm field]] contains the date and time that a patient '''physically arrived''' on unit ([[Service/Location field]]).
+ | 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,
+This means the {{PAGENAME}} should be equal to the first [[Boarding Loc]] DtTm.
-* 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.
+== Planned elimination of this field ==
+see [[Change to replace Accept DtTm with first Service tmp entry, and Arrive DtTm with first Boarding Loc]]
-== Data Use ==
+{{Data Integrity Check List}}
-Many things, need to pull them together Ttenbergen 12:59, 2016 March 21 (CDT)
-== {{CCMDB Data Integrity Checks}} ==
+== Legacy ==
-Implemented:
+{{Collapsable
-* function ''[[Dispo Chronological]]''
+| always=Click to see legacy info
-* function ''Panelling_admit_transfer_same(Pat_ID)'': a record is an error if both
+| full=
-** [[Primary Admit Diagnosis]] = [[Panelling or Discharge Planning]] (90601 or 90602)
+*For Medicine this concept is related to old [[ER Wait]] date an time.
-** ([[Transfer Ready DtTm]]) <> ([[Arrive DtTm]])
-* [[Minimal Data Set]] - or at least the date part is, will need instructions for that. {{discussion}} how shall we handle this? Ttenbergen 11:30, 2016 June 27 (CDT)
+*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.
-* Discussed with Trish, we'll allow 00:00 for minimal data set but time has to be not 00:00 to finalize. Ttenbergen 12:36, 2016 June 27 (CDT)
-== Legacy ==
+* For ICU this concept is related to the old [[Admit date and time]]. Resp L_Log.R_AdmDate and L_Log.R_AdmTime.
-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]].
+== Related Articles ==
+{{Related Articles}}
-[[Category: 2016 Time and Place changes]]
+[[Category:2016 Time and Place changes]]
-[[Category: Admit/Discharge]]
+[[Category:Admit/Discharge]]
+[[Category:Data Collection Guide]]