Created Variables Common 2021 table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Line 5: Line 5:
* open the table, delete contents
* open the table, delete contents
* then double-click [[Created_Variables_Common_maker_2021 query]]
* 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 ==
== Update to [[PatientFollow Project]] structure ==

Revision as of 08:25, 2022 June 9

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.

Testing

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


When this is done, Query check_long_transfer_delay will need to be reviewed. Ttenbergen 08:25, 2022 June 9 (CDT)

  • SMW


  • Cargo


  • Categories

Update to PatientFollow Project structure

ER Delay

Has been updated to ER_Delay: Nz([created_FirstNonER_BoardingLoc].[dttm],[Arrive_dttm])-Nz([Admit_DtTm])

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

No change to the GCS entries. They are in Created Variables Common 2021 table because they are also used by the ALERT Scale.

Data Structure

field type description source
D_ID text link to L_Log table relational derived
age integer Age calculated
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
LOS Double LOS calculated
ER_Delay Single ER Delay calculated
GCS_Eye_pts byte from L Log table and s_GCS_eye query relational derived
GCS_Eye_text string from L Log table and s_GCS_eye query relational derived
GCS_Motor_pts byte from L Log table and s_GCS_motor query relational derived
GCS_Motor_text string from L Log table and s_GCS_motor query relational derived
GCS_Verbal_pts byte from L Log table and s_GCS_verbal query relational derived
GCS_Verbal_text string from L Log table and s_GCS_verbal query relational derived
GCS_Total byte sum of GCS_Eye_pts, GCS_Motor_pts, GCS_Verbal_pts calculated
Site string from L Log table and s_dispo table relational derived
Ward string from L Log table and s_dispo table relational derived
Program string from L Log table and s_dispo table relational derived

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.

Log

Related articles

Related articles: