Statistician

p:Julie Mojica is the full time Statistician for the Critical Care and Medicine Database.

She provides Statistical Analysis and Reporting using our data.

The Statistician is a member of the Steering Committee & the Task Team.

Questions on wiki

Here is a list of questions driven by the Template:Discuss that have been flagged for Julie.

4

	Question	Modification date"Modification date" is a predefined property that corresponds to the date of the last modification of a subject and is provided by Semantic MediaWiki.
ER Delay	I have re-updated Created_Variables_Common_maker_2021 query, for some reason the change I had made was not reflected in the master version. Ready to test. Ttenbergen 13:25, 2022 June 28 (CDT) emailed Tina some inconsistencies found in ER Delays Aug 15,2022. --JMojica 13:21, 2022 August 29 (CDT) are these still an issue? Ttenbergen 11:15, 2024 May 1 (CDT) I will re-check again. Can't remember if have been resolved. --JMojica 14:40, 2024 October 2 (CDT) I just had a look at that sas file (they open as text files) to see how you define transfer delay. If that file is still being used we may have a problem, it still defines tdelay different if a pt goes to a higher level of care, goes AMA or dies, and we changed that some time ago. So is this still the reference of how you calculate this? Ttenbergen 22:50, 2024 November 16 (CST) This data is problematic before 2011-Q2,the only reason there are any is because it derives them for EMIPs. Some data may be available in Moves for Medicine, but that would still leave a gap. Ttenbergen 23:09, 2024 November 16 (CST)	17 November 2024 05:11:10
ER Wait	no ER Wait concept in Moves for Medicine, so not sure what this means. Ttenbergen 13:53, 2024 November 14 (CST) The closest thing I have been able to find to a definition for the earlier state of this is \\ad.wrha.mb.ca\WRHA\HSC\shared\MED\MED_CCMED\Julie\SAS_CFE\CFE_macros\CFE_ERWait_Moves.sas , but that file has a date stamp of 2016-3-17, so it wouldn't have any of the newer developments in it. Is there a definitive file you use? Ttenbergen 22:59, 2024 November 16 (CST) Also, that file uses this project from 2011-06-04 onward, but this project doesn't contain data until 2013-11-23. So we seem to have a gap. Ttenbergen 22:59, 2024 November 16 (CST)	17 November 2024 04:59:36
Instructions for importing a batch of DSM Data	The old process used L_Problems_D_ID table. Does the new process still use and populate it? If so, can we update this with details? If not, can we retire it? Or, in any case, update the data on L_Problems_D_ID table? Ttenbergen 15:15, 2024 October 17 (CDT)	17 October 2024 20:15:36
DSM Labs data.accdb	Emailed Julie: found overlap in old file, what does it mean proposed using labDtTm for split threshold Ttenbergen 16:51, 2024 May 2 (CDT)	2 May 2024 21:51:04

IT Access used

• File share HSC Critical Care
• Critical Care Sharepoint ExtraNet