Created Variables CC 2021 table
The Created_variables_CC_2021 table in CFE contains most of the profile-level derived Indicators for critical care profiles (see Created_Variables_Common_2021 table) 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
| |||
| Program | string | from L Log table and s_dispo table | relational derived | ||
| activeLocation | yes/no | from L Log table and s_dispo table
| |||
| RecordStatus | text(20) | RecordStatus from L Log table | relational derived |
Implementation
This table populated by the Created _Variables_CC maker_2021 query when the button "calc created variables" on the front screen of CFE is pressed.
Background
This table replaces the Created_Variables_CC table.