Created Variables Common table

From CCMDB Wiki

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

Related articles

Related articles: