Created Variables CC 2021 table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m →Log |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 127: | Line 127: | ||
== Log == | == Log == | ||
* 2022-12-08 - removed fields [[Ap Chronic]] (ie old L_Log field) and ''chronic_pts'' (ie duplicate of ApTotal_Chronic). | |||
* 2022-09-29 - reverted to old version of query | * 2022-09-29 - reverted to old version of query | ||
* 2022-09-28 - rolled out a broken version after attempted changes to [[Transfer Delay (Critical Care)|Transfer Delay]] | * 2022-09-28 - rolled out a broken version after attempted changes to [[Transfer Delay (Critical Care)|Transfer Delay]] | ||
Revision as of 11:31, 2022 December 8
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 |
| Transfer_Delay_CC | single | as per Transfer Delay (Critical Care), from Created transferDelay table | 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 via Created_APACHE_Chronic query | 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 |
| Program | string | from L Log table and s_dispo table | relational derived |
| 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.
It uses Created_APACHE_Chronic query.
Log
- 2022-12-08 - removed fields Ap Chronic (ie old L_Log field) and chronic_pts (ie duplicate of ApTotal_Chronic).
- 2022-09-29 - reverted to old version of query
- 2022-09-28 - rolled out a broken version after attempted changes to Transfer Delay
- 2022-04-28 - added field Transfer_Delay_CC to table and Created _Variables_CC maker_2021 query