Created Variables Common table
Jump to navigation
Jump to search
The Created_Variables_Common table in CFE contains the values created by Created_Variables_Common_maker query. They are stored rather than generated on the fly because the query is slow for the volume of data involved (~12s on Tina's PC) and because some actions can't run against queries. It is used by the statistician for reporting and data extracts.
Data Structure
field | type | description | source |
---|---|---|---|
D_ID | text | link to L_Log table | relational derived |
age | integer | Age | calculated |
adm | DtTm | Admit DtTm | relational derived |
trans | DtTm | Transfer Ready DtTm | relational derived |
dis | DtTm | Dispo DtTm | relational derived |
LOS | Double | LOS | calculated |
Transfer_Delay | Single | Transfer Delay | calculated |
ER_Delay | Single | ER Delay | calculated |
Ap_Eye | string | weird twin of another column, not used | relational derived |
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 |
activeLocation | yes/no | from L Log table and s_dispo table | relational derived |