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	remove as discussed 2019-09-29. added: no added date action: no action date Cargo Categories details needed }}	relational derived
trans	DtTm	remove as discussed 2019-09-29. added: no added date action: no action date Cargo Categories details needed }}	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	This one can added: no added date action: no action date Cargo Categories	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 remove as discussed 2019-09-29. added: no added date action: no action date Cargo Categories
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 remove as discussed 2019-09-29. added: no added date action: no action date Cargo Categories

Log

• 2021-04-21

• to do:
  • change Age to use first service dttm instead of (Accept_DtTm if available, Arrive_DtTm otherwise)
  • adm - (Accept_DtTm if available, Arrive_DtTm otherwise)
  • trans - Transfer Ready DtTm, included because used to be calculated
  • dis - Dispo DtTm, included because used to be calculated
  • Transfer Delay
  • ER Delay
  • Glasgow Coma Scale