ER Delay: Difference between revisions

(10 intermediate revisions by 2 users not shown)

Line 2:

| field_name = ER Delay

| element_description = The ER Delay is the difference between the pre-ER [[Boarding Loc]] and first post-ER [[Boarding Loc]], for patients arriving from the ER.

| in_table = ~~Created_Variables_Common~~ table

| in_table = Created_Variables_Common_2021 table

| data_type = date

| datafield_length = n/a

Line 10:

}}

It's is calculated by [[~~Created_Variables_Common_maker~~ query]] and stored in [[~~Created_Variables_Common~~ table]] in [[CFE]].

It's is calculated by [[Created_Variables_Common_maker_2021 query]] and stored in [[Created_Variables_Common_2021 table]] in [[CFE]]. It is related to one of our [[Indicators]], [[Length_of_Time_for_Transfer_from_ED_to_ICU_within_same_facility]].

~~{{DJ | This~~ is ~~really~~ one of ~~the~~ [[Indicators]], ~~right? If so we should add that template... That would also include which reports use it, and what the n is, etc. [[User:Ttenbergen|Ttenbergen]] 10:27, 2023 February 2 (CST)~~

*we have already [[Length_of_Time_for_Transfer_from_ED_to_ICU_within_same_facility]]

~~--[[User:JMojica|JMojica]] 15:30, 2023 April 19 (CDT)}}~~

== Data use ==

Line 35:

Line 31:

:::: [Arrive_dttm]),Nz([created_FirstNonER_BoardingLoc].[dttm],[Dispo_DtTm])-[created_FirstER_BoardingLoc].[dttm])

== Log ==

=== Outliers ===

{{DT |

==== ED stays in mid-hospitalization ====

* there are occasions where pts go back to the ED while under the care of ICU; we do not include these in ER Delays; discussed at [[JALT_Meeting_-_Rolling_Agenda_and_Minutes_2023#JALT_Meeting_%E2%80%93_October_31,_2024 | JALT 2024-10-31]]...

==== Moves for Medicine ====

{{DJ |

* This data is problematic before 2011-Q2,the only reason there are any is because it derives them for EMIPs. Some data may be available in [[Moves for Medicine]], but that would still leave a gap. [[User:Ttenbergen|Ttenbergen]] 23:09, 2024 November 16 (CST)

** OK, will be working on this getting data from [[Moves for Medicine]] from period Sept 2007 to June 3, 2011. will give to Pagasa for upload to [[Arrive DtTm field]]. I will update the WIKI as soon as done. Conclusion: for Medicine, prior Sept 2007, no ER delay while for Critical Care, no ER Delay prior July 1, 2016 -- these are treated as missing. --[[User:JMojica|JMojica]] 16:35, 2024 December 11 (CST)}}

== Log ==

{{Discuss |

* I have re-updated [[Created_Variables_Common_maker_2021 query]], for some reason the change I had made was not reflected in the master version. Ready to test. [[User:Ttenbergen|Ttenbergen]] 13:25, 2022 June 28 (CDT)

** emailed Tina some inconsistencies found in ER Delays Aug 15,2022. --[[User:JMojica|JMojica]] 13:21, 2022 August 29 (CDT)}}

** emailed Tina some inconsistencies found in ER Delays Aug 15,2022. --[[User:JMojica|JMojica]] 13:21, 2022 August 29 (CDT)

*** are these still an issue? [[User:Ttenbergen|Ttenbergen]] 11:15, 2024 May 1 (CDT)

**** I will re-check again. Can't remember if have been resolved. --[[User:JMojica|JMojica]] 14:40, 2024 October 2 (CDT)}}

* 2022-06-28 - previous change got lost somehow, re-applied it; updated query to use [[query created_PatientFollow]] rather than in-query definition

Line 51:

Line 58:

== Reporting and Analysis ==

The SAS Program to read the data is in X:\Julie\SAS_CFE\CFE_macros\datetimes.sas

The SAS Program to read the data is in {{S:\MED\MED_CCMED}}Julie\SAS_CFE\CFE_macros\datetimes.sas

{{DJ|

* I just had a look at that sas file (they open as text files) to see how you define transfer delay. If that file is still being used we may have a problem, it still defines tdelay different if a pt goes to a higher level of care, goes AMA or dies, and we changed that some time ago. So is this still the reference of how you calculate this? [[User:Ttenbergen|Ttenbergen]] 22:50, 2024 November 16 (CST)

}}

== Legacy ==

@@ Line 2: / Line 2: @@
 | field_name = ER Delay
 | element_description = The ER Delay is the difference between the pre-ER [[Boarding Loc]] and first post-ER [[Boarding Loc]], for patients arriving from the ER.
-| in_table = Created_Variables_Common table
+| in_table = Created_Variables_Common_2021 table
 | data_type = date
 | datafield_length = n/a
@@ Line 10: / Line 10: @@
 }}
-It's is calculated by [[Created_Variables_Common_maker query]] and stored in [[Created_Variables_Common table]] in [[CFE]].
+It's is calculated by [[Created_Variables_Common_maker_2021 query]] and stored in [[Created_Variables_Common_2021 table]] in [[CFE]]. It is related to one of our [[Indicators]], [[Length_of_Time_for_Transfer_from_ED_to_ICU_within_same_facility]].
-{{DJ | This is really one of the [[Indicators]], right? If so we should add that template... That would also include which reports use it, and what the n is, etc. [[User:Ttenbergen|Ttenbergen]] 10:27, 2023 February 2 (CST)
-*we have already  [[Length_of_Time_for_Transfer_from_ED_to_ICU_within_same_facility]]
---[[User:JMojica|JMojica]] 15:30, 2023 April 19 (CDT)}}
 == Data use ==
@@ Line 35: / Line 31: @@
 :::: [Arrive_dttm]),Nz([created_FirstNonER_BoardingLoc].[dttm],[Dispo_DtTm])-[created_FirstER_BoardingLoc].[dttm])
-== Log ==
+=== Outliers ===
-{{DT |
+==== ED stays in mid-hospitalization ====
+* there are occasions where pts go back to the ED while under the care of ICU; we do not include these in ER Delays; discussed at [[JALT_Meeting_-_Rolling_Agenda_and_Minutes_2023#JALT_Meeting_%E2%80%93_October_31,_2024 | JALT 2024-10-31]]...
+==== Moves for Medicine ====
+{{DJ |
+* This data is problematic before 2011-Q2,the only reason there are any is because it derives them for EMIPs. Some data may be available in [[Moves for Medicine]], but that would still leave a gap.  [[User:Ttenbergen|Ttenbergen]] 23:09, 2024 November 16 (CST)
+** OK, will be working on this getting data from [[Moves for Medicine]] from period Sept 2007 to June 3, 2011.  will give to Pagasa for upload to [[Arrive DtTm field]].  I will update the WIKI as soon as done.   Conclusion: for Medicine, prior Sept 2007, no ER delay while for Critical Care, no ER Delay prior July 1, 2016 -- these are treated as missing.   --[[User:JMojica|JMojica]] 16:35, 2024 December 11 (CST)}}
+== Log ==
+{{Discuss |
 * I have re-updated [[Created_Variables_Common_maker_2021 query]], for some reason the change I had made was not reflected in the master version. Ready to test. [[User:Ttenbergen|Ttenbergen]] 13:25, 2022 June 28 (CDT)
-** emailed Tina some inconsistencies found in ER Delays Aug 15,2022. --[[User:JMojica|JMojica]] 13:21, 2022 August 29 (CDT)}}
+** emailed Tina some inconsistencies found in ER Delays Aug 15,2022. --[[User:JMojica|JMojica]] 13:21, 2022 August 29 (CDT)
+*** are these still an issue? [[User:Ttenbergen|Ttenbergen]] 11:15, 2024 May 1 (CDT)
+**** I will re-check again.  Can't remember if have been resolved. --[[User:JMojica|JMojica]] 14:40, 2024 October 2 (CDT)}}
 * 2022-06-28 - previous change got lost somehow, re-applied it; updated query to use [[query created_PatientFollow]] rather than in-query definition
@@ Line 51: / Line 58: @@
 == Reporting and Analysis ==
-The SAS Program to read the data is in X:\Julie\SAS_CFE\CFE_macros\datetimes.sas
+The SAS Program to read the data is in {{S:\MED\MED_CCMED}}Julie\SAS_CFE\CFE_macros\datetimes.sas
+{{DJ|
+* I just had a look at that sas file (they open as text files) to see how you define transfer delay. If that file is still being used we may have a problem, it still defines tdelay different if a pt goes to a higher level of care, goes AMA or dies, and we changed that some time ago. So is this still the reference of how you calculate this? [[User:Ttenbergen|Ttenbergen]] 22:50, 2024 November 16 (CST)
+}}
 == Legacy ==