Accept DtTm field: Difference between revisions

(11 intermediate revisions by 2 users not shown)

Line 1:

{{~~Data_element~~

{{Todo

| field_name = Accept DtTm

| who = Tina

| CCMDB_label = Accept DtTm

| todo_added = 2022-06-30

~~| element_description = First [[Service tmp entry]] DtTm for pts from the '''ER department''' only~~

| todo_action = 2023-05-04

| in_table = L_Log table

| question = _ccmdb_dev

| data_type = date

* Field is legacy; once no longer used, remove it from sending and then from ccmdb_data.

| program_collecting = Med and CC

** remove from sending

| created_raw = Raw

** remove from CCMDB_data

| data_element_start_date = 2016-07-01

}}

| data_element_sort_index = 43

{{Data element

|field_name=Accept DtTm

|CCMDB_label=Accept DtTm

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

|element_description=First [[Service tmp entry]] DtTm for pts who came from the '''ER department''' only

}}

== Collection Instruction ==

~~Use the instructions~~ for the ~~time in~~ the '''~~first~~ [[Service tmp entry]]~~''' profile, but {{PAGENAME}} is entered only for profiles originating in the ER~~.

For each patient, enter First [[Service tmp entry]] DtTm for pts who came from the same hospital's the '''ER department''' only (i.e. who had an initial [[Boarding Loc]] of ER). Follow the instructions at [[Service tmp entry]].

This means the {{PAGENAME}} should be equal to [[Service tmp entry]] if it is entered at all.

This means the {{PAGENAME}} should be equal to the first [[Service tmp entry]] DtTm if it is entered at all.

== ~~Elimination~~ of this field ==

== Planned elimination of this field ==

~~The data in this field is now a duplication of the data in~~ [[Service tmp entry~~]]. We plan to retire this field eventually, but it is relevant to many things so we need to be deliberate about it.~~

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

~~{{Discuss | who = Julie |~~

~~Is there a target date for eliminating this field? [[User:Ttenbergen|Ttenbergen]] 15:10, 2021 April 15 (CDT)~~

}}

~~{{Todo | who = Tina |~~

* work through [[#Data Integrity Checks SMW)]], update documentation in process

* remove ADT2 button that automatically populates this

* confirm no more actionable links to this

* hide field in [[CCMDB.accdb]] when all done

* [[Created Variables]]

~~| todo_added = 2021-04-15~~

~~| todo_action =~~

}}

~~{{Todo | who = Julie |~~

* change the source of her "admit dttm" that she generates via program

* work through any reports that currently use this concept, ~~update documentation in process~~

** [[#Related articles]] ~~provides a good starting list of related concepts~~

~~| todo_added = 2021-04-15~~

~~| todo_action =~~

}}

== Data Use ==

Line 47:

Line 35:

Accept DtTm is used as part of the formula to calculate delay in the transfer of patient from ER bed to Med ward or ICU bed - see [[ER Delay]]. This measures the amount of time for the patient already accepted in Medicine or Critical Care service but still using the ER bed and resources.

~~== Data Integrity Checks ==~~

== Legacy ==

{{Collapsable

| always=Click to see legacy info

| full=

* related info: [[Change to start collection at accept rather than arrive time]]

* 2017_January: also enter lines in TMP for all [[AcceptDateSource]]s.

Line 59:

Line 49:

**For '''medicine''' this concept is ''related'' to [[admit date and time]] (when pt is from ER). It does not simply replace the field, so this value still needs to be entered for patients not from ER. Resp. field L_Log.R_AdmDate and L_Log.R_AdmTime

**For '''critical care''' this concept is related to [[Service Sending to ICU]]. (There is no comparable field in ICU for this in the old system).

}}

== Related articles ==

@@ Line 1: / Line 1: @@
-{{Data_element
+{{Todo
-| field_name = Accept DtTm
+ | who = Tina
-| CCMDB_label = Accept DtTm
+ | todo_added = 2022-06-30
-| element_description = First [[Service tmp entry]] DtTm  for pts from the '''ER department''' only
+ | todo_action = 2023-05-04
-| in_table = L_Log table
+ | question =  _ccmdb_dev
-| data_type = date
+* Field is legacy; once no longer used, remove it from sending and then from ccmdb_data.
-| program_collecting = Med and CC
+** remove from sending
-| created_raw = Raw
+** remove from CCMDB_data
-| data_element_start_date = 2016-07-01
+ }}
-| data_element_sort_index = 43
+{{Data element
+|field_name=Accept DtTm
+|CCMDB_label=Accept DtTm
+|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=43
+|element_description=First [[Service tmp entry]] DtTm for pts who came from the '''ER department''' only
 }}
 == Collection Instruction ==
-Use the instructions for the time in the '''first [[Service tmp entry]]''' profile, but {{PAGENAME}} is entered only for profiles originating in the ER.
+For each patient, enter First [[Service tmp entry]] DtTm for pts who came from the same hospital's the '''ER department''' only (i.e. who had an initial [[Boarding Loc]] of ER). Follow the instructions at [[Service tmp entry]].
-This means the {{PAGENAME}} should be equal to [[Service tmp entry]] if it is entered at all.
+This means the {{PAGENAME}} should be equal to the first [[Service tmp entry]] DtTm if it is entered at all.
-== Elimination of this field ==
+== Planned elimination of this field ==
-The data in this field is now a duplication of the data in [[Service tmp entry]]. We plan to retire this field eventually, but it is relevant to many things so we need to be deliberate about it.
+see [[Change to replace Accept DtTm with first Service tmp entry, and Arrive DtTm with first Boarding Loc]]
-{{Discuss | who = Julie |
-Is there a target date for eliminating this field? [[User:Ttenbergen|Ttenbergen]] 15:10, 2021 April 15 (CDT)
-}}
-{{Todo | who = Tina |
-* work through [[#Data Integrity Checks SMW)]], update documentation in process
-* remove ADT2 button that automatically populates this
-* confirm no more actionable links to this
-* hide field in [[CCMDB.accdb]] when all done
-* [[Created Variables]]
-| todo_added = 2021-04-15
-| todo_action =
-}}
-{{Todo | who = Julie |
-* change the source of her "admit dttm" that she generates via program
-* work through any reports that currently use this concept, update documentation in process
-** [[#Related articles]] provides a good starting list of related concepts
-| todo_added = 2021-04-15
-| todo_action =
-}}
 == Data Use ==
@@ Line 47: / Line 35: @@
 Accept DtTm is used as part of the formula to calculate delay in the transfer of patient from ER bed to Med ward or ICU bed - see [[ER Delay]]. This measures the amount of time for the patient already accepted in Medicine or Critical Care service but still using the ER bed and resources.
-== Data Integrity Checks ==
 {{Data Integrity Check List}}
 == Legacy ==
+{{Collapsable
+| always=Click to see legacy info
+| full=
 * related info: [[Change to start collection at accept rather than arrive time]]
 * 2017_January:  also enter lines in TMP for all [[AcceptDateSource]]s.
@@ Line 59: / Line 49: @@
 **For '''medicine''' this concept is ''related'' to [[admit date and time]] (when pt is from ER). It does not simply replace the field, so this value still needs to be entered for patients not from ER. Resp. field L_Log.R_AdmDate and L_Log.R_AdmTime
 **For '''critical care''' this concept is related to [[Service Sending to ICU]]. (There is no comparable field in ICU for this in the old system).
+}}
 == Related articles ==