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 152 unassigned questions.

wiki page question Last modified
"EMIP" button
  • If this button doesn't work as expected, please log it here. If nothing has been logged by Sep 30 this can be deleted. Ttenbergen 12:41, 2020 September 22 (CDT)
2020-09-22 5:41:33 PM
"Mine! Mine!" button
  • Actually, does HSC CC use it? For them it would exclude the H6 patients if they sneak in somehow, but is it actually used, and if it's always used, should we just exclude those from the Cognos list altogether?
    • Sorry Tina, I have no clue what you are asking here...We don't ever use the MINE MINE button, and I'm not sure what H6 has to do with anything??
      • If I remember right, initially some H6 patients were showing up in the CC list because CC docs follow them there? If so, these H6 might show up on HSC CC Cognos Admitter. We don't follow these, so I had set up the minemine button for HSC CC laptops to exclude these. Are you not getting any of those H6 pts cluttering your list without the minemine button? Ttenbergen 12:03, 2020 October 21 (CDT)
    • I have never used the minemine button. As far as I remember you told us that it wasn't quite set up and not to use it. I might have missed the instructions to start? --Jvelasco 13:27, 2020 October 21 (CDT)
2020-10-21 6:27:45 PM
"View exclusions" button
  • Is it possible to also see the names of the patients in the View Excluded tab, so it’s easier to tell who has been excluded if we have multiple patients in there? What if I want to put one back and not the others? How do I find that one patient in a list of hospital numbers…--Jvelasco 11:28, 2020 June 12 (CDT)
    • That is actually not so straightfwd. I don't show the name, so would need to look it up based on chart, and that would turn it into a query, and from that we can't delete. I could build something like this, but would need a reason. Do we mistakenly exclude records often enough to make it worth it? If we do, I would be interested to know why, ie which part of our process has us excluding records that should not have been excluded? Ttenbergen 10:09, 2020 June 17 (CDT)
  • I haven't used this feature yet, but since it's there, people might want to exclude multiple entries for whatever reason. I just thought it would be easier to use if you could see names in there, if that was the case. In what scenario would we want to exclude one patient or multiple patients from the main admitter list? --Jvelasco 12:30, 2020 June 18 (CDT)
2020-06-30 4:12:23 AM
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-08-13 7:00:27 PM
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-08-13 7:00:27 PM
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)
    • Did not happen at all. we can ignore this scenario. --JMojica 10:00, 2020 June 12 (CDT)
2020-08-13 7:00:27 PM
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)
      • update There are no COVID specific suspect or positive wards as of May 27, 2020 Lisa Kaita 13:49, 2020 June 11 (CDT)
2020-08-13 7:00:27 PM
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-08-13 7:00:27 PM
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?
  • Did not happen at all. We can ignore this scenario for now. --JMojica 10:02, 2020 June 12 (CDT)
2020-08-13 7:00:27 PM
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-08-13 7:01:26 PM
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-08-13 7:01:26 PM
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-08-13 7:01:26 PM
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-08-13 7:01:26 PM
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-08-13 7:01:26 PM
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-08-13 7:01:26 PM
2020-05 HSC 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)
  • Suspects are on units ICSM, ICCS and ACCU. COVID+ are in ICMS together with the nonCovid as shown in the database.--JMojica 10:33, 2020 June 11 (CDT)
2020-08-13 7:01:26 PM
2020-05 HSC COVID unit transition what needs to change on laptops? Trish Ostryzniuk 18:00, 2020 May 12 (CDT) 2020-08-13 7:01:26 PM
2020-06 s dispo table cleanup
  • Emailed Pagasa to change STB_E5a-880 one to service location STB_E5 so we can delete the STB_E5 entry. Ttenbergen 14:22, 2020 June 5 (CDT)
2020-06-17 2:34:54 PM
2020-06 s dispo table cleanup
  • The pages behind the following links should probably be deleted, since there are no entries for them; however, at least some of them are linked from other places, so those links need to be cleaned up as well...
2020-06-17 2:34:54 PM
Admit Type for APACHE II
  • Thanks for the clarification, Michelle. I like your explanation and think it is clear. We still have the flow chart floating around on this wiki, though: File:Patient Type Flowchart.gif; we should either get rid of it (preferred) or update and integrate it here (not preferred, since its contents would not be searchable). Ttenbergen 15:18, 2020 October 7 (CDT)
2020-10-07 8:18:50 PM
ALERT Scale timing of assessment 2020-07-09 4:34:24 PM
Allan's links 2020-10-22 6:08:48 PM
Attribution of infections
  • Is the following correct, then:

A decided that an infection that is discovered within the first 48 hrs after admission should be coded as an Admit Diagnosis, and an infection discovered after that as an Acquired Diagnosis.

2020-08-28 2:37:43 AM
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
  • Does it really start in ER? since that's now one off-ward location? In any case, we should really only link to the definition in APACHE from here so this doesn't become inconsistent. If someone knows where that's documented, can you please confirm and fix? Ttenbergen 00:36, 2020 October 16 (CDT)
    • I haven't been able to find it on the Wiki, but I was told to get my values for my Apache from the previous location. So for example a patient getting admitted to the ward from ER, the Apache values would be the ones just prior to their Accept Dt/Tm. Think "this was their condition when they were accepted by medicine". If it's a transfer to the ward from ICU, I take the last values before they left. Surbanski 11:14, 2020 October 19 (CDT)
    • To confirm for patients admitted from ER, Apache vital signs are taken from closest to but prior to Accept Date/time?
      • For medicine yes. I don't know if ICU does anything different. If I've been doing it wrong I expect someone from medicine at the other sites will say something :) Surbanski 10:31, 2020 October 20 (CDT)
        • Dose ICU start there APACHE and TISS from the ER accept time or ICU admit time. Currently we collect from the ER accept time only when the patient is boarded in the ER for greater than 2 hours. Gthomson2 10:43, 2020 October 20 (CDT)
          • Since Oct.15th, I have been using the 24 hour period after the accept time, which means that I am including the applicable Vitals from ER if the patient was from the ER. I wasn't at the task meeting yesterday, so I don't know if this was discussed, but this was my understanding of how we are supposed to collect apacheMlagadi 11:02, 2020 October 23 (CDT)
2020-10-23 4:02:39 PM
Boarding Loc
  • This would now mean TISS starts in ER if the pt is in ER long enough. We discussed that a while ago and I can't remember the outcome. This might need to be updated to correspond to that. Or rather, this should only be a link to that so it doesn't go inconsistent in the future. If some one knows what was decided, can you please fix this? Ttenbergen 00:36, 2020 October 16 (CDT)
2020-10-23 4:02:39 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-10-23 4:02:39 PM
Change from Service Location to Service, Boarding Loc and Transfer Ready DtTm tmp entry
  • How should we now keep track of the ward info on the wiki? Do we actually need to? Or is it sufficient to tell the number of beds at Grace Medicine on this wiki? Ttenbergen 18:11, 2020 October 13 (CD per ward is being reported.
2020-10-22 9:54:15 PM
Change from Service Location to Service, Boarding Loc and Transfer Ready DtTm tmp entry
  • If this is going to be the main page for all the changes that occurred suddenly October 15, should be include something about starting collection at accept time vs admit time? I feel like we need a central location for all the changes that happened and this might be the best spot. (blezak)
2020-10-22 9:54:15 PM
Change from Service Location to Service, Boarding Loc and Transfer Ready DtTm tmp entry
  • Occupancy per ward is being reported and/or requested. I have to change my program using the boarding loc info - have two fields arrival and departure per boarding location. it is very important that the location and dates arrived must be promptly entered so I can calculate occupancy accurately for the right physical location. --JMojica 09:38, 2020 October 14 (CDT)
2020-10-22 9:54:15 PM
Change to start collection at accept rather than arrive time
  • need a way for collectors to enter pre-arrive TISS data - or do we?
2020-10-22 6:01:43 PM
Check has transfer ready entry
  • On a first read I am not sure how we would make sure this exists for each level of care; it would be a complicated query; how badly do we want this?
  • Is there a simplified version that only makes sure a first entry exists, and that any entry that does exist is internally consistent (no time checkbox vs having a time vs presence of acceptable comment entry)
2020-10-16 4:46:34 AM
Check if awaiting code is primary dx then Transfer Ready DtTm must be equal to Arrive DtTm
  • new check should likely go against Boarding Loc entries instead of Arrive DtTms
  • Now that there may be several Transfer Ready DtTm tmp entry entries, is that check still the right logic? Should it instead check every awaiting code against a TR date entry? Or does the whole thing become so messy that we shouldn't do it at all?
2020-10-16 4:28:47 AM
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
Checking TISS Data from CCMDB.accdb The pages Flagging for TISS and Checking TISS Data from CCMDB.accdb are likely evil twins, or at least evil cousins. 2020-06-16 9:34:32 PM
Cognos Admitter
  • Michelle and Sherry both reported that a patient wasn't on the Cognos list when they should have been. When I got around to checking the list a few days later, the pt was on the list. So If a patient is not on the Cognos list, please email me the details and keep track of it, but don't enter them manually. Then check the next day to see if the pt is on the list then. Ttenbergen 14:47, 2020 September 22 (CDT)
2020-09-22 7:47:58 PM
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.
    • at this point, rather than working this out it would be best to wait until PatientFollow Project, which will make this grouping of records much simpler. Ttenbergen 10:41, 2020 July 29 (CDT)
2020-09-22 7:47:58 PM
Cognos Admitter
  • We have had patients transferred from MICU to a boarding location that are not showing up in the admitter, because on transfer they are still under critical care medicine, they are changed to medicine service at a later date. Will they show up on the admitter when their service is changed from critical care to medicine service? if not these admissions will be missed. Lisa Kaita 13:50, 2020 July 13 (CDT)
    • That is an interesting scenario. To start with, are we talking about the admitter or the discharger where these are not showing up? Then: I think right now the discharger only shows lines that have a unit end date; should it also show lines that have a service end date, then? It would be an easy change, it would just mean more lines you don't need to deal with showing up in discharger. Is there anything else that we would be able to filter on to only show service changes when they make a record relevant to our discharges? For example, would this be only if someone is on a unit where we don't collect? And, have you had a look at the raw data, are the lines actually in there? This might be a niche case where they are not, so good place to start. Ttenbergen 16:51, 2020 July 15 (CDT)
    • They should show up in Admitter once the service changes. Pls let me know if they don't. Which EPR Report do these show up on, then? I can't think why the EPR report would catch this but Cognos would not. Do they not enter the unit change for thes pts into EPR? Ttenbergen 16:16, 2020 August 12 (CDT)
2020-09-22 7:47:58 PM
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)
      • I have added better connecting of l_log, boarding loc and cognos data; if there are still duplicates, let me know examples. Ttenbergen 15:04, 2020 June 3 (CDT)
        • There are less duplicates, but on a couple of patients that moved from two different units that I collect on, there was no peach color allowing me to enter a new profile on the patient. I don't know if this is because I entered the dispo time on profile #1 prior to creating profile #2, but even when I went in and deleted the dispo information, the two lines still showed up as light green. I then went into my CCMB and entered a new profile for that patient using the patient copier button, at which time I had four lines for that patient in my admitter, one of them is now peach. Not sure how to better explain this unless I am showing you as it is happening...
          • I changed the colours and how they are generated pretty much completely (two buttons now); please give it a try now and let me know if it still misbehaves. Ttenbergen 23:01, 2020 June 29 (CDT)
2020-09-22 7:47:58 PM
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 working on a way to deal better with the Boarding Loc entries.
      • Cognos Discharger should be an easier place to deal with transfers; I would always deal with discharger first. And Patient Viewer Tab Cognos ADT is an easier place to deal with tmp/boarding transfers, so if a record looks like it should have boarding records, open it from Admitter and then do the actual additions in there. The color indicator where a tmp already exists should be fixed now. Ttenbergen 23:01, 2020 June 29 (CDT)
2020-09-22 7:47:58 PM
Cognos data not showing up in ADT tab
  • If you encounter the problem, please try the steps above and tell me what you find. I have thought several times now that I finally figured this out, but there must still be some scenarios I have not thought of. Ttenbergen 17:43, 2020 October 13 (CDT)
2020-10-13 10:48:14 PM
Cognos Report Integrator Where should this live? 2020-07-31 2:45:03 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
Courier
  • Would that make it cheaper to just print things at GRA as required, especially since printer project means we no longer pay wear and tear or toner? Ttenbergen 10:49, 2020 September 23 (CDT)
2020-09-23 3:51:24 PM
Courier This is inconsistent with the GRA instruction below where it says no cost centre required. 2020-09-23 3:51:24 PM
Courier this needs to be made consistent with what is written above. actually, should there even be two sections of instructions or just one? Ttenbergen 2020-09-23 3:51:24 PM
COVID-19 (SARS-COV-2)
  • For people who are admitted with Covid-19 pneumonia, should COVID-19 be the primary diagnosis or pneumonia, viral? I would normally do pneumonia not the organism, but I'm wondering for COVID data collection if the process is different. (blezak)
    • Please follow the same rules as usual for Primary Admit Diagnosis, code the pneumonia, that way our long term reporting doesn't get any weird discontinuities. If we need to report something for COVID we can still find that it was associated with the same priority. Ttenbergen 18:29, 2020 October 21 (CDT)
2020-10-21 11:29:34 PM
Critical Care and Medicine Database Core Curriculum
  • This is no longer true with PatientFollow Project; how should we best give the one-liner here and then link to the instructions there? Ttenbergen 15:11, 2020 October 23 (CDT)
2020-10-23 8:11:53 PM
Data collection log form
  • emailed Lisa to find out if/how these are actually still used.
2020-07-25 4:30:13 AM
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-07-25 4:30:13 AM
Data collector xxdc account for EPR 2020-08-21 2:43:39 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
  • The way this is worded: "Collection for medicine patients starts at Accept DtTm ie possibly while in ER." makes it sound like CCI collection starts at accept time, which isn't the current practice. Maybe we could change the wording to say "except for CCI counts"?
    • Good point, I think the definition might not have been updated after we moved to ICD10/CCI. Are there other things which we collect differently during the ER part of the admisison?
    • And then there are EMIPs, and I believe for those we do collect the CCIs during their ER stay... I updated the statement, please have a look and see if it more fully captures things now. Ttenbergen 15:31, 2020 August 19 (CDT)
    • Actually, I think some of this has been discussed at Task meeting lately, so this might be outdated already or at least in flux. Ttenbergen 15:31, 2020 August 19 (CDT)
2020-10-23 5:53:28 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-10-23 5:53:28 PM
ECIP
  • Actually I am not sure if "* Critical Care / *" would always be MICU, the list includes "HSC Critical Care / Orthopedics" and "HSC Critical Care / Plastics", what does that even mean? Ttenbergen 15:36, 2020 October 6 (CDT)
2020-10-16 12:51:47 PM
ECIP 2020-10-16 12:51:47 PM
ECIP
  • As per email discussion with Lisa: "We could also have a safety net where by the other ICU collectors could email the collectors at HSC when they receive an admission from HSC ER?"
    • If others receiving an admission from HSC ER would be a filter, we might actually have that info in Cognos, it just would not be showing up in your (ie HSC’s) data at this time. But that would mean collectors would always need to review patients who went to another ICU from the HSC ER (and likely the same for the STB ER, possibly even the GRA one...), so that seems like a lot of overhead. Are we OK to just identify SICU ECIPs as a population we likely usually don't capture? Ttenbergen 15:36, 2020 October 6 (CDT)
  • On the online Bed Board (https://whiteboard.manitoba-ehealth.ca/whiteboard/icu), there is a column OFF_service Patients which means any patient overflowing to either Resuscitation room in ED, PACU/PARR, ICCS, etc. and entry is real time. For HSC SICU, the common overflow location is PACU (haven’t seen any at ER). Only GRA ICU shows overflows in ER. This may give us a clue for possible ECIP but not sure how DC will crosscheck the online bed board if the timing won't synchronized. maybe we just have to ignore SICU ECIP if there is such a thing. --JMojica 16:27, 2020 October 6 (CDT)
2020-10-16 12:51:47 PM
ECIP
  • The GRA MICU does not use the ECIP Code, there is no option for this in our Service Location.Gens 07:25, 2020 October 16 (CDT)gens
    • No one had an ECIP code. This sort of thing was not collected until now, and we used to think it doesn't exist, especially at GRA. We now think it probably does happen: a pt taken care of critical care in ER who never makes it to ICU. This page just explains how they should be entered if you encounter them.Ttenbergen 07:51, 2020 October 16 (CDT)
2020-10-16 12:51:47 PM
ECIP
  • what would even be the actual definition of a surgical / SICU ECIP? There is no surgical equivalent to a "Critical Care service" it seems. Ttenbergen 15:36, 2020 October 6 (CDT)
2020-10-16 12:51:47 PM
Emergency Surgery (concept) This info is from 2009 - is it still the same? 2020-04-10 1:44:48 AM
EMIP
  • ...with the exception of the ER delay pop up which pops up 4 times, we check the first time but find the remaining 3 reminders slightly overkill...
    • Can you confirm that this is the check Query ''check ER Delay not too big''? If so, then the problem should be gone now, since we can't run that check any more (will need to be replaced with a new check that goes between Boarding Loc entries eventually, but the mechanism that causes multiple errors won't be an issue any longer for those). This is also tracked in Multiple LOS errors. Ttenbergen 22:12, 2020 October 18 (CDT)
2020-10-21 7:53:17 PM
EMIP
  • Is that still true that we can't dispo to an ER? Should we be able to? EG if Emergency Medicine takes them back (does that happen?) or they get sent to another site's ER? Why should that not be allowed? Ttenbergen 21:59, 2020 October 18 (CDT)
2020-10-21 7:53:17 PM
EMIP
  • Should we now re-define this as "Patient who has a record in EPR/Cognos Report Integrator for a Service we collect while in ER , and who does not then end up on one of the wards/units that correspond with that service, regardless where they go instead." and then turn the specific scenarios into examples rather than keep them part of the definition? I guess it depends on the outcome of the discussions under #Identifying EMIPs...
2020-10-21 7:53:17 PM
EMIP
  • There are emails flying back and forth right now that make it clear that the identification process described here is not the full, true story. Hopefully someone who actually uses the process can fix that. Likely best to wait until after the meeting about this on the afternoon of Oct 22. Ttenbergen 14:52, 2020 October 21 (CDT)
2020-10-21 7:53:17 PM
EMIP
  • What would be the best approach:
    • Enter them as EMIP and change the location to a Ward later if the patient arrives on a ward; this would provide the most complete data but would cause Orphans in Centralized data.mdb when changed to a ward later
    • delay entering them until it is clear whether they have become an EMIP or a fully arrived patient
      • After discussion in the office we thought the best option would be to delay entering them until we know if they are an EMIP or a regular ward admission. We thought a pop up reminder when you "x" out of the admitter window would be helpful (you have un-entered admissions do you really want to close?) or something like that would be helpful. We all here read the pop-ups and find them helpful, ...
        • This will likely be addressed by 2020-10 EMIP changes. If it has been addressed, please integrate and delete the discussion.
2020-10-21 7:53:17 PM
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
  • As reported by Mailah: "I am trying to open reports integrator and I am encountering this error message. This also happened on Monday. "
    • Requesting a copy of the exported file from Mailah. Also asking if there is a file from a few days ago that didn't cause this misbehaviour. Ttenbergen 09:46, 2020 July 16 (CDT)
2020-07-16 2:50:19 PM
EPR Reports Integrator
  • As reported by Michelle: "I am using the integrator to enter a couple of patients that aren’t on the Cognos admitter. When I enter them, the MRN is showing up with all of the leading zeros, and the dash. I checked with Lisa, and she hasn’t had the same issue this morning."
    • Requesting a copy of the exported file from Michelle. Also asking if there is a file from a few days ago that didn't cause this misbehaviour. Ttenbergen 09:46, 2020 July 16 (CDT)
2020-07-16 2:50:19 PM
EPR Reports Integrator
  • I have emailed the service desk requesting info about how the EPR software update will affect EPR reports. INC000004174208 Ttenbergen 09:50, 2020 July 16 (CDT)
2020-07-16 2:50:19 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)
      • We never set a time for this. Pam, if this is still an issue, please lets book a time to discuss Ttenbergen 09:33, 2020 July 16 (CDT)
2020-07-16 2:50:19 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
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
Flagging for TISS The pages Flagging for TISS and Checking TISS Data from CCMDB.accdb are likely evil twins, or at least evil cousins. 2020-06-16 9:34:43 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)
      • Sorry, missed this when it was written - is it still needed? Ttenbergen 16:16, 2020 July 29 (CDT)
2020-07-29 9:16:32 PM
GRA Boarding Locations
  • PACU? Anything else?
2020-01-31 8:16:29 PM
GRA ER use as borrow location
  • Does GRA successfully track these in Cognos Report Integrator now? If not, what is stopping you from finding them in there. We should be phasing out EPR Reports Integrator since I am no longer making changes to it and we are phasing it out. Ttenbergen 08:02, 2020 October 16 (CDT)
    • I will tentatively say yes they're tracking … beds are tight so we've been seeing more EMIP's lately. I think the biggest barrier is our eagerness to get records entered. We see them in EPR and if they're not in Cognos we think they're missed. We'll start waiting for another Cognos cycle to see if they show up and if they're missed after 2 cycles we'll let you know. As far as Integrator goes, we haven't used EPR Reports Integrator since we switched to Cognos. Surbanski 13:53, 2020 October 16 (CDT)
      • OK, good to know that this doesn't mean EPR Integrator needs to be kept up for this. I am sure you will let me know if they don't show up in Cognos. Ttenbergen 21:36, 2020 October 18 (CDT)
2020-10-19 2:36:22 AM
GRA General Collection Guide
  • is that still true? Is there a local link that could be put so that when this changes it will get updated?
2020-10-09 1:28:26 AM
GRA ICU Collection Guide
  • Is this section still relevant? I thought GRA was using Cognos to identify, keep track of and enter patients now. If these local paper logs are still part of the process, how do they fit in now with Cognos? If they are no longer part of the process, can we delete this section to reduce clutter. Ttenbergen 07:57, 2020 October 16 (CDT)
2020-10-16 12:57:41 PM
GRA Medical Records requests I moved info here that was in GRA General Collection Guide. It needs to be pruned down to a current state instruction for what a vacation covering collector would need to know: where is MedRec, how do we request charts, and how do we access them once available. Ttenbergen 15:36, 2020 October 7 (CDT) 2020-10-07 8:36:17 PM
GRA Medicine Collection Guide Is this section actually relevant to collection? How would a vacation covering collector from elsewhere need to use this? If it's not relevant, can we take it out? 2020-10-09 2:03:28 AM
Grace Hospital Contacts Where is that form? Is there a link? 2020-01-02 2:15:10 AM
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 Boarding Locations 2020-10-09 2:36:32 AM
HSC Boarding Locations
  • 2018_Aug_1: Dr Dowhanik /Dr. Vanymede are emptying the B5 medicine beds and will not admit into them unless "emergency/ absolute need" for medicine overflow patient movement. The B5 bed overflow option will be "formally closed" within 6 months.-Llemoine 09:25, 2018 August 1 (CDT)
    • Did that ever happen? If so, can we clean this section out of here if it's no longer applicable? Ttenbergen 21:36, 2020 October 8 (CDT)
2020-10-09 2:36:32 AM
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-06-05 3:48:57 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-06-05 3:48:57 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
Identifying ICU admissions
  • what are those plans? Are we still planning to? Ttenbergen 09:31, 2016 November 10 (CST)
    • I suspect not, since that would bring us back to the problems we had with Moves for Medicine. Then again, Boarding Loc does much of that, and Cognos would give us all unit and service moves, so this would actually be quite feasible now. Ttenbergen 13:42, 2020 July 24 (CDT)
2020-10-22 4:25:56 PM
Identifying ICU admissions
  • What is this Affinity software, is it another name for the EPR or is it a separate tool?
2020-10-22 4:25:56 PM
Identifying ICU admissions 2020-10-22 4:25:56 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)
    • we can print reports but are still looking for a way to find service transfers while in ER
2020-10-22 4:25:56 PM
Identifying ICU admissions multiple questions, especially for HSC and GRA 2020-10-22 4:25:56 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
Isolation, infectious For EMIPs with covid suspect as part of admit dx list and already on isolation, would the isolation be considered an admit or acquired CCI? 2020-10-23 5:16:33 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
Medicine Curriculum Any other links that would be helpful to new medicine collectors at all sites? --Jvelasco 15:29, 2020 July 3 (CDT) 2020-07-09 4:31:20 PM
New Pt Serial helper form With the new changes to patient follow and having general MED and CC Service Loc is there any way to make this the default? So for us in GH Medicine our default would be GRA_MED? Or to have the specific units removed? Surbanski 08:00, 2020 October 22 (CDT) 2020-10-22 1:00:25 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
PatientFollow Project
  • Could an HSC collector please have a look at HSC Medical Records requests to make sure it is consistent with these changes? Once you have dealt with that, please take out this discussion. Ttenbergen 21:34, 2020 October 15 (CDT)
2020-10-23 10:09:29 PM
PatientFollow Project Is this correct, Grace Med DC? or you went back to Sept 1,2020? --JMojica 17:09, 2020 October 23 (CDT) 2020-10-23 10:09:29 PM
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
Pre-admit Inpatient Institution field what are those entered as then? 2020-10-20 9:10:37 PM
Previous Location field
  • S dispo chooser‎ probably no longer makes sense now; will either need to be updated or removed. Does anyone actually use this? Ttenbergen 15:55, 2020 October 20 (CDT)
2020-10-21 11:21:07 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-10-19 4:18:25 AM
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 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
Reset Button
  • This button exists for ancient legacy reasons, generally opening and closing the program is easier and as fast. I will get rid of it in some future version unless someone tells me within the next week or so that they use it and would like to keep it. If you don't use it, NNTR. Ttenbergen 15:17, 2020 July 23 (CDT)
2020-07-23 8:17:18 PM
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
Sending TISS forms Do you do collect forms for combined sending / drop off? Where, how? 2020-09-23 3:50:33 PM
Sending TISS forms Do you do collect forms for combined sending? Where, how? 2020-09-23 3:50:33 PM
Service tmp entry
  • Are we adding the date and time that each service takes over? Where do we find this information on EPR? (blezak)
    • Good point. The data is in the Cognos Admitter; what was the "Accept DtTm equiv" and only visible if pt came from ER is now the Service Start DtTm, and always visible. Change is in v2020-10-21-1. If that answers the question, please remove the discussion. If not, please elaborate. Ttenbergen 18:15, 2020 October 21 (CDT)
2020-10-21 11:15:28 PM
Service tmp entry
  • should be able to add something to Cognos Admitter and Patient Viewer Tab Cognos ADT that facilitates entering and viewing this; will delay that until we have collected this for a little while; if we find these entries to be identical to Cognos data we might not need to enter them at all but instead import them directly, but not until we have checked consistency. And if we can stop entering Accept and Arrive, and service location becomes trivial we can safe space.
The thing is, that tab is getting very full, and I will need to either make fonts smaller or squeeze an area to show even fewer lines. I wonder how best to do that in a way that works for collectors. It’s on the “later” pile for now, but for sure something I want to deal with. Open to suggestions. Ttenbergen 12:24, 2020 October 16 (CDT)
2020-10-21 11:15:28 PM
Sorting Cognos Admitter freezes program
  • This is in Cognos Admitter right? I can't replicate the problem. Which field are you sorting on? And what do you do before you sort, I wonder if that's part of what needs to happen for it to freeze.
  • Will just closing the admitter form not fix it, do you really need to close CCMDB altogether? Ttenbergen 09:19, 2020 October 16 (CDT)
2020-10-16 3:42:00 PM
STB ACCU Collection Guide
  • Is this still done? How does this actually impact collection, ie why would these pts be marked so?
2020-06-29 4:03:48 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 Critical Care Collection Guide
  • The following seems to be different than what is in Admit_Type_for_APACHE_II - there it says they have to be directly from OR.
  • These things should be the same for medicine and critical care at STB, no? If any instructions separate from Admit Type for APACHE II are actually required, they should live in STB General Collection Guide instead of here. Ttenbergen 15:40, 2020 October 7 (CDT)
2020-10-07 8:40:42 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 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 Medicine Collection Guide will any med collectors be on site at intervals like STB_Critical_Care_Collection_Guide#IMPORTANT_INFORMATION_DURING_COVID_PANDEMIC? 2020-10-09 1:12:33 AM
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
Survey about deleting files after sending
  • How frequently does Pagasa send for people and therefore requires manual deletion?
2020-06-05 11:40:40 AM
Survey about deleting files after sending emailed Marla for reply 2020-06-05 11:40:40 AM
Swap Locations
  • one option would be to delete lines with current unit is a swap location from the cognos data, but it's not clear if this will result in the previous and subsequent records having non-matching next locations and previous locations. Can we just delete these lines from Cognos? Discussing with Lisa... Ttenbergen 14:03, 2020 August 28 (CDT)
2020-08-28 7:21:41 PM
Swap Locations 2020-08-28 7:21:41 PM
Task Team Meeting - Rolling Agenda and Minutes 2020 2020-10-21 10:57:35 PM
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-10-21 10:57:35 PM
TISS28 Collection Guide
  • How is that different from above and is that still correct for PatientFollow?
2020-10-23 8:41:14 PM
TISS28 Collection Guide
  • Is that still correct for PatientFollow? I think main office would be fine if the same form was used, but not sure how that would work for collectors. In fact, main office might find duplication in TISS items if we don't use the same form; no idea if that will be a problem, Pagasa will need to flag if it happens. Ttenbergen 15:41, 2020 October 23 (CDT)
2020-10-23 8:41:14 PM
TISS28 Collection Guide
  • The following two lines are not applicable to the data collector, so who are they for? Is the intended audience for this page not a data collector? If we want to put instructions for unit nurses those really are a different audience and should be a different page, e.g. Bedside nurse education for TISS28. Joanna, could you have a look? Ttenbergen 15:23, 2020 October 23 (CDT)
2020-10-23 8:41:14 PM
Transfer Ready DtTm field
  • I believe this contradicts the information on the Transfer Ready DtTm tmp entry page, not sure which is correct. I thought we were doing a transfer ready line for every physical location, not just lower levels of care?
    • The distinction is between what means transfer ready (that is a matter of intent to discharge) and the things that actually happen (pt became worse and went to a higher level of care). The definition below is right for what defines when pt is transfer ready. The explanation in Transfer Ready DtTm tmp entry essentially just says when the clock re-sets, and that could either be because pt was successfully moved to a lower level of care, or because they died (still no longer taking up a bed) or because they became worse and went to a higher level of care (again no longer waiting for that initial lower level of care). Ttenbergen 14:19, 2020 October 19 (CDT)
2020-10-19 7:19:51 PM
Transfer Ready DtTm tmp entry
  • For the date cutoff are we referring to admission date, transfer ready date, or discharge date? Surbanski 10:22, 2020 October 16 (CDT)
2020-10-20 3:14:50 PM
Transfer Ready DtTm tmp entry
  • So do we need a transfer ready time for every physical move - for example, ER to D4, D4 to H4? Or only when a patient moves to a lower level of care. So when ER --> D4, no transfer ready time, but D4 --> WRS3, we would have a transfer ready time.
    • no new entry for same level of care, but entry for higher or lower level of care. Why higher as well? Because once a patient actually moves to a higher level of care, the original determination that they were transfer ready almost certainly is no longer valid. The only exception might be the original ER entry - that is a high level of care location, but would we expect someone to become transfer ready there and then still move to the ward? Probably not. I'd say no entry for that part, but should see what Julie has to say. Ttenbergen 15:16, 2020 October 16 (CDT)
      • Should we be entering a date/TM for every entry? the reason I ask is because if we check off B and put not transfer ready in column Q, we often have multiple entries, How will Julie know which boarding LOC is associated with each transfer ready entry without a date? Lisa Kaita 10:14, 2020 October 20 (CDT)
2020-10-20 3:14:50 PM
Transfer Ready DtTm tmp entry Moving this into a different topic because it's about how to interpret these, not how to enter them
  • This is my dilemma with our definition, it is the intent which I cannot qualify thru the data. if I see an entry in transfer ready date but the physical transfer location is the same or higher level of care, I have to consider that transfer ready date to be valid. I rely that the entry is correct. I rather have the definition to be consistent with the level of care (except for Deaths) so I can quality check the transfer date entry and remove the intent as part of the definition. The goal is to measure bed wastage and when the patient moves to the same or higher level of care, that is not bed wastage to me. --JMojica 10:18, 2020 October 16 (CDT)
    • When the patient was deemed transfer ready, additional time in the ward was "wasted time" - if we could have sent them elsewhere we would have. If the patient later crashes, that doesn't make it not-wasted time - they could have crashed anywhere. So the interpretation that a pt moving to a higher level of care after transfer ready is not wasted time is not right. We discussed this repeatedly at task. The only way this makes sense is if it is done by intent. Ttenbergen 15:16, 2020 October 16 (CDT)
2020-10-20 3:14:50 PM
Update of D ID exclude service/location
  • can someone else think of how this might not work out right?
2020-08-16 10:53:45 PM
Using Cognos Report Integrator to keep track of patients
  • I am trying to set out how using Cognos Discharger, Cognos Admitter and Patient Viewer Tab Cognos ADT should make it possible to keep track of patients arriving and leaving. In some ways the process might be quite backward from what you do now, but the idea to have a process where the data just tells you the next thing to deal with, rather than you having to look for it. I would appreciate testing and feedback! Thanks!
2020-10-21 4:19:12 PM
Using Cognos Report Integrator to keep track of patients
  • We have discussed this at main office, but I will flag this question for Julie and Trish to make sure that my understanding that this is understood and accepted is correct. If so, Julie or Trish, please update this section and remove the discussion. Ttenbergen 11:18, 2020 October 21 (CDT)
2020-10-21 4:19:12 PM
Using Cognos Report Integrator to keep track of patients If we use the Cognos Discharger as I suggest, it would make sense to actually hide entries from it that have either a corresponding Boarding Loc or Dispo entry. They are entered, so if they disappear of the list then the list can be used to drive the process - once it's empty, you are done with it for the day. Are there any concerns about hiding records on here that have been entered? 2020-10-21 4:19:12 PM

All questions

There are currently 385 questions.

wiki page who question
"Delete Sent Patients" button Tina dev_CCMDB
  • disallow individual record delete on the patient lister built-in.
  • add a delete button that does the logical delete correctly on a per-patient basis.
  • this seems to be relatively low priority since we are not basing anything absolute on the logical delete feature, but needs to get done eventually to clean this up.
"EMIP" button all
  • If this button doesn't work as expected, please log it here. If nothing has been logged by Sep 30 this can be deleted. Ttenbergen 12:41, 2020 September 22 (CDT)
"Mine! Mine!" button all
  • Actually, does HSC CC use it? For them it would exclude the H6 patients if they sneak in somehow, but is it actually used, and if it's always used, should we just exclude those from the Cognos list altogether?
    • Sorry Tina, I have no clue what you are asking here...We don't ever use the MINE MINE button, and I'm not sure what H6 has to do with anything??
      • If I remember right, initially some H6 patients were showing up in the CC list because CC docs follow them there? If so, these H6 might show up on HSC CC Cognos Admitter. We don't follow these, so I had set up the minemine button for HSC CC laptops to exclude these. Are you not getting any of those H6 pts cluttering your list without the minemine button? Ttenbergen 12:03, 2020 October 21 (CDT)
    • I have never used the minemine button. As far as I remember you told us that it wasn't quite set up and not to use it. I might have missed the instructions to start? --Jvelasco 13:27, 2020 October 21 (CDT)
"View exclusions" button all
  • Is it possible to also see the names of the patients in the View Excluded tab, so it’s easier to tell who has been excluded if we have multiple patients in there? What if I want to put one back and not the others? How do I find that one patient in a list of hospital numbers…--Jvelasco 11:28, 2020 June 12 (CDT)
    • That is actually not so straightfwd. I don't show the name, so would need to look it up based on chart, and that would turn it into a query, and from that we can't delete. I could build something like this, but would need a reason. Do we mistakenly exclude records often enough to make it worth it? If we do, I would be interested to know why, ie which part of our process has us excluding records that should not have been excluded? Ttenbergen 10:09, 2020 June 17 (CDT)
  • I haven't used this feature yet, but since it's there, people might want to exclude multiple entries for whatever reason. I just thought it would be easier to use if you could see names in there, if that was the case. In what scenario would we want to exclude one patient or multiple patients from the main admitter list? --Jvelasco 12:30, 2020 June 18 (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)
    • Did not happen at all. we can ignore this scenario. --JMojica 10:00, 2020 June 12 (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)
      • update There are no COVID specific suspect or positive wards as of May 27, 2020 Lisa Kaita 13:49, 2020 June 11 (CDT)
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?
  • Did not happen at all. We can ignore this scenario for now. --JMojica 10:02, 2020 June 12 (CDT)
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
  • 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 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)
  • Suspects are on units ICSM, ICCS and ACCU. COVID+ are in ICMS together with the nonCovid as shown in the database.--JMojica 10:33, 2020 June 11 (CDT)
2020-05 HSC COVID unit transition all what needs to change on laptops? Trish Ostryzniuk 18:00, 2020 May 12 (CDT)
2020-06 s dispo table cleanup all
  • Emailed Pagasa to change STB_E5a-880 one to service location STB_E5 so we can delete the STB_E5 entry. Ttenbergen 14:22, 2020 June 5 (CDT)
2020-06 s dispo table cleanup all
  • The pages behind the following links should probably be deleted, since there are no entries for them; however, at least some of them are linked from other places, so those links need to be cleaned up as well...
2020-10 COVID unit collection Julie
  • As in the first wave will we exclude those patients that are not under any of our medicine services? Ie. neurology and respiratory patients but we do include nephrology patients.
    • I will pass this question on to Julie, since reporting needs should drive the answer to this. Ttenbergen 21:22, 2020 October 15 (CDT)
2020-10 EMIP changes Tina Will need to reconcile the following:
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
Accept Loc Park Task
  • Does this go away as well now as part of Change from Service Location to Service, Boarding Loc and Transfer Ready DtTm tmp entry? If not going away, pls update. Ttenbergen 23:07, 2020 October 18 (CDT)
    • should go away. maybe wait until the DC implement this in the new scheme and no more questions before we remove this article.
      • OK, turning it into a Task item so we can confirm there that we are ready to do away with this. Ttenbergen 14:11, 2020 October 19 (CDT)
Acquired Diagnosis / Complication Allan
Acquired Diagnosis / Complication Task
Acquired Diagnosis / Complication Task this relates to Attribution of infections and we need to be sure to have it consistent.
ACS Allan 1
ADL General Collection Information Task
Admit Diagnosis Allan 1
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 Diagnosis Task
Admit Type for APACHE II all
  • Thanks for the clarification, Michelle. I like your explanation and think it is clear. We still have the flow chart floating around on this wiki, though: File:Patient Type Flowchart.gif; we should either get rid of it (preferred) or update and integrate it here (not preferred, since its contents would not be searchable). Ttenbergen 15:18, 2020 October 7 (CDT)
ALERT Scale timing of assessment all
Allan's links all
Allan's links Allan Hi Allan as per our discussion in the office can you help us determine how to code Hemophagocytic lymphohistiocytosis (HLH) a google search has determined that the proper ICD 10 code is D76.1 which we don't have. Thank youLisa Kaita 13:08, 2020 October 22 (CDT)
Attribution of infections all
  • Is the following correct, then:

A decided that an infection that is discovered within the first 48 hrs after admission should be coded as an Admit Diagnosis, and an infection discovered after that as an Acquired Diagnosis.

Attribution of infections Task
  • I finally figured out how to ask this at task: I was worried that we might apply the delay at the data entry end and also at the reporting end (i.e. the delay might be included twice or not at all, so we need to phrase and then link this correctly so it's clear whether the delay is considered at collection or at reporting. Ttenbergen 21:37, 2020 August 27 (CDT)
Attribution of infections Tina When this is all settled, the details need to be integrated into Template: ICD10 Guideline Infection, Lab and culture reports, Infections in ICD10
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
  • Does it really start in ER? since that's now one off-ward location? In any case, we should really only link to the definition in APACHE from here so this doesn't become inconsistent. If someone knows where that's documented, can you please confirm and fix? Ttenbergen 00:36, 2020 October 16 (CDT)
    • I haven't been able to find it on the Wiki, but I was told to get my values for my Apache from the previous location. So for example a patient getting admitted to the ward from ER, the Apache values would be the ones just prior to their Accept Dt/Tm. Think "this was their condition when they were accepted by medicine". If it's a transfer to the ward from ICU, I take the last values before they left. Surbanski 11:14, 2020 October 19 (CDT)
    • To confirm for patients admitted from ER, Apache vital signs are taken from closest to but prior to Accept Date/time?
      • For medicine yes. I don't know if ICU does anything different. If I've been doing it wrong I expect someone from medicine at the other sites will say something :) Surbanski 10:31, 2020 October 20 (CDT)
        • Dose ICU start there APACHE and TISS from the ER accept time or ICU admit time. Currently we collect from the ER accept time only when the patient is boarded in the ER for greater than 2 hours. Gthomson2 10:43, 2020 October 20 (CDT)
          • Since Oct.15th, I have been using the 24 hour period after the accept time, which means that I am including the applicable Vitals from ER if the patient was from the ER. I wasn't at the task meeting yesterday, so I don't know if this was discussed, but this was my understanding of how we are supposed to collect apacheMlagadi 11:02, 2020 October 23 (CDT)
Boarding Loc all
  • This would now mean TISS starts in ER if the pt is in ER long enough. We discussed that a while ago and I can't remember the outcome. This might need to be updated to correspond to that. Or rather, this should only be a link to that so it doesn't go inconsistent in the future. If some one knows what was decided, can you please fix this? Ttenbergen 00:36, 2020 October 16 (CDT)
Boarding Loc all Which if any of Project_Borrow_arrive#Data_Integrity_Checks_.28SMW.29 will need to be moved over to this instead?
Boarding Loc Tina
  • inactivate legacy entry Home Medicine ward once last pt using it is discharged
Boarding Loc Tina
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)
Cardiac arrest Allan
  • Should we be coding cardiac arrest as a comorb if they have a past history of cardiac arrest? Or is it considered resolved? Some of us are coding it as a comorb and some of us aren't. Thanks - Brynn
    • I think Comorbid_Diagnosis#When_not_to_code_a_dx_at_all answers this, but you say some people code it differently. Could someone who codes this as a comorbid explain why they code it? I want to flag this for my meeting with Allan to address collector questions, and I think we will need to know what the reasoning is. Ttenbergen 09:30, 2020 August 26 (CDT)
      • I have included this code for a patient with a fairly recent arrest and also to highlight the extent of their CAD and comorbs. I would also likely include it if the admitting diagnosis is cardiac related.
--Mailah Damian 13:08, 2020 September 4 (CDT)
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.
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?
Change from Service Location to Service, Boarding Loc and Transfer Ready DtTm tmp entry all
  • How should we now keep track of the ward info on the wiki? Do we actually need to? Or is it sufficient to tell the number of beds at Grace Medicine on this wiki? Ttenbergen 18:11, 2020 October 13 (CD per ward is being reported.
Change from Service Location to Service, Boarding Loc and Transfer Ready DtTm tmp entry all
  • If this is going to be the main page for all the changes that occurred suddenly October 15, should be include something about starting collection at accept time vs admit time? I feel like we need a central location for all the changes that happened and this might be the best spot. (blezak)
Change from Service Location to Service, Boarding Loc and Transfer Ready DtTm tmp entry all
  • Occupancy per ward is being reported and/or requested. I have to change my program using the boarding loc info - have two fields arrival and departure per boarding location. it is very important that the location and dates arrived must be promptly entered so I can calculate occupancy accurately for the right physical location. --JMojica 09:38, 2020 October 14 (CDT)
Change from Service Location to Service, Boarding Loc and Transfer Ready DtTm tmp entry Tina
  • what is the the name of the LOS check? It needs to change with this change
Change from Service Location to Service, Boarding Loc and Transfer Ready DtTm tmp entry Tina
  • Template:Collection Location fields "Collection Service Type Legacy" and "Collection Workload Split" and "Collection Service Type" and "Collection Collector" are becoming meaningless, what is the best way to clean that up? This whole template needs to move to Cargo instead of SMW. Ttenbergen 17:39, 2020 October 15 (CDT)
Change to start collection at accept rather than arrive time all
  • need a way for collectors to enter pre-arrive TISS data - or do we?
Change to start collection at accept rather than arrive time Allen
  • For ICU patients we will decide on a Minimum data set of TISS items to be collected when patients are boarding. These will have to be recorded by collectors.
    • Of note, Tina reports that the DSM data we’re getting DOES include labs from the time in ED, so she will simply need to include the lab data from the time when our service takes over care.
  • Regarding the “machinery” for this -- discuss next time expanding the “Boarding Location” machinery to initial admission and all moves thereafter. In this schema, the name would be changed to something like “Physical Locations”, and the initial one would be wherever the patient was when he/she first began to be cared for by the service/team. This machinery can then easily be used by Julie to report on boarding, lengths of stay and every other aspect of location and timing of care. Because such moves are much more frequent and confusing for Medicine than ICU, as suggested by Michelle, for Medicine patients we would have only 3 possible physical locations: ED, their service location, or a generic boarding location which is not further subdivided.
  • We began to discuss that with the above changes, and the increased boarding that will likely become the norm, it would be simpler to keep track of database records not as we do now (i.e. by home location) but rather by home service. The machinery discussed above will allow Julie to write SAS code to slice and dice the information in any way desired -- e.g. time in each physical location (including high obs). After we discuss this more next time, Allan will talk to Drs. Renner/Hajadiacos if they see any major problems with such a change in process.
Change to start collection at accept rather than arrive time Task Page to track required and completed tasks to move to collecting data from Accept DtTm. If and when any of these things are changed there would be further discussion and documentation.
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 has service entry Julie
  • This probably needs to be considered in context of Minimal Data Set - if it is part of that it changes the check time (ie for all records or only for complete records?).
Check has transfer ready entry all
  • On a first read I am not sure how we would make sure this exists for each level of care; it would be a complicated query; how badly do we want this?
  • Is there a simplified version that only makes sure a first entry exists, and that any entry that does exist is internally consistent (no time checkbox vs having a time vs presence of acceptable comment entry)
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 if awaiting code is primary dx then Transfer Ready DtTm must be equal to Arrive DtTm all
  • new check should likely go against Boarding Loc entries instead of Arrive DtTms
  • Now that there may be several Transfer Ready DtTm tmp entry entries, is that check still the right logic? Should it instead check every awaiting code against a TR date entry? Or does the whole thing become so messy that we shouldn't do it at all?
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?
Checking TISS Data from CCMDB.accdb all The pages Flagging for TISS and Checking TISS Data from CCMDB.accdb are likely evil twins, or at least evil cousins.
Chest Physio (TISS Item) Trish sounds to me like this is still done differently by different people. Ttenbergen 12:58, 2017 July 27 (CDT)
Chronic Health APACHE Allan z
  • We are considering changing how this is collected to extracting the data from APACHE Comorbidities in ICD10 codes instead of coding a separate field. Further discussions to come. AG confirmed 2018-11-28 that this is an option
Cleaning up a failed send Pagasa
Cleaning up a failed send Pagasa
Cognos Admitter all
  • Michelle and Sherry both reported that a patient wasn't on the Cognos list when they should have been. When I got around to checking the list a few days later, the pt was on the list. So If a patient is not on the Cognos list, please email me the details and keep track of it, but don't enter them manually. Then check the next day to see if the pt is on the list then. Ttenbergen 14:47, 2020 September 22 (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.
    • at this point, rather than working this out it would be best to wait until PatientFollow Project, which will make this grouping of records much simpler. Ttenbergen 10:41, 2020 July 29 (CDT)
Cognos Admitter all
  • We have had patients transferred from MICU to a boarding location that are not showing up in the admitter, because on transfer they are still under critical care medicine, they are changed to medicine service at a later date. Will they show up on the admitter when their service is changed from critical care to medicine service? if not these admissions will be missed. Lisa Kaita 13:50, 2020 July 13 (CDT)
    • That is an interesting scenario. To start with, are we talking about the admitter or the discharger where these are not showing up? Then: I think right now the discharger only shows lines that have a unit end date; should it also show lines that have a service end date, then? It would be an easy change, it would just mean more lines you don't need to deal with showing up in discharger. Is there anything else that we would be able to filter on to only show service changes when they make a record relevant to our discharges? For example, would this be only if someone is on a unit where we don't collect? And, have you had a look at the raw data, are the lines actually in there? This might be a niche case where they are not, so good place to start. Ttenbergen 16:51, 2020 July 15 (CDT)
    • They should show up in Admitter once the service changes. Pls let me know if they don't. Which EPR Report do these show up on, then? I can't think why the EPR report would catch this but Cognos would not. Do they not enter the unit change for thes pts into EPR? Ttenbergen 16:16, 2020 August 12 (CDT)
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)
      • I have added better connecting of l_log, boarding loc and cognos data; if there are still duplicates, let me know examples. Ttenbergen 15:04, 2020 June 3 (CDT)
        • There are less duplicates, but on a couple of patients that moved from two different units that I collect on, there was no peach color allowing me to enter a new profile on the patient. I don't know if this is because I entered the dispo time on profile #1 prior to creating profile #2, but even when I went in and deleted the dispo information, the two lines still showed up as light green. I then went into my CCMB and entered a new profile for that patient using the patient copier button, at which time I had four lines for that patient in my admitter, one of them is now peach. Not sure how to better explain this unless I am showing you as it is happening...
          • I changed the colours and how they are generated pretty much completely (two buttons now); please give it a try now and let me know if it still misbehaves. Ttenbergen 23:01, 2020 June 29 (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 working on a way to deal better with the Boarding Loc entries.
      • Cognos Discharger should be an easier place to deal with transfers; I would always deal with discharger first. And Patient Viewer Tab Cognos ADT is an easier place to deal with tmp/boarding transfers, so if a record looks like it should have boarding records, open it from Admitter and then do the actual additions in there. The color indicator where a tmp already exists should be fixed now. Ttenbergen 23:01, 2020 June 29 (CDT)
Cognos data not showing up in ADT tab all
  • If you encounter the problem, please try the steps above and tell me what you find. I have thought several times now that I finally figured this out, but there must still be some scenarios I have not thought of. Ttenbergen 17:43, 2020 October 13 (CDT)
Cognos Discharger Tina I think we could exclude these by also linking based on the Accept DtTm/Arrive DtTm, but there were weird exceptions to this(e.g. first set of vitals for Arrive DtTm field). Not all sites used to use the values in EPR if they thought they had a better source, and I would need to check how this would affect EMIP records that don't have all the times. Ttenbergen 13:04, 2020 September 22 (CDT)
Cognos Discharger Tina Since moving to patient follow, I've found that now I've got 'clutter' in my Cognos Discharger with patients who have moved between medicine units. They usually clear out of Discharger if their Dispo info is entered, but now that we're not closing off profiles and creating new ones they linger (to give you an idea, I currently have about a dozen there right now). Is there any way to link this with the Boarding Loc? So that once their location change has been entered it clears out of the Cognos Discharger? Surbanski 08:48, 2020 October 20 (CDT)
Cognos Report Integrator all Where should this live?
Colonized with organism (not infected) Allan you wanted to update this list
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 1
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
Comorbid Diagnosis Task
Confidential waste disposal all collectors, please document what your process is at your office location.Trish Ostryzniuk 17:37, 2019 March 5 (CST)
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
  • Would that make it cheaper to just print things at GRA as required, especially since printer project means we no longer pay wear and tear or toner? Ttenbergen 10:49, 2020 September 23 (CDT)
Courier all This is inconsistent with the GRA instruction below where it says no cost centre required.
Courier all this needs to be made consistent with what is written above. actually, should there even be two sections of instructions or just one? Ttenbergen
COVID-19 (SARS-COV-2) all
  • For people who are admitted with Covid-19 pneumonia, should COVID-19 be the primary diagnosis or pneumonia, viral? I would normally do pneumonia not the organism, but I'm wondering for COVID data collection if the process is different. (blezak)
    • Please follow the same rules as usual for Primary Admit Diagnosis, code the pneumonia, that way our long term reporting doesn't get any weird discontinuities. If we need to report something for COVID we can still find that it was associated with the same priority. Ttenbergen 18:29, 2020 October 21 (CDT)
Crash TISS MDB Pagasa
Critical Care and Medicine Database Core Curriculum all
  • This is no longer true with PatientFollow Project; how should we best give the one-liner here and then link to the instructions there? Ttenbergen 15:11, 2020 October 23 (CDT)
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
  • emailed Lisa to find out if/how these are actually still used.
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 xxdc account for EPR all
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
  • The way this is worded: "Collection for medicine patients starts at Accept DtTm ie possibly while in ER." makes it sound like CCI collection starts at accept time, which isn't the current practice. Maybe we could change the wording to say "except for CCI counts"?
    • Good point, I think the definition might not have been updated after we moved to ICD10/CCI. Are there other things which we collect differently during the ER part of the admisison?
    • And then there are EMIPs, and I believe for those we do collect the CCIs during their ER stay... I updated the statement, please have a look and see if it more fully captures things now. Ttenbergen 15:31, 2020 August 19 (CDT)
    • Actually, I think some of this has been discussed at Task meeting lately, so this might be outdated already or at least in flux. Ttenbergen 15:31, 2020 August 19 (CDT)
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 Allan
  • putting this on Allan's list Ttenbergen 11:26, 2020 October 22 (CDT)
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 Allan
  • putting this on Allan's list Ttenbergen 11:25, 2020 October 22 (CDT)
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?
Desktop shortcuts for collection laptops Tina I tried to follow these instructions on restoring the shortcuts, but it did not work. I ended up talking to ehealth and they have a group there who specialize in shortcuts and they were able to help me. I referred them to this page on the wiki to see what shortcuts we needed and they were able to fix this for me.
  • Allyson had same issue on another day at STB and spend few hours trying to find files needed to do her work. ServiceDesk called back much later to help her but she had already sorted herself out. The bat file also did not work for her.--LKolesar 12:37, 2020 September 9
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)
Dispo field Tina Since no one person knows when this is the case on all laptops for all fields Tina will need to make a query that checks for this in the centralized data. Ttenbergen 15:42, 2020 October 20 (CDT)
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 all
  • Actually I am not sure if "* Critical Care / *" would always be MICU, the list includes "HSC Critical Care / Orthopedics" and "HSC Critical Care / Plastics", what does that even mean? Ttenbergen 15:36, 2020 October 6 (CDT)
ECIP all
ECIP all
  • As per email discussion with Lisa: "We could also have a safety net where by the other ICU collectors could email the collectors at HSC when they receive an admission from HSC ER?"
    • If others receiving an admission from HSC ER would be a filter, we might actually have that info in Cognos, it just would not be showing up in your (ie HSC’s) data at this time. But that would mean collectors would always need to review patients who went to another ICU from the HSC ER (and likely the same for the STB ER, possibly even the GRA one...), so that seems like a lot of overhead. Are we OK to just identify SICU ECIPs as a population we likely usually don't capture? Ttenbergen 15:36, 2020 October 6 (CDT)
  • On the online Bed Board (https://whiteboard.manitoba-ehealth.ca/whiteboard/icu), there is a column OFF_service Patients which means any patient overflowing to either Resuscitation room in ED, PACU/PARR, ICCS, etc. and entry is real time. For HSC SICU, the common overflow location is PACU (haven’t seen any at ER). Only GRA ICU shows overflows in ER. This may give us a clue for possible ECIP but not sure how DC will crosscheck the online bed board if the timing won't synchronized. maybe we just have to ignore SICU ECIP if there is such a thing. --JMojica 16:27, 2020 October 6 (CDT)
ECIP all
  • The GRA MICU does not use the ECIP Code, there is no option for this in our Service Location.Gens 07:25, 2020 October 16 (CDT)gens
    • No one had an ECIP code. This sort of thing was not collected until now, and we used to think it doesn't exist, especially at GRA. We now think it probably does happen: a pt taken care of critical care in ER who never makes it to ICU. This page just explains how they should be entered if you encounter them.Ttenbergen 07:51, 2020 October 16 (CDT)
ECIP all
  • what would even be the actual definition of a surgical / SICU ECIP? There is no surgical equivalent to a "Critical Care service" it seems. Ttenbergen 15:36, 2020 October 6 (CDT)
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
  • ...with the exception of the ER delay pop up which pops up 4 times, we check the first time but find the remaining 3 reminders slightly overkill...
    • Can you confirm that this is the check Query ''check ER Delay not too big''? If so, then the problem should be gone now, since we can't run that check any more (will need to be replaced with a new check that goes between Boarding Loc entries eventually, but the mechanism that causes multiple errors won't be an issue any longer for those). This is also tracked in Multiple LOS errors. Ttenbergen 22:12, 2020 October 18 (CDT)
EMIP all
  • Is that still true that we can't dispo to an ER? Should we be able to? EG if Emergency Medicine takes them back (does that happen?) or they get sent to another site's ER? Why should that not be allowed? Ttenbergen 21:59, 2020 October 18 (CDT)
EMIP all
  • Should we now re-define this as "Patient who has a record in EPR/Cognos Report Integrator for a Service we collect while in ER , and who does not then end up on one of the wards/units that correspond with that service, regardless where they go instead." and then turn the specific scenarios into examples rather than keep them part of the definition? I guess it depends on the outcome of the discussions under #Identifying EMIPs...
EMIP all
  • There are emails flying back and forth right now that make it clear that the identification process described here is not the full, true story. Hopefully someone who actually uses the process can fix that. Likely best to wait until after the meeting about this on the afternoon of Oct 22. Ttenbergen 14:52, 2020 October 21 (CDT)
EMIP all
  • What would be the best approach:
    • Enter them as EMIP and change the location to a Ward later if the patient arrives on a ward; this would provide the most complete data but would cause Orphans in Centralized data.mdb when changed to a ward later
    • delay entering them until it is clear whether they have become an EMIP or a fully arrived patient
      • After discussion in the office we thought the best option would be to delay entering them until we know if they are an EMIP or a regular ward admission. We thought a pop up reminder when you "x" out of the admitter window would be helpful (you have un-entered admissions do you really want to close?) or something like that would be helpful. We all here read the pop-ups and find them helpful, ...
        • This will likely be addressed by 2020-10 EMIP changes. If it has been addressed, please integrate and delete the discussion.
EMIP Julie
  • That is an interesting point. GRA_Med is not really a location. Julie, if you can confirm that this is how you want these coded, please take out the question, else how should they be coded? And same for ECIPs?
EMIP Julie
  • Ditto.
    • see above.
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 Analytics Tina
  • looking for further information about this.
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
  • As reported by Mailah: "I am trying to open reports integrator and I am encountering this error message. This also happened on Monday. "
    • Requesting a copy of the exported file from Mailah. Also asking if there is a file from a few days ago that didn't cause this misbehaviour. Ttenbergen 09:46, 2020 July 16 (CDT)
EPR Reports Integrator all
  • As reported by Michelle: "I am using the integrator to enter a couple of patients that aren’t on the Cognos admitter. When I enter them, the MRN is showing up with all of the leading zeros, and the dash. I checked with Lisa, and she hasn’t had the same issue this morning."
    • Requesting a copy of the exported file from Michelle. Also asking if there is a file from a few days ago that didn't cause this misbehaviour. Ttenbergen 09:46, 2020 July 16 (CDT)
EPR Reports Integrator all
  • I have emailed the service desk requesting info about how the EPR software update will affect EPR reports. INC000004174208 Ttenbergen 09:50, 2020 July 16 (CDT)
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)
      • We never set a time for this. Pam, if this is still an issue, please lets book a time to discuss Ttenbergen 09:33, 2020 July 16 (CDT)
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....
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.
Flagging for TISS all The pages Flagging for TISS and Checking TISS Data from CCMDB.accdb are likely evil twins, or at least evil cousins.
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)
      • Sorry, missed this when it was written - is it still needed? Ttenbergen 16:16, 2020 July 29 (CDT)
