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.

edit	page	question	ModDate
edit	page	question	ModDate
edit	LOS Medicine per hospital admission	"None yet." What does that mean in the context of "Target"? And how does "Target" fit in with the structure you described in Template:Reporting Indicators?	2021-07-13 9:30:34 PM
edit	Check CCI CXR vs LOS	... This reminds me of another concern - should this be done vis-a-vis to boarding loc. if pt moves to another loc, enter a separate CXR entry starting on the next boarding loc date. Are we over doing these CCIs - too much work, are they needed? In the CC report, I need only a separation of CXR for HSC MICU and HSC SICU. This would not be a problem if we are handling continuous stay of MICU and SICU service in two records and not as one record in patient follow model. --JMojica 14:36, 2021 September 2 (CDT) additional decision needed from Px Date - if we do collect different dttms for each Boarding Loc then the count needs to be per Boarding Loc LOS, not overall LOS. Ttenbergen 15:52, 2021 September 2 (CDT) I am checking the sum of all counts in CCI since collectors can enter them over time, so for now I can do a cross check over overall LOS. If we want to break the cross check down further, let's discuss. Ttenbergen 16:49, 2021 September 15 (CDT)	2021-09-16 4:10:35 PM
edit	Check pre acute consistent	... unless they are discharged somewhere else entirely, like another ward. So what do we really mean with this? That they can't come from one PCH and go to another or maybe "home" after all? I realize this maybe hard to do. what I mean here is that if one is already a PCH resident, when leaving the hospital, the dispo location must be a PCH location too. or is a patient is already in CHF, the destination when leaving the hospital must either be a CHF or another PCH.	2021-02-11 6:11:08 PM
edit	Direct admit	above it seems to say these no longer need to be via ED, or does the report still only list the ED ones? Ttenbergen 09:58, 2021 September 8 (CDT) I think we might want to mention here that we capture these by Visit Admit = first service (or however else we do it) since we don't list a data based definition yet.	2021-09-08 3:00:45 PM
edit	Directors Quarterly Report (Critical Care)	Added this because CAM positive (TISS Item) refers to it. What is this report? Two reports- one is the Critical Care Quality indicator chart Report and second - from database request by STB which is being reported by month.--JMojica 15:55, 2021 September 7 (CDT) The second report you mention, is that documented as one of the Reports yet? Ttenbergen 11:10, 2021 September 8 (CDT)	2021-09-08 4:11:32 PM
edit	Check CCI CXR vs LOS	Any checks required for these?	2021-09-16 4:10:35 PM
edit	2020-04 HSC COVID unit transition	April 2020 HSC_MICU will admitted both SICU and MICU physician Service patients that are either suspect or confirmed COVID patients. No suspect or positive covid will be admitted to HSC SICU. Though MICU is a close unit the SICU patient in this unit will be under the SICU attending service physician. Depending on skill set required, sometime may be a SICU nurse or just MICU nurse. The nurse bit we will not be able to track. We need to ask Randy and Bojan how they want this tracked in Database in terms of service occupancy. Put service Loc as HSC SICU and tag in TMP as boarding location? Julie would some of the logic applied to bed board apply to how we tag this.	2021-09-02 2:20:21 PM
edit	Query check long transfer delay	At the meeting about cross checks (a long time ago) it was decided to change the cut-off to SD*3; if we want to proceed with this check, I will need values for that. Ttenbergen 23:08, 2020 October 15 (CDT)	2021-07-13 10:15:47 PM
edit	Reporting from ICD10/CCI	Different procedures would be listed with the same CCI code; will Julie easily interpret and utilize CCI codes for reporting? Do we care that we will not be able to differentiate between a Blakemore tube from an Upper GI scope with banding or hemostasis, when in CCI they both look the same: (T) Stomach, pylorus... and Control of Bleeding. --LKolesar 14:11, 2018 May 1 (CDT) discussed at task 14:08, 2018 June 20 (CDT), Julie to review what she needs and we will discuss again Ttenbergen 14:08, 2018 June 20 (CDT)	2019-03-21 4:11:32 PM
edit	Clinical Assessment Unit	Do we need to correct these old inconsistencies? Ttenbergen 11:09, 2021 May 5 (CDT)	2021-05-05 4:18:12 PM
edit	Clinical Assessment Unit	Do you care if we keep the old entries around, or do you want them converted to plain *Ward entries to show up differently in any reporting you do? If fine as is then we should set this page (and the local equivalents) to Legacy. If you want to convert, we can do that and then delete the old CAU pages.	2021-05-05 4:18:12 PM
edit	Readmission	Does the following need to be moved to one of the sub pages? Or can it be deleted, if it is only about how we used to report (vs store) data in the distant past? Legacy information (Legacy: planned surgery used to be excluded, but this stopped because of insufficient data when we stopped collecting some APACHE elements in the medicine program Dec 31, 2006)	2021-07-13 10:37:57 PM
edit	Continuous Stay	Does this use Arrive DtTm or Accept DtTm in the new schema?	2021-05-05 9:39:58 PM
edit	Check pre acute consistent	from a data perspective, what do you mean by "admitted directly"? If I were to build a check, where would I find that? OR maybe I don't need to know, but then I need to have a definition of what combination of data would be an error. Integrity check if Previous Location field ='Home' then Pre acute living situation field is either Apartment, Assisted Living,Supportive Housing,Prison / Jail / Correctional Institution or House; otherwise Error. if Previous Location field = 'Deer Lodge' or 'Riverview' or 'St Amant' then Pre acute living situation field = Chronic Health Facility; otherwise Error. if Previous Location field = 'any PCH location' then Pre acute living situation field = Personal Care Home; otherwise Error.	2021-02-11 6:11:08 PM
edit	Collection location documentation	How should we now keep track of the ward/unit info on the wiki? More questions on page.Ttenbergen 16:07, 2021 July 14 (CDT)	2021-07-14 9:36:39 PM
edit	Transfer Delay (Critical Care)	I don't quite understand this. Does it mean that, for whatever report uses this, it only considers the TRDtm+4hrs?	2021-07-22 9:30:02 PM
edit	Transfer Delay (Medicine)	I don't quite understand this. Does it mean that, for whatever report uses this, it only considers the TRDtm+4hrs?	2021-08-04 1:21:23 AM
edit	2020-05 HSC COVID unit transition	If all the covid wards are operational, how to handle the case where the patient stayed in 2 official covid wards consecutively - 1) separate records or 2)one continuous record? I think we should consider (2) as continuous. No idea what was actually done for this. Julie, could you either fill in what was done, or eliminate the question altogether? Ttenbergen 09:23, 2021 September 2 (CDT)	2021-09-02 4:20:50 PM
edit	Query check long transfer delay	If we actually want a cross check like this it needs to be based not on NTU/CTU. We could either base it on specific units or on Level of care hierarchy, ie. add another column to s_level_of_care table. Would that work for you? Ttenbergen 23:08, 2020 October 15 (CDT)	2021-07-13 10:15:47 PM
edit	Query s tmp Boarding Loc date item	if we enter unit info from Cognos, then the unit start date and time for the initial boarding loc will almost always be before the accept date and time. So I have removed that cross check for now so we can decide how we want to do this. I think we should enter the unit start from Cognos; this will be easier, less typo-prone, and it will allow us to eventually move to a system where we simply import this from Cognos possibly without human intervention (or in any case, possibly with only administrative intervention rather than from nurse data collector). It would mean treating this data differently to screen out the time on unit before service, and it would mean we can no longer cross check for this. We will need to review out cross-checks anyway, we don't have one for services yet at all. Emailing Julie for input. Regardless of the what we decide, we will need to clarify this in Boarding Loc since collectors are likely entering this first boarding slightly differently. Ttenbergen 16:48, 2020 November 6 (CST)	2021-09-02 4:25:38 PM
edit	Template:ICD10 Guideline Transplant Failure	Is "don't code history of transplant when coding transplant rejection because it's implied" something you are aware of? It's not something I would have thought of if you had asked me to write a query that lists all records with previous transplants. If we want to change this could you bring it to task meeting? Ttenbergen 16:41, 2020 January 31 (CST)	2020-04-10 3:51:51 AM
edit	Critical Care Inter-facility Transfer Report	Is semi-annual a thing? I don't see any in Reports.	2021-07-13 8:50:13 PM
edit	Director's Chart Report	Is this an evil twin of Directors Quarterly Report (Critical Care)? Ttenbergen 17:05, 2021 July 13 (CDT)	2021-09-08 4:08:14 PM
edit	LOS Medicine per hospital admission	Is this still a thing? This would now be three different profiles, right? What of pt went to surgical ward in between instead? Ttenbergen 16:33, 2021 May 5 (CDT)	2021-07-13 9:30:34 PM
edit	Requested TISS changes for the next version	Is this still relevant or required? After the changes we made to TISS 28? What is the intended use of these reports? I will add the report template so this gets drawn into relevant lists, but if we want to go ahead with it each report should be on its own page. Ttenbergen 13:22, 2021 July 5 (CDT)	2021-09-08 4:33:21 PM
edit	Form Covid rept	Julie, pls have a look at that query in CFE and let me know if it contains what we need, otherwise explain what we need. The query looks great. Just one additional request on the pivot - please make the column area to be combination of Arrived_Dt and Obs_for_Covid in order to show the trend across time. Thanks. --JMojica 08:58, 2020 April 20 (CDT) Sorry, missed this when it was written - is it still needed? Ttenbergen 16:16, 2020 July 29 (CDT) Also: will Carrier of infectious disease, unspecified need to be added? Ttenbergen 12:06, 2021 February 11 (CST)	2021-02-11 6:06:45 PM
edit	Directors Quarterly Report (Medicine)	Medicine Task Elements tasks are no longer collected, what should really be listed here?	2021-07-15 3:03:14 PM
edit	Readmission Rate to ICU	might be readmitted from Ward within or outside Winnipeg hospitals or home or nursing home can also specify to include only from any ward within the region.	2021-09-02 3:25:57 PM
edit	Manitoba Health Crosschecking Background	Need to know how this arrives to set up processing. Where will this data live? Ttenbergen 16:11, 2014 August 25 (CDT) Actually, I think you have not been getting those for ages, right? We would just need to update that. We may or may not blow away this page, depending on whether we think we will ever get this again.	2019-11-07 10:55:54 PM
edit	Created Variables Common table	Not sure why we have this field, it seems to be the same as GCS_Eye_text. Can we remove it? Ttenbergen 16:22, 2021 April 21 (CDT)	2021-04-21 7:37:10 PM
edit	Created Variables Common table	Not sure why we have this field, it seems to be the same as GCS_Eye_text. Can we remove it? Ttenbergen 16:22, 2021 April 21 (CDT)	2021-04-22 2:21:31 PM
edit	Query check long transfer delay	Requiring notes to have content is really a very soft error check... do we need to consider something better?	2021-07-13 10:15:47 PM
edit	Hospice	Still D5, or now HSC WRS3?	2021-09-02 2:44:14 PM
edit	Continuous Stay	That last line seems to be obvious in new schema from the other definitions... is AMA still at all relevant here or can it be taken out?	2021-05-05 9:39:58 PM
edit	Check pre acute consistent	The listed postal codes are correlated to the items ‘PCH’ and ‘Chronic Health facility’ of the Pre-Acute Living Situation. Since the data collectors are collecting the postal code from the patient’s address, will it be possible to automatically fill up the Pre-Acute Living Situation as PCH or Chronic Health facility if the PCH postal codes are entered or ‘other ways’ to link the two fields and make them consistent. Info about PCH is now getting more attention/request. Tina, Will this be hard to do? Any suggestions? I have changed my mind to add the PCH postal code to the Postal_Code_Master due to the possible effect on its size (when adding a new column containing text where most of the records will only be blanks). It is better to have it in separate table since this pertains to Winnipeg area only. I have added the exact address of these PCH facilities - link to table in email sent on Jan 12.18 at 1224 hrs from p:Julie Mojica Is any change to CFE still required then? If not, please remove this discussion and heading. Ttenbergen 15:47, 2019 July 4 (CDT)	2021-02-11 6:11:08 PM
edit	CT Summary Discharges FiscalYear query	The previous query said "*Data: will be counts of Completes in RecordStatus field" - why would this be only completes? Wouldn't we still report on incompletes that have dispo dttm filled in?	2021-08-26 4:09:05 PM
edit	Palliative Service	there was a question about palliation at beginning vs end of stay. It was discussed at task but never cleaned up. Could you have a look a this page? If this is all no longer an option, please delete the section. If it was resolved, then what did we decide? Or was that why we starte Comfort Care? Ttenbergen 00:01, 2018 November 27 (CST)	2021-06-10 9:20:54 PM
edit	Continuous Stay	This def of Bed holds is not consistent with the one in Bed holds; they probably should be, i.e. the same definition should be used throughout. Are they actually consistent in your program? Can we remove the detail from here and link to bed hold?	2021-05-05 9:39:58 PM
edit	Query check has service entry	This probably needs to be considered in context of Minimal Data Set - if it is part of that it changes the check time (ie for all records or only for complete records?).	2021-01-28 7:54:14 PM
edit	Continuous Stay	This will likely have changed when we eliminated the 5 minute rule for local transfers; Julie, could you confirm that this was also changed wherever it has an impact? Does this use Arrive DtTm or Accept DtTm in the new schema?	2021-05-05 9:39:58 PM
edit	Mortality and readmission report	we don't collect hospital discharge, what exactly is this?	2021-09-02 2:51:04 PM
edit	Lab identification in the DSM data	We should change this; however, do we only change it going forward or do we also re-import back data? Julie is about to re-import back data until 2019-01-01, so maybe we should reimport back data for all that far? shouldn't it be Accept_DtTm and use Arrive_DtTm if Accept_DtTm is blank. We have discussed that in the Project Boarding Loc, we can still determine the counts in between Accept_DtTm and Arrive_DtTm if needed. --JMojica 10:25, 2019 December 10 (CST) That is pretty much what I mean, it should be as you say. Do we want to do this going back in data as you re-import, or just going forward for future imports? Ttenbergen 09:41, 2019 December 11 (CST)	2021-09-02 3:28:17 PM
edit	Mortality and readmission report	what kind of "admit dttm" is this, accept, arrive, service, boarding?	2021-09-02 2:51:04 PM
edit	Medical Assistance In Dying	When we started out this dx used code U23, but then as of 2018-07-17 ICD10 actually added a code for this so we changed ours to that code. I don't really think we are interested in keeping that very early test data, so this comment can probably just go, and we can delete them. I am removing the code from our s_ICD10 table.	2021-07-15 8:51:16 PM
edit	ICU Acquired Sepsis	which dxs are used?	2020-02-12 4:56:38 PM
edit	CAM positive (TISS Item)	Which of our Reports is this; is it STB ICUs CAM Rate, VAP Rate, CLIBSI Rate Summary? Ttenbergen 13:43, 2021 July 13 (CDT)	2021-09-08 4:07:48 PM
edit	Readmission Rate to ICU	will it be "...first ICU Service Start DtTm" instead of admit date/time going forward?	2021-09-02 3:25:57 PM
edit	Mortality and readmission report	With PatientFollow, do we still do this by unit?	2021-09-02 2:51:04 PM
edit	Continuous Stay	would it make sense to take out the ICU requirement for this? The same might be rarer for Medicine patients but would still be true. I will implement Encounter processing like that for now unless I hear otherwise. Ttenbergen 12:06, 2015 January 22 (CST) Glad you put that in Tina, I was going to make a similar comment.--CMarks 12:48, 2015 January 22 (CST)	2021-05-05 9:39:58 PM
edit	L ICD10 APACHE Dx query	You and Allan discussed what should be on the list. At some point we will need to integrate the result into this query. Did you end up including Acquireds? Since the first 24hrs might include them, but they might happen later, and the difference is not clear from Dx_Date? Ttenbergen 20:20, 2018 November 24 (CST)	2020-04-02 5:02:37 PM
edit	Tracheostomy days	you requested this indicator page in one of our documentation meetings - please fill in the details or delete headings as appropriate.	2021-07-14 2:13:33 PM
edit	Hemodialysis days	you requested this indicator page in one of our documentation meetings - please fill in the details or delete headings as appropriate.	2021-07-14 2:13:36 PM
edit	2020-05 HSC COVID unit transition	You said: We need to ask Randy and Bojan how they want this tracked in Database in terms of service occupancy. Put service Loc as HSC SICU and tag in TMP as boarding location? and Tina asked Julie would some of the logic applied to bed board apply to how we tag this. Julie: is there anything from this that should be documented? If so, can you fill it in, and if not can you delete the question? Ttenbergen 09:25, 2021 September 2 (CDT)	2021-09-02 4:20:50 PM
edit	Central Line Associated Blood-Stream Infection (CLA-BSI) rate	A central lines (CL) is a central venous catheters (CVC) that terminates at or close to the heart or one of the great vessels. Great vessels include the pulmonary artery, superior vena cava, inferior vena cava, brachiocephalic, internal jugular, subclavian, external iliac and the common femoral veins. Could we link to Central Line for details instead so that if we change any they will remain consistent?	2019-08-14 12:23:04 AM
edit	Directors Annual Report (Critcal Care)	Includes ICU Inter-facility Transfers is that right? Is that ever done as a separate report? If not, why does it have its own name?	2021-07-13 9:26:53 PM
edit	Check CRF vs ARF across multiple encounters	Using the ICD10 renal codes, we still need to know when the transition from acute to chronic occurs - so we can decide whether the multiple encounters consistency checking is still relevant. --JMojica 11:51, 2018 November 14 (CST) is the transition on the next hospital stay? Example in this hospital stay, patient is diagnosed with ARF and stayed continuously in both ICU and ward in same or different hospital. On the next hospital stay, he is now chronic renal patient. Or the transition is on the next ICU or ward stay? Ex. the first stay is ICU and diagnosed with ARF. then patient was transferred in a ward of same or diff hospital - is he now a chronic renal patient? The data collection instructions are in the related pages, and additional info is in Renal Coding Considerations for ICD10, but they are a beast of a network of concepts. Those might tell you how we currently propose to collect the renal codes, but not necessarily what you or the users of the data would want. Usually these cross checks would be driven by what you need for data requests, so do our proposed instructions line up with how you want to use this? Or is this maybe too case-by-case of a concept to even make a cross check? Ttenbergen 18:59, 2019 January 6 (CST)	2019-09-16 4:30:12 PM
edit	Created Variables Common maker query	1 I have made a new query created_variables_common_maker_2021 and corresponding table. I have populated the table with data for today, but not updated the calc created button yet because this is so slow that I don't want to run new AND old routinely. I have started to do comparisons, but so far all discrepancies I have found seem to stem from data errors. Emailed Julie and Pagasa about those. Aside from that, I am putting a copy of CFE with the new query and a populated Created_variables_common_2021 and old version to ::\\ad.wrha.mb.ca\WRHA\HSC\shared\MED\MED_CCMED\CCMDB\centralized_front_end\2021-created_test How do you want to test and proceed to using the new version? Ttenbergen 16:39, 2021 May 19 (CDT) I suppose you are changing the columns from adm to ER-delay, are these correct? are you just changing the data source from L_Log to tmp service or changing how to present the LOS - by record or by each service of each record? how about the transfer delay for MED involving High obs and regular ward where there are more than one legit transfer dates - are you including that in the calculation? I just changed the source from the L_Log values to the tmp values, where available, ie they would still be by profile. If we wanted them by service it could not really go onto Created Variables as it is right now, since it outputs one line per profile. I can make queries that e.g. do LOS per service, but those would have to be different queries that would have more than one line per profile, and we would need to define them before I can build them. Ttenbergen 15:10, 2021 June 3 (CDT) I need the rest for the ALERT Score in Medicine report - these have no change, right? The only things in CV common that I changed are the ones that use start times. Ttenbergen 15:10, 2021 June 3 (CDT) Ok to roll out since you have both the old and new in CFE. I will crosscheck the entries of LOS, transfer delay, ER wait once I have completed mine in SAS and will let you know. Thanks.---JMojica 10:22, 2021 May 20 (CDT) I have rolled the change. You will have to generate the output manually by running query created_variables_common_maker_2021. Ttenbergen 15:36, 2021 June 3 (CDT)	2021-04-21 7:47:55 PM
edit	Created Variables Common maker query	1 I have made a new query created_variables_common_maker_2021 and corresponding table. I have populated the table with data for today, but not updated the calc created button yet because this is so slow that I don't want to run new AND old routinely. I have started to do comparisons, but so far all discrepancies I have found seem to stem from data errors. Emailed Julie and Pagasa about those. Aside from that, I am putting a copy of CFE with the new query and a populated Created_variables_common_2021 and old version to ::\\ad.wrha.mb.ca\WRHA\HSC\shared\MED\MED_CCMED\CCMDB\centralized_front_end\2021-created_test How do you want to test and proceed to using the new version? Ttenbergen 16:39, 2021 May 19 (CDT) I suppose you are changing the columns from adm to ER-delay, are these correct? are you just changing the data source from L_Log to tmp service or changing how to present the LOS - by record or by each service of each record? how about the transfer delay for MED involving High obs and regular ward where there are more than one legit transfer dates - are you including that in the calculation? I just changed the source from the L_Log values to the tmp values, where available, ie they would still be by profile. If we wanted them by service it could not really go onto Created Variables as it is right now, since it outputs one line per profile. I can make queries that e.g. do LOS per service, but those would have to be different queries that would have more than one line per profile, and we would need to define them before I can build them. Ttenbergen 15:10, 2021 June 3 (CDT) I need the rest for the ALERT Score in Medicine report - these have no change, right? The only things in CV common that I changed are the ones that use start times. Ttenbergen 15:10, 2021 June 3 (CDT) Ok to roll out since you have both the old and new in CFE. I will crosscheck the entries of LOS, transfer delay, ER wait once I have completed mine in SAS and will let you know. Thanks.---JMojica 10:22, 2021 May 20 (CDT) I have rolled the change. You will have to generate the output manually by running query created_variables_common_maker_2021. Ttenbergen 15:36, 2021 June 3 (CDT)	2021-06-10 7:30:24 PM
edit	Query check CCI TISS time means must be two	1 Julie had said in email: If any CCI date has a matching date on boarding loc, CCI must have at least two records (one with time and without time) if the yesterday and tomorrow have this same item. Here we are identifying missing line. Example H7-3316. Boarding loc move Dec 10 20:57 . CVC has dates Dec 9, 10,11. Dec 10 must have two lines one with time and another with time 20:57. Not necessarily... what if the CVC simply wasn’t there for the MICU portion of the switch day? Discussed with Julie: We might be able to do this as a soft check but would need to know how many false positives there would be. Also, we would not want to do this for all TISS items: for example, for intubation and extubation this would not make sense,but are there others? Ttenbergen 16:37, 2021 September 2 (CDT) Hard check on selected TISS items which are present in continuous days with a date in-between where patient is at two locations : T9 CAM+ T10 IPM T13 & 14 Vasoactive T15 Swan Ganz T16 Peripheral art line T17 CVC T18 Inv Mech Vent T20 Supp O2 T21 Non-Inv CPAP T22 ETT present T23 Trach present T36 IV hyperalimentation T38 Isolation That can still at best be a soft check. They might have discontinued the therapy in prep for discharging from ICU and then have had to re-start it as pt got worse. And coincidentally the pt was moved to other loc.	2021-09-08 4:33:15 PM
edit	TISS quality checks	1 This is a good starting place from which to discuss required TISS checks	2021-09-15 7:02:28 PM
edit	Arrive DtTm field	1 This may still be inconsistent with the dt and tm in Boarding Loc, need to make sure we all use the same instructions, and that all relevant remaining instructions get moved to Boarding Loc instead of here.	2021-09-02 2:39:26 PM
edit	Isolation, infectious	1 We have no Directors Monthly Report (Medicine) documented. Should this be Directors Quarterly Report (Medicine)?	2021-09-08 4:37:58 PM
edit	Task Team Meeting - Rolling Agenda and Minutes 2019	Actually, I think Julie decided to re-claim these from backups, no?	2021-09-08 4:22:36 PM
edit	Critical Care Regional OpPlan	Added this because CAM positive (TISS Item) refers to it. What is this report?	2021-06-15 9:38:16 PM
edit	ICU Mortality	Allan says don't include Brain death admits in the numerator or denominator ?	2019-08-14 12:16:07 AM
edit	Query s ICD10 Chapter block dxs	any other plans for these?	2019-03-27 3:28:43 PM
edit	Director's Chart Report	as in Bed occupancy?	2021-09-08 4:08:14 PM
edit	Director's Chart Report	as in Severity of illness?	2021-09-08 4:08:14 PM
edit	Change of GRA location names from "our" names to EPR/Cognos names	As per email from 2021-05-04, "The question is whether to use the generic HIGH OBS and IMCU instead of physical locations H7S or L2ME if we would like to enter the physical locations COGNOS is showing. If the decision is physical Locations – how would I know which are the high obs wards? we would have to put it in the comments, so are we any further ahead?" How does that feature into our plan to move all to Cognos values? On the same note, it appears that GRA is using two designations for PACU dependign on post-OR vs Covid use...	2021-06-10 6:40:58 PM
edit	Nursing Workload	Average or mean? Different in description and definition.	2019-08-14 12:16:07 AM
edit	CRRT Days	Based on what, CRRT, CRRT, CRRT Project?	2021-06-15 9:50:07 PM
edit	Risk factors for seizures in cardiac surgery ICU Patients	Can't find any reference to this paper. The Pubmed link instead goes to an article "A survival benefit of combination antibiotic therapy for serious infections associated with sepsis and septic shock is contingent only on the risk of death: a meta-analytic/meta-regression study." how did we support this publication?	2019-11-05 4:26:39 PM
edit	Project Borrow arrive	did they ever get back to us? no response from HSC SICU --JMojica 10:14, 2019 May 6 (CDT)	2020-08-05 7:25:06 PM
edit	ICU Var 6 - AMA	Did we transition the following into tmp or otherwise? Ttenbergen 13:58, 2017 June 6 (CDT) If we did not then this question can just be removed, but if we did move this elsewhere we should explain where to.	2020-07-25 2:27:24 AM
edit	S dispo.service type	Do you know what is the description? Especially in contrast to S dispo.loc_type. How do you use this? Please put the answer in the element_description above	2020-04-10 4:37:23 AM
edit	ICU Acquired Catheter-associated Urinary Tract Infection (CAUTI) rate	Do you mean "reported once per patient"? Because it could legitimately be duplicated in data if it happened twice, and it would now be more "per service admission" than "per patient"	2021-09-02 3:30:50 PM
edit	Created Variables CC table	does that field still make sense now with Boarding Loc?	2021-07-27 9:26:18 PM
edit	ICU Mortality	Does this also consider any of the Diagnosis implying death?	2019-08-14 12:16:07 AM
edit	LOS Medicine per hospital admission	Does this mean time spent in an ICU between wards is included in the LOS? If not, can we tweak the text so that is clearer?	2021-07-13 9:30:34 PM
edit	S dispo.service type	entries in s_dispo table might be inconsistent with entries on wiki. Which are right? These are mostly used by you for Reporting so could you please make sure wiki and dispo are consistent? Or, we could take them out of wiki if you would rather not maintain them in two places.	2020-04-10 4:37:23 AM
edit	Check pre acute consistent	How does Chronic Health Facility fit into this? Or Imprisonment/incarceration and other info in Prison / Jail / Correctional Institution?	2021-02-11 6:11:08 PM
edit	Severe Sepsis	I don't think this was ever implemented, can't find any evidence of it. Do we need it? Ttenbergen 11:04, 2018 September 25 (CDT)	2019-09-12 9:45:18 PM
edit	Severe Sepsis	I don't think this was ever implemented, can't find any evidence of it. Do we need it? Ttenbergen 11:04, 2018 September 25 (CDT)	2019-10-31 3:04:29 PM
edit	Transfer time rule	I suspect this is all legacy, we would use the proper dates and times from EPR now, right? If so I propose we delete this page without leaving a legacy entry since knowledge of this is not really required to makes sense of our data. Ttenbergen 22:08, 2020 October 15 (CDT)	2020-10-19 4:23:14 AM
edit	AaDO2	I wonder if "null" is actually intended here, or if it was supposed to be 0. Ttenbergen 14:44, 2017 January 8 (CST) AaDO2 is null if there is no data for FIO2, PaO2 and PaCO2. However, no data was set to zero value instead of null. In addition, AaDO2 and the corresponding score are required only when FIO2 >= 50%, otherwise should be treated as null. (Similarly with PO2 score, it is required when FIO2 < 50% and otherwise should be treated as null. When FIO2 =0, both AaDO2 and its score and PO2 score should be null.) Are we setting null to zero to facilitate the programming calculation? Is it possible to differentiate null from valid zero in both L_LOG and created_variables_CC - will the work be big? In L_LOG, these are the FIO2, CO2, PO2 and SerCO2. 14:49, 2017 March 16 (CDT)	2020-07-15 9:30:44 PM
edit	QA Septic Shock	If we ever pick this back up we need to answer: Is "Every entry for project QA Septic must have either a date or a time." a request for a cross check? or does that check exist already?	2019-09-16 7:43:49 PM
edit	S dispo.loc type	Indeed, what is the description? Especially in contrast to S dispo.service type; when you give the answer, please put it behind "element_description" above and delete this question.	2020-04-10 4:33:12 AM
edit	Director's Chart Report	is that Primary Admit Diagnosis only, or of all dxs?	2021-09-08 4:08:14 PM
edit	SAS application for Missing Transfer Ready Time	Is this all still a thing? If so, then since tehre is no more CCVSM what are the criteria?	2021-06-15 9:25:11 PM
edit	Severity of illness	Is this average as in description or mean as in definition?	2019-08-14 12:16:06 AM
edit	LOS Medicine per hospital admission	is this Arrive DtTm or Accept DtTm?	2021-07-13 9:30:34 PM
edit	ICU Resource Utilization - Creatinine Tests	Is this DSM Lab Extract?	2019-08-14 12:16:08 AM
edit	ICU Resource Utilization - Chest Xrays	Is this DSM Lab Extract?	2019-08-14 12:16:06 AM
edit	LOS per Critical Care Unit	Julie will fill in...	2021-06-03 9:03:15 PM
edit	Distribution of Annual and Quarterly Reports	Julie, what, is this "regional report", is it different from all sites or own site?	2021-07-13 9:40:54 PM
edit	ICU Acquired Sepsis	Just to be clear, is it number of cases (possibly >1 per pt) or once per pt as mentioned above?	2020-02-12 4:56:38 PM
edit	ICU Acquired Catheter-associated Urinary Tract Infection (CAUTI) rate	Just to be clear, is it number of cases (possibly >1 per pt) or once per pt as mentioned above?	2021-09-02 3:30:50 PM
edit	Outcomes Improvement Team Quarterly ICU Report	Mentioned on Statistician's PC page. What is this report? And most importantly, what Indicators does it use? Ttenbergen 13:36, 2021 July 13 (CDT)	2021-07-13 6:36:28 PM
edit	Length of Time for Transfer from ED to ICU within same facility	No significance in your ppt?	2019-08-14 12:16:06 AM
edit	Continuous Stay	Not sure where this is used, but using Visit Admit DtTm is likely cleaner. You back-populated that for old records, so that definition would work even for old records.	2021-05-05 9:39:58 PM
edit	ICU Acquired Sepsis	Nothing was listed in your power point, what is the significance?	2020-02-12 4:56:38 PM
edit	SAS Data Integrity Checks	Now that we have a structure for cross-checks we should add those you do in SAS to here as well, using the same structure as for those listed in Data Integrity Checks Ttenbergen 20:46, 2018 October 26 (CDT)	2018-10-30 1:48:15 AM
edit	Length of Stay (ICU Report)	Right now this is slightly inconsistent with Definition of a Critical Care Laptop Admission which doesn't explicitly exclude the ER pts. I have flagged that page for task review. Once that is done, can we just use that definition here as well to ensure consistency?	2021-04-21 8:00:06 PM
edit	ICU Acquired Catheter-associated Urinary Tract Infection (CAUTI) rate	There was no significance listed in your PPT - what is it.	2021-09-02 3:30:50 PM
edit	Check pre acute consistent	There was talk about comparing Postal Codes to known PCH Postal Codes. Since these might include other buildings at the same site that are not PCHs, this check can at best be a soft check. Please add the list of these postal codes here.	2021-02-11 6:11:08 PM
edit	Statistical Analysis	This article will likely be one of the more common landing points for external users. What do we want to tell them? Do we have any project articles we want to link in that especially highlight what we can do? ALERT Scale?Ttenbergen 22:50, 2017 June 7 (CDT)	2019-02-07 4:48:08 AM
edit	Chart Review Lists	This is linked from the front page and intended to give an idea of how one could use our data. Is there anything on Publications that would be a good example for how our DB was used for this? If not, should we take it out? With nothing here it doesn't look very good coming from front page.	2020-04-04 4:11:33 AM
edit	Pre op Admit-Cardiovasc Patient	This is not coded under ICD10 or CCI. Do we report this, and therefore need to accommodate otherwise, or how will we treat this? We have Preparatory care (incl preop optimization) but that doesn't capture the full concept. Ttenbergen 22:45, 2018 November 27 (CST)	2018-12-31 3:06:12 AM
edit	Pre-OP Admit - Research Patient - Cardiovascular	This is not coded under ICD10 or CCI. Do we report this, and therefore need to accommodate otherwise, or how will we treat this? We have Preparatory care (incl preop optimization) but that doesn't capture the full concept. Ttenbergen 22:45, 2018 November 27 (CST)	2018-12-31 3:05:46 AM
edit	Base Population for Research	This page is linked from the front page, so we should either make it good or get rid of that. Is there anything on Publications that would be a good example for how our DB was used for this?	2021-03-11 4:11:49 PM
edit	Validation against Patient Registry Data	This page was started long ago to keep track of our attempt to get access to the registry. I think it would be good to re-convene on it so we have a central point where past efforts and current efforts can be tracked. That would also make it easier to take it to task or steering and have consistent info. Do you have a log of this somewhere? We can rename it if you want.	2019-01-03 9:26:12 PM
edit	LOS Medicine per hospital admission	this still talks about TMSX... what is the new status of this field?	2021-07-13 9:30:34 PM
edit	Check VAP acquired only first encounter	We decided that VAP can actually happen in medicine if pt admitted from ICU. How would we deal with that for this check?	2019-03-26 1:57:30 AM
edit	Director's Chart Report	What are Quality Indicators?	2021-09-08 4:08:14 PM
edit	Director's Chart Report	What are Regional Indicators?	2021-09-08 4:08:14 PM
edit	Nursing Workload	What are the details?	2019-08-14 12:16:07 AM
edit	Delirium days	What are the details?	2020-12-08 3:15:40 AM
edit	Severity of illness	What are the details?	2019-08-14 12:16:06 AM
edit	ICU Mortality	What are the details?	2019-08-14 12:16:07 AM
edit	Over Census at Midnight	What are the details?	2019-08-14 12:16:07 AM
edit	ICU Interfacility Transfer	What are the details?	2019-08-14 12:16:06 AM
edit	ICU Resource Utilization - Creatinine Tests	What are the details?	2019-08-14 12:16:08 AM
edit	ICU Resource Utilization - Chest Xrays	What are the details?	2019-08-14 12:16:06 AM
edit	Length of Time for Transfer from ED to ICU within same facility	What are the details?	2019-08-14 12:16:06 AM
edit	Check pre acute consistent	what exactly do we want to check for? Please also have a look at the stuff below that doesn't specifically have your name. This requested check ties into a bunch of things and if we want the check we need to be sure that instructions stay consistent and lose ends are tied up.	2021-02-11 6:11:08 PM
edit	Resource Use	which others in Category:Indicators	2021-06-15 10:00:56 PM
edit	Night Time Discharges	Why only to wards? How about to home?	2019-05-23 3:27:59 PM
edit	QA Infection VAP	will we still need to collect this in ICD10, since I think all the data now lives in the dx codes as well. I am holding off on implementing Query s tmp QAInf tmp no dx until resolved. same reply as in QA CLI. --JMojica 12:04, 2018 December 27 (CST)	2021-06-15 9:31:51 PM
edit	Function long LOS()	Change from Service Location to Service, Boarding Loc and Transfer Ready DtTm tmp entry changed Service/Location to aggregate values for the whole stay in a program. The values used in s_dispo table for the longest likely LOS were filled with previous entries from the same program, but should likely be longer now, since an aggregate stay would on average be longer. Once we have some data with the new aggregate model we should update these values.	2021-04-15 9:34:09 PM
edit	LOS Medicine per hospital admission	p:Dr. Dan Roberts You had this as "PRESCRIBED BY: "; which is not how you set it in Template:Reporting Indicators. Also, Dan is likely no longer the user of this, so it should probably be updated. If we use a title rather than a name it will be self updating.	2021-07-13 9:30:34 PM

IT Access used

• File share HSC Critical Care
• Critical Care Sharepoint ExtraNet