Questions

From CCMDB Wiki
Jump to navigationJump to search

Lists all pages in. For those that were added with Template:Discuss it also lists the question.

Unassigned questions

There are currently 140 unassigned questions.

wiki page question Last modified
"Make B Loc" button
  • "item" needs to be filled in manually for now, but convince me that it should be automatic and I will try to think my way through it. Ttenbergen 17:19, 2020 May 21 (CDT)
2020-05-21 10:19:11 PM
2020-03 STB COVID unit transition what is STB ICU doing for suspect or positive covid patients? Will they be in the ICMS along with nocovid?Trish Ostryzniuk 17:27, 2020 May 7 (CDT) 2020-05-07 10:27:12 PM
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.
2020-05-28 3:30:17 AM
2020-04 HSC COVID unit transition
  • Have not yet checked how this will impact CFE Data Integrity Checks. Pagasa, of the top of your head which would be impacted and how?
2020-05-28 3:30:17 AM
2020-04 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. (who asked?)
    • what was the decision? Ttenbergen 10:31, 2020 May 14 (CDT)
2020-05-28 3:30:17 AM
2020-04 HSC COVID unit transition
  • Julie wrote - We should have a cut-off date for the additional covid ward D2 and MS3. As I understand these new wards are for covid positives. Once dates are confirmed, then we start collecting at D2 and MS3.
    • Currently D2 is still a suspect ward, D4 is still our only COVID + ward Lisa Kaita 17:01, 2020 April 16 (CDT)
2020-05-28 3:30:17 AM
2020-04 HSC COVID unit transition 2020-05-28 3:30:17 AM
2020-04 HSC COVID unit transition
  • Does that mean all those should be removed as s_dispo table entries? If we keep them in both linking will mess up.
    • are you using the tmp entries in linking? I use the s_dispo when I do linking. I use the tmp entries to calculate time spent in each boarding loc and home ward. --JMojica 11:03, 2020 April 15 (CDT)
      • No, not using tmp entries for linking, but if info is kept in tmp instead of new record added then the dispo entry in previous record or previous entry in next record may not match with the service location.
2020-05-28 3:30:17 AM
2020-04 HSC COVID unit transition Related to ICU, how will the patient originally at HSC_MICU then move to either H7 or A7 under the care of MICU be collected - will the move to H7/A7 be a new record or continuation? 2020-05-28 3:30:17 AM
2020-05 HSC COVID unit transition 2020-06-03 2:57:52 AM
2020-05 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.
2020-06-03 2:57:52 AM
2020-05 HSC COVID unit transition
  • Have not yet checked how this will impact CFE Data Integrity Checks. Pagasa, of the top of your head which would be impacted and how?
2020-06-03 2:57:52 AM
2020-05 HSC COVID unit transition
  • Julie wrote - We should have a cut-off date for the additional covid ward D2 and MS3. As I understand these new wards are for covid positives. Once dates are confirmed, then we start collecting at D2 and MS3.
    • Currently D2 is still a suspect ward, D4 is still our only COVID + ward Lisa Kaita 17:01, 2020 April 16 (CDT)
      • May 12.20 D2 C is no longer suspect ward. will now be ortho pts. D4 will house both suspect and +ve covid
      • May 26th.20 D4 started transitioning to accept all D medicine patients, no longer a dedicated COVID positive or suspect ward. By May 28th, this transition was completed, and all patients from D5 were moved back to D4.
2020-06-03 2:57:52 AM
2020-05 HSC COVID unit transition
  • Related to ICU, how will the patient originally at HSC_MICU then move to either H7 or A7 under the care of MICU be collected - will the move to H7/A7 be a new record or continuation?
2020-06-03 2:57:52 AM
2020-05 HSC COVID unit transition
  • We have no CCMDB.accdb Data Integrity Checks yet for Boarding Loc , so that won’t limit our options. Is this the time to add cross-checks?
    • Yes, I think we need to add now the integrity checks. See below and check if I have missed anything:
      • 1. Date_var and Time_var must not be before Accept DtTm/Arrive DtTm
      • 2. Date_var and Time_var must not be on or after Dispo DtTm
      • 3. Item should not be the same as the service_location for Medicine profile
      • 4. Item should be either ‘no borrow’ or with boarding item but must not have both
      • 5. When having a boarding location, both date and time must be present. Should not have missing time.
---JMojica 08:52, 2020 May 28 (CDT)
2020-06-03 2:57:52 AM
2020-05 HSC COVID unit transition
  • Does that mean all those should be removed as s_dispo table entries? If we keep them in both linking will mess up.
    • are you using the tmp entries in linking? I use the s_dispo when I do linking. I use the tmp entries to calculate time spent in each boarding loc and home ward. --JMojica 11:03, 2020 April 15 (CDT)
      • No, not using tmp entries for linking, but if info is kept in tmp instead of new record added then the dispo entry in previous record or previous entry in next record may not match with the service location.
2020-06-03 2:57:52 AM
2020-05 HSC COVID unit transition Depending on how we do this with tmp vs service location we may end up with linking issues and orphans; need to review. 2020-06-03 2:57:52 AM
2020-05 HSC COVID unit transition what needs to change on laptops? Trish Ostryzniuk 18:00, 2020 May 12 (CDT) 2020-06-03 2:57:52 AM
Attribution of infections
  • there may be others dx right now that my search for 48 did not find because maybe they use a 12 hr or 17 hour... rule. Collectors, can you think of any? Ttenbergen 15:38, 2020 March 25 (CDT)
2020-03-25 8:38:52 PM
Battery disposal collectors, please document what your process is at your office location.Trish Ostryzniuk 17:38, 2019 March 5 (CST) 2020-04-30 4:26:36 PM
Boarding Loc
  • I think there are now additional circumstances where we use comment field for Borrow Loc, to do with COVID moves. Could someone link in where those are documented?
2020-05-21 4:47:14 PM
Boarding Loc
  • ECIP - these are now happening, so how would we enter them?
  • EMIP - this structure could accommodate EMIPs, but the problem is
    • how do we identify then (right now people take turns at some sites...
    • which collector would collect them what service/location do we collect them as? Right now we have a special service location for these...
    • how about that "service x" at HSC?
2020-05-21 4:47:14 PM
Boarding Loc Which if any of Project_Borrow_arrive#Data_Integrity_Checks_.28SMW.29 will need to be moved over to this instead? 2020-05-21 4:47:14 PM
Cadham
  • Gladys said: "We currently do not have access to Cadham lab reports on EPR."; how do data colletors go about reviewing them?
2020-04-03 3:38:53 PM
Cadham
  • Which others?
2020-04-03 3:38:53 PM
Check pre acute consistent How does Chronic Health Facility fit into this? Or Imprisonment/incarceration and other info in Prison / Jail / Correctional Institution? 2019-09-22 4:44:32 PM
Check pre acute consistent There was a previous attempt to address some of this in Care levels in the community; this page and it need to be consistent, and consistently linked from the relevant field definitions. If we can get it short enough we might make a template to apply the instructions to each of the field pages. 2019-09-22 4:44:32 PM
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. 2019-09-22 4:44:32 PM
Cognos Admitter
  • How does this work for a patient who is discharged twice in the Cognos Report time frame of 2 weeks? Are you able to see which instance you are looking at and does it open it correctly?
    • If the Chart and Accept DtTm in your data match those in EPR / Cognos, then Cognos Admitter should show the record as green and open the correct record in Patient viewer tab Cognos ADT. If it does not, tell me. In Patient viewer tab Cognos ADT, additional lines from the Cognos data that are not part of this admission might be present; we could filter those out, but for now I figured the more the better to give context and make sense of the situation. Ttenbergen 15:31, 2020 June 2 (CDT)
2020-06-03 3:20:08 AM
Cognos Admitter
  • we can group services together to show all for a laptop with one click in the future, but I don't know enough about how collectors split and decide this to automate at this point.
2020-06-03 3:20:08 AM
Cognos Admitter
  • ... quite a few patients that are on my transfer register, that are not showing up at all on my cognos admitter. Mlagadi 11:32, 2020 May 28 (CDT)...
    • The Cognos report will always provide data up to just before midnight. If we want to use it that will be come our new frame of reference, we will be about half a day behind in our newest admissions.
2020-06-03 3:20:08 AM
Cognos Admitter
  • The patients that have already been entered on our laptop, but are being transferred back to our units, requiring a second or third admission are hard to pick out/decipher. It would be helpful to have a clear "previous location", next to an "arrive time" field on the Cognos Admitter screen, so that we could easily figure out what we are supposed to be doing with that patient. These patients are also showing up multiple times in the Admitter, adding to the confusion. I'm not sure if there is anyway to get rid of the multiple lines showing the same information?
    • Agreed, this is something that needs to be improved still. I can show previous unit or service from the Cognos data for anyone, and previous location data for patients already entered. I think the real confusion here is that we still see too many lines right now: if there are two records in cognos and two in L_Log, right now you get 4 lines as it compares (a-A), (a-B), (b-A) and (b-B). I am working on a way to not show (a-B) and (b-A), which will improve this. One of my problems is that some of the records will match on a Boarding Loc entry, not an Arrive DtTm. Ttenbergen 15:47, 2020 June 2 (CDT)
2020-06-03 3:20:08 AM
Cognos Admitter
  • The transfers out of the unit are also difficult to appreciate/easily pick up with the current layout.
    • I would expect you to find the transfers out in the Cognos Discharger instead of the admitter. And if you deal with them in there, you should not have to deal with them in here. Caveat: I am workign on a way to deal better with the Boarding Loc entries.
2020-06-03 3:20:08 AM
Cognos Admitter
  • The "Add Patient with Serial Helper" button seems to be working well if the patient is on my home unit, but if the patient is on one of the boarding locations, then the serial number helper defaults to 150 every time, and I have to manually enter in my actual number.
    • The idea is that the location gets populated automatically if it matches one of our Service/Locations. If it doesn't match, you should still be able to change it manually, and when you do, the next serial for that location should show up. If that doesn't work, let me know and I will need to find out where it goes wrong. Ttenbergen 15:49, 2020 June 2 (CDT)
      • Joanna reported the same: "Also, the way the admitter defaults to 150 makes us have to find which number we need to use next. The quickest way is to look at our paper log. Otherwise you have to close out of the admitter, enter the patient list in CCMDB, sort for last # used, then re-enter the admitter, find your patient again, and by then you’ve forgotten the next serial number! LOL! (well, not me, but I could see that being a problem!) ".
2020-06-03 3:20:08 AM
Cognos Discharger
  • How does this work for a patient who is discharged twice in the Cognos Report time frame of 2 weeks? Are you able to see which instance you are looking at and does it open it correctly? Ttenbergen 15:15, 2020 June 2 (CDT)
2020-06-03 2:27:39 AM
Cognos Discharger
  • The Cognos Discharger has very few entries-Are you trying to enter patients into this program, or are we just supposed to work with the Cognos Admitter for now?
    • The discharger will only list records where a local record exists (that should have been created through Cognos Admitter), that have a discharge date in the last two weeks, and for which discharge data (e.g. Dispo DtTm, Dispo) are not yet entered. In other words, it is only really meant to replace what you would have used the Discharge report and possibly the transfer report for before. Should anyone else be listed in tehre? If so, why, and how would you use the data? Ttenbergen 15:14, 2020 June 2 (CDT)
2020-06-03 2:27:39 AM
Confidential waste disposal collectors, please document what your process is at your office location.Trish Ostryzniuk 17:37, 2019 March 5 (CST) 2019-11-08 1:01:00 PM
Contact list Tina, could we have all the contacts on this page? I am not sure if there are existing links that we can add, but it would be nice to have phone numbers for Allan as well as the main office staff in one spot. --Jvelasco 14:41, 2020 May 4 (CDT) 2020-05-04 7:41:32 PM
Courier
  • Western is not mentioned in the Internal Medicine Wiki (See link right below question, it breaks the discussion template). Are we sure Western is still the correct answer? Ttenbergen 16:38, 2020 February 23 (CST)
    • Yes it is WM is the medical legal courier from HSC to GRACE. Trish Ostryzniuk 11:50, 2020 February 28 (CST)
  • Do we actually contact the courier? It kind of sounds below like we just send through interoffice. If so, let's rename page and take out the info about Western. We don't really need to track how the mail room does it, just how we do it.
  • No we do not contact the courier. We must put cost center on package of forms being SENT to Grace out of HSC mail room.
  • Between HSC and STB an visa versa, the mail room has daily drops and pick ups and there is no cost for sending between these two sites.
2020-03-06 7:38:08 PM
Data collection log form
  • We now have Facilitated Management of Serial numbers. This should eliminate the function of the paper forms to keep track of serials. If it doesn't, could someone please explain how the paper log is still helping with this? Ttenbergen 09:11, 2020 April 15 (CDT)
2020-04-15 2:11:47 PM
Data collector's binder
  • At STB we keep track of CLI and VAP's on a paper list in our binders for the purpose of our Quality coordinator in the hospital. Lois and I attend the STB VAP Committee meetings and need to share this information at the meeting each time (monthly). --LKolesar 10:26, 2017 July 19 (CDT)
    • Would it make sense to just notify the coordinator with this info ASAP when the VAP/CLI happens? That's what we do at STB, we use a button right in the program for it so there is very little overhead for collectors. One less thing to carry around, and the coordinator gets the info in a more timely manner... Ttenbergen 18:04, 2017 July 26 Ttenbergen 11:28, 2020 April 9 (CDT) (CDT)
    • At HSC we are supposed to email Basil Evan and 'cc' the ICU managers with identified VAPs and CLIs. We are to include the main admission diagnosis as well as the the criteria we used to identify these infections, so there is a bit of work involved in typing up these emails. --Jvelasco 12:32, 2020 April 9 (CDT)
      • Do they involve the data collector's binder, though? I was asking the question here to see if this really needs to go in the binder, hoping to have less and less in that binder over time. Ttenbergen 15:12, 2020 April 14 (CDT)
2020-04-14 8:12:27 PM
Definition of a Medicine Service admission pls update how things are now that STB_E6_B has moved to STB_A7_B; is that still true? 2020-04-14 9:03:34 PM
Definition of a Medicine Service admission We collect data on some patients who never arrive on one of our units, e.g. EMIPs. Are there any other scenarios? There was a page for the HSC off warders HSC Boarding Locations#Medicine which might help in thinking about these. 2020-04-14 9:03:34 PM
Emergency Surgery (concept) This info is from 2009 - is it still the same? 2020-04-10 1:44:48 AM
EMIP
  • I have had a couple of scenarios in the past few months that I have not considered an EMIP, but I thought I should get a second opinion: The emergency notes state that a patient from another hospital/nursing station, etc. is a "direct for internal medicine". The patient gets to our ER, and is immediately deemed too sick for the ward, and ICU is consulted. The internal medicine doctor may or may not have even laid eyes on this patient, and there is no admission order. In these cases, although the medicine doctor may have written a note about seeing the patient in the ER, they never took over care/wrote orders for the patient. How are other collectors entering these patients?Mlagadi 11:38, 2019 October 1 (CDT)
    • I think this scenario is not an EMIP since the Med doc did not took over. Did the patient go to ICU - if yes then this is an ICU admission? --JMojica 17:09, 2019 October 3 (CDT)
      • This is an interesting case because the medicine service technically accepted the patient to begin with, as they came direct to medicine, and an ER physician did not see them. If medicine sees them, then it could be considered an EMIP? but if medicine doesn't see them, who decided that the patient was too sick for the ward? and consulted ICU? if it was the ER physician than I don't think it would be an EMIP. Just my two cents, it is definitely not clear cut Lisa Kaita 11:03, 2019 October 8 (CDT)
2020-04-27 12:31:03 AM
EMIP
  • need to resolve EMIP and figure out where that info will live. Ttenbergen 11:30, 2016 December 29 (CST)
    • If a patient is still considered an ER patient in a CAU, they can potentially be an EMIP if they get accepted by internal medicine but subsequently are discharged or sent to another hospital.
      • At STB CAU contains inpatients under family Medicine (they are not under the ER physician).
        • If the CAU is considered part of ER then I guess patients that are accepted by internal medicine and go out elsewhere could be EMIP's. It depends how you view the area.
          • Is the CAU considered the same as ER or not? Management will have to determine how they want this done. Currently no one at STB collects data at all on the patients in the CAU. --LKolesar 11:49, 2017 October 27 (CDT)
2020-04-27 12:31:03 AM
EPR Lists Are these the manual lists where you have to add patients? Instructions almost look like it's a counterpart to EPR Reports instead. Are these even still available? What are the advantages / disadvantages for this vs EPR Reports? 2019-10-23 10:19:51 PM
EPR Lists who uses this?
  • uses:
    • names?
  • doesn't use:
    • names?
2019-10-23 10:19:51 PM
EPR Lists Would it be correct to say that the lists are manually populated based on EPR Reports? 2019-10-23 10:19:51 PM
EPR Reports Integrator
  • Noted that after using Reports Integrator upon return to ccmdb list, the find patient function screen freezes and does not work. To remedy, the collector has to exit from ccmdb entirely and restart ccmdb, then the find patient function will work. (Pam)
    • emailed Pam to set time for next week to have her show me this. Ttenbergen 14:34, 2020 May 29 (CDT)
2020-06-01 11:43:39 AM
Error: There isn't enough free memory to update the display. Close unneeded programs and try again. Please enter your laptop and under what circumstances you have seen this error below. 2019-07-29 9:12:04 PM
Exporting EPR Reports for EPR Reports Integrator
  • Filter the report; Val/Michelle, could you provide details for what filtering you used for this, if it is other than what was given in those three pages? If same just take out question....
2019-11-14 12:17:56 AM
Facilitated Management of Serial numbers
  • As people are testing Cognos Admitter and "Add Patient with Serial Helper" button, I am hearing that there are two ways to generate the next Serial number. Some use a serial pool per Service/Location, and some use one serial pool for everything on their laptop. There might be a third option where some service locations are pooled but there also is a second pool for another service location. This makes automation or vacation coverage problematic. Could you please fill in what you do on your laptop?
2020-06-03 3:17:43 AM
Facilitated Management of Serial numbers
  • Looks like HSC_WRS3 uses negative and possibly decreasing serial numbers. That would throw a wrench into automatic number suggestion. Is this a usual thing or just something to solve problems generated by the COVID moves?
2020-06-03 3:17:43 AM
Facilitated Management of Serial numbers
  • Would anyone see a problem if we standardized this to using one serial number pool per laptop? What would be the problems? Ttenbergen 19:55, 2020 June 2 (CDT)
2020-06-03 3:17:43 AM
First Annual Baking Event if you have a recipe you would be willing to share, please post it here. 2019-12-17 7:25:11 PM
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)
2020-04-21 9:37:38 PM
GRA 2S
  • Is there workload splitting for this location?
2020-05-05 8:11:42 PM
GRA 2S
  • Will that also be used for this location?
2020-05-05 8:11:42 PM
GRA Boarding Locations
  • PACU? Anything else?
2020-01-31 8:16:29 PM
GRA ER use as borrow location
  • Do we need to add the option to track these for other sites?
    • this is an ER wait/delay case and not to be included in the Project Boarding Loc. The ECIP case is a whole stay in ER but under the Critical Care attending Physician.
2020-04-01 7:31:21 PM
GRA ER use as borrow location 2020-04-01 7:31:21 PM
GRA ER use as borrow location
  • There is a strange thing going on at the Grace that leads to situations similar to ECIP.... Made this page to consolidate details here.
2020-04-01 7:31:21 PM
GRA ER use as borrow location Do we need to change our EPR Report / identification process to make sure we capture these? Just for Grace or for all sites? 2020-04-01 7:31:21 PM
GRA General Collection Guide
  • emailed Grace collectors to please update here Ttenbergen 21:39, 2020 April 5 (CDT)
  • pls also see next heading
2020-04-06 2:42:23 AM
GRA General Collection Guide
  • is this what you would enter as "GRA Ambulatory Care"? Or how do you enter this? Ttenbergen 21:42, 2020 April 5 (CDT)
2020-04-06 2:42:23 AM
GRA General Collection Guide march 25.20 - p:Stephanie Cortilet, what was the process at Grace to get printer paper? 2020-04-06 2:42:23 AM
GRA Medical Records requests Is there anything else a collector new to GRA would need to know to do this right so we don't lose the good will of MedRec tehre? Ttenbergen 13:58, 2019 December 11 (CST) 2019-12-11 8:02:25 PM
GRA Medicine Collection Guide
  • CTU vs NTU
2020-04-10 1:52:50 AM
GRA Medicine Collection Guide 2020-04-10 1:52:50 AM
GRA Medicine Collection Guide Steph's no longer at GRA, so is this stuff up-to-date? Ttenbergen 20:52, 2020 April 9 (CDT) 2020-04-10 1:52:50 AM
GRA PACU Leaving content from GRA_MICU for now although this is almost certainly wrong, could someone please clean it up? 2020-04-16 4:17:49 PM
Grace Hospital Contacts Where is that form? Is there a link? 2020-01-02 2:15:10 AM
Grace Hospital Office Staff have moved into new office space effective March 27.20. p:Lisa Kaita, would not have key to new office, they would have to turn in old keys and get new ones? *Please let Trish know and update Wiki that old keys turned in and new ones obtains. Trish Ostryzniuk 14:07, 2020 March 27 (CDT) 2020-04-04 11:15:38 PM
HD (Hemodialysis)
  • I need clarification on this one-if a patient is either dialysed in Emerg, or on a different ward, (ie. anytime during the current hospitalization prior to coming to your area), are we to enter this only as an admit CCI?Mlagadi 10:26, 2019 February 11 (CST)
    • Please have a look at Admit Procedure, it should explain whether to code a procedure or not. There is no explicit exception for Dialysis. If the info there does not give you the answer you need, please elaborate. If the info is there, then, would you have looked there? How can we make clearer to look there? Ttenbergen 11:53, 2019 February 13 (CST)
2019-02-13 5:53:56 PM
Health Sciences Center Office
    • Does Iris Deleon have a key?
2019-11-07 9:21:16 PM
Health Sciences Center Office
    • Joanna Velasco - I have a key, but it doesn't work on any of the cabinets in the office.
      • Is that still true? Have you talked with Trish?
2019-11-07 9:21:16 PM
Health Sciences Center Office
    • Lori Lovell - now that she's part time does she really still have a key?
2019-11-07 9:21:16 PM
Hospice 2020-04-10 4:32:49 AM
HSC A7 MI Please fill in 2020-04-08 4:36:27 PM
HSC A7 SI Please fill in 2020-04-08 4:36:30 PM
HSC B2 C
  • I made the page, but know nothing about this unit, could someone update? Ttenbergen 22:57, 2020 May 27 (CDT)
2020-05-28 4:58:58 PM
HSC Boarding Locations 2020-04-09 10:08:22 PM
HSC EMIP
  • Is this still the same split with understaffing? Ttenbergen 11:33, 2020 April 9 (CDT)
2020-04-09 4:33:11 PM
HSC H7 MI Please fill in 2020-04-08 4:36:32 PM
HSC H7 SI Please fill in 2020-04-08 4:36:17 PM
HSC MICU Collection Guide
  • I have spoken to the clerks in MICU and they do order their own TISS forms and Green sheets. Is it not possible to have SICU and IICU order their own as well? --Jvelasco 11:57, 2020 February 28 (CST)
    • will check this out with Pagasa and printshop. If we made changes to the form then unit would not get most current. Trish Ostryzniuk 14:44, 2020 February 28 (CST)
    • Which Cost Center they are charging to?
      • I do not know. --Jvelasco 15:14, 2020 April 7 (CDT)
2020-04-26 11:32:59 PM
HSC MICU Collection Guide Another question: Since we are not to go to the units during the COVID outbreak, how do we supply the ICU's with TISSs and Green sheets? For sure SICU and IICU will need to be restocked. MICU seems to restock their own according to the ward clerks, but that does not seem to be verified so far...--Jvelasco 15:14, 2020 April 7 (CDT)
  • when was the last time you request TISS form for SICU or IICU guys? Pagasa say HSC has not requested any for long time since Oct 2019 actually. Trish Ostryzniuk 17:19, 2020 April 15 (CDT)
    • We do not request TISS forms/Green sheets for SICU or IICU. We go to your office and Pagasa gives us a stack of both. Or we email Pagasa when the supply is running low in our office, she brings them here and we then deliver some to both units. --Jvelasco 13:26, 2020 April 17 (CDT)
2020-04-26 11:32:59 PM
HSC MS3 Please fill in 2020-04-08 4:36:25 PM
HSC Unknown Service
  • So if Lisa had to cover for one of you while you are aware, how would she know which ones to pick up. Do you have a method for splitting these?
2020-01-30 10:28:50 PM
HSC WRS3
  • Will this location profile be identical to what HSC_D5 was before?
2020-04-07 6:50:43 PM
Iatrogenic, infection, central venous catheter-related bloodstream infection (CVC-BSI, CLI) 2020-06-02 6:59:20 PM
Identifying ICU admissions
  • what are those plans? Are we still planning to? Ttenbergen 09:31, 2016 November 10 (CST)
2020-04-15 4:00:00 PM
Identifying ICU admissions
  • What is this Affinity software, is it another name for the EPR or is it a separate tool?
2020-04-15 4:00:00 PM
Identifying ICU admissions 2020-04-15 4:00:00 PM
Identifying ICU admissions
  • Grace, are collectors now able to use EPR Reports to generate own transfer, admit and discharge reports?Trish Ostryzniuk 11:35, 2016 May 20 (CDT)
    • no access to ERP reports yet to generate our our listsMschaffer 08:57, 2016 May 31 (CDT)
    • we can print reports but are still looking for a way to find service transfers while in ER
2020-04-15 4:00:00 PM
Identifying ICU admissions multiple questions, especially for HSC and GRA 2020-04-15 4:00:00 PM
Identifying patients in boarding locations 2020-01-31 8:20:38 PM
Identifying patients in boarding locations We need to make sure nothing in here is inconsistent with the following: 2020-01-31 8:20:38 PM
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)
2020-05-14 7:39:29 PM
MediaWiki:Common.js ", post: " 2020-04-02 5:06:12 PM
Notes field
  • track all lab and pharmacy manually, the notes save time in that it eliminates the need to go back & recount.
    • would you not just enter a new line for these, and the date of the new line would tell you how far you got? Ttenbergen 14:24, 2014 September 19 (CDT)
2020-04-02 4:38:27 PM
Patient viewer tab Cognos ADT
  • as this matures we might be able to filter further to show less data in there. talk to me if that's a priority Ttenbergen 17:36, 2020 May 21 (CDT)
2020-06-02 9:04:24 PM
Patient viewer tab Cognos ADT
  • I feel like this tab has a lot of useful information, and functions that I am unaware of. We probably need to discuss this page more, so that we can figure out what the info on this page is supposed to tell us, and iron out the layout to make it more readable.
    • Yes, it needs more work. I think the biggest part will be to decide which lines can be omitted. To start with, each line contains a snapshot of all data for the current entry. So, it re-iterates that the pt came from ED, and when they were accepted, even if the current line is there because there is a change in unit and the ED and service info is temporarily irrelevant. We could group this data differently to not re-iterate things like Visit Admit DtTm, but we sometimes have weird things like a service changing without a location changing, and the more I hide detail and make this pretty, the more likely weird scenarios like that will lead to a view that makes even less sense. I will work on something somewhat easier to look at. Ttenbergen 16:04, 2020 June 2 (CDT)
2020-06-02 9:04:24 PM
Patient viewer tab Cognos ADT
  • ...I tried to enter a boarding location on a patient by hitting the "make B loc" button, and nothing seemed to happen. I just visited the WIKI page on that now, and it does state that it still needs to added manually-I don't understand why there is an option to press this button at all then?
    • The button should create a line with the date and time and the project pre-populated. You need to fill in the Item (ie location your ward or boarding ward), because I am not yet sure how I would extract that directly from the Cognos data, especially with all the special cases due to covid moves right now. I figured only having to change that dropdown, with the full story listed right below, would be easier than re-keying it manually. Now, if that button does not even generate the Boarding Loc line for you, that is a different matter and I would have to troubleshoot that.
2020-06-02 9:04:24 PM
PatientFollow Project
  • The list would need to be exported on a regular basis and then made available to collectors. How would this best be done?
  • There was talk about EPR lists to help collectors keep track of their patients. If we use that method then how will we handle it when there needs to be coverage?
  • How do we make sure no pts are missed?
  • How do we make sure no pts are duplicated?
2019-11-09 5:40:24 PM
PatientFollow Project
  • It should be questioned then whether amalgamating all data collection units within a site for example there are 4 medicine collection units at STB + EMIPs how to possibly track and reconcile all these lists with any semblance of accuracy. This would be a very labor/time intensive and complicated process, as well as a significant logistical challenge. Use of EPR lists to create further lists/spreadsheets in Excel seems redundant and a risky proposition in terms of inclusion and accuracy. There are also potential PHIA considerations whereas patient information on laptops is currently stored/accessed through a separate program, what are the implications for "personal" and/or redundant storage of patient information on data collector accounts? Pamela Piche 10:19, 2019 September 5 (CDT)
2019-11-09 5:40:24 PM
PatientFollow Project The potential to either, have multitudes of patients duplicated, or more importantly, patients missed seems astronomical. Inadvertently duplicating patients will end up being way more work for data collectors. How will we, as data collectors even know that we have duplicated a patient that another data collector has already done? Or conversely, how will we know if we have missed a patient? 2019-11-09 5:40:24 PM
PHIN field
  • With Cognos EPR Report we now get PHINs from out of province with province prefix; do we want to start collecting these for out-of-province patients for cleaner matching, and to enable better matching for external users of our data such as MCHP?
  • sure. will this affect any of the query? the data type will become text if you will add the province prefix. --JMojica 19:03, 2020 April 5 (CDT)
2020-04-06 12:03:01 AM
PL missing L Tables content Have there been more since? 2019-12-11 10:21:47 PM
PL missing L Tables content Have there been more since? 2020-05-05 9:53:39 PM
Previous Service field
  • As per last Task Meeting - is this correct or do we need to discuss further? --Jvelasco 14:39, 2019 June 26 (CDT)
    • Good question. 6 months later, what do people think?
2020-04-02 4:42:57 PM
Project Borrow arrive
  • Trish said " Legacy - need to get updated in master database change to all borrow arrive to boarding Loc instead of 2 different things that mean the same things now is main database. Julie had mentioned but can be done later. "
    • Trish, what do you mean by that? Ttenbergen 10:52, 2020 May 14 (CDT)
2020-05-14 8:28:55 PM
Project Discharge Documentation I could set up a query in CFE to dump this to keep it off Julie's desk. This user might find speed more important than quality? If needed, let me know. 2020-05-06 2:18:46 AM
Project Discharge Documentation Will these documents be retained on charts once they hit med records? 2020-05-06 2:18:46 AM
Query check long transfer delay
  • Requiring notes to have content is really a very soft error check... do we need to consider something better?
2019-09-22 5:01:48 PM
Query check long transfer delay 2019-09-22 5:01:48 PM
Query check long transfer delay At the meeting about cross checks it was decided to change the cut-off to SD*3; will need to get that from Julie if we ever address the other questions. 2019-09-22 5:01:48 PM
Query Import request matcher This one is fairly easy, Pagasa will try to make it. 2019-05-15 5:39:43 PM
Query Import request matcher This one is fairly easy, Pagasa will try to make it. 2020-05-05 9:53:45 PM
Query s tmp Bording Loc sensible DtTm vs no borrow
  • This cross check had been disabled for Borrow Arrive because there were many errors: check was disabled in VBA with comment "2019-01-24 disabled for now because too many errors". I think we were concerned at the time because of high workload and fresh ICD10/CCI and didn't want to analyze and fix then. We will need to review what this should be to get an acceptable number of errors only.
    • Are we ready to have a cross check for this that requires either
      • no borrow and a checkbox and no time
      • at least one borrow location and a time
2019-09-25 10:25:25 PM
Requested CCMDB changes for the next version 2020-04-10 3:44:35 AM
Resource Use do we have a counterpart like Avoidable Days in Medicine? 2019-11-05 4:25:07 PM
Resource Use which others in Category:Indicators 2019-11-05 4:25:07 PM
STB A7 B I have left this info as it was on E6; does any of it change in the new unit? 2020-04-06 9:47:11 PM
STB ACCU Collection Guide
  • Is this still done? How does this actually impact collection, ie why would these pts be marked so?
2020-05-05 7:05:34 PM
STB B5 If you check Definition of a Medicine Service admission is that still true? Ttenbergen 21:07, 2018 November 24 (CST) 2020-05-26 2:09:16 PM
STB Boarding Locations
  • Any other boarding locs for STB Med?
2020-05-05 7:05:36 PM
STB Boarding Locations
  • PACU? Anything else?
2020-05-05 7:05:36 PM
STB E5 Is that exception about radiology still true? Ttenbergen 21:03, 2018 November 24 (CST) 2020-01-07 1:30:01 PM
STB E6 C This is probably all wrong now, please update 2020-03-30 4:37:34 AM
STB Electronic Patient Record
  • "...Also, the "APACHE" score for medicine is not dependent upon the first 24 hours of vital signs and labs so exact accuracy here is less important. --LKolesar 06:44, 2019 October 24 (CDT)"
    • We don't do an apache score for medicine at all, so I am not sure what you mean here. AFAIK the instructions how to collect e.g. WBC are the same for medicine and ICU, no? In any case, I think it's separate from the purpose of this page, how EPR is used at STB. If you agree, can you please take out this whole Discussion? Ttenbergen 11:31, 2019 October 30 (CDT)
2019-10-30 4:31:42 PM
STB Medical Records requests If I was a new collector, how would I find that shelf? 2020-05-05 7:05:36 PM
STB Medicine Collection Guide
  • Does that mean any pt who is in a boarding location, regardless of service, will be on the S4 Laptop? Or that the wards collected on S5, S6 don't have off-ward patients collected? How does that work for Julie's reporting?
2020-05-21 6:40:50 PM
STB Medicine Collection Guide will any med collectors be on site at intervals like STB_Critical_Care_Collection_Guide#IMPORTANT_INFORMATION_DURING_COVID_PANDEMIC? 2020-05-21 6:40:50 PM
STB Medicine Workload splitting 2020-05-26 2:24:20 PM
STB MICU Collection Guide
  • With the new instructions for Contacting Quality Officer and Manager for VAPs and CLIs, can we discontinue that sheet? We should not be retaining patient info once we are done dealing with it. Ttenbergen 10:26, 2017 September 18 (CDT)
    • Basil Evan , QI officer, is asking that perhaps a worksheet be submitted to him regarding which criteria were met for either VAP for CLI when collector make determination from chart. Perhaps we could make a checklist in TMP instead in regards to which criteria are met for these two special projects instead of paper worksheets that are different at each collection site? Suggestions? --Trish Ostryzniuk 17:14, 2018 November 19 (CST)
    • added to tmp was abandoned. Trish Ostryzniuk 18:46, 2019 February 4 (CST)
      • Emailed Trish "What do you mean by was abandoned, the question or the project or the paperwork?" Ttenbergen 22:29, 2019 February 5 (CST)
2020-05-05 7:05:35 PM
Switching to a single serial pool per laptop
  • Do you think there would be a problem with your collection work flow if you moved to automatically assigned serials from a single number pool? Are there processes identifying patients or similar (ie processes that are not on the laptop) that would be confused by this? Ttenbergen 21:16, 2020 April 26 (CDT)
    • The only problem that I can see is that the numbers help us figure out which patients are in High Obs, or which patients are EMIP's. We could fix that problem by entering a location in the Record field.Mlagadi 07:50, 2020 April 27 (CDT)
      • Due to space restrictions we initially didn't include the location as a column on the Patient List, but we did set up colors per unit. I just realized I didn't initially document this on the wiki, but I now have, see Patient_List#Row_colours_on_Patient_List. Would that be an alternative to using the serial to figure out the unit? Ttenbergen 12:11, 2020 April 28 (CDT)
      • I could also add a button to sort by unit, even if it's not displayed. Let me know if that would be helpful. Ttenbergen 12:11, 2020 April 28 (CDT)
2020-04-29 9:30:20 PM
Switching to a single serial pool per laptop
  • Moving here from a page where it didn't fit in:
  • "One more point, D5 & B3 use consecutive numbers also. These would be hard to keep track of without a paper log for the really quick admissions & discharges that are sometimes seen on B3.--CMarks 13:22, 2012 October 1 (CDT)"
    • Iris, is that still a thing, and will it make any difference if we change these to a single pool? If not, please remove this discussion. Ttenbergen 16:30, 2020 April 29 (CDT)
2020-04-29 9:30:20 PM
Task Team Meeting - Rolling Agenda and Minutes 2020 2020-06-03 1:39:41 AM
Task Team Meeting - Rolling Agenda and Minutes 2020
  • Will this mean entering and possibly later changing Service/Location and therefore D_ID of patient records?
2020-06-03 1:39:41 AM
Ward admission log forms Which sites still use the ward logs? 2019-09-22 5:02:20 PM

All questions

There are currently 335 questions.

wiki page who question
"Make B Loc" button all
  • "item" needs to be filled in manually for now, but convince me that it should be automatic and I will try to think my way through it. Ttenbergen 17:19, 2020 May 21 (CDT)
2020 TISS audit Task "If adequate (>90% or so), then cease having our collectors do TISS" Who should we report to about fidelity, and in what format?
2020 TISS audit Task
  • This was the initial idea, but then we discussed TISS form audit; where do we want to go with this?
2020 TISS audit Task How will we keep the survey TISSes separate from the other ones? Would an "A" at beginning or end of the location on the TISS sheet work for our processes?
2020 TISS audit Task this is mentioned in many bits of documentation, and we will need to clean those up.
2020 TISS audit Task Task_Team_Meeting_-_Rolling_Agenda_and_Minutes_2019 discussed that routine review of TISS sheets will stop, but we will need to audit the results of this.
2020-03 STB COVID unit transition all what is STB ICU doing for suspect or positive covid patients? Will they be in the ICMS along with nocovid?Trish Ostryzniuk 17:27, 2020 May 7 (CDT)
2020-04 HSC COVID unit transition all
  • 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.
2020-04 HSC COVID unit transition all
  • Have not yet checked how this will impact CFE Data Integrity Checks. Pagasa, of the top of your head which would be impacted and how?
2020-04 HSC COVID unit transition all
  • 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. (who asked?)
    • what was the decision? Ttenbergen 10:31, 2020 May 14 (CDT)
2020-04 HSC COVID unit transition all
  • Julie wrote - We should have a cut-off date for the additional covid ward D2 and MS3. As I understand these new wards are for covid positives. Once dates are confirmed, then we start collecting at D2 and MS3.
    • Currently D2 is still a suspect ward, D4 is still our only COVID + ward Lisa Kaita 17:01, 2020 April 16 (CDT)
2020-04 HSC COVID unit transition all
2020-04 HSC COVID unit transition all
  • Does that mean all those should be removed as s_dispo table entries? If we keep them in both linking will mess up.
    • are you using the tmp entries in linking? I use the s_dispo when I do linking. I use the tmp entries to calculate time spent in each boarding loc and home ward. --JMojica 11:03, 2020 April 15 (CDT)
      • No, not using tmp entries for linking, but if info is kept in tmp instead of new record added then the dispo entry in previous record or previous entry in next record may not match with the service location.
2020-04 HSC COVID unit transition all Related to ICU, how will the patient originally at HSC_MICU then move to either H7 or A7 under the care of MICU be collected - will the move to H7/A7 be a new record or continuation?
2020-05 HSC COVID unit transition all
2020-05 HSC COVID unit transition all
  • 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.
2020-05 HSC COVID unit transition all
  • Have not yet checked how this will impact CFE Data Integrity Checks. Pagasa, of the top of your head which would be impacted and how?
2020-05 HSC COVID unit transition all
  • Julie wrote - We should have a cut-off date for the additional covid ward D2 and MS3. As I understand these new wards are for covid positives. Once dates are confirmed, then we start collecting at D2 and MS3.
    • Currently D2 is still a suspect ward, D4 is still our only COVID + ward Lisa Kaita 17:01, 2020 April 16 (CDT)
      • May 12.20 D2 C is no longer suspect ward. will now be ortho pts. D4 will house both suspect and +ve covid
      • May 26th.20 D4 started transitioning to accept all D medicine patients, no longer a dedicated COVID positive or suspect ward. By May 28th, this transition was completed, and all patients from D5 were moved back to D4.
2020-05 HSC COVID unit transition all
  • Related to ICU, how will the patient originally at HSC_MICU then move to either H7 or A7 under the care of MICU be collected - will the move to H7/A7 be a new record or continuation?
2020-05 HSC COVID unit transition all
  • We have no CCMDB.accdb Data Integrity Checks yet for Boarding Loc , so that won’t limit our options. Is this the time to add cross-checks?
    • Yes, I think we need to add now the integrity checks. See below and check if I have missed anything:
      • 1. Date_var and Time_var must not be before Accept DtTm/Arrive DtTm
      • 2. Date_var and Time_var must not be on or after Dispo DtTm
      • 3. Item should not be the same as the service_location for Medicine profile
      • 4. Item should be either ‘no borrow’ or with boarding item but must not have both
      • 5. When having a boarding location, both date and time must be present. Should not have missing time.
---JMojica 08:52, 2020 May 28 (CDT)
2020-05 HSC COVID unit transition all
  • Does that mean all those should be removed as s_dispo table entries? If we keep them in both linking will mess up.
    • are you using the tmp entries in linking? I use the s_dispo when I do linking. I use the tmp entries to calculate time spent in each boarding loc and home ward. --JMojica 11:03, 2020 April 15 (CDT)
      • No, not using tmp entries for linking, but if info is kept in tmp instead of new record added then the dispo entry in previous record or previous entry in next record may not match with the service location.
2020-05 HSC COVID unit transition all Depending on how we do this with tmp vs service location we may end up with linking issues and orphans; need to review.
2020-05 HSC COVID unit transition all what needs to change on laptops? Trish Ostryzniuk 18:00, 2020 May 12 (CDT)
AaDO2 Julie 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)
ABG Data Allan z
  • Identified as something we should do to streamline data collection. I have made this page to document progress toward this import. Blood gas data is in DSM listing; need to compare to see if we can use it
Acquired Diagnosis / Complication Allan
Admit Diagnosis Allan Como Admit Acquired Primary Limits - this is part of that discussion - if we limit which admits will count as comos we need to review
Admit Procedure Allan May be inconsistent with Task_Team_Meeting_-_Rolling_Agenda_and_Minutes_2020#ICU_Database_Task_Group_Meeting_-_February_12.2C_2020, what do we actually want here?
ARF (APACHE) Task
  • I have a patient with GFR 12, but not yet on HD at home. She came in septic, in AKI, which lead to a new start of HD during this admission. I entered CKD stage 5 in comorbs, AKI in admits, but it won't allow me to enter "YES" for ARF (APACHE), and "4CRF-sevr" under CHRONIC in APACHE. The definitions of chronic and acute renal failure are different for ICD10 and APACHE, so I am confused. What is the correct way of doing the APACHE for this patient? --Jvelasco 10:34, 2020 May 21 (CDT)
Attribution of infections all
  • there may be others dx right now that my search for 48 did not find because maybe they use a 12 hr or 17 hour... rule. Collectors, can you think of any? Ttenbergen 15:38, 2020 March 25 (CDT)
Attribution of infections Julie
  • Julie, the above question specifically affects some projects you work with as well - do you think unifying this rule will be a problem for any of them?
  • if there are specific rules already in place (e.g. VAP, CLI, etc.) we should follow them. Those which don't have perhaps those are the ones we can unify. --JMojica 14:51, 2020 March 20 (CDT)
Attribution of infections Task
  • What is the attribution rule for our program on MRSA colonization? For example if a patient comes from SOGH ICU to the Concordia and tests positive for MRSA in less than 24 hours I would attribute this colonization to the SOGH not the Concordia. Is that correct?
    • If we will have such a rule at all, could it be one that applies to infections in general and would therefore live in Template: ICD10 Guideline Infection. Also, we would want to make sure that "attribution" as a concept doesn't get muddled - if we search for that there are several hits, and we use other terms like "gets credit" elsewhere I believe. And in Lab and culture reports...
      • Allan confirmed that all the attributions should be the same and can be moved into that infection template. Ttenbergen 14:09, 2018 October 29 (CDT)
Does anyone think making this one rule for all will be a problem?
Base Population for Research Julie 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?
Battery disposal all collectors, please document what your process is at your office location.Trish Ostryzniuk 17:38, 2019 March 5 (CST)
Bed borrow Task Wouldn't "medicine borrows a ICU bed for Cardioversion" be a case of Bed holds instead of a borrow? Same for several others above...
Bed Census Data Processing Instructions Pagasa
  • copy the database back up to the server
    • which server?
Bed Census Data Processing Instructions Pagasa
  • probably incomplete... Ttenbergen 18:17, 2016 April 14 (CDT) emailed Trish/PAgasa Ttenbergen 16:46, 2018 October 30 (CDT)
Bed Census Data Processing Instructions Pagasa
  • is this the current process, or is Bed_census.mdb? I think the process is better off here than in the .mdb article.
Bed Census Data Processing Instructions Pagasa what is the purpose of having clerk processing this data?
  • quality control?
  • preparing for reports?
  • ?
Bed holds Julie Julie seems to set the limit at 1 day - emailed Julie Ttenbergen 10:07, 2016 November 10 (CST)
Bed occupancy Julie Is this about Bed census.mdb or a different thing?
Bed occupancy Julie with TMSX not having been around for a while, is this still relevant? Do you provide this data otherwise? Do we need to implement this?
Blood Product Data Allan z
  • Identified as something we should do to streamline data collection. I have made this page to document progress toward this import.
Boarding Loc all
  • I think there are now additional circumstances where we use comment field for Borrow Loc, to do with COVID moves. Could someone link in where those are documented?
Boarding Loc all
  • ECIP - these are now happening, so how would we enter them?
  • EMIP - this structure could accommodate EMIPs, but the problem is
    • how do we identify then (right now people take turns at some sites...
    • which collector would collect them what service/location do we collect them as? Right now we have a special service location for these...
    • how about that "service x" at HSC?
Boarding Loc all Which if any of Project_Borrow_arrive#Data_Integrity_Checks_.28SMW.29 will need to be moved over to this instead?
Cadham all
  • Gladys said: "We currently do not have access to Cadham lab reports on EPR."; how do data colletors go about reviewing them?
Cadham all
  • Which others?
CAM positive (TISS Item) Julie
  • Did these ever get better? Ttenbergen 12:44, 2017 May 11 (CDT) Does anything need to be done about this? Ttenbergen 20:15, 2018 November 27 (CST)
Care levels in the community Julie
  • There usually isn't much info in the charts about the "type" of group home or level of care provided there, so in those cases we have been coding "other - known but not listed". Please clarify --Jvelasco 13:47, 2019 September 4 (CDT)
    • Julie, how do we use this, and how should this be coded in unclear cases? If you are not sure about the answer either, could you bring it to Task?
CCI Volumes 2019 Task There have been concerns about the volume of work generated by CCI entries. Since we had already reduced certain entries earlier in 2019, the numbers referenced here are only for pts admitted during the third quarter of 2019.
CCMDB.accdb Change Log 2020 Task pop-up hints on Pharmacy screen - need to deal with, emailing ICU Task Team
Central Line Associated Blood-Stream Infection (CLA-BSI) rate Julie
    • 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?
Changing D IDs Pagasa
  • what queries would get you to change a D_ID for medicine? We would want to cross-link them so they point to these instructions, and so these instructions can list them as cause.
Changing D IDs Pagasa
  • what queries would get you to change a D_ID? We would want to cross-link them so they point to these instructions, and so these instructions can list them as cause.
Changing D IDs Pagasa
  • Which program do you do this in? This may actually need to be different instructions for different scenarios.
Changing D IDs Pagasa How about L TISS Form table, L TISS Item table and L Labs DSM table? Are there others I am not thinking about ? Ttenbergen 22:20, 2019 February 6 (CST)
Charlson Comorbidity Index Julie Is that the Annual report?
Chart Review Lists Julie 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.
Check CCI CXR vs LOS Julie would we not use Accept DtTm here? Because we could have CXRs on days before arrival...
Check CRF vs ARF across multiple encounters Julie
  • 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)
    1. 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.
    2. 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)
Check ICD10 some cant be primary Allan Como Admit Acquired Primary Limits - Category:Mechanism would need to be excluded as well, and so would past history, and quickly the list gets so large again that we are back at discussing Controlling Dx Type for ICD10 codes where we should simply include "Primary"-ability.
  • AG OBSERVATION --- we will just take care of this when we take care of Admit/Comorbid/Acquired
Check pre acute consistent all How does Chronic Health Facility fit into this? Or Imprisonment/incarceration and other info in Prison / Jail / Correctional Institution?
Check pre acute consistent all There was a previous attempt to address some of this in Care levels in the community; this page and it need to be consistent, and consistently linked from the relevant field definitions. If we can get it short enough we might make a template to apply the instructions to each of the field pages.
Check pre acute consistent all 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.
Check pre acute consistent Julie
  • ... 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.
Check pre acute consistent Julie
  • 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

Check pre acute consistent Julie
  • 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)
Check pre acute consistent Julie 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.
Check VAP acquired only first encounter Julie We decided that VAP can actually happen in medicine if pt admitted from ICU. How would we deal with that for this check?
Chest Physio (TISS Item) Trish sounds to me like this is still done differently by different people. Ttenbergen 12:58, 2017 July 27 (CDT)
Cleaning up a failed send Pagasa
Cognos Admitter all
  • How does this work for a patient who is discharged twice in the Cognos Report time frame of 2 weeks? Are you able to see which instance you are looking at and does it open it correctly?
    • If the Chart and Accept DtTm in your data match those in EPR / Cognos, then Cognos Admitter should show the record as green and open the correct record in Patient viewer tab Cognos ADT. If it does not, tell me. In Patient viewer tab Cognos ADT, additional lines from the Cognos data that are not part of this admission might be present; we could filter those out, but for now I figured the more the better to give context and make sense of the situation. Ttenbergen 15:31, 2020 June 2 (CDT)
Cognos Admitter all
  • we can group services together to show all for a laptop with one click in the future, but I don't know enough about how collectors split and decide this to automate at this point.
Cognos Admitter all
  • ... quite a few patients that are on my transfer register, that are not showing up at all on my cognos admitter. Mlagadi 11:32, 2020 May 28 (CDT)...
    • The Cognos report will always provide data up to just before midnight. If we want to use it that will be come our new frame of reference, we will be about half a day behind in our newest admissions.
Cognos Admitter all
  • The patients that have already been entered on our laptop, but are being transferred back to our units, requiring a second or third admission are hard to pick out/decipher. It would be helpful to have a clear "previous location", next to an "arrive time" field on the Cognos Admitter screen, so that we could easily figure out what we are supposed to be doing with that patient. These patients are also showing up multiple times in the Admitter, adding to the confusion. I'm not sure if there is anyway to get rid of the multiple lines showing the same information?
    • Agreed, this is something that needs to be improved still. I can show previous unit or service from the Cognos data for anyone, and previous location data for patients already entered. I think the real confusion here is that we still see too many lines right now: if there are two records in cognos and two in L_Log, right now you get 4 lines as it compares (a-A), (a-B), (b-A) and (b-B). I am working on a way to not show (a-B) and (b-A), which will improve this. One of my problems is that some of the records will match on a Boarding Loc entry, not an Arrive DtTm. Ttenbergen 15:47, 2020 June 2 (CDT)
Cognos Admitter all
  • The transfers out of the unit are also difficult to appreciate/easily pick up with the current layout.
    • I would expect you to find the transfers out in the Cognos Discharger instead of the admitter. And if you deal with them in there, you should not have to deal with them in here. Caveat: I am workign on a way to deal better with the Boarding Loc entries.
Cognos Admitter all
  • The "Add Patient with Serial Helper" button seems to be working well if the patient is on my home unit, but if the patient is on one of the boarding locations, then the serial number helper defaults to 150 every time, and I have to manually enter in my actual number.
    • The idea is that the location gets populated automatically if it matches one of our Service/Locations. If it doesn't match, you should still be able to change it manually, and when you do, the next serial for that location should show up. If that doesn't work, let me know and I will need to find out where it goes wrong. Ttenbergen 15:49, 2020 June 2 (CDT)
      • Joanna reported the same: "Also, the way the admitter defaults to 150 makes us have to find which number we need to use next. The quickest way is to look at our paper log. Otherwise you have to close out of the admitter, enter the patient list in CCMDB, sort for last # used, then re-enter the admitter, find your patient again, and by then you’ve forgotten the next serial number! LOL! (well, not me, but I could see that being a problem!) ".
Cognos Discharger all
  • How does this work for a patient who is discharged twice in the Cognos Report time frame of 2 weeks? Are you able to see which instance you are looking at and does it open it correctly? Ttenbergen 15:15, 2020 June 2 (CDT)
Cognos Discharger all
  • The Cognos Discharger has very few entries-Are you trying to enter patients into this program, or are we just supposed to work with the Cognos Admitter for now?
    • The discharger will only list records where a local record exists (that should have been created through Cognos Admitter), that have a discharge date in the last two weeks, and for which discharge data (e.g. Dispo DtTm, Dispo) are not yet entered. In other words, it is only really meant to replace what you would have used the Discharge report and possibly the transfer report for before. Should anyone else be listed in tehre? If so, why, and how would you use the data? Ttenbergen 15:14, 2020 June 2 (CDT)
Cognos dispo translator table Tina Need to add templates and categories to this
Colonized with organism (not infected) Allan z "It was decided that Allan with contact Dr. Embil and see if we can obtain this data from Infection Control. If so, we could import it into the database, and have our data collectors cease obtaining it." - did anything come of that?
Comorbid Diagnosis Allan Como Admit Acquired Primary Limits - this is part of that discussion - if we limit which admits will count as comos we need to review
Confidential waste disposal all collectors, please document what your process is at your office location.Trish Ostryzniuk 17:37, 2019 March 5 (CST)
Contact list all Tina, could we have all the contacts on this page? I am not sure if there are existing links that we can add, but it would be nice to have phone numbers for Allan as well as the main office staff in one spot. --Jvelasco 14:41, 2020 May 4 (CDT)
Continuous Stay Julie
Continuous Stay Julie
  • 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?
Continuous Stay Julie
  • 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?
Continuous Stay Julie
  • 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?
Continuous Stay Julie
  • 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)
Controlling Dx Type for ICD10 codes Allan Como Admit Acquired Primary Limits 1/ Dx grouping - this is part of both of those discussion
  • I have emailed Allan the table with all Dxs to set them as Como_allowed, Admit_allowed, Acquired_allowed. Will set up infrastructure to contain this once I have data. Ttenbergen 12:31, 2019 February 13 (CST)
    • Allan won't have a chance to review until at least mid Sept 2019
Courier all
  • Western is not mentioned in the Internal Medicine Wiki (See link right below question, it breaks the discussion template). Are we sure Western is still the correct answer? Ttenbergen 16:38, 2020 February 23 (CST)
    • Yes it is WM is the medical legal courier from HSC to GRACE. Trish Ostryzniuk 11:50, 2020 February 28 (CST)
  • Do we actually contact the courier? It kind of sounds below like we just send through interoffice. If so, let's rename page and take out the info about Western. We don't really need to track how the mail room does it, just how we do it.
  • No we do not contact the courier. We must put cost center on package of forms being SENT to Grace out of HSC mail room.
  • Between HSC and STB an visa versa, the mail room has daily drops and pick ups and there is no cost for sending between these two sites.
COVID-19 (SARS-COV-2) Task
CPR, cardiac resuscitation Allan
  • does this include open chest cardiac massage or should this be coded in a different way?
CPR, cardiac resuscitation Task
  • does this include open chest cardiac massage or should this be coded in a different way?
Crash TISS MDB Pagasa
Critical Care and Medicine Database Core Curriculum Trish How does Critical Care and Medicine Database Core Curriculum co-exist with Data Collector Portal? The audience is different, one is for newbies and one as day-to-day reference, but how does that change what needs to be told, without just duplicating all? Ttenbergen 21:08, 2019 January 3 (CST)
Critical Care Vital Signs Monitoring Julie It says that CCVSM is in Quarterly report. If CCVSM is no longer, is it still in quarterly?
Data collection log form all
  • We now have Facilitated Management of Serial numbers. This should eliminate the function of the paper forms to keep track of serials. If it doesn't, could someone please explain how the paper log is still helping with this? Ttenbergen 09:11, 2020 April 15 (CDT)
Data collector's binder all
  • At STB we keep track of CLI and VAP's on a paper list in our binders for the purpose of our Quality coordinator in the hospital. Lois and I attend the STB VAP Committee meetings and need to share this information at the meeting each time (monthly). --LKolesar 10:26, 2017 July 19 (CDT)
    • Would it make sense to just notify the coordinator with this info ASAP when the VAP/CLI happens? That's what we do at STB, we use a button right in the program for it so there is very little overhead for collectors. One less thing to carry around, and the coordinator gets the info in a more timely manner... Ttenbergen 18:04, 2017 July 26 Ttenbergen 11:28, 2020 April 9 (CDT) (CDT)
    • At HSC we are supposed to email Basil Evan and 'cc' the ICU managers with identified VAPs and CLIs. We are to include the main admission diagnosis as well as the the criteria we used to identify these infections, so there is a bit of work involved in typing up these emails. --Jvelasco 12:32, 2020 April 9 (CDT)
      • Do they involve the data collector's binder, though? I was asking the question here to see if this really needs to go in the binder, hoping to have less and less in that binder over time. Ttenbergen 15:12, 2020 April 14 (CDT)
Data Integrity Checks/review list Pagasa Pagasa, regarding the meeting with Trish, Julie and Allan to decide which checks to continue to do when, please
  • expand this list to 50
  • click the “edit w f” link at the start of the line to open any that need change right in a form to use dropdowns to update them
  • confirm that all queries correctly list
    • whether you check them always or only complete (timing field)
    • whether they use L_Problem
    • whether there is a backlog (I just added that field, it defaults to "yes" so change to no if caught up)
Definition of a Medicine Service admission all pls update how things are now that STB_E6_B has moved to STB_A7_B; is that still true?
Definition of a Medicine Service admission all We collect data on some patients who never arrive on one of our units, e.g. EMIPs. Are there any other scenarios? There was a page for the HSC off warders HSC Boarding Locations#Medicine which might help in thinking about these.
Definition of a Medicine Service admission Task Current way of checking through Transfer Register will miss off ward patients who arrived at off-ward locations from elsewhere than emerg. Laura and Tina discussed, did not find solution yet, should be rare, though. 13:41, 2017 March 1 (CST)
Definition of an ICU admission Task We need to update this to explicitly discuss ER pts (ECIP). Yes, allegedly this "never happens", but since we explicitly exclude these, we should state so. This would also ensure consistency with pages like Length of Stay (ICU Report) which rely on this definition.
Delirium days Julie What are the details?
Direct Data Access for RIS/PACS Allan z
  • Identified as something we should do; the notes below are quite old but might still be a starting point.
Discharge Register Trish The following needs clarification, I don't have a report in front of me, how would a new collector read which of these are EMIPs and which not? Emailed Laura Ttenbergen 16:53, 2019 January 3 (CST)
  • is this just available for STB or is this how GRACE and HSC can find in EPR?Trish Ostryzniuk 18:01, 2019 January 3 (CST)
  • I would think that all the hospitals have this because it is just a demographic issue and I believe that everyone has access to this, just get them to test it in other centers to make sure.--LKolesar 07:56, 2019 January 4 (CST)
Dx Primary Task For reporting purposes, Julie puts the primary diagnosis into 8 different categories:
  • respiratory disorders
  • post cardiac arrest
  • trauma and poisoning
  • metabolic/renal/GI/hypovolemic shock
  • cardiac disease
  • neurologic disorder
  • post-operative care
  • sepsis/septic shock

Traditionally we have put the "primary" diagnosis as the main reason they are in the ICU (or ward). The problem is that the reason they came may not really fit the proper category in all cases. For example, the patient came to the ICU with respiratory failure requiring intubation, however the patient may have sepsis which caused the respiratory failure and technically we should be putting sepsis as our primary. Another example is cardiac arrest which traditionally has always been put as the primary diagnosis. However, it does not always capture the correct category which is why they went into cardiac arrest. They may have had an overdose or an airway obstruction or apnea or sepis or it may be a true cardiac event. We would put the cause still as #1 along with the cardiac arrest but it would be missed because Julie only picks up the primary (checked) diagnosis. Putting cardiac arrest as primary can miss the true category. To make it even more complicated however, there is a category for cardiac arrest so which is more important to capture? We all need direction on which diagnosis is "primary". --LKolesar 13:38, 2019 June 25 (CDT)

    • I guess the question is if any dxs can not be captured in those 8 groups. If they are all captured there is no problem, or is there? Ttenbergen 10:09, 2019 October 4 (CDT)
ECIP Task We keep discussing whether EMIP like patients should be collected in Critical Care. Consensus is that they are rare, but for consistency it would be good if we caught them. At task meeting 2020 Jan 29, reviewed. Question: Is this easy to get from EPR? Trish reviewed with p:Lisa kaita and apparently fairly easy to catch.
  • Currently any ECIP are documented in CCMDB TMP project Boarding Loc.
    • 2020 Feb 12: DB Task meeting discussed to continue adding as borrow location as Tina is currently working on EPR lists dump via Congnos? SO we will wait for better solution before any further changes and to continue with current practice to capture these
      • 2020 Feb 18: Allan thoughts were not to add ECIP, call it NCIP because they are not only in ER. I think he was not clear about what this is suppose to be. Not resolved.
Eliminating distinction between different ward types Julie any of Julie's Reporting that use this concept? I no longer used the hierarchy level when computing transfer delays. I assume that if transfer ready datetime is present, DC follows the rule and they are included in the computation. In Medicine Report, there is no more tables showing teaching vs. non teaching. --JMojica 11:10, 2020 January 30 (CST)
Emergency Surgery (concept) all This info is from 2009 - is it still the same?
EMIP all
  • I have had a couple of scenarios in the past few months that I have not considered an EMIP, but I thought I should get a second opinion: The emergency notes state that a patient from another hospital/nursing station, etc. is a "direct for internal medicine". The patient gets to our ER, and is immediately deemed too sick for the ward, and ICU is consulted. The internal medicine doctor may or may not have even laid eyes on this patient, and there is no admission order. In these cases, although the medicine doctor may have written a note about seeing the patient in the ER, they never took over care/wrote orders for the patient. How are other collectors entering these patients?Mlagadi 11:38, 2019 October 1 (CDT)
    • I think this scenario is not an EMIP since the Med doc did not took over. Did the patient go to ICU - if yes then this is an ICU admission? --JMojica 17:09, 2019 October 3 (CDT)
      • This is an interesting case because the medicine service technically accepted the patient to begin with, as they came direct to medicine, and an ER physician did not see them. If medicine sees them, then it could be considered an EMIP? but if medicine doesn't see them, who decided that the patient was too sick for the ward? and consulted ICU? if it was the ER physician than I don't think it would be an EMIP. Just my two cents, it is definitely not clear cut Lisa Kaita 11:03, 2019 October 8 (CDT)
EMIP all
  • need to resolve EMIP and figure out where that info will live. Ttenbergen 11:30, 2016 December 29 (CST)
    • If a patient is still considered an ER patient in a CAU, they can potentially be an EMIP if they get accepted by internal medicine but subsequently are discharged or sent to another hospital.
      • At STB CAU contains inpatients under family Medicine (they are not under the ER physician).
        • If the CAU is considered part of ER then I guess patients that are accepted by internal medicine and go out elsewhere could be EMIP's. It depends how you view the area.
          • Is the CAU considered the same as ER or not? Management will have to determine how they want this done. Currently no one at STB collects data at all on the patients in the CAU. --LKolesar 11:49, 2017 October 27 (CDT)
EMIP Task
  • When reviewing the Cognos EPR Report I came across a few entries that were "ED Death after Arrival" (4 across sites between 2020-03-16 - 29) . Our current definition would exclude these from EMIP collection. Do we include or exclude them in practice? Is that intentional or have we just never thought about them?
EMIP Task
  • When reviewing the Cognos EPR Report I came across a few entries that were "ED Reg/Triaged/Assess LAMA" (6 across sites between 2020-03-16 - 29) . Our current definition would exclude these from EMIP collection. Do we include or exclude them in practice? Is that intentional or have we just never thought about them?
Employee Assistance Program Trish Emailed Trish to fill this in. Ttenbergen 16:26, 2017 June 22 (CDT)
Encounter processing Pagasa
  • says inactive, but do you actually do this? Is there anything else to it? Do we have, and do you run any multi-encounter checks yet? I guess a lot of the PLs kind of are those...
EPR Lists all Are these the manual lists where you have to add patients? Instructions almost look like it's a counterpart to EPR Reports instead. Are these even still available? What are the advantages / disadvantages for this vs EPR Reports?
EPR Lists all who uses this?
  • uses:
    • names?
  • doesn't use:
    • names?
EPR Lists all Would it be correct to say that the lists are manually populated based on EPR Reports?
EPR Reports Integrator all
  • Noted that after using Reports Integrator upon return to ccmdb list, the find patient function screen freezes and does not work. To remedy, the collector has to exit from ccmdb entirely and restart ccmdb, then the find patient function will work. (Pam)
    • emailed Pam to set time for next week to have her show me this. Ttenbergen 14:34, 2020 May 29 (CDT)
Error: There isn't enough free memory to update the display. Close unneeded programs and try again. all Please enter your laptop and under what circumstances you have seen this error below.
Exporting EPR Reports for EPR Reports Integrator all
  • Filter the report; Val/Michelle, could you provide details for what filtering you used for this, if it is other than what was given in those three pages? If same just take out question....
Facilitated Management of Serial numbers all
  • As people are testing Cognos Admitter and "Add Patient with Serial Helper" button, I am hearing that there are two ways to generate the next Serial number. Some use a serial pool per Service/Location, and some use one serial pool for everything on their laptop. There might be a third option where some service locations are pooled but there also is a second pool for another service location. This makes automation or vacation coverage problematic. Could you please fill in what you do on your laptop?
Facilitated Management of Serial numbers all
  • Looks like HSC_WRS3 uses negative and possibly decreasing serial numbers. That would throw a wrench into automatic number suggestion. Is this a usual thing or just something to solve problems generated by the COVID moves?
Facilitated Management of Serial numbers all
  • Would anyone see a problem if we standardized this to using one serial number pool per laptop? What would be the problems? Ttenbergen 19:55, 2020 June 2 (CDT)
First Annual Baking Event all if you have a recipe you would be willing to share, please post it here.
Fixing a D ID in TISS28.accdb Pagasa Pagasa will test the quicker way, and if satisfied, will clean out the two old methods.
Form Covid rept all
  • 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)
General Collection Practices Trish I have linked this from Critical Care and Medicine Database Core Curriculum, but it likely needs updating. Unless we don't want it at all.
General Diagnosis Coding Guidelines Task
  • I don't know how feasible it is to speak to ward staff/doctors for clarification anymore, given that we mostly collect retrospectively now. --Jvelasco 13:24, 2020 April 24 (CDT)
    • Good question. I think there are other places that still mention that concept. Could you bring up at task whether we want to realistically take that out? Ttenbergen 16:40, 2020 April 29 (CDT)
GRA 2S all
  • Is there workload splitting for this location?
GRA 2S all
  • Will that also be used for this location?
GRA Boarding Locations all
  • PACU? Anything else?
GRA CAU Trish
  • We made GRA_CAU available as dispo, but this raises questions about how the field should be treated in reporting. Trish emailed Mary Anne Lynch to find out how these units are actually intended to be used now. Ttenbergen 11:35, 2018 March 8 (CST)
    • Trish, did you ever get an answer for this? Ttenbergen 10:18, 2019 November 5 (CST)
GRA ER use as borrow location all
  • Do we need to add the option to track these for other sites?
    • this is an ER wait/delay case and not to be included in the Project Boarding Loc. The ECIP case is a whole stay in ER but under the Critical Care attending Physician.
GRA ER use as borrow location all
GRA ER use as borrow location all
  • There is a strange thing going on at the Grace that leads to situations similar to ECIP.... Made this page to consolidate details here.
GRA ER use as borrow location all Do we need to change our EPR Report / identification process to make sure we capture these? Just for Grace or for all sites?
GRA General Collection Guide all
  • emailed Grace collectors to please update here Ttenbergen 21:39, 2020 April 5 (CDT)
  • pls also see next heading
GRA General Collection Guide all
  • is this what you would enter as "GRA Ambulatory Care"? Or how do you enter this? Ttenbergen 21:42, 2020 April 5 (CDT)
GRA General Collection Guide all march 25.20 - p:Stephanie Cortilet, what was the process at Grace to get printer paper?
GRA Medical Records requests all Is there anything else a collector new to GRA would need to know to do this right so we don't lose the good will of MedRec tehre? Ttenbergen 13:58, 2019 December 11 (CST)
GRA Medicine Collection Guide All
  • CTU vs NTU
GRA Medicine Collection Guide all
GRA Medicine Collection Guide all Steph's no longer at GRA, so is this stuff up-to-date? Ttenbergen 20:52, 2020 April 9 (CDT)
GRA PACU all Leaving content from GRA_MICU for now although this is almost certainly wrong, could someone please clean it up?
Grace Hospital Contacts all Where is that form? Is there a link?
Grace Hospital Office all Staff have moved into new office space effective March 27.20. p:Lisa Kaita, would not have key to new office, they would have to turn in old keys and get new ones? *Please let Trish know and update Wiki that old keys turned in and new ones obtains. Trish Ostryzniuk 14:07, 2020 March 27 (CDT)
H1N1 Trish seems odd that we would have done a flu study only for 1 month in a summer...
HD (Hemodialysis) all
  • I need clarification on this one-if a patient is either dialysed in Emerg, or on a different ward, (ie. anytime during the current hospitalization prior to coming to your area), are we to enter this only as an admit CCI?Mlagadi 10:26, 2019 February 11 (CST)
    • Please have a look at Admit Procedure, it should explain whether to code a procedure or not. There is no explicit exception for Dialysis. If the info there does not give you the answer you need, please elaborate. If the info is there, then, would you have looked there? How can we make clearer to look there? Ttenbergen 11:53, 2019 February 13 (CST)
HD (Hemodialysis) Julie
  • We used to have a special procedure for indicating if a renal transplant patient received dialysis post transplant under the tasks. If we are now only coding HD once, it will often be missed if the patient required HD post renal transplant. Do we care about collecting this information? There is the post procedural renal failure code that will be coded in the acquireds, but this does not automatically mean that they received dialysis.
    • AG REPLY -- I don't see any special reason to need this info. Unless Julie tells us it's being requested, I think we can do without it.
      • Julie, what are your thoughts on this? Ttenbergen 11:53, 2019 February 13 (CST)
Health Sciences Center Office all
    • Does Iris Deleon have a key?
Health Sciences Center Office all
    • Joanna Velasco - I have a key, but it doesn't work on any of the cabinets in the office.
      • Is that still true? Have you talked with Trish?
Health Sciences Center Office all
    • Lori Lovell - now that she's part time does she really still have a key?
Height and weight Task Z) decided to revisit SOFA scoring 6 months after ICD10 so same should likely go for this.
High dose chemotherapy as primary admit Trish This page is listed as an exception in Definition of a Medicine Service admission so I wanted to make sure we include that instruction with the new codes. However, what _is_ the new code for this? Found nothing suitable in CCI Picklist, CCI component 2 codes - what was done, and ICD10 Diagnosis List only has Antineoplastic/chemotherapy or immunosuppressive drugs, adverse effect which doesn't seem a real match either. In general we would only code the cancer now, right, but this is a bit of a special case, so do we want to treat it separately?
  • AG REPLY -- we don't need this at all and there's no way to code it specifically in ICD10 -- except that such an admission would have the Dx code of the cancer being treated, and the CCI code for the chemotherapy
    • emailed Julie and Trish to make sure they are comfortable with this.
      • Trish, if you are fine with how this is or isn't addressed in ICD10 going fwd, pls remove the tag
Hospice all
Hospitalization in Winnipeg, Canada due to Occupational Disease: A Pilot Study Trish I see Pat's name... did this actually use the DB or just a collector? how did we support this publication?
HSC A7 MI all Please fill in
HSC A7 SI all Please fill in
HSC B2 C all
  • I made the page, but know nothing about this unit, could someone update? Ttenbergen 22:57, 2020 May 27 (CDT)
HSC Boarding Locations all
HSC CAU Task
  • There is info about "CBA (Central Bed Access)" on this page - why?
  • Are these subacute wards at the VIC ie Transitional Care?
  • Do we need to know more about the CBA designation or process, does it affect our collection or reporting? Does this have anything to do with CAU, or why is it in here? If we need this info at all, is this the right place or should it be on a page of its own? Or is it just a bit of info that has nothing to do with us and that we could delete? Ttenbergen 21:10, 2020 May 11 (CDT)
HSC EMIP all
  • Is this still the same split with understaffing? Ttenbergen 11:33, 2020 April 9 (CDT)
HSC H7 MI all Please fill in
HSC H7 SI all Please fill in
HSC MICU Collection Guide all
  • I have spoken to the clerks in MICU and they do order their own TISS forms and Green sheets. Is it not possible to have SICU and IICU order their own as well? --Jvelasco 11:57, 2020 February 28 (CST)
    • will check this out with Pagasa and printshop. If we made changes to the form then unit would not get most current. Trish Ostryzniuk 14:44, 2020 February 28 (CST)
    • Which Cost Center they are charging to?
      • I do not know. --Jvelasco 15:14, 2020 April 7 (CDT)
HSC MICU Collection Guide all Another question: Since we are not to go to the units during the COVID outbreak, how do we supply the ICU's with TISSs and Green sheets? For sure SICU and IICU will need to be restocked. MICU seems to restock their own according to the ward clerks, but that does not seem to be verified so far...--Jvelasco 15:14, 2020 April 7 (CDT)
  • when was the last time you request TISS form for SICU or IICU guys? Pagasa say HSC has not requested any for long time since Oct 2019 actually. Trish Ostryzniuk 17:19, 2020 April 15 (CDT)
    • We do not request TISS forms/Green sheets for SICU or IICU. We go to your office and Pagasa gives us a stack of both. Or we email Pagasa when the supply is running low in our office, she brings them here and we then deliver some to both units. --Jvelasco 13:26, 2020 April 17 (CDT)
HSC MS3 all Please fill in
HSC Unknown Service all
  • So if Lisa had to cover for one of you while you are aware, how would she know which ones to pick up. Do you have a method for splitting these?
HSC WRS3 all
  • Will this location profile be identical to what HSC_D5 was before?
Iatrogenic, infection, central venous catheter-related bloodstream infection (CVC-BSI, CLI) all
Iatrogenic, puncture or laceration, related to a procedure or surgery NOS Tina find page for general rule of not coding iatrogenic events as traumas
ICU Acquired Catheter-associated Urinary Tract Infection (CAUTI) rate Julie Just to be clear, is it number of cases (possibly >1 per pt) or once per pt as mentioned above?
ICU Acquired Catheter-associated Urinary Tract Infection (CAUTI) rate Julie There was no significance in your PPT.
ICU Acquired Sepsis Julie
  • which dxs are used?
ICU Acquired Sepsis Julie Just to be clear, is it number of cases (possibly >1 per pt) or once per pt as mentioned above?
ICU Acquired Sepsis Julie Nothing was listed in your power point, what is the significance?
ICU Interfacility Transfer Julie What are the details?
ICU Mortality Julie Allan says don't include Brain death admits in the numerator or denominator ?
ICU Mortality Julie Does this also consider any of the Diagnosis implying death?
ICU Mortality Julie What are the details?
ICU Resource Utilization - Chest Xrays Julie Is this DSM Lab Extract?
ICU Resource Utilization - Chest Xrays Julie What are the details?
ICU Resource Utilization - Creatinine Tests Julie Is this DSM Lab Extract?
ICU Resource Utilization - Creatinine Tests Julie What are the details?
ICU Var 6 - AMA Julie 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.
Identifying ICU admissions all
  • what are those plans? Are we still planning to? Ttenbergen 09:31, 2016 November 10 (CST)
Identifying ICU admissions all
  • What is this Affinity software, is it another name for the EPR or is it a separate tool?
Identifying ICU admissions all
Identifying ICU admissions all
  • Grace, are collectors now able to use EPR Reports to generate own transfer, admit and discharge reports?Trish Ostryzniuk 11:35, 2016 May 20 (CDT)
    • no access to ERP reports yet to generate our our listsMschaffer 08:57, 2016 May 31 (CDT)
    • we can print reports but are still looking for a way to find service transfers while in ER
Identifying ICU admissions all multiple questions, especially for HSC and GRA
Identifying patients in boarding locations all
Identifying patients in boarding locations all We need to make sure nothing in here is inconsistent with the following:
Inflammatory/immune arthritis, NOS Allan Does this also include https://en.wikipedia.org/wiki/Adult-onset_Still%27s_disease ? (question from Deb)
L ICD10 APACHE Dx query Julie
  • 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)
Lab identification in the DSM data all
  • 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)
Length of Stay (ICU Report) Julie Right now this is slightly inconsistent with Definition of an ICU 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?
Length of Time for Transfer from ED to ICU within same facility Julie No significance in your ppt?
Length of Time for Transfer from ED to ICU within same facility Julie What are the details?
Link suspect mismatch to ours incomplete query Pagasa
  • There is a query Link suspect mismatch to ours incomplete2 (with a 2 at the end) in CFE. What is the story, and which one do you actually use?
Link suspect transfer ready before arrive date Pagasa
  • Someone could be transfer ready before theArrive_DtTm , if they become transfer ready after the Accept_DtTm. Is this really a good check to do? It sounds like it would have plenty of false positives. Should it be Accept_DtTm instead?
LOS Julie LOS Medicine per hospital admission and LOS Medicine per ward stay may duplicate content above. Do they? If we ever split these out into reporting documentation indicator pages we will need to make sure these are not duplicated.
LOS Medicine per hospital admission Julie "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?
LOS Medicine per hospital admission Julie 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?
LOS Medicine per hospital admission Julie is this Arrive DtTm or Accept DtTm?
LOS Medicine per hospital admission Julie this still talks about TMSX... what is the new status of this field?
LOS Medicine per hospital admission Julie 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.
LOS Medicine per ward stay Julie Hi Dr. Garland,A thought came up after the last Task meeting related to the discussion on using Service LOS vs. Physical bed LOS (location). We also have A/D/H service patients go to the ward D5. This ward is typically less acute and patients will transfer to D5 from all of the medicine wards (A4/H4/D4/B3/H7). The patients retain their service (A/D/H) while they are on D5, some patients will switch attending (to the D5 Attending), others will stay with the same Attending they had prior to arrival on D5, but the service will remain the same. The Attendings on D5 do not have a specific service and, there is no rule as to which patients switch to the D5 attending. Some patients will be discharged from D5 still under the same Attending that cared for them prior to arrival on D5.

When patients leave A4/D4/H4/B3/H7 their profiles are completed (discharged) by the designated ward collector and a new profile is created by the D5 collector.Thanks, Val Penner, May 16.19

  • AG THOUGHTS -- given the variability in where a ward patients is/goes and which service takes care of them, dealing with this issue requires us to know what the powers that be want as respect to how we keep track of LOS. Do they WANT by physical ward, or service, or something else?
LOS Medicine per ward stay Task ward LOS vs Service LOS - Val Penner - HSC-D5 follow up from May 7 task meeting- May 16.19
Manitoba Health Crosschecking Background Julie
  • 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.
MediaWiki:Common.js all ", post: "
MediaWiki:Common.js Allan ", post: "
MediaWiki:Common.js Task ", post: "
MediaWiki:Common.js Tina ", post: "
Medical Assistance In Dying Julie
  • 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.
Mortality and readmission report Julie
  • who is this report given to? thank you--TOstryzniuk 18:40, 30 November 2010 (CST) Ttenbergen 23:43, 2017 June 7 (CDT)
Mortality and readmission report Julie What is the Mortality and readmission report report?
Night Time Discharges Julie Why only to wards? How about to home?
Notes field all
  • track all lab and pharmacy manually, the notes save time in that it eliminates the need to go back & recount.
    • would you not just enter a new line for these, and the date of the new line would tell you how far you got? Ttenbergen 14:24, 2014 September 19 (CDT)
Nursing Workload Julie Average or mean? Different in description and definition.
Nursing Workload Julie What are the details?
Oculys Allan
  • Allan is trying to find out if patient level info is available in other parts of Oculys that we may not have access to. He has sent off an email about this.
Over Census at Midnight Julie What are the details?
Palliative Service Julie
  • 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)
Patient viewer tab Cognos ADT all
  • as this matures we might be able to filter further to show less data in there. talk to me if that's a priority Ttenbergen 17:36, 2020 May 21 (CDT)
Patient viewer tab Cognos ADT all
  • I feel like this tab has a lot of useful information, and functions that I am unaware of. We probably need to discuss this page more, so that we can figure out what the info on this page is supposed to tell us, and iron out the layout to make it more readable.
    • Yes, it needs more work. I think the biggest part will be to decide which lines can be omitted. To start with, each line contains a snapshot of all data for the current entry. So, it re-iterates that the pt came from ED, and when they were accepted, even if the current line is there because there is a change in unit and the ED and service info is temporarily irrelevant. We could group this data differently to not re-iterate things like Visit Admit DtTm, but we sometimes have weird things like a service changing without a location changing, and the more I hide detail and make this pretty, the more likely weird scenarios like that will lead to a view that makes even less sense. I will work on something somewhat easier to look at. Ttenbergen 16:04, 2020 June 2 (CDT)
Patient viewer tab Cognos ADT all
  • ...I tried to enter a boarding location on a patient by hitting the "make B loc" button, and nothing seemed to happen. I just visited the WIKI page on that now, and it does state that it still needs to added manually-I don't understand why there is an option to press this button at all then?
    • The button should create a line with the date and time and the project pre-populated. You need to fill in the Item (ie location your ward or boarding ward), because I am not yet sure how I would extract that directly from the Cognos data, especially with all the special cases due to covid moves right now. I figured only having to change that dropdown, with the full story listed right below, would be easier than re-keying it manually. Now, if that button does not even generate the Boarding Loc line for you, that is a different matter and I would have to troubleshoot that.
Patient viewer tab Cognos ADT Tina
  • I already know the following:
    • At least some patients show duplicate lines in the Cognos list
PatientFollow Project all
  • The list would need to be exported on a regular basis and then made available to collectors. How would this best be done?
  • There was talk about EPR lists to help collectors keep track of their patients. If we use that method then how will we handle it when there needs to be coverage?
  • How do we make sure no pts are missed?
  • How do we make sure no pts are duplicated?
PatientFollow Project all
  • It should be questioned then whether amalgamating all data collection units within a site for example there are 4 medicine collection units at STB + EMIPs how to possibly track and reconcile all these lists with any semblance of accuracy. This would be a very labor/time intensive and complicated process, as well as a significant logistical challenge. Use of EPR lists to create further lists/spreadsheets in Excel seems redundant and a risky proposition in terms of inclusion and accuracy. There are also potential PHIA considerations whereas patient information on laptops is currently stored/accessed through a separate program, what are the implications for "personal" and/or redundant storage of patient information on data collector accounts? Pamela Piche 10:19, 2019 September 5 (CDT)
PatientFollow Project all The potential to either, have multitudes of patients duplicated, or more importantly, patients missed seems astronomical. Inadvertently duplicating patients will end up being way more work for data collectors. How will we, as data collectors even know that we have duplicated a patient that another data collector has already done? Or conversely, how will we know if we have missed a patient?
PHIA policy Trish Trish will put link.
PHIN field all
  • With Cognos EPR Report we now get PHINs from out of province with province prefix; do we want to start collecting these for out-of-province patients for cleaner matching, and to enable better matching for external users of our data such as MCHP?
  • sure. will this affect any of the query? the data type will become text if you will add the province prefix. --JMojica 19:03, 2020 April 5 (CDT)
PL missing L Tables content all Have there been more since?
PL missing L Tables content Pagasa
  • Pagasa, could you please log here when this query lists errors, and what was found to be the problem (ie whether there was data in CCMDB.accdb that didn't make it, or no data in first place.
Pneumothorax, nontension, nontraumatic Tina find page for general rule of not coding iatrogenic events as traumas
Pneumothorax, nontraumatic, NOS Tina find page for general rule of not coding iatrogenic events as traumas
Pneumothorax, tension, nontraumatic Tina find page for general rule of not coding iatrogenic events as traumas
Pre op Admit-Cardiovasc Patient Julie 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)
Pre-linking checks Pagasa This automatic list includes an PL missing L Tables content - where does it fit in into the order in which you run these above? It is likely a very first thing, right?
Pre-OP Admit - Research Patient - Cardiovascular Julie 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)
Previous Location field Julie
  • In the event that both the bed and the service are borrowed: ie. STB MICU borrows a bed in CICU under CICU service then patient is transferred to STB medicine units-for the medicine profile does the Previous Location mean Pre Admit Inpatient Institution ie. STB_MICU? Does previous service mean Critical care in these instances?
    • Good question. I think for the service borrowed, we still need to use the collection location for the Previous Location is equal to Pre-admit Inpatient Institution. For the Previous Service, I am not so sure but for your example the Critical Care makes more sense to enter than Cardiac surgery and so we need to check with Tina if this is allowed in her integrity checks. --JMojica 09:59, 2020 January 23 (CST)
      • If I understand you right you suggest that the first entry will be Service/Location STB_MICU with a Boarding Loc entry telling that they are in CICU, and the second entry will be Service/Location STB_MICU and Previous Service would be "Critical Care". If so, that is the same as any normal STB_MICU patient, no? So, yes this should work as far as queries are concerned. But is this really the thing we want to enter? How is this patient at all still a STB_MICU patient if both service and bed have moved on? How is this not a transferred patient?
Previous Service field all
  • As per last Task Meeting - is this correct or do we need to discuss further? --Jvelasco 14:39, 2019 June 26 (CDT)
    • Good question. 6 months later, what do people think?
Previous Service field Task
  • The Registry Patient Type field was replaced by the Previous Service field, how will the patient types be derived from the previous service field? the s_previous_service table must have a column defining the patient type.
    • Patient Type is Surgical if previous service is Cardiac Surgery, General surgery ,etc.,
    • Patient type is Cardiac if previous service is Cardiology,
    • what about Patient type Medical? if Ob/Gyne or Emergency Medicine, is it Medical type? how about critical care?
    • It was also mentioned earlier to use the diagnosis instead, can we begin working on this? --JMojica 15:48, 2019 May 21 (CDT)
    • If I remember right it the Registry Patient Type data was supposed to be inferred from several fields, not just Previous Service field, but I can't remember the details either. We can absolutely add a column for this to s_previous_service table once we know what we need. Ttenbergen 12:49, 2019 June 4 (CDT)
Procedure when there are differences between L Log and L PHI Pagasa Why, what does that tell you? The only way I can imagine this would happen is if the record was deleted in centralized L_Log. In that case, if you are lucky and there is still a ccmdb_data with the completed/sent record, you can follow the Re-sending data process. If not, find it in a previous version of Centralized data.mdb, print or write down all data for the record, and manually re-enter it in a CCMDB.accdb and follow the Re-sending data process. Or what do you do? Ttenbergen 21:38, 2019 February 6 (CST)
Processing errors in patient data Pagasa
Project Borrow arrive all
  • Trish said " Legacy - need to get updated in master database change to all borrow arrive to boarding Loc instead of 2 different things that mean the same things now is main database. Julie had mentioned but can be done later. "
    • Trish, what do you mean by that? Ttenbergen 10:52, 2020 May 14 (CDT)
Project Borrow arrive Julie did they ever get back to us? no response from HSC SICU --JMojica 10:14, 2019 May 6 (CDT)
Project Discharge Documentation all I could set up a query in CFE to dump this to keep it off Julie's desk. This user might find speed more important than quality? If needed, let me know.
Project Discharge Documentation all Will these documents be retained on charts once they hit med records?
Project Discharge Documentation Julie pls fill in once you set it up
Property:Collection Location Service Type Trish What is CTE? I am adding it for now because not having it is breaking SMW, but we really should not have it here if it isn't defined.
Psychoactive substance NOS, chronic abuse/dependence/addiction Task We were wondering if we should ever be using any of the chronic abuse codes as an admit diagnosis. For example, some of our patients are being followed by an Addictions service on the wards. Some are started on the methadone program, others get discharged to an addictions unit. If it is actively being treated on our unit, then should we code it as an admit, as well as a comorb?Mlagadi 10:20, 2020 May 15 (CDT)
    • This is about any of the codes in Category:Addiction and any outcome should likely live in Template:ICD10 Guideline Chronic Substance Abuse. I moved the question here from the category because (a) categories should only contain info about what would qualify a page to be in the category and (b) some of the queries and templates don't work the same with categories. This way it will show up on the task agenda. Ttenbergen 22:06, 2020 May 18 (CDT)
QA Infection VAP Julie 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)
QA Septic Shock Julie 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?
Quarterly report Julie What is the Quarterly report report?
Query check CCI must have entry Pagasa
  • Patients without CCI entries are slipping through and found by PL missing L Tables content , must fix PTorres 09:42, 2019 February 7 (CST)
    • I seem to remember discussing this with Pagasa. There was a misconception that a "no CCIs" had to be present in both component and picklist, but that is not true: it only needs to be in the Picklist. Is this still a problem? If so, please tell me an example when one comes up.
    • Michelle sent email 2019-10-31 that she was able to click "D" with no CCIs entered. I tested on my copy and got an error when I tried. Will need more info about the scenarios where this can slip through.
