Created Variables Common table

From CCMDB Wiki
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
Todo.svg

Swiss Army Knife.svg

remove as discussed 2019-09-29.

  • added: no added date
  • action: no action date
  • Cargo


  • Categories
  • details needed

}}

relational derived
trans DtTm
Todo.svg

Swiss Army Knife.svg

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
Todo.svg

Swiss Army Knife.svg

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
Todo.svg

Swiss Army Knife.svg

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
Todo.svg

Swiss Army Knife.svg

remove as discussed 2019-09-29.

  • added: no added date
  • action: no action date
  • Cargo


  • Categories

Log

  • 2021-04-21

Related articles

Related articles: