|
|
| (16 intermediate revisions by 2 users not shown) |
| Line 1: |
Line 1: |
| '''Created_Variables_Table''' is a table in [[Centralized_data_front_end.mdb]] which is populated by the query '''Created_Variables''' in the same .mdb when the button "calc created variables" on the front screen of the app is pressed. It is used by the [[statistician]] for reporting and data extracts.
| | #redirect:[[Calc created variables button]] |
|
| |
|
| == List of values ==
| | [[Category:Created Variables]] |
| *Age in years - see details in [[Date of Birth]]
| |
| *Length of Stay in days - see details in [[LOS]]
| |
| *[[Transfer Delay]] in days
| |
| *APACHE - see details in [[APACHE Scoring table]]
| |
| **Total APACHE SCORE
| |
| **Mean Blood Pressure
| |
| **Glasgow Coma Scale - ([[Glasgow Coma Scale]])
| |
| **Acute Physiological points
| |
| **Age points
| |
| **Chronic Health points
| |
| | |
| == Testing... ==
| |
| Julie/Trish, let's track testing information for created_variables here... {{discussion}}
| |
| | |
| === Transfer Delay ===
| |
| * As per Julie: Transfer delay should not occur to those who move to another ICU. Transfer_Delay must be blanks instead of large negative values – see Created_variable table below.
| |
| ** Tina: Is that a part of the definition of Transfer Delay? I had never heard of it and it’s not in [[Transfer_Delay ]]. So generally, is it the following?
| |
| Transfer delay =
| |
| iif(location = <an ICU>,
| |
| iif(discharge_to <> <other ICU>,
| |
| dischargedttm – transferdttm,
| |
| 0),
| |
| dischargedttm – transferdttm,)
| |
| ::* Julie: Transfer delay is derived from transfer ready date_time and discharge date_time. For CC, only transfer to HSC IICU requires transfer ready date_time (or delays) , other ICUs (MICU,SICU,CCU) don’t require it [[Transfer_Ready_date_and_time]]
| |
| | |
| == Background ==
| |
| The system replaces [[Created Variables in TMSX or Med TMS]] that were created by [[TMSX and MedTMS]].
| |
| | |
| [[Category: 2013 data upgrades]]
| |
| [[Category: Centralized data front end.mdb]]
| |