Created Variables Common 2021 table
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
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 *
|
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
- 2021-04-21
|
|