Glasgow Coma Scale Task
  • Will this 24 hour timeframe change for patients admitted from ER to begin/coincide with Accept DtTm for medicine program?
    • presumably same question applies for Critical Care program? Or would this be different? Ttenbergen 21:01, 2020 October 21 (CDT)
GRA Boarding Locations all
  • PACU? Anything else?
GRA ER use as borrow location all
  • Does GRA successfully track these in Cognos Report Integrator now? If not, what is stopping you from finding them in there. We should be phasing out EPR Reports Integrator since I am no longer making changes to it and we are phasing it out. Ttenbergen 08:02, 2020 October 16 (CDT)
    • I will tentatively say yes they're tracking … beds are tight so we've been seeing more EMIP's lately. I think the biggest barrier is our eagerness to get records entered. We see them in EPR and if they're not in Cognos we think they're missed. We'll start waiting for another Cognos cycle to see if they show up and if they're missed after 2 cycles we'll let you know. As far as Integrator goes, we haven't used EPR Reports Integrator since we switched to Cognos. Surbanski 13:53, 2020 October 16 (CDT)
      • OK, good to know that this doesn't mean EPR Integrator needs to be kept up for this. I am sure you will let me know if they don't show up in Cognos. Ttenbergen 21:36, 2020 October 18 (CDT)
GRA General Collection Guide all
  • is that still true? Is there a local link that could be put so that when this changes it will get updated?
GRA ICU Collection Guide all
  • Is this section still relevant? I thought GRA was using Cognos to identify, keep track of and enter patients now. If these local paper logs are still part of the process, how do they fit in now with Cognos? If they are no longer part of the process, can we delete this section to reduce clutter. Ttenbergen 07:57, 2020 October 16 (CDT)
GRA Medical Records requests all I moved info here that was in GRA General Collection Guide. It needs to be pruned down to a current state instruction for what a vacation covering collector would need to know: where is MedRec, how do we request charts, and how do we access them once available. Ttenbergen 15:36, 2020 October 7 (CDT)
GRA Medicine Collection Guide all Is this section actually relevant to collection? How would a vacation covering collector from elsewhere need to use this? If it's not relevant, can we take it out?
Grace Hospital Contacts all Where is that form? Is there a link?
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 Boarding Locations all
HSC Boarding Locations all
  • 2018_Aug_1: Dr Dowhanik /Dr. Vanymede are emptying the B5 medicine beds and will not admit into them unless "emergency/ absolute need" for medicine overflow patient movement. The B5 bed overflow option will be "formally closed" within 6 months.-Llemoine 09:25, 2018 August 1 (CDT)
    • Did that ever happen? If so, can we clean this section out of here if it's no longer applicable? Ttenbergen 21:36, 2020 October 8 (CDT)
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 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?
Hypoalbuminemia, severe Allan I see you removed the link to the guideline:

Symptom/Sign/Test Result not needed when cause known

  • This code identifies a symptom or a sign, or an abnormal test result, not a disorder.
    • So, you should code the cause of the symptom/sign/abnormal test, if known -- and if you do so, then also coding and combining the symptom/sign/abnormal test result to that cause is generally optional, but is guided by the following guidelines.
  • Here are guidelines for whether or not to ALSO code the symptom/sign/abnormal test when you DO code the underlying cause:
    • If it is a subjective symptom (e.g. pain) then coding it is optional
    • When it is a physical exam finding (e.g. abdominal tenderness) then coding it is generally optional
      • An exception is when the symptom/sign/abnormal testis so severe that all by itself it mandates hospitalization and/or a procedure -- a good example is a patient who has Wegener's granulomatosis is admitted due withHemoptysis. Since hemoptysis is a physical finding that fits this description of "severe" it should be coded, and combined with Wegener's.
    • When it is an abnormal laboratory finding which in and of itself has relevance (e.g. hyperkalemia, hypoalbuminemia) then USUALLY code it
      • You don't need to code the abnormal lab finding is when it is actually a major component of the underlying cause --- example is when a person presents with an acute MI, there is no need to code the abnormal troponin as Abnormal blood chemistry NOS
    • The trickiest of these guidelines is for abnormal radiologic tests
      • When the abnormal test is fully explained by the underlying diagnosis/diagnoses (e.g. pneumonia as cause of abnormal chest imaging, or a skull fracture with an intracranial hemorrhage both identified by an abnormal head CT) then coding the abnormal imaging result is optional
      • But remember there are some rare things for which the abnormal imaging result IS part of coding the entity, for example we code retroperitoneal hemorrhage by the combination of Hemorrhage, NOS and Retroperitoneal area, diagnostic imaging, abnormal
  • Sometimes there may be multiple symptom/sign/test result that might or might NOT be related to each other by virtue of having the same underlying cause. Since in the absence of KNOWING that cause, such assumptions may well be incorrect, do NOT combine them together if you are not certain they actually have the same underlying cause.
That guideline says that when reasons for results are known, the results don’t need to be entered. I just want to be sure that you removed that intentionally. If you did, we should probably both review that rule (since hypoalbuminuria is now an exception that should be stated) and probably review which other pages also call that template where you now think we should code them even if the cause is known.
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)
    • I suspect not, since that would bring us back to the problems we had with Moves for Medicine. Then again, Boarding Loc does much of that, and Cognos would give us all unit and service moves, so this would actually be quite feasible now. Ttenbergen 13:42, 2020 July 24 (CDT)
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)
    • 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 ICU admissions Allan
  • putting this on Allan's list Ttenbergen 11:25, 2020 October 22 (CDT)
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:
Isolation, infectious all For EMIPs with covid suspect as part of admit dx list and already on isolation, would the isolation be considered an admit or acquired CCI?
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 and culture reports Task
  • I doubt that we wait 5 days resp 2 weeks after the discharge of each patient to see if they had any results come back from the lab. So what do we actually mean by this? Ttenbergen 21:15, 2020 August 27 (CDT)
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?
Level of care hierarchy Allan
  • we are confused about the distinction with "lower level of care" with NTU... how do we resolve that? Ttenbergen 14:50, 2020 October 19 (CDT)
Level of care hierarchy Allan
  • We need a level for ER; with our new scheme, someone could conceptually be ready for a lower level of care than ER but be stuck there. Certainly for GRA who uses it for ICU. I think that level would be between ICU and IICU. Thoughts? Might be a question for Allan. For now I am setting this ER as a level between ICU and IICU; if OK please update this page accordingly, if needs discussion, please make it happen. Ttenbergen 19:18, 2020 October 15 (CDT)
Level of care hierarchy Allan
  • We need a level for PACU/Recovery; with our new scheme, someone could conceptually be ready for a lower level of care than PACU but be stuck there. C I think that level would be same as ICU. Thoughts? Might be a question for Allan. For now I am setting this the PACUs as a level same as ICU; if OK please update this page accordingly, if needs discussion, please make it happen. Ttenbergen 19:22, 2020 October 15 (CDT)
Level of care hierarchy Julie
  • I populated most of the s_level_of_care table; for the rest I would need a list of all locations tracked in comment and what level of care we would attribute to them. List needs to be pulled from CFE, and then levels added, and I don't know what those would be, so we need someone (Lisa?) to help us fill that in. This will be needed by Julie for reporting, but not for collectors to be able to work tomorrow, so I am leaving this for now. It if becomes important before I get back to it, catch me. Ttenbergen 19:35, 2020 October 15 (CDT)
    • where is the list? cannot see it in CFE. I got the ver2020-10-15. --JMojica 11:56, 2020 October 20 (CDT)
      • List is in CCMDB.accdb, would need to be linked into CFE if you want to see it from there. Ttenbergen 11:01, 2020 October 22 (CDT)
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.
Medicine Curriculum all Any other links that would be helpful to new medicine collectors at all sites? --Jvelasco 15:29, 2020 July 3 (CDT)
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?
Multiple LOS errors Tina
  • Flagged as still a problem in 2020-10, possibly for Query ''check ER Delay not too big''; if so, it's now fixed since that check got disabled. Ttenbergen 22:08, 2020 October 18 (CDT)
New Pt Serial helper form all With the new changes to patient follow and having general MED and CC Service Loc is there any way to make this the default? So for us in GH Medicine our default would be GRA_MED? Or to have the specific units removed? Surbanski 08:00, 2020 October 22 (CDT)
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)
Parked in ER Julie
  • Does this make Previous Location entry "STB - ER (parked)" etc defunct? Or should those still be used? If defunct, pls let me know when the last pt that uses these is sent so I can remove them from S dispo table. If not defunct, how should those now be used? Ttenbergen 22:40, 2020 October 18 (CDT)
Patient record or move shows in Cognos but not in EPR Tina
  • waiting to hear back if there is a way for us to verify that this is what happened if it happens again. Email subject "RE: Cognos shows WRS3 for patient where EPR only ever shows H4" . Ttenbergen 09:59, 2020 September 18 (CDT)
  • Sherry may have encountered this as well, email subject "Cognos Admitter Troubleshooting", forwarded to Chastity. Ttenbergen 10:58, 2020 September 18 (CDT)
  • There have been other instances since then, I think one from Michelle Oct1/2 Ttenbergen 14:51, 2020 October 7 (CDT)
Patient Viewer Tab Cognos ADT Tina
  • At least some patients show duplicate lines in the Cognos list. Or they were. Are they still?
Patient Viewer Tab Cognos ADT Tina
PatientFollow Project all
  • Could an HSC collector please have a look at HSC Medical Records requests to make sure it is consistent with these changes? Once you have dealt with that, please take out this discussion. Ttenbergen 21:34, 2020 October 15 (CDT)
PatientFollow Project all Is this correct, Grace Med DC? or you went back to Sept 1,2020? --JMojica 17:09, 2020 October 23 (CDT)
PHIA policy Trish Trish will put link.
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-admit Inpatient Institution field all what are those entered as then?
Pre-admit Inpatient Institution field Tina Since no one person knows when this is the case on all laptops for all fields Tina will need to make a query that checks for this in the centralized data. Ttenbergen 15:42, 2020 October 20 (CDT)
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 all
  • S dispo chooser‎ probably no longer makes sense now; will either need to be updated or removed. Does anyone actually use this? Ttenbergen 15:55, 2020 October 20 (CDT)
Previous Location field Tina Since no one person knows when this is the case on all laptops for all fields Tina will need to make a query that checks for this in the centralized data. Ttenbergen 15:42, 2020 October 20 (CDT)
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?
Problem related to unspecified psychosocial circumstances Allan
  • Can we use this to code Sexual abuse?
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 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 Julie
  • At the meeting about cross checks (a long time ago) it was decided to change the cut-off to SD*3; if we want to proceed with this check, I will need values for that. Ttenbergen 23:08, 2020 October 15 (CDT)
Query check long transfer delay Julie
  • If we actually want a cross check like this it needs to be based not on NTU/CTU. We could either base it on specific units or on Level of care hierarchy, ie. add another column to s_level_of_care table. Would that work for you? Ttenbergen 23:08, 2020 October 15 (CDT)
Query check long transfer delay Julie
  • Requiring notes to have content is really a very soft error check... do we need to consider something better?
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 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 TISS changes for the next version Julie What is the intended use of these reports?
Reset Button all
  • This button exists for ancient legacy reasons, generally opening and closing the program is easier and as fast. I will get rid of it in some future version unless someone tells me within the next week or so that they use it and would like to keep it. If you don't use it, NNTR. Ttenbergen 15:17, 2020 July 23 (CDT)
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
Respiratory failure (insufficiency), chronic Task
  • This is the first time I am reading the WIKI on this code. It looks like this code should be used as a comorb on some of our patients. in the pre ICD 10 codes, we had COPD-mild, moderate or severe as Comorb options, with guidelines for when to use each. It would be helpful to have some "cut-off" guidelines for when to use this code, rather than having it be subjective. For example, if someone has chronic COPD now, I am simply coding it in the COMORB field as COPD, without exacerbation, even if that patient is on home oxygen.
    • Does Allan's recent edit address this question? If so, please take it out Ttenbergen 15:18, 2020 July 3 (CDT)
Respiratory failure (insufficiency), chronic Task I am confused by the last 2 statements which follow the sentence "it's appropriate in the ICU record prior to IICU transfer to code it as an acquired diagnosis". So if a patient with no prior history of chronic respiratory failure has a long admission with multiple moves in acute care facilities and "evolves" into a chronic respiratory insufficiency/failure, are we supposed to use this code or not? --Jvelasco 14:44, 2020 July 14 (CDT)
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?
Sending TISS forms all Do you do collect forms for combined sending / drop off? Where, how?
Sending TISS forms all Do you do collect forms for combined sending? Where, how?
Service tmp entry all
  • Are we adding the date and time that each service takes over? Where do we find this information on EPR? (blezak)
    • Good point. The data is in the Cognos Admitter; what was the "Accept DtTm equiv" and only visible if pt came from ER is now the Service Start DtTm, and always visible. Change is in v2020-10-21-1. If that answers the question, please remove the discussion. If not, please elaborate. Ttenbergen 18:15, 2020 October 21 (CDT)
Service tmp entry all
  • should be able to add something to Cognos Admitter and Patient Viewer Tab Cognos ADT that facilitates entering and viewing this; will delay that until we have collected this for a little while; if we find these entries to be identical to Cognos data we might not need to enter them at all but instead import them directly, but not until we have checked consistency. And if we can stop entering Accept and Arrive, and service location becomes trivial we can safe space.
The thing is, that tab is getting very full, and I will need to either make fonts smaller or squeeze an area to show even fewer lines. I wonder how best to do that in a way that works for collectors. It’s on the “later” pile for now, but for sure something I want to deal with. Open to suggestions. Ttenbergen 12:24, 2020 October 16 (CDT)
Service tmp entry Julie
  • I am trying to enter my first critical care patient at HSC. There are multiple choices (dozens) for HSC critical care, and it is not evident which one I should be choosing. I think that it would be a lot more intuitive if the choices are limited to Critical Care-surgical, Critical Care-medical, and Critical care-Intermediate.Mlagadi 09:01, 2020 October 16 (CDT)
    • I'd like that, too. The problem is SICU - AFAIK they are an "open unit" so all sorts of services play there, and therefore show up in Cognos. I made a list that reflects Cognos. We should bring this up to Julie to see what she needs, we might be able to get away with what you suggest. I will flag this for Julie, but if it isn't dealt with by the time the next task meeting comes around, please bring it up then. Ttenbergen 23:32, 2020 October 18 (CDT)
Service tmp entry Tina
  • add a cross check to make sure this is not left as "no service entered"
Service tmp entry Tina
  • This project does might eventually replace ICUotherService; we will still need this item in the event that both the bed and the service are both borrowed. Administration at STB want this data.
Service/Location field Tina Since no one person knows when this is the case on all laptops for all fields Tina will need to make a query that checks for this in the centralized data. Ttenbergen 15:42, 2020 October 20 (CDT)
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
Sorting Cognos Admitter freezes program all
  • This is in Cognos Admitter right? I can't replicate the problem. Which field are you sorting on? And what do you do before you sort, I wonder if that's part of what needs to happen for it to freeze.
  • Will just closing the admitter form not fix it, do you really need to close CCMDB altogether? Ttenbergen 09:19, 2020 October 16 (CDT)
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 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 Critical Care Collection Guide all
  • The following seems to be different than what is in Admit_Type_for_APACHE_II - there it says they have to be directly from OR.
  • These things should be the same for medicine and critical care at STB, no? If any instructions separate from Admit Type for APACHE II are actually required, they should live in STB General Collection Guide instead of here. Ttenbergen 15:40, 2020 October 7 (CDT)
STB E5 all Is that exception about radiology still true? Ttenbergen 21:03, 2018 November 24 (CST)
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 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 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)
Survey about deleting files after sending all
  • How frequently does Pagasa send for people and therefore requires manual deletion?
Survey about deleting files after sending all emailed Marla for reply
Swap Locations all
  • one option would be to delete lines with current unit is a swap location from the cognos data, but it's not clear if this will result in the previous and subsequent records having non-matching next locations and previous locations. Can we just delete these lines from Cognos? Discussing with Lisa... Ttenbergen 14:03, 2020 August 28 (CDT)
Swap Locations all
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
Task Team Meeting - Rolling Agenda and Minutes 2020 Allan
Template:ICD10 Guideline Como vs Admit Allan 1
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 Como vs Admit Task
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 Signs Symptoms Test Results not needed when cause known Task
  • As per email from Allan:

'"`UNIQ--pre-000001B6-QINU`"'

Once decided we will need to figure out which pages need to be update and how (will this template still be called by the same pages? Will we need a second template?
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:Location dropdown cleanup Tina Since no one person knows when this is the case on all laptops for all fields Tina will need to make a query that checks for this in the centralized data. Ttenbergen 15:42, 2020 October 20 (CDT)
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 Collection Guide all
  • How is that different from above and is that still correct for PatientFollow?
TISS28 Collection Guide all
  • Is that still correct for PatientFollow? I think main office would be fine if the same form was used, but not sure how that would work for collectors. In fact, main office might find duplication in TISS items if we don't use the same form; no idea if that will be a problem, Pagasa will need to flag if it happens. Ttenbergen 15:41, 2020 October 23 (CDT)
TISS28 Collection Guide all
  • The following two lines are not applicable to the data collector, so who are they for? Is the intended audience for this page not a data collector? If we want to put instructions for unit nurses those really are a different audience and should be a different page, e.g. Bedside nurse education for TISS28. Joanna, could you have a look? Ttenbergen 15:23, 2020 October 23 (CDT)
TISS28 Collection Guide Task As of Oct.15th, we are now supposed to collect TISS from the accept time. This means that the ER part of the patient's stay will also have to be entered on the TISS. Should we be filling out a separate TISS for this part of the stay, and marking "ER" as the unit, or should we be using the TISS form that has been started in the ICU, and adding any applicable items that occurred in the ER on the corresponding ICU day? The most common occurrence I can think of is a patient getting intubated in the ER vs the ICU. Does the program want to differentiate where this event occurred? What if the transfer happened after the calendar day? For example the patient was in the ER the previous evening, but got transferred to ICU after midnight.Mlagadi 12:09, 2020 October 21 (CDT)
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.
Transfer Ready DtTm field all
  • I believe this contradicts the information on the Transfer Ready DtTm tmp entry page, not sure which is correct. I thought we were doing a transfer ready line for every physical location, not just lower levels of care?
    • The distinction is between what means transfer ready (that is a matter of intent to discharge) and the things that actually happen (pt became worse and went to a higher level of care). The definition below is right for what defines when pt is transfer ready. The explanation in Transfer Ready DtTm tmp entry essentially just says when the clock re-sets, and that could either be because pt was successfully moved to a lower level of care, or because they died (still no longer taking up a bed) or because they became worse and went to a higher level of care (again no longer waiting for that initial lower level of care). Ttenbergen 14:19, 2020 October 19 (CDT)
Transfer Ready DtTm tmp entry all
  • For the date cutoff are we referring to admission date, transfer ready date, or discharge date? Surbanski 10:22, 2020 October 16 (CDT)
Transfer Ready DtTm tmp entry all
  • So do we need a transfer ready time for every physical move - for example, ER to D4, D4 to H4? Or only when a patient moves to a lower level of care. So when ER --> D4, no transfer ready time, but D4 --> WRS3, we would have a transfer ready time.
    • no new entry for same level of care, but entry for higher or lower level of care. Why higher as well? Because once a patient actually moves to a higher level of care, the original determination that they were transfer ready almost certainly is no longer valid. The only exception might be the original ER entry - that is a high level of care location, but would we expect someone to become transfer ready there and then still move to the ward? Probably not. I'd say no entry for that part, but should see what Julie has to say. Ttenbergen 15:16, 2020 October 16 (CDT)
      • Should we be entering a date/TM for every entry? the reason I ask is because if we check off B and put not transfer ready in column Q, we often have multiple entries, How will Julie know which boarding LOC is associated with each transfer ready entry without a date? Lisa Kaita 10:14, 2020 October 20 (CDT)
Transfer Ready DtTm tmp entry all Moving this into a different topic because it's about how to interpret these, not how to enter them
  • This is my dilemma with our definition, it is the intent which I cannot qualify thru the data. if I see an entry in transfer ready date but the physical transfer location is the same or higher level of care, I have to consider that transfer ready date to be valid. I rely that the entry is correct. I rather have the definition to be consistent with the level of care (except for Deaths) so I can quality check the transfer date entry and remove the intent as part of the definition. The goal is to measure bed wastage and when the patient moves to the same or higher level of care, that is not bed wastage to me. --JMojica 10:18, 2020 October 16 (CDT)
    • When the patient was deemed transfer ready, additional time in the ward was "wasted time" - if we could have sent them elsewhere we would have. If the patient later crashes, that doesn't make it not-wasted time - they could have crashed anywhere. So the interpretation that a pt moving to a higher level of care after transfer ready is not wasted time is not right. We discussed this repeatedly at task. The only way this makes sense is if it is done by intent. Ttenbergen 15:16, 2020 October 16 (CDT)
Transfer time rule Julie I suspect this is all legacy, we would use the proper dates and times from EPR now, right? If so I propose we delete this page without leaving a legacy entry since knowledge of this is not really required to makes sense of our data. Ttenbergen 22:08, 2020 October 15 (CDT)
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.
Update of D ID exclude service/location all
  • can someone else think of how this might not work out right?
Update of D ID exclude service/location Tina
  • created Function make_D_ID
    • Problem: If I use a function for this, then the way the delete queries work breaks with a non-specific #Error if a record has been deleted; Possible solutions:
      • Save D_ID locally already rather than only generating it on sending
      • there might' be another way to re-write the query so it doesn't break
  • To do:
    • Make sure that PHI sending and importing will work
    • make sure that TISS scanning and importing will work
  • I plan to have this function just generate the old style D_ID for now, and integrate it into all the sending spots. Then we can decide the start dttm after which we want to use the new format, and I just set that as a parameter in the function.
Using Cognos Report Integrator to keep track of patients all
  • I am trying to set out how using Cognos Discharger, Cognos Admitter and Patient Viewer Tab Cognos ADT should make it possible to keep track of patients arriving and leaving. In some ways the process might be quite backward from what you do now, but the idea to have a process where the data just tells you the next thing to deal with, rather than you having to look for it. I would appreciate testing and feedback! Thanks!
Using Cognos Report Integrator to keep track of patients all
  • We have discussed this at main office, but I will flag this question for Julie and Trish to make sure that my understanding that this is understood and accepted is correct. If so, Julie or Trish, please update this section and remove the discussion. Ttenbergen 11:18, 2020 October 21 (CDT)
Using Cognos Report Integrator to keep track of patients all If we use the Cognos Discharger as I suggest, it would make sense to actually hide entries from it that have either a corresponding Boarding Loc or Dispo entry. They are entered, so if they disappear of the list then the list can be used to drive the process - once it's empty, you are done with it for the day. Are there any concerns about hiding records on here that have been entered?
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.
Working from home Trish
  • What forms need filling? Space requirements? Responsibility for records? Anything else?