Created Variables CC 2021 table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) m (→Background) |
||
| (13 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
The | 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 Scoring table|APACHE score]] and its components, e.g. [[Glasgow Coma Scale]]. | ||
{| class="wikitable sortable" | {| class="wikitable sortable" | ||
| Line 16: | Line 16: | ||
|| '''age_pts''' || integer || as per VBA Function ApScore_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 | || '''ApTotal_Age''' || byte|| twin of age_pts || calculated | ||
| Line 22: | Line 22: | ||
|| '''Ap_AdmitType''' || text(10) || [[Admit Type for APACHE II]] || relational derived | || '''Ap_AdmitType''' || text(10) || [[Admit Type for APACHE II]] || relational derived | ||
|- | |- | ||
|| ''' | || '''hasChronic''' || shortText(3)|| as per [[Created_APACHE_Chronic query]] || calculated | ||
|- | |- | ||
|| '''Ap_Temp''' || single || [[Temperature]] from [[L Log table]] || relational derived | || '''Ap_Temp''' || single || [[Temperature]] from [[L Log table]] || relational derived | ||
| Line 107: | Line 105: | ||
|- | |- | ||
|| '''ES''' || text(255) || IIf(InStr([Ap_AdmitType],"Elect")>0,"Y","N") || calculated | || '''ES''' || text(255) || IIf(InStr([Ap_AdmitType],"Elect")>0,"Y","N") || calculated | ||
|- | |- | ||
|| '''ApTotal_Chronic''' || byte || as per VBA Function AP_Chronic || calculated | || '''ApTotal_Chronic''' || byte || as per VBA Function AP_Chronic || calculated | ||
| Line 115: | Line 111: | ||
|- | |- | ||
|| '''Site''' || string || from [[L Log table]] and [[s_dispo table]] || relational derived | || '''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 | || '''Program''' || string || from [[L Log table]] and [[s_dispo table]] || relational derived | ||
| Line 122: | Line 120: | ||
== Implementation == | == Implementation == | ||
This table populated by the [[Created _Variables_CC maker_2021 query]] when the | This table populated by the [[Created _Variables_CC maker_2021 query]] when the [[Calc created variables button]] on the front screen of [[CFE]] is pressed. | ||
It uses [[Created_APACHE_Chronic query]]. | It uses [[Created_APACHE_Chronic query]]. | ||
== Background == | |||
This table replaced "Created_Variables_CC" table, which had earlier replaced [[Created Variables in TMSX or Med TMS]]. | |||
== Log == | == Log == | ||
* 2022-04-28 | * 2022-12-08 - removed fields [[Ap Chronic]] (ie old L_Log field), ''CH'' 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 (Critical Care)|Transfer Delay]] | |||
* 2022-04-28 - added field [[Transfer_Delay_CC]] to table and [[Created _Variables_CC maker_2021 query]] | |||
== Related articles == | == Related articles == | ||
| Line 135: | Line 139: | ||
[[Category:Data structure]] | [[Category:Data structure]] | ||
[[Category:Created Variables]] | [[Category:Created Variables]] | ||
[[Category: | [[Category:Created_Variables_CC_2021 table]] | ||
[[Category:PatientFollow Project]] | [[Category:PatientFollow Project]] | ||
Latest revision as of 17:11, 2023 April 19
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 |
| hasChronic | shortText(3) | as per Created_APACHE_Chronic query | 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 |
| 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 |
| RecordStatus | text(20) | RecordStatus from L Log table | relational derived |
Implementation
This table populated by the Created _Variables_CC maker_2021 query when the Calc created variables button on the front screen of CFE is pressed.
It uses Created_APACHE_Chronic query.
Background
This table replaced "Created_Variables_CC" table, which had earlier replaced Created Variables in TMSX or Med TMS.
Log
- 2022-12-08 - removed fields Ap Chronic (ie old L_Log field), CH 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