|
|
| (12 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... ==
| |
| {{Potential Change}}
| |
| | |
| Julie/Trish, let's track testing information for created_variables here... {{discussion}}
| |
| | |
| *“Transfer_Delay must be blanks instead of large negative values”
| |
| **Got it, I’ll fix that. Well, maybe we should decide if we want to keep to Ed’s std for missing transfer time. I could import/change the actual …3000… dates to nulls, I think. Should I try to change the actual data? That would also make it consistent with how new data will arrive.
| |
| ***Sure, I agree that we change those dummy dates to null.
| |
| ****I have created update query “1use_only_update_3000_transfer_dates_to_null” in centralized_front_end to update all records in centralized_data.mdb that have a 3000 transfer date and their corresponding transfer times to null. Since this will change much data it should probably be run by Pagasa on a master version of the data after creating a specific backup of the data. Trish, could you please coordinate with Pagasa once the newest front end that includes this is rolled out?
| |
| | |
| *Is 1/1/3000 9:45 your DEFAULT transf ready date time?
| |
| **It’s not mine, it’s how it shows in Ed’s data when I import it.
| |
| ***OK, I am just surprise that there is time – I thought they are all zeroes.
| |
| ****I just tried to find a record that has that transfer date time combination and can’t. Could you provide a D_ID?
| |
| | |
| ===Calculation error due to dummy year and dummy times from blanks===
| |
| | |
| {| class="wikitable" border=1 <hiddentext> set to 0 for no borders</hiddentext>
| |
| |- style="font-size:9pt;font-weight:bold"
| |
| | width="74" height="25" | D_ID
| |
| | width="29" | R_age
| |
| | width="37" | adm
| |
| | width="52" | trans
| |
| | width="46" | dis
| |
| | width="30" | R_LOS
| |
| | width="60" | Transfer_Delay
| |
| | |
| |- style="font-size:9pt"
| |
| | height="20" | HSC_MICU--1366
| |
| | align="right" | 55
| |
| | align="right" | 7/11/1988
| |
| |style="background-color:#FFFF00" align="right" | 1/1/3000 9:45
| |
| | align="right" | 7/13/1988
| |
| | align="right" | 2.427
| |
| | align="right" | -369431.771
| |
| | |
| |- style="font-size:9pt"
| |
| | height="20" | HSC_SICU--22
| |
| | align="right" | 83
| |
| | align="right" | 7/21/1988
| |
| |style="background-color:#FFFF00" align="right" | 1/1/3000 9:45
| |
| | align="right" | 7/25/1988
| |
| | align="right" | 3.667
| |
| | align="right" | -369419.851
| |
| | |
| |- style="font-size:9pt"
| |
| | height="20" | HSC_SICU--34
| |
| | align="right" | 75
| |
| | align="right" | 7/28/1988
| |
| |style="background-color:#FFFF00" align="right" | 1/1/3000 9:45
| |
| | align="right" | 7/28/1988
| |
| | align="right" | 0.117
| |
| | align="right" | -369416.675
| |
| | |
| |- style="font-size:9pt"
| |
| | height="20" | HSC_MICU--1383
| |
| | align="right" | 67
| |
| | align="right" | 7/29/1988
| |
| |style="background-color:#FFFF00" align="right" | 1/1/3000 9:45
| |
| | align="right" | 7/30/1988
| |
| | align="right" | 0.931
| |
| | align="right" | -369414.924
| |
| | |
| |- style="font-size:9pt"
| |
| | height="20" | HSC_SICU--32
| |
| | align="right" | 64
| |
| | align="right" | 7/27/1988
| |
| |style="background-color:#FFFF00" align="right" | 1/1/3000 9:45
| |
| | align="right" | 8/3/1988
| |
| | align="right" | 6.865
| |
| | align="right" | -369410.802
| |
| | |
| |- style="font-size:9pt"
| |
| | height="20" | HSC_MICU--1406
| |
| | align="right" | 62
| |
| | align="right" | 8/21/1988
| |
| |style="background-color:#FFFF00" align="right" | 1/1/3000 9:45
| |
| | align="right" | 8/22/1988
| |
| | align="right" | 1.062
| |
| | align="right" | -369391.802
| |
| | |
| |- style="font-size:9pt"
| |
| | height="20" | HSC_SICU--115
| |
| | align="right" | 63
| |
| | align="right" | 9/19/1988
| |
| |style="background-color:#FFFF00" align="right" | 1/1/3000 9:45
| |
| | align="right" | 9/26/1988
| |
| | align="right" | 7.455
| |
| | align="right" | -369356.469
| |
| | |
| |- style="font-size:9pt"
| |
| | height="20" | HSC_MICU--1446
| |
| | align="right" | 85
| |
| | align="right" | 9/30/1988
| |
| |style="background-color:#FFFF00" align="right" | 1/1/3000 9:45
| |
| | align="right" | 10/1/1988
| |
| | align="right" | 0.896
| |
| | align="right" | -369351.969
| |
| | |
| |- style="font-size:9pt"
| |
| | height="20" | HSC_SICU--127
| |
| | align="right" | 75
| |
| | align="right" | 9/28/1988
| |
| |style="background-color:#FFFF00" align="right" | 1/1/3000 9:45
| |
| | align="right" | 10/1/1988
| |
| | align="right" | 3.201
| |
| | align="right" | -369351.538
| |
| | |
| |- style="font-size:9pt"
| |
| | height="20" | HSC_MICU--1439
| |
| | align="right" | 69
| |
| | align="right" | 9/24/1988
| |
| |style="background-color:#FFFF00" align="right" | 1/1/3000 9:45
| |
| | align="right" | 10/2/1988
| |
| | align="right" | 8.573
| |
| | align="right" | -369350.729
| |
| | |
| |- style="font-size:9pt"
| |
| | height="20" | HSC_SICU--149
| |
| | align="right" | 79
| |
| | align="right" | 10/9/1988
| |
| |style="background-color:#FFFF00" align="right" | 1/1/3000 9:45
| |
| | align="right" | 10/9/1988
| |
| | align="right" | 0.292
| |
| | align="right" | -369343.531
| |
| | |
| |- style="font-size:9pt"
| |
| | height="20" | HSC_SICU--160
| |
| | align="right" | 65
| |
| | align="right" | 10/13/1988
| |
| |style="background-color:#FFFF00" align="right" | 1/1/3000 9:45
| |
| | align="right" | 10/14/1988
| |
| | align="right" | 0.854
| |
| | align="right" | -369338.865
| |
| | |
| |- style="font-size:9pt"
| |
| | height="20" | HSC_SICU--153
| |
| | align="right" | 76
| |
| | align="right" | 10/11/1988
| |
| |style="background-color:#FFFF00" align="right" | 1/1/3000 9:45
| |
| | align="right" | 10/21/1988
| |
| | align="right" | 10.403
| |
| | align="right" | -369331.844
| |
| | |
| |}
| |
| | |
| === 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]]
| |