Created Variables Common table
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 |