Created Variables: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
(→‎Testing...: cleaned up testing section, all recent elements had been addressed)
Line 14: Line 14:


== Testing... ==
== Testing... ==
{{Potential Change}}
all elements from most recent round were addressed. Ttenbergen 16:24, 2014 June 16 (CDT)
See: [[Change Priorities]] list
 
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 ==
== Background ==

Revision as of 16:24, 2014 June 16

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.

List of values

Testing...

all elements from most recent round were addressed. Ttenbergen 16:24, 2014 June 16 (CDT)

Background

The system replaces Created Variables in TMSX or Med TMS that were created by TMSX and MedTMS.

Retrieved from "https://ccmdb.kuality.ca/index.php?title=Created_Variables&oldid=39151"