Created Variables Common 2021 table: Difference between revisions

(11 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.

~~== Testing ==~~

~~During Testing, the query will need to be filled by manually:~~

* open the table, delete contents

* then double-click [[Created_Variables_Common_maker_2021 query]]

~~{{DT | When this is done, [[Query check_long_transfer_delay]] will need to be reviewed. [[User:Ttenbergen|Ttenbergen]] 08:25, 2022 June 9 (CDT)}}~~

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

~~=== ER Delay ===~~

* [[Created_AdmitDtTm query]]

~~Has been updated to <code>ER_Delay: Nz(~~[~~created_FirstNonER_BoardingLoc].~~[~~dttm~~]~~,[Arrive_dttm])-Nz([Admit_DtTm~~]~~)</code>~~

* [[ER Delay]]

~~=== Transfer Ready DtTm ===~~

~~We will need to remove~~ [[~~Transfer Delay]] from this query because there could be more than one per profile in [[Transfer~~ Delay ~~(Medicine)~~]] ~~and we should only implement it once. See those pages for details.~~

=== GCS ===

Line 31:

Line 21:

|-

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

|-

~~|| '''trans''' || DtTm || Nz([[Created_FirstTransferReady query]].FirstTransferReady_DtTm,[[Transfer_Ready_DtTm]] )~~

|-

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

Line 62:

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

Line 79:

Line 67:

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

[[Category:Created_Variables_Common_2021 table | *]]

[[Category:Created Variables]]

[[Category:Centralized_data_front_end.accdb]]

@@ 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.
-== Testing ==
-During Testing, the query will need to be filled by manually:
-* open the table, delete contents
-* then double-click [[Created_Variables_Common_maker_2021 query]]
-{{DT | When this is done, [[Query check_long_transfer_delay]] will need to be reviewed. [[User:Ttenbergen|Ttenbergen]] 08:25, 2022 June 9 (CDT)}}
 == Update to [[PatientFollow Project]] structure ==
-=== ER Delay ===
+* [[Created_AdmitDtTm query]]
-Has been updated to <code>ER_Delay: Nz([created_FirstNonER_BoardingLoc].[dttm],[Arrive_dttm])-Nz([Admit_DtTm])</code>
+* [[ER Delay]]
-=== Transfer Ready DtTm ===
-We will need to remove [[Transfer Delay]] from this query because there could be more than one per profile in [[Transfer Delay (Medicine)]] and we should only implement it once. See those pages for details.
 === GCS ===
@@ Line 31: / Line 21: @@
 |-
 || '''adm''' || DtTm || pulled in from [[Created AdmitDtTm query]]
-|-
-|| '''trans''' || DtTm || Nz([[Created_FirstTransferReady query]].FirstTransferReady_DtTm,[[Transfer_Ready_DtTm]] )
 |-
 || '''dis''' || DtTm || [[Dispo DtTm]] || relational derived
@@ Line 62: / 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 ==
@@ Line 79: / Line 67: @@
 {{Related Articles}}
-[[Category:Created Variables Common table | *]]
+[[Category:Created_Variables_Common_2021 table | *]]
 [[Category:Created Variables]]
 [[Category:Centralized_data_front_end.accdb]]