Query check ICD10 ESRD and AKI only if transplant Allan Would the past history really allow for this? i think only a CCI makes it OK to have both an ESRD and an AKI dx in same patient.
Query check long transfer delay all
  • Requiring notes to have content is really a very soft error check... do we need to consider something better?
Query check long transfer delay all
Query check long transfer delay all At the meeting about cross checks it was decided to change the cut-off to SD*3; will need to get that from Julie if we ever address the other questions.
Query Import request matcher all This one is fairly easy, Pagasa will try to make it.
Query NDC Bad Postal Code Pagasa You mentioned that you occasionally got patients with letters rather than numbers; if that happens again, pls let me know.
Query NDC CLI vs DX but no TISS17 CentralLine Pagasa
  • It said here that this should be retired, but this is still relevant, no? We stopped tmp, but the dc and the TISS entry still exist... Do you still run this tests?
Query NDC VAP no TISS Julie FYI Maybe
Query NDC zCRRT TISS no tmp Tina _dev_CFE - remove this and *old
Query NDC zCRRT tmp no TISS Tina _dev_CFE - remove this and *old
Query s ICD10 Chapter block dxs Julie any other plans for these?
Query s tmp Bording Loc sensible DtTm vs no borrow all
  • This cross check had been disabled for Borrow Arrive because there were many errors: check was disabled in VBA with comment "2019-01-24 disabled for now because too many errors". I think we were concerned at the time because of high workload and fresh ICD10/CCI and didn't want to analyze and fix then. We will need to review what this should be to get an acceptable number of errors only.
    • Are we ready to have a cross check for this that requires either
      • no borrow and a checkbox and no time
      • at least one borrow location and a time
Query TISS Errors ETT consistent Julie
  • A patient might arrive intubated, so there would be no intubation. Does this check really make sense? Ttenbergen 23:23, 2019 March 25 (CDT)
    • I have revised the conditions, pls check if they now make sense.--JMojica 16:38, 2019 July 9 (CDT)
Query TISS Errors missing days Julie which report/s are these actually included in?
Re-admission Julie
Reporting from ICD10/CCI Julie
  • 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)
Requested CCMDB changes for the next version all
Requested TISS changes for the next version Julie What is the intended use of these reports?
Resistance to antimicrobials, methicillin (anti-staph penicillins) Allan z "It was decided that Allan with contact Dr. Embil and see if we can obtain this data from Infection Control. If so, we could import it into the database, and have our data collectors cease obtaining it." - did anything come of that?
Resource Use all do we have a counterpart like Avoidable Days in Medicine?
Resource Use all which others in Category:Indicators
Risk factors for seizures in cardiac surgery ICU Patients Julie 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?
S dispo.loc type Julie 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.
S dispo.service type Julie 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
S dispo.service type Julie 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.
S ICD10 APACHE Como patterns table Allan
  • Allan, if you have a reference, ideally online, for what you used to make the APACHE comorbid ranges, please add it here.
S ICD10 APACHE Dx patterns table Allan dx grouping

if you have a reference, ideally online, for what you used to make the APACHE comorbid ranges, please add it here.

  • AG NOTE TO SELF -- you have to go through and confirm the ICD10/CCI codes to automatically code for the AP2 comorbs
But mainly I used this ref: https://rstudio-pubs-static.s3.amazonaws.com/231351_940f14aa51a6427a9e92d5a04daefc3e.html
S ICD10 Charlson Como patterns table Allan Como Admit Acquired Primary Limits - this is part of that discussion - if we want to limit some of these to not being allowed as admits, it will likely have to be done here.
  • AG REPLY --- yes we can and should go through ALL ICD10 codes and indicate which of the 3 Dx Types they're allowed in (ie deal with Controlling Dx Type for ICD10 codes). AG needs to be reminded to deal with this around June 2019
SAS Data Integrity Checks Julie 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)
Scheduled Tasks Pagasa Do we still schedule Backup Checker?
Setting up Regional EPR Access for Data Collectors Trish
  • I emailed Joy Lyn Roxas to find out if regular accounts team and Acute care actually share these instructions; if not this might be our problem. Ttenbergen 16:52, 2019 April 17 (CDT)
    • Did we ever find out how to properly request this? Ttenbergen 20:00, 2019 November 13 (CST)
Severe Sepsis Julie 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)
Severity of illness Julie Is this average as in description or mean as in definition?
Severity of illness Julie What are the details?
SOFA scoring Task Z) decided to revisit 6 months after ICD10
Staphylococcus aureus Allan z "It was decided that Allan with contact Dr. Embil and see if we can obtain this data from Infection Control. If so, we could import it into the database, and have our data collectors cease obtaining it." - did anything come of that?
Statistical Analysis Julie 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)
StatusReport.bat Pagasa
  • have we got rid of all these old files? IF so we can delete these articles, but if they are still around we might want to keep them... I think we should just get rid of the files, though. Ttenbergen 22:42, 2017 June 7 (CDT)
    • confirmed that X:\PAGASA\STATUS_REPORT still exists; can we clean that up?
STB A7 B all I have left this info as it was on E6; does any of it change in the new unit?
STB ACCU Collection Guide all
  • Is this still done? How does this actually impact collection, ie why would these pts be marked so?
STB B5 all If you check Definition of a Medicine Service admission is that still true? Ttenbergen 21:07, 2018 November 24 (CST)
STB Boarding Locations all
  • Any other boarding locs for STB Med?
STB Boarding Locations all
  • PACU? Anything else?
STB E5 all Is that exception about radiology still true? Ttenbergen 21:03, 2018 November 24 (CST)
STB E6 C all This is probably all wrong now, please update
STB Electronic Patient Record all
  • "...Also, the "APACHE" score for medicine is not dependent upon the first 24 hours of vital signs and labs so exact accuracy here is less important. --LKolesar 06:44, 2019 October 24 (CDT)"
    • We don't do an apache score for medicine at all, so I am not sure what you mean here. AFAIK the instructions how to collect e.g. WBC are the same for medicine and ICU, no? In any case, I think it's separate from the purpose of this page, how EPR is used at STB. If you agree, can you please take out this whole Discussion? Ttenbergen 11:31, 2019 October 30 (CDT)
STB Medical Records requests all If I was a new collector, how would I find that shelf?
STB Medicine Collection Guide all
  • Does that mean any pt who is in a boarding location, regardless of service, will be on the S4 Laptop? Or that the wards collected on S5, S6 don't have off-ward patients collected? How does that work for Julie's reporting?
STB Medicine Collection Guide all will any med collectors be on site at intervals like STB_Critical_Care_Collection_Guide#IMPORTANT_INFORMATION_DURING_COVID_PANDEMIC?
STB Medicine Collection Guide Julie
  • How does that work for Julie's reporting?
STB Medicine Workload splitting all
STB MICU Collection Guide All
  • With the new instructions for Contacting Quality Officer and Manager for VAPs and CLIs, can we discontinue that sheet? We should not be retaining patient info once we are done dealing with it. Ttenbergen 10:26, 2017 September 18 (CDT)
    • Basil Evan , QI officer, is asking that perhaps a worksheet be submitted to him regarding which criteria were met for either VAP for CLI when collector make determination from chart. Perhaps we could make a checklist in TMP instead in regards to which criteria are met for these two special projects instead of paper worksheets that are different at each collection site? Suggestions? --Trish Ostryzniuk 17:14, 2018 November 19 (CST)
    • added to tmp was abandoned. Trish Ostryzniuk 18:46, 2019 February 4 (CST)
      • Emailed Trish "What do you mean by was abandoned, the question or the project or the paperwork?" Ttenbergen 22:29, 2019 February 5 (CST)
Switching to a single serial pool per laptop all
  • Do you think there would be a problem with your collection work flow if you moved to automatically assigned serials from a single number pool? Are there processes identifying patients or similar (ie processes that are not on the laptop) that would be confused by this? Ttenbergen 21:16, 2020 April 26 (CDT)
    • The only problem that I can see is that the numbers help us figure out which patients are in High Obs, or which patients are EMIP's. We could fix that problem by entering a location in the Record field.Mlagadi 07:50, 2020 April 27 (CDT)
      • Due to space restrictions we initially didn't include the location as a column on the Patient List, but we did set up colors per unit. I just realized I didn't initially document this on the wiki, but I now have, see Patient_List#Row_colours_on_Patient_List. Would that be an alternative to using the serial to figure out the unit? Ttenbergen 12:11, 2020 April 28 (CDT)
      • I could also add a button to sort by unit, even if it's not displayed. Let me know if that would be helpful. Ttenbergen 12:11, 2020 April 28 (CDT)
Switching to a single serial pool per laptop all
  • Moving here from a page where it didn't fit in:
  • "One more point, D5 & B3 use consecutive numbers also. These would be hard to keep track of without a paper log for the really quick admissions & discharges that are sometimes seen on B3.--CMarks 13:22, 2012 October 1 (CDT)"
    • Iris, is that still a thing, and will it make any difference if we change these to a single pool? If not, please remove this discussion. Ttenbergen 16:30, 2020 April 29 (CDT)
Task Team Meeting - Rolling Agenda and Minutes 2019 Julie Actually, I think Julie decided to re-claim these from backups, no?
Task Team Meeting - Rolling Agenda and Minutes 2020 all
Task Team Meeting - Rolling Agenda and Minutes 2020 all
  • Will this mean entering and possibly later changing Service/Location and therefore D_ID of patient records?
Task Team Meeting - Rolling Agenda and Minutes 2020 Allan Inconsistent with Acquired Diagnosis / Complication
Task Team Meeting - Rolling Agenda and Minutes 2020 Allan May be inconsistent with Admit Procedure, what do we want?
Template:ICD10 Guideline Como vs Admit Allan Como Admit Acquired Primary Limits - this is part of that discussion - if we limit which admits will count as comos we need to review
Template:ICD10 Guideline Iatrogenic Pneumothorax Tina find page for general rule of not coding iatrogenic events as traumas
Template:ICD10 Guideline MRSA Allan z "It was decided that Allan with contact Dr. Embil and see if we can obtain this data from Infection Control. If so, we could import it into the database, and have our data collectors cease obtaining it." - did anything come of that?
Template:ICD10 Guideline Transplant Failure Julie
  • 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)
Template:Newsflash Tina needs troubleshooting
Temporary page to list dxs documented as requiring treatment to be coded Trish
  • Tina -- to deal with these, let's make a template and put it in all the ICD10 pages that link to the list right below here. That template to say: This is an entity which you SHOULD code even if it is not being treated.
    • I have made Template:ICD10 Guideline code even if not treated; should it be applied to the new codes or only those old pages?
      • We need to decide were to put that info; adding it to old pages is probably not the right place. ICD10 collection might be it - will people look there?
        • Emailed Trish about this. Ttenbergen 09:07, 2019 April 30 (CDT)
TISS Form (TISS28) Pagasa what actually needs to be specified when ordering?
TISS Form (TISS28) Pagasa where does one get that requisition form?
TISS28 backup and start.vbs Pagasa Do you still use this? It is not linked, so as part of what process?
TISS28 Form Scanning Pagasa
  • If a frozen version is kept available during TISS scanning anyways then there is no reason to not do these checks in CFE, is there? Or rather, collectors sending would not be the reason. Pagasa, let's talk about this. Maybe we can make this more convenient for you. Or write down the actual reason why it can't be done. Ttenbergen 00:34, 2017 November 12 (CST)
    • Discussed this with Pagasa. It would mean doing scanning during send time, and likely doing all fixes during pull time, so all checks could actually be done form CFE. Discussed also w Pagasaa that we would delete the error checks from TISS so there is no duplicates getting out of sync.
      • Do we want to make this change then, Pagasa? You would be the only one who would be affected, so mostly up to you. Maybe confirm with Trish.
Transfusion of platelets Task There are conflicting and misleading instructions here. We might need to take out Template:CCI Collection Mode since this is a one-of. Same for Template:CCI Guideline Transfusions.
Vacation and staff shortage collection priorities Trish For coverage on the medicine ward isn't the overstay project the priority and not the discharges. Are we not trying to generate a color on admissions as soon as possible to identify reds and letting managers know as soon as possible? GHall 11:51, 2017 August 14 (CDT)
Validation against Patient Registry Data Julie 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.
Ward admission log forms all Which sites still use the ward logs?
Ward admission log forms Trish I think you really mean the EPR in general. We should probably review that page and the local ones since we use it rather more specifically now than when we first started. Actually, what we probably want is a page for EMR Web Reports. Or do we need specific pages for specific reports that we use, so we can link to them? Ttenbergen 16:11, 2019 May 17 (CDT)
Working from home Trish
  • What forms need filling? Space requirements? Responsibility for records? Anything else?