Created Variables Common 2021 table: Difference between revisions

(29 intermediate revisions by the same user not shown)

Line 1:

The Created_Variables_Common_2021 table in [[CFE]] contains the values created by [[Created_Variables_Common_maker_2021 query]]. They are stored rather than generated on the fly because the query is slow for the volume of data involved (many minutes on Tina's PC) and because SAS can not read some data from queries. It is used by the [[statistician]] for reporting and data extracts.

The Created_Variables_Common_2021 table in [[CFE]] contains the values created by [[Created_Variables_Common_maker_2021 query]] when the [[Calc created variables button]] is pressed. They are stored rather than generated on the fly because the query is slow for the volume of data involved (many minutes on Tina's PC) and because SAS can not read some data from queries. It is used by the [[statistician]] for reporting and data extracts.

== Update to [[PatientFollow Project]] structure ==

* [[Created_AdmitDtTm query]]

* [[ER Delay]]

=== GCS ===

No change to the GCS entries. They are in {{PAGENAME}} because they are also used by the [[ALERT Scale]].

== Data Structure ==

Line 13:

Line 20:

|| '''age''' || integer || [[Age]] || calculated

|-

|| '''adm''' || DtTm || ~~derived~~ from [[~~Accept DtTm~~]] ~~resp [[Arrive DtTm]] || relational derived~~

|| '''adm''' || DtTm || pulled in from [[Created AdmitDtTm query]]

|-

~~|| '''trans''' || DtTm || [[Transfer Ready DtTm]] || relational derived~~

|-

|| '''dis''' || DtTm || [[Dispo DtTm]] || relational derived

|-

|| '''LOS''' || Double || [[LOS]] || calculated

|-

~~|| '''Transfer_Delay''' || Single || [[Transfer Delay]] || calculated~~

|-

|| '''ER_Delay''' || Single || [[ER Delay]] ||calculated

Line 47:

Line 50:

== Background ==

Replacement for the old [[Created Variables Common table]] to deal with process changes such as [[PatientFollow Project]]. A new table/query was set up instead of modifying the old one in order to allow for testing over a period of time.

Replacement for the old "Created Variables Common" table to deal with process changes such as [[PatientFollow Project]]. A new table/query was set up instead of modifying the old one in order to allow for testing over a period of time.

== Log ==

* ~~2021~~-04-21

* 2022-06-09 or before

** updated definition for [[ER Delay]]

* ~~to do:~~

** removed [[RecordStatus]] discontinued from the query

** change [[~~Age~~]] ~~to use first service dttm instead of (~~[[~~Accept_DtTm~~]] ~~if available, [[Arrive_DtTm]] otherwise)~~

* 2022-04-27

** ~~''adm'' - (~~[[~~Accept_DtTm~~]] ~~if available,~~ [[~~Arrive_DtTm~~]] ~~otherwise)~~

** removed [[Transfer Ready DtTm]]/[[Transfer Ready DtTm tmp entry]] resp [[Transfer Delay]] because there can be more than one of these per record; see those pages for how it will now be calculated

** trans - [[Transfer ~~Ready DtTm~~]]~~, included~~ because ~~used to~~ be calculated

** confirmed "Adm" and [[Age]] are based on [[Admit_DtTm]]

** ~~dis -~~ [[~~Dispo DtTm~~]]~~, included because used~~ to ~~be calculated~~

** updated LOS to use [[Function LOS()]]

** [[Transfer Delay]]

** removed [[Transfer Delay]] because there can be more than one, see the relevant pages

** [[ER Delay]]

** confirmed [[ER Delay]] uses new definition of [[Admit DtTm]]

** [[~~Glasgow Coma Scale~~]]

* 2021-04-21 - original implementation

== Related articles ==

[[Category:~~Created Variables Common~~ table | *]]

[[Category:Created_Variables_Common_2021 table | *]]

[[Category:Created Variables]]

[[Category:Centralized_data_front_end.accdb]]

[[Category:Data structure]]

[[Category:Reporting]]

[[Category:PatientFollow Project]]

@@ Line 1: / Line 1: @@
-The Created_Variables_Common_2021 table in [[CFE]] contains the values created by [[Created_Variables_Common_maker_2021 query]]. They are stored rather than generated on the fly because the query is slow for the volume of data involved (many minutes on Tina's PC) and because SAS can not read some data from queries. It is used by the [[statistician]] for reporting and data extracts.
+The Created_Variables_Common_2021 table in [[CFE]] contains the values created by [[Created_Variables_Common_maker_2021 query]] when the [[Calc created variables button]] is pressed. They are stored rather than generated on the fly because the query is slow for the volume of data involved (many minutes on Tina's PC) and because SAS can not read some data from queries. It is used by the [[statistician]] for reporting and data extracts.
+== Update to [[PatientFollow Project]] structure ==
+* [[Created_AdmitDtTm query]]
+* [[ER Delay]]
+=== GCS ===
+No change to the GCS entries. They are in {{PAGENAME}} because they are also used by the [[ALERT Scale]].
 == Data Structure ==
@@ Line 13: / Line 20: @@
 || '''age''' || integer || [[Age]] || calculated
 |-
-|| '''adm''' || DtTm || derived from [[Accept DtTm]] resp [[Arrive DtTm]] || relational derived
+|| '''adm''' || DtTm || pulled in from [[Created AdmitDtTm query]]
-|-
-|| '''trans''' || DtTm || [[Transfer Ready DtTm]] || relational derived
 |-
 || '''dis''' || DtTm || [[Dispo DtTm]] || relational derived
 |-
 || '''LOS''' || Double || [[LOS]] || calculated
-|-
-|| '''Transfer_Delay''' || Single || [[Transfer Delay]] || calculated
 |-
 || '''ER_Delay''' || Single || [[ER Delay]] ||calculated
@@ Line 47: / Line 50: @@
 == Background ==
-Replacement for the old [[Created Variables Common table]] to deal with process changes such as [[PatientFollow Project]]. A new table/query was set up instead of modifying the old one in order to allow for testing over a period of time.
+Replacement for the old "Created Variables Common" table to deal with process changes such as [[PatientFollow Project]]. A new table/query was set up instead of modifying the old one in order to allow for testing over a period of time.
 == Log ==
-* 2021-04-21
+* 2022-06-09 or before
+** updated definition for [[ER Delay]]
-* to do:
+** removed [[RecordStatus]] discontinued from the query
-** change [[Age]] to use first service dttm instead of ([[Accept_DtTm]] if available, [[Arrive_DtTm]] otherwise)
+* 2022-04-27
-** ''adm'' - ([[Accept_DtTm]] if available, [[Arrive_DtTm]] otherwise)
+** removed [[Transfer Ready DtTm]]/[[Transfer Ready DtTm tmp entry]] resp [[Transfer Delay]] because there can be more than one of these per record; see those pages for how it will now be calculated
-** trans - [[Transfer Ready DtTm]], included because used to be calculated
+** confirmed "Adm" and [[Age]] are based on [[Admit_DtTm]]
-** dis - [[Dispo DtTm]], included because used to be calculated
+** updated LOS to use [[Function LOS()]]
-** [[Transfer Delay]]
+** removed [[Transfer Delay]] because there can be more than one, see the relevant pages
-** [[ER Delay]]
+** confirmed [[ER Delay]] uses new definition of [[Admit DtTm]]
-** [[Glasgow Coma Scale]]
+* 2021-04-21 - original implementation
 == Related articles ==
 {{Related Articles}}
-[[Category:Created Variables Common table | *]]
+[[Category:Created_Variables_Common_2021 table | *]]
 [[Category:Created Variables]]
 [[Category:Centralized_data_front_end.accdb]]
 [[Category:Data structure]]
 [[Category:Reporting]]
+[[Category:PatientFollow Project]]