Created Variables Common 2021 table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
Line 79: | Line 79: | ||
* 2021-04-21 | * 2021-04-21 | ||
* to do: | {{Todo | ||
** change [[Age]] to use | | who = Tina | ||
| todo_added = 2022-04-21 | |||
| todo_action = 2022-04-21 | |||
| question = | |||
* * to do: | |||
** change [[Age]] to use [[Admit DtTm]] instead of (''Accept_DtTm'' if available, ''Arrive_DtTm'' otherwise) | |||
** ''adm'' - [[Admit DtTm]] | ** ''adm'' - [[Admit DtTm]] | ||
** trans - [[Transfer Ready DtTm]], included because used to be calculated | ** trans - [[Transfer Ready DtTm]], included because used to be calculated | ||
Line 86: | Line 91: | ||
** [[Transfer Delay]] | ** [[Transfer Delay]] | ||
** [[ER Delay]] | ** [[ER Delay]] | ||
** [[Glasgow Coma Scale]] | ** [[Glasgow Coma Scale]] }} | ||
== Related articles == | == Related articles == |
Revision as of 16:43, 2022 April 21
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:
- open the table, delete contents
- then double-click Created_Variables_Common_maker_2021 query
Update to PatientFollow Project structure
ER Delay
|
Transfer Ready DtTm
|
GCS *
|
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 |
Transfer_Delay | Single | Transfer Delay | 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
- 2021-04-21
|
|