CCMDB Wiki

Created Variables Common 2021 table: Difference between revisions

← Older editNewer edit →
mNo edit summary
Line 1: Line 1:
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.
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:
* double-click query 'created_variables_common_deleter_2021''
* then double-click [[Created_Variables_Common_maker_2021 query]]
{{Todo
| who = Tina
| todo_added = 2023-04-19
| todo_action = 2023-04-19
| question = _after
* When this is done, [[Query check_long_transfer_delay]] will need to be reviewed.[[User:Ttenbergen|Ttenbergen]] 13:41, 2022 June 14 (CDT)
}}


== Update to [[PatientFollow Project]] structure ==
== Update to [[PatientFollow Project]] structure ==
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Created_Variables_Common_2021_table"