# Created Variables CC table

Jump to navigation
Jump to search

The Created_variables_CC table in CFE contains the most of the profile-level derived Indicators and duplicates some related stored data for convenience . It is populated and used by the statistician for reporting and data extracts. Primarily these are the APACHE score and its components, e.g. Glasgow Coma Scale

field | type | description | source |
---|---|---|---|

D_ID |
text | link to L_Log table | relational derived |

Birth |
date | DOB from L Log table | relational derived |

age |
integer | Age | calculated |

age_pts |
integer | as per VBA Function ApScore_Age | calculated |

ApTotal_Age |
byte | twin of age_pts | calculated |

Ap_AdmitType |
text(10) | Admit Type for APACHE II | relational derived |

Ap_Chronic |
text(30) | Chronic Health APACHE | relational derived |

chronic_pts |
long | as per VBA Function Ap_Chronic | calculated |

Ap_Temp |
single | Temperature from L Log table | relational derived |

temp_pts |
integer | as per VBA Function ApScore_Temp | calculated |

Ap_APSysBP |
long | Sys BP from L Log table | relational derived |

Ap_APDiasBP |
long | Dias BP from L Log table | relational derived |

MBP |
integer | Mean BP via VBA function AP_MeanBP | calculated |

BP_pts |
integer | twin of MBP | calculated |

Ap_HeartRate |
integer | HR from L Log table | relational derived |

heart_pts |
integer | as per VBA Function ApScore_HeartRate | calculated |

Ap_RespRate |
long | RR from L Log table | relational derived |

resp_pts |
integer | as per VBA Function ApScore_RespRate | calculated |

Ap_Eye |
text(13) | AP Eye field from L Log table | relational derived |

eye_pts |
integer | as per VBA Function GCS_Eye_pts | calculated |

Ap_Motor |
text(19) | AP Motor field from L Log table | relational derived |

motor_pts |
integer | as per VBA Function GCS_Motor_pts | calculated |

Ap_Verbal |
text(26) | AP Verbal field from L Log table | relational derived |

verbal_pts |
integer | as per VBA Function GCS_Verbal_pts | calculated |

ApTotal_Neuro |
byte | 15-(eye_pts + motor_pts + verbal_pts]) | calculated |

Ap_FIO2 |
single | FIO2 from L Log table | relational derived |

Ap_PO2 |
single | PO2 from L Log table | relational derived |

PO2_score |
integer | as per VBA Function ApScore_PO2 | calculated |

Ap_CO2 |
single | CO2 from L Log table | relational derived |

Ap_pH |
single | PH from L Log table | relational derived |

ph_score |
integer | as per VBA Function ApScore_pH | calculated |

Ap_SerCO2 |
single | Serum CO2 from L Log table | relational derived |

SerCO2_score |
integer | as per VBA Function ApScore_SerCO2 | calculated |

AaDO2 |
integer | AaDO2 from L Log table | relational derived |

aado2_score |
integer | as per VBA Function ApScore_AaDO2 | calculated |

abg_score |
integer | as per VBA Function ApScore_ABG | calculated |

Ap_Na |
single | Na from L Log table | relational derived |

na_score |
integer | as per VBA Function ApScore_Na | calculated |

Ap_K |
single | K from L Log table | relational derived |

k_score |
integer | as per VBA Function ApScore_K | calculated |

Ap_Hemat |
single | HCT from L Log table | relational derived |

hemat_score |
integer | as per VBA Function ApScore_Hemat | calculated |

Ap_WBC |
integer | WBC from L Log table | relational derived |

wbc_score |
integer | as per VBA Function ApScore_WBC | calculated |

Ap_Creat |
single | Creatinine from L Log table | relational derived |

Ap_ARF |
text(5) | ARF from L Log table | relational derived |

creat_score |
integer | as per VBA Function ApScore_Creat | calculated |

ApTotal_Physiological |
byte | as per VBA Function ApTotal_Physiological | calculated |

ES |
text(255) | IIf(InStr([Ap_AdmitType],"Elect")>0,"Y","N") | calculated |

CH |
text(255) | IIf([Ap_Chronic]="9No CH","N","Y") | calculated |

ApTotal_Chronic |
byte | as per VBA Function AP_Chronic | calculated |

ApTotal |
byte | as per VBA Function APACHE_Total | 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 | |

RecordStatus |
text(20) | RecordStatus from L Log table | relational derived |

## Implementation

This table is implemented to be filled by Created _Variables_CC maker query as needed.

## Log

2021-05? - made query Created_Variables_CC maker_2021 to test new derivations of fields