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

wiki page question Last modified
"ActiveX component can't create object" error when sending
  • Are any others getting this error?
 2020-07-24 2:25:10 PM
"ActiveX component can't create object" error when sending
  • Need more details. It’s intermittent, right? Does it happen the first time every time you send? Does it happen only when you send from home? At what point during sending does it happen?
 2020-07-24 2:25:10 PM
"exclude" button
  • I am reluctant to tus the exclude button because in the past with the integrator, when I used the exclude button and the patient was readmitted it would not show up. Will this be the same for cognos? The exclude button works based on excluding records with that chart and that service start / accept date and time. This is still based on what it was in EPR Integrator, and of course, it hides future moves of that patient.
    • No, this should not be a problem in Cognos. EPR Integrator excluded by Arrive_DtTm/Service Start Dtm resp EPR Admit DtTm. Excluding based on that meant that, if a patient changes units later on but remains on the same service, those moves would be hidden as well. That's why it changed to Unit Start Dtm in Cognos. The EPR Reports use inconsistent values for this so I don't think we can change its behaviour to be same as Cognos, this was one of the main reasons we went to Cognos data: it doesn't consist of three uncomparable lists.
 2020-06-30 4:13:08 AM
"Make B Loc" button
  • "item" needs to be filled in manually for now, but convince me that it should be automatic and I will try to think my way through it. Ttenbergen 17:19, 2020 May 21 (CDT)
 2020-05-21 10:19:11 PM
"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-06-25 3:26:28 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-06-25 3:26:28 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-06-25 3:26:28 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-06-25 3:26:28 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-06-25 3:26:28 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-06-25 3:26:28 PM
2020-05 HSC COVID unit transition 2020-06-17 2:38:32 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-06-17 2:38:32 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-06-17 2:38:32 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-06-17 2:38:32 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-06-17 2:38:32 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-06-17 2:38:32 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-06-17 2:38:32 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-06-17 2:38:32 PM
2020-05 HSC COVID unit transition what needs to change on laptops? Trish Ostryzniuk 18:00, 2020 May 12 (CDT) 2020-06-17 2:38:32 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
Accept DtTm field
  • The date in Transfer Register is actually the inpatient admit dtm; this should be similar to an accept dtm, but it might be relevant to be aware. Cognos Report Integrator was changed 2020-07-28 to generate a field Accept DtTm Equiv which it only populates if the patient is from ER, since clearly the Service Start DtTm we had been getting from Cognos as well is a different date stamp. Hopefully we will now the the same date from Cognos as from EPR, but we may have to adjust what we think that date means. Ttenbergen 15:58, 2020 July 28 (CDT)
 2020-07-28 9:05:49 PM
ALERT Scale timing of assessment 2020-07-09 4:34:24 PM
Attribution of infections
  • there may be others dx right now that my search for 48 did not find because maybe they use a 12 hr or 17 hour... rule. Collectors, can you think of any? Ttenbergen 15:38, 2020 March 25 (CDT)
 2020-06-17 9:44:53 PM
Battery disposal collectors, please document what your process is at your office location.Trish Ostryzniuk 17:38, 2019 March 5 (CST) 2020-04-30 4:26:36 PM
Boarding Loc
  • ECIP - these are now happening, so how would we enter them?
  • EMIP - this structure could accommodate EMIPs, but the problem is
    • how do we identify then (right now people take turns at some sites...
    • which collector would collect them what service/location do we collect them as? Right now we have a special service location for these...
    • how about that "service x" at HSC?
 2020-07-24 6:51:22 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-07-24 6:51:22 PM
Check pre acute consistent How does Chronic Health Facility fit into this? Or Imprisonment/incarceration and other info in Prison / Jail / Correctional Institution? 2019-09-22 4:44:32 PM
Check pre acute consistent There was a previous attempt to address some of this in Care levels in the community; this page and it need to be consistent, and consistently linked from the relevant field definitions. If we can get it short enough we might make a template to apply the instructions to each of the field pages. 2019-09-22 4:44:32 PM
Check pre acute consistent There was talk about comparing Postal Codes to known PCH Postal Codes. Since these might Include other buildings at the same site that are not PCHs, this check can at best be a soft check. Please add the list of these postal codes here. 2019-09-22 4:44:32 PM
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
  • 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-07-31 2:45:02 AM
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)
 2020-07-31 2:45:02 AM
Cognos Admitter
  • The patients that have already been entered on our laptop, but are being transferred back to our units, requiring a second or third admission are hard to pick out/decipher. It would be helpful to have a clear "previous location", next to an "arrive time" field on the Cognos Admitter screen, so that we could easily figure out what we are supposed to be doing with that patient. These patients are also showing up multiple times in the Admitter, adding to the confusion. I'm not sure if there is anyway to get rid of the multiple lines showing the same information?
    • Agreed, this is something that needs to be improved still. I can show previous unit or service from the Cognos data for anyone, and previous location data for patients already entered. I think the real confusion here is that we still see too many lines right now: if there are two records in cognos and two in L_Log, right now you get 4 lines as it compares (a-A), (a-B), (b-A) and (b-B). I am working on a way to not show (a-B) and (b-A), which will improve this. One of my problems is that some of the records will match on a Boarding Loc entry, not an Arrive DtTm. Ttenbergen 15:47, 2020 June 2 (CDT)
      • 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-07-31 2:45:02 AM
Cognos Admitter
  • The transfers out of the unit are also difficult to appreciate/easily pick up with the current layout.
    • I would expect you to find the transfers out in the Cognos Discharger instead of the admitter. And if you deal with them in there, you should not have to deal with them in here. Caveat: I am 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-07-31 2:45:02 AM
Cognos data import Currently this process lives on Tina's laptop, and Tina is the only one who can do it. We need a better solution. 2020-07-30 9:39:13 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
  • Western is not mentioned in the Internal Medicine Wiki (See link right below question, it breaks the discussion template). Are we sure Western is still the correct answer? Ttenbergen 16:38, 2020 February 23 (CST)
    • Yes it is WM is the medical legal courier from HSC to GRACE. Trish Ostryzniuk 11:50, 2020 February 28 (CST)
  • Do we actually contact the courier? It kind of sounds below like we just send through interoffice. If so, let's rename page and take out the info about Western. We don't really need to track how the mail room does it, just how we do it.
  • No we do not contact the courier. We must put cost center on package of forms being SENT to Grace out of HSC mail room.
  • Between HSC and STB an visa versa, the mail room has daily drops and pick ups and there is no cost for sending between these two sites.
 2020-03-06 7:38:08 PM
Data collection log form
  • 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'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 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-07-20 8:04:39 PM
Emergency Surgery (concept) This info is from 2009 - is it still the same? 2020-04-10 1:44:48 AM
EMIP
  • I have had a couple of scenarios in the past few months that I have not considered an EMIP, but I thought I should get a second opinion: The emergency notes state that a patient from another hospital/nursing station, etc. is a "direct for internal medicine". The patient gets to our ER, and is immediately deemed too sick for the ward, and ICU is consulted. The internal medicine doctor may or may not have even laid eyes on this patient, and there is no admission order. In these cases, although the medicine doctor may have written a note about seeing the patient in the ER, they never took over care/wrote orders for the patient. How are other collectors entering these patients?Mlagadi 11:38, 2019 October 1 (CDT)
    • I think this scenario is not an EMIP since the Med doc did not took over. Did the patient go to ICU - if yes then this is an ICU admission? --JMojica 17:09, 2019 October 3 (CDT)
      • This is an interesting case because the medicine service technically accepted the patient to begin with, as they came direct to medicine, and an ER physician did not see them. If medicine sees them, then it could be considered an EMIP? but if medicine doesn't see them, who decided that the patient was too sick for the ward? and consulted ICU? if it was the ER physician than I don't think it would be an EMIP. Just my two cents, it is definitely not clear cut Lisa Kaita 11:03, 2019 October 8 (CDT)
 2020-07-09 3:38:45 PM
EMIP
  • need to resolve EMIP and figure out where that info will live. Ttenbergen 11:30, 2016 December 29 (CST)
    • If a patient is still considered an ER patient in a CAU, they can potentially be an EMIP if they get accepted by internal medicine but subsequently are discharged or sent to another hospital.
      • At STB CAU contains inpatients under family Medicine (they are not under the ER physician).
        • If the CAU is considered part of ER then I guess patients that are accepted by internal medicine and go out elsewhere could be EMIP's. It depends how you view the area.
          • Is the CAU considered the same as ER or not? Management will have to determine how they want this done. Currently no one at STB collects data at all on the patients in the CAU. --LKolesar 11:49, 2017 October 27 (CDT)
 2020-07-09 3:38:45 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
Error: There isn't enough free memory to update the display. Close unneeded programs and try again. Please enter your laptop and under what circumstances you have seen this error below. 2019-07-29 9:12:04 PM
Exporting EPR Reports for EPR Reports Integrator
  • Filter the report; Val/Michelle, could you provide details for what filtering you used for this, if it is other than what was given in those three pages? If same just take out question....
 2019-11-14 12:17:56 AM
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 2S
  • Is there workload splitting for this location?
 2020-05-05 8:11:42 PM
GRA 2S
  • Will that also be used for this location?
 2020-05-05 8:11:42 PM
GRA Boarding Locations
  • PACU? Anything else?
 2020-01-31 8:16:29 PM
GRA ER use as borrow location
  • Do we need to add the option to track these for other sites?
    • this is an ER wait/delay case and not to be included in the Project Boarding Loc. The ECIP case is a whole stay in ER but under the Critical Care attending Physician.
 2020-04-01 7:31:21 PM
GRA ER use as borrow location 2020-04-01 7:31:21 PM
GRA ER use as borrow location
  • There is a strange thing going on at the Grace that leads to situations similar to ECIP.... Made this page to consolidate details here.
 2020-04-01 7:31:21 PM
GRA ER use as borrow location Do we need to change our EPR Report / identification process to make sure we capture these? Just for Grace or for all sites? 2020-04-01 7:31:21 PM
GRA General Collection Guide
  • is this what you would enter as "GRA Ambulatory Care"? Or how do you enter this? Ttenbergen 21:42, 2020 April 5 (CDT)
 2020-06-29 3:57:01 PM
GRA Medical Records requests Is there anything else a collector new to GRA would need to know to do this right so we don't lose the good will of MedRec tehre? Ttenbergen 13:58, 2019 December 11 (CST) 2019-12-11 8:02:25 PM
GRA Medicine Collection Guide 2020-06-23 6:18:38 PM
GRA PACU Leaving content from GRA_MICU for now although this is almost certainly wrong, could someone please clean it up? 2020-04-16 4:17:49 PM
Grace Hospital Contacts Where is that form? Is there a link? 2020-01-02 2:15:10 AM
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-07-30 2:47:09 PM
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?
 2020-07-30 2:47:09 PM
HSC EMIP
  • Is this still the same split with understaffing? Ttenbergen 11:33, 2020 April 9 (CDT) Ttenbergen 16:52, 2020 June 5 (CDT)
 2020-06-05 9:52:36 PM
HSC HOBS
  • Is the unit info above still correct once this moves back to H7?
 2020-07-30 2:51:36 PM
HSC HOBS needs detail 2020-07-30 2:51:36 PM
HSC MICU Collection Guide
  • I have spoken to the clerks in MICU and they do order their own TISS forms and Green sheets. Is it not possible to have SICU and IICU order their own as well? --Jvelasco 11:57, 2020 February 28 (CST)
    • will check this out with Pagasa and printshop. If we made changes to the form then unit would not get most current. Trish Ostryzniuk 14:44, 2020 February 28 (CST)
    • Which Cost Center they are charging to?
      • I do not know. --Jvelasco 15:14, 2020 April 7 (CDT)
 2020-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 MS3 Please fill in 2020-04-08 4:36:25 PM
HSC Unknown Service
  • So if Lisa had to cover for one of you while you are aware, how would she know which ones to pick up. Do you have a method for splitting these?
 2020-01-30 10:28:50 PM
HSC WRS3
  • Will this location profile be identical to what HSC_D5 was before?
 2020-04-07 6:50:43 PM
ICU Curriculum Any other links that would be helpful to new ICU collectors at all sites? --Jvelasco 15:04, 2020 July 6 (CDT) 2020-07-21 4:01:05 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-07-24 6:42:14 PM
Identifying ICU admissions
  • What is this Affinity software, is it another name for the EPR or is it a separate tool?
 2020-07-24 6:42:14 PM
Identifying ICU admissions 2020-07-24 6:42:14 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-07-24 6:42:14 PM
Identifying ICU admissions multiple questions, especially for HSC and GRA 2020-07-24 6:42:14 PM
Identifying patients in boarding locations 2020-01-31 8:20:38 PM
Identifying patients in boarding locations We need to make sure nothing in here is inconsistent with the following: 2020-01-31 8:20:38 PM
Lab identification in the DSM data
  • We should change this; however, do we only change it going forward or do we also re-import back data? Julie is about to re-import back data until 2019-01-01, so maybe we should reimport back data for all that far?
    • shouldn't it be Accept_DtTm and use Arrive_DtTm if Accept_DtTm is blank. We have discussed that in the Project Boarding Loc, we can still determine the counts in between Accept_DtTm and Arrive_DtTm if needed. --JMojica 10:25, 2019 December 10 (CST)
      • That is pretty much what I mean, it should be as you say. Do we want to do this going back in data as you re-import, or just going forward for future imports? Ttenbergen 09:41, 2019 December 11 (CST)
 2020-05-14 7:39:29 PM
MediaWiki:Common.js ", post: " 2020-04-02 5:06:12 PM
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
Nephritic syndrome, acute Lisa had added the following content to each nephritic dx page, because this template was invisible. I have made the template visible, but now there is likely duplication. Can someone medical please integrate Lisa's content with the stuff below that was here already? Between the lines is Lisa's content: 2020-08-05 7:19:31 PM
Nephritic syndrome, chronic Lisa had added the following content to each nephritic dx page, because this template was invisible. I have made the template visible, but now there is likely duplication. Can someone medical please integrate Lisa's content with the stuff below that was here already? Between the lines is Lisa's content: 2020-08-05 7:17:54 PM
Nephritic syndrome, NOS Lisa had added the following content to each nephritic dx page, because this template was invisible. I have made the template visible, but now there is likely duplication. Can someone medical please integrate Lisa's content with the stuff below that was here already? Between the lines is Lisa's content: 2020-08-05 7:17:05 PM
Nephritic syndrome, rapidly progressive Lisa had added the following content to each nephritic dx page, because this template was invisible. I have made the template visible, but now there is likely duplication. Can someone medical please integrate Lisa's content with the stuff below that was here already? Between the lines is Lisa's content: 2020-08-05 7:19:09 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
Parked in ER
  • Lisa, you changed this from "the service at the sending facility". I think the new definition is inconsistent with what is said in Previous Service field which seems to say to enter "Not Applicable". Am I missing something? Ttenbergen 10:43, 2020 July 9 (CDT)
 2020-07-09 3:43:12 PM
Patient Viewer Tab Cognos ADT
  • My patients coming from ER have a different Accept DtTm on EPR Reports than what shows up in Cognos ADT. Cognos seems to use the same DtTm as Unit Start. Right now I'm changing it to what EPR Reports shows. --Jvelasco 13:13, 2020 June 12 (CDT)
    • I am looking into that now... Ttenbergen 10:15, 2020 June 17 (CDT)
 2020-07-31 2:45:06 AM
PatientFollow Project
  • The list would need to be exported on a regular basis and then made available to collectors. How would this best be done?
  • There was talk about EPR lists to help collectors keep track of their patients. If we use that method then how will we handle it when there needs to be coverage?
  • How do we make sure no pts are missed?
  • How do we make sure no pts are duplicated?
 2020-07-30 3:12:17 PM
PatientFollow Project 2020-07-30 3:12:17 PM
PatientFollow Project
  • It should be questioned then whether amalgamating all data collection units within a site for example there are 4 medicine collection units at STB + EMIPs how to possibly track and reconcile all these lists with any semblance of accuracy. This would be a very labor/time intensive and complicated process, as well as a significant logistical challenge. Use of EPR lists to create further lists/spreadsheets in Excel seems redundant and a risky proposition in terms of inclusion and accuracy. There are also potential PHIA considerations whereas patient information on laptops is currently stored/accessed through a separate program, what are the implications for "personal" and/or redundant storage of patient information on data collector accounts? Pamela Piche 10:19, 2019 September 5 (CDT)
 2020-07-30 3:12:17 PM
PatientFollow Project The potential to either, have multitudes of patients duplicated, or more importantly, patients missed seems astronomical. Inadvertently duplicating patients will end up being way more work for data collectors. How will we, as data collectors even know that we have duplicated a patient that another data collector has already done? Or conversely, how will we know if we have missed a patient? 2020-07-30 3:12:17 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
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-07-17 8:01:13 PM
Project Discharge Documentation I could set up a query in CFE to dump this to keep it off Julie's desk. This user might find speed more important than quality? If needed, let me know. 2020-05-06 2:18:46 AM
Project Discharge Documentation Will these documents be retained on charts once they hit med records? 2020-05-06 2:18:46 AM
Query check long transfer delay
  • Requiring notes to have content is really a very soft error check... do we need to consider something better?
 2019-09-22 5:01:48 PM
Query check long transfer delay 2019-09-22 5:01:48 PM
Query check long transfer delay At the meeting about cross checks it was decided to change the cut-off to SD*3; will need to get that from Julie if we ever address the other questions. 2019-09-22 5:01:48 PM
Query Import request matcher This one is fairly easy, Pagasa will try to make it. 2019-05-15 5:39:43 PM
Query Import request matcher This one is fairly easy, Pagasa will try to make it. 2020-05-05 9:53:45 PM
Renal Coding Considerations for ICD10 Lisa had added the following content to each nephritic dx page, because this template was invisible. I have made the template visible, but now there is likely duplication. Can someone medical please integrate Lisa's content with the stuff below that was here already? Between the lines is Lisa's content: 2020-02-03 10:45:23 PM
Requested CCMDB changes for the next version 2020-07-24 3:55:33 AM
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
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 E5 Is that exception about radiology still true? Ttenbergen 21:03, 2018 November 24 (CST) 2020-01-07 1:30:01 PM
STB E6 C This is probably all wrong now, please update 2020-03-30 4:37:34 AM
STB Electronic Patient Record
  • "...Also, the "APACHE" score for medicine is not dependent upon the first 24 hours of vital signs and labs so exact accuracy here is less important. --LKolesar 06:44, 2019 October 24 (CDT)"
    • We don't do an apache score for medicine at all, so I am not sure what you mean here. AFAIK the instructions how to collect e.g. WBC are the same for medicine and ICU, no? In any case, I think it's separate from the purpose of this page, how EPR is used at STB. If you agree, can you please take out this whole Discussion? Ttenbergen 11:31, 2019 October 30 (CDT)
 2019-10-30 4:31:42 PM
STB General Collection Guide Are gloves no longer to be supplied? With regular/ongoing occupancy of Medicine office for orientation starting July, will masks be provided? 2020-06-17 12:23:00 PM
STB Medical Records requests If I was a new collector, how would I find that shelf? 2020-05-05 7:05:36 PM
STB Medicine Collection Guide will any med collectors be on site at intervals like STB_Critical_Care_Collection_Guide#IMPORTANT_INFORMATION_DURING_COVID_PANDEMIC? 2020-07-09 5:01:32 PM
STB Medicine workload splitting 2020-07-09 5:00:18 PM
STB MICU Collection Guide
  • With the new instructions for Contacting Quality Officer and Manager for VAPs and CLIs, can we discontinue that sheet? We should not be retaining patient info once we are done dealing with it. Ttenbergen 10:26, 2017 September 18 (CDT)
    • Basil Evan , QI officer, is asking that perhaps a worksheet be submitted to him regarding which criteria were met for either VAP for CLI when collector make determination from chart. Perhaps we could make a checklist in TMP instead in regards to which criteria are met for these two special projects instead of paper worksheets that are different at each collection site? Suggestions? --Trish Ostryzniuk 17:14, 2018 November 19 (CST)
    • added to tmp was abandoned. Trish Ostryzniuk 18:46, 2019 February 4 (CST)
      • Emailed Trish "What do you mean by was abandoned, the question or the project or the paperwork?" Ttenbergen 22:29, 2019 February 5 (CST)
 2020-05-05 7:05:35 PM
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
Switching to a single serial pool per laptop
  • Do you think there would be a problem with your collection work flow if you moved to automatically assigned serials from a single number pool? Are there processes identifying patients or similar (ie processes that are not on the laptop) that would be confused by this? Ttenbergen 21:16, 2020 April 26 (CDT)
    • The only problem that I can see is that the numbers help us figure out which patients are in High Obs, or which patients are EMIP's. We could fix that problem by entering a location in the Record field.Mlagadi 07:50, 2020 April 27 (CDT)
      • Due to space restrictions we initially didn't include the location as a column on the Patient List, but we did set up colors per unit. I just realized I didn't initially document this on the wiki, but I now have, see Patient_List#Row_colours_on_Patient_List. Would that be an alternative to using the serial to figure out the unit? Ttenbergen 12:11, 2020 April 28 (CDT)
      • I could also add a button to sort by unit, even if it's not displayed. Let me know if that would be helpful. Ttenbergen 12:11, 2020 April 28 (CDT)
 2020-04-29 9:30:20 PM
Switching to a single serial pool per laptop
  • Moving here from a page where it didn't fit in:
  • "One more point, D5 & B3 use consecutive numbers also. These would be hard to keep track of without a paper log for the really quick admissions & discharges that are sometimes seen on B3.--CMarks 13:22, 2012 October 1 (CDT)"
    • Iris, is that still a thing, and will it make any difference if we change these to a single pool? If not, please remove this discussion. Ttenbergen 16:30, 2020 April 29 (CDT)
 2020-04-29 9:30:20 PM
Task Team Meeting - Rolling Agenda and Minutes 2020 2020-07-23 10:05:13 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-07-23 10:05:13 PM
Template:ICD10 Guideline Nephritic Syndrome Lisa had added the following content to each nephritic dx page, because this template was invisible. I have made the template visible, but now there is likely duplication. Can someone medical please integrate Lisa's content with the stuff below that was here already? Between the lines is Lisa's content: 2020-08-05 7:16:16 PM
Update of D ID exclude service/location
  • can someone else think of how this might not work out right?
 2020-07-24 7:27:33 PM

All questions

There are currently 329 questions.

wiki page who question
"ActiveX component can't create object" error when sending all
  • Are any others getting this error?
"ActiveX component can't create object" error when sending all
  • Need more details. It’s intermittent, right? Does it happen the first time every time you send? Does it happen only when you send from home? At what point during sending does it happen?
"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.
"exclude" button all
  • I am reluctant to tus the exclude button because in the past with the integrator, when I used the exclude button and the patient was readmitted it would not show up. Will this be the same for cognos? The exclude button works based on excluding records with that chart and that service start / accept date and time. This is still based on what it was in EPR Integrator, and of course, it hides future moves of that patient.
    • No, this should not be a problem in Cognos. EPR Integrator excluded by Arrive_DtTm/Service Start Dtm resp EPR Admit DtTm. Excluding based on that meant that, if a patient changes units later on but remains on the same service, those moves would be hidden as well. That's why it changed to Unit Start Dtm in Cognos. The EPR Reports use inconsistent values for this so I don't think we can change its behaviour to be same as Cognos, this was one of the main reasons we went to Cognos data: it doesn't consist of three uncomparable lists.
"Make B Loc" button all
  • "item" needs to be filled in manually for now, but convince me that it should be automatic and I will try to think my way through it. Ttenbergen 17:19, 2020 May 21 (CDT)
"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
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...
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 DtTm field all
  • The date in Transfer Register is actually the inpatient admit dtm; this should be similar to an accept dtm, but it might be relevant to be aware. Cognos Report Integrator was changed 2020-07-28 to generate a field Accept DtTm Equiv which it only populates if the patient is from ER, since clearly the Service Start DtTm we had been getting from Cognos as well is a different date stamp. Hopefully we will now the the same date from Cognos as from EPR, but we may have to adjust what we think that date means. Ttenbergen 15:58, 2020 July 28 (CDT)
Acquired Diagnosis / Complication Allan
Admit Diagnosis Allan Como Admit Acquired Primary Limits - this is part of that discussion - if we limit which admits will count as comos we need to review
Admit Procedure Allan May be inconsistent with Task_Team_Meeting_-_Rolling_Agenda_and_Minutes_2020#ICU_Database_Task_Group_Meeting_-_February_12.2C_2020, what do we actually want here?
ALERT Scale timing of assessment all
Attribution of infections all
  • there may be others dx right now that my search for 48 did not find because maybe they use a 12 hr or 17 hour... rule. Collectors, can you think of any? Ttenbergen 15:38, 2020 March 25 (CDT)
Attribution of infections Julie
  • Julie, the above question specifically affects some projects you work with as well - do you think unifying this rule will be a problem for any of them?
  • if there are specific rules already in place (e.g. VAP, CLI, etc.) we should follow them. Those which don't have perhaps those are the ones we can unify. --JMojica 14:51, 2020 March 20 (CDT)
Attribution of infections Task
  • What is the attribution rule for our program on MRSA colonization? For example if a patient comes from SOGH ICU to the Concordia and tests positive for MRSA in less than 24 hours I would attribute this colonization to the SOGH not the Concordia. Is that correct?
    • If we will have such a rule at all, could it be one that applies to infections in general and would therefore live in Template: ICD10 Guideline Infection. Also, we would want to make sure that "attribution" as a concept doesn't get muddled - if we search for that there are several hits, and we use other terms like "gets credit" elsewhere I believe. And in Lab and culture reports...
      • Allan confirmed that all the attributions should be the same and can be moved into that infection template. Ttenbergen 14:09, 2018 October 29 (CDT)
Does anyone think making this one rule for all will be a problem?
Base Population for Research Julie This page is linked from the front page, so we should either make it good or get rid of that. Is there anything on Publications that would be a good example for how our DB was used for this?
Battery disposal all collectors, please document what your process is at your office location.Trish Ostryzniuk 17:38, 2019 March 5 (CST)
Bed borrow Task Wouldn't "medicine borrows a ICU bed for Cardioversion" be a case of Bed holds instead of a borrow? Same for several others above...
Bed Census Data Processing Instructions Pagasa
  • copy the database back up to the server
    • which server?
Bed Census Data Processing Instructions Pagasa
  • probably incomplete... Ttenbergen 18:17, 2016 April 14 (CDT) emailed Trish/PAgasa Ttenbergen 16:46, 2018 October 30 (CDT)
Bed Census Data Processing Instructions Pagasa
  • is this the current process, or is Bed_census.mdb? I think the process is better off here than in the .mdb article.
Bed Census Data Processing Instructions Pagasa what is the purpose of having clerk processing this data?
  • quality control?
  • preparing for reports?
  • ?
Bed holds Julie Julie seems to set the limit at 1 day - emailed Julie Ttenbergen 10:07, 2016 November 10 (CST)
Bed occupancy Julie Is this about Bed census.mdb or a different thing?
Bed occupancy Julie with TMSX not having been around for a while, is this still relevant? Do you provide this data otherwise? Do we need to implement this?
Blood Product Data Allan z
  • Identified as something we should do to streamline data collection. I have made this page to document progress toward this import.
Boarding Loc all
  • ECIP - these are now happening, so how would we enter them?
  • EMIP - this structure could accommodate EMIPs, but the problem is
    • how do we identify then (right now people take turns at some sites...
    • which collector would collect them what service/location do we collect them as? Right now we have a special service location for these...
    • how about that "service x" at HSC?
Boarding Loc all Which if any of Project_Borrow_arrive#Data_Integrity_Checks_.28SMW.29 will need to be moved over to this instead?
CAM positive (TISS Item) Julie
  • Did these ever get better? Ttenbergen 12:44, 2017 May 11 (CDT) Does anything need to be done about this? Ttenbergen 20:15, 2018 November 27 (CST)
Care levels in the community Julie
  • There usually isn't much info in the charts about the "type" of group home or level of care provided there, so in those cases we have been coding "other - known but not listed". Please clarify --Jvelasco 13:47, 2019 September 4 (CDT)
    • Julie, how do we use this, and how should this be coded in unclear cases? If you are not sure about the answer either, could you bring it to Task?
CCI Volumes 2019 Task There have been concerns about the volume of work generated by CCI entries. Since we had already reduced certain entries earlier in 2019, the numbers referenced here are only for pts admitted during the third quarter of 2019.
CCMDB.accdb Change Log 2020 Task pop-up hints on Pharmacy screen - need to deal with, emailing ICU Task Team
Central Line Associated Blood-Stream Infection (CLA-BSI) rate Julie
    • A central lines (CL) is a central venous catheters (CVC) that terminates at or close to the heart or one of the great vessels. Great vessels include the pulmonary artery, superior vena cava, inferior vena cava, brachiocephalic, internal jugular, subclavian, external iliac and the common femoral veins.
      • Could we link to Central Line for details instead so that if we change any they will remain consistent?
Centralized data front end.accdb Change Log 2020 Trish
  • this version has not been rolled out because we dont' know if Pagasa has newer stuff.Need to figure out. Ttenbergen 17:30, 2020 July 9 (CDT)
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 ICD10 some cant be primary Allan Como Admit Acquired Primary Limits - Category:Mechanism would need to be excluded as well, and so would past history, and quickly the list gets so large again that we are back at discussing Controlling Dx Type for ICD10 codes where we should simply include "Primary"-ability.
  • AG OBSERVATION --- we will just take care of this when we take care of Admit/Comorbid/Acquired
Check pre acute consistent all How does Chronic Health Facility fit into this? Or Imprisonment/incarceration and other info in Prison / Jail / Correctional Institution?
Check pre acute consistent all There was a previous attempt to address some of this in Care levels in the community; this page and it need to be consistent, and consistently linked from the relevant field definitions. If we can get it short enough we might make a template to apply the instructions to each of the field pages.
Check pre acute consistent all There was talk about comparing Postal Codes to known PCH Postal Codes. Since these might Include other buildings at the same site that are not PCHs, this check can at best be a soft check. Please add the list of these postal codes here.
Check pre acute consistent Julie
  • ... unless they are discharged somewhere else entirely, like another ward. So what do we really mean with this? That they can't come from one PCH and go to another or maybe "home" after all?
    • I realize this maybe hard to do. what I mean here is that if one is already a PCH resident, when leaving the hospital, the dispo location must be a PCH location too. or is a patient is already in CHF, the destination when leaving the hospital must either be a CHF or another PCH.
Check pre acute consistent Julie
  • from a data perspective, what do you mean by "admitted directly"? If I were to build a check, where would I find that? OR maybe I don't need to know, but then I need to have a definition of what combination of data would be an error.

Integrity check

Check pre acute consistent Julie
  • The listed postal codes are correlated to the items ‘PCH’ and ‘Chronic Health facility’ of the Pre-Acute Living Situation. Since the data collectors are collecting the postal code from the patient’s address, will it be possible to automatically fill up the Pre-Acute Living Situation as PCH or Chronic Health facility if the PCH postal codes are entered or ‘other ways’ to link the two fields and make them consistent. Info about PCH is now getting more attention/request. Tina, Will this be hard to do? Any suggestions?
    • I have changed my mind to add the PCH postal code to the Postal_Code_Master due to the possible effect on its size (when adding a new column containing text where most of the records will only be blanks). It is better to have it in separate table since this pertains to Winnipeg area only. I have added the exact address of these PCH facilities - link to table in email sent on Jan 12.18 at 1224 hrs from p:Julie Mojica
      • Is any change to CFE still required then? If not, please remove this discussion and heading. Ttenbergen 15:47, 2019 July 4 (CDT)
Check pre acute consistent Julie what exactly do we want to check for? Please also have a look at the stuff below that doesn't specifically have your name. This requested check ties into a bunch of things and if we want the check we need to be sure that instructions stay consistent and lose ends are tied up.
Check VAP acquired only first encounter Julie We decided that VAP can actually happen in medicine if pt admitted from ICU. How would we deal with that for this check?
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
  • 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)
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 import all Currently this process lives on Tina's laptop, and Tina is the only one who can do it. We need a better solution.
Cognos EPR Report Tina
  • 2020-06-25 as of about 2 weeks ago, gender is no longer included in the data because it was breaking the export. I have reminded Chastity repeatedly to put it back in but there is no ETA for this.
Cognos Report Integrator all Where should this live?
Colonized with organism (not infected) Allan z "It was decided that Allan with contact Dr. Embil and see if we can obtain this data from Infection Control. If so, we could import it into the database, and have our data collectors cease obtaining it." - did anything come of that?
Comorbid Diagnosis Allan Como Admit Acquired Primary Limits - this is part of that discussion - if we limit which admits will count as comos we need to review
Confidential waste disposal all collectors, please document what your process is at your office location.Trish Ostryzniuk 17:37, 2019 March 5 (CST)
Continuous Stay Julie
Continuous Stay Julie
  • That last line seems to be obvious in new schema from the other definitions... is AMA still at all relevant here or can it be taken out?
Continuous Stay Julie
  • This def of Bed holds is not consistent with the one in Bed holds; they probably should be, i.e. the same definition should be used throughout. Are they actually consistent in your program? Can we remove the detail from here and link to bed hold?
Continuous Stay Julie
  • This will likely have changed when we eliminated the 5 minute rule for local transfers; Julie, could you confirm that this was also changed wherever it has an impact?
  • Does this use Arrive DtTm or Accept DtTm in the new schema?
Continuous Stay Julie
  • would it make sense to take out the ICU requirement for this? The same might be rarer for Medicine patients but would still be true. I will implement Encounter processing like that for now unless I hear otherwise. Ttenbergen 12:06, 2015 January 22 (CST)
    • Glad you put that in Tina, I was going to make a similar comment.--CMarks 12:48, 2015 January 22 (CST)
Controlling Dx Type for ICD10 codes Allan Como Admit Acquired Primary Limits 1/ Dx grouping - this is part of both of those discussion
  • I have emailed Allan the table with all Dxs to set them as Como_allowed, Admit_allowed, Acquired_allowed. Will set up infrastructure to contain this once I have data. Ttenbergen 12:31, 2019 February 13 (CST)
    • Allan won't have a chance to review until at least mid Sept 2019
Courier all
  • Western is not mentioned in the Internal Medicine Wiki (See link right below question, it breaks the discussion template). Are we sure Western is still the correct answer? Ttenbergen 16:38, 2020 February 23 (CST)
    • Yes it is WM is the medical legal courier from HSC to GRACE. Trish Ostryzniuk 11:50, 2020 February 28 (CST)
  • Do we actually contact the courier? It kind of sounds below like we just send through interoffice. If so, let's rename page and take out the info about Western. We don't really need to track how the mail room does it, just how we do it.
  • No we do not contact the courier. We must put cost center on package of forms being SENT to Grace out of HSC mail room.
  • Between HSC and STB an visa versa, the mail room has daily drops and pick ups and there is no cost for sending between these two sites.
Crash TISS MDB Pagasa
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'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 We collect data on some patients who never arrive on one of our units, e.g. EMIPs. Are there any other scenarios? There was a page for the HSC off warders HSC Boarding Locations#Medicine which might help in thinking about these.
Definition of a Medicine Service admission Task Current way of checking through Transfer Register will miss off ward patients who arrived at off-ward locations from elsewhere than emerg. Laura and Tina discussed, did not find solution yet, should be rare, though. 13:41, 2017 March 1 (CST)
Definition of an ICU admission Task We need to update this to explicitly discuss ER pts (ECIP). Yes, allegedly this "never happens", but since we explicitly exclude these, we should state so. This would also ensure consistency with pages like Length of Stay (ICU Report) which rely on this definition.
Delirium days Julie What are the details?
Direct Data Access for RIS/PACS Allan z
  • Identified as something we should do; the notes below are quite old but might still be a starting point.
Discharge Register Trish The following needs clarification, I don't have a report in front of me, how would a new collector read which of these are EMIPs and which not? Emailed Laura Ttenbergen 16:53, 2019 January 3 (CST)
  • is this just available for STB or is this how GRACE and HSC can find in EPR?Trish Ostryzniuk 18:01, 2019 January 3 (CST)
  • I would think that all the hospitals have this because it is just a demographic issue and I believe that everyone has access to this, just get them to test it in other centers to make sure.--LKolesar 07:56, 2019 January 4 (CST)
Dx Primary Task For reporting purposes, Julie puts the primary diagnosis into 8 different categories:
  • respiratory disorders
  • post cardiac arrest
  • trauma and poisoning
  • metabolic/renal/GI/hypovolemic shock
  • cardiac disease
  • neurologic disorder
  • post-operative care
  • sepsis/septic shock

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

    • I guess the question is if any dxs can not be captured in those 8 groups. If they are all captured there is no problem, or is there? Ttenbergen 10:09, 2019 October 4 (CDT)
ECIP Task We keep discussing whether EMIP like patients should be collected in Critical Care. Consensus is that they are rare, but for consistency it would be good if we caught them. At task meeting 2020 Jan 29, reviewed. Question: Is this easy to get from EPR? Trish reviewed with p:Lisa kaita and apparently fairly easy to catch.
  • Currently any ECIP are documented in CCMDB TMP project Boarding Loc.
    • 2020 Feb 12: DB Task meeting discussed to continue adding as borrow location as Tina is currently working on EPR lists dump via Congnos? SO we will wait for better solution before any further changes and to continue with current practice to capture these
      • 2020 Feb 18: Allan thoughts were not to add ECIP, call it NCIP because they are not only in ER. I think he was not clear about what this is suppose to be. Not resolved.
Eliminating distinction between different ward types Julie any of Julie's Reporting that use this concept? I no longer used the hierarchy level when computing transfer delays. I assume that if transfer ready datetime is present, DC follows the rule and they are included in the computation. In Medicine Report, there is no more tables showing teaching vs. non teaching. --JMojica 11:10, 2020 January 30 (CST)
Emergency Surgery (concept) all This info is from 2009 - is it still the same?
EMIP all
  • I have had a couple of scenarios in the past few months that I have not considered an EMIP, but I thought I should get a second opinion: The emergency notes state that a patient from another hospital/nursing station, etc. is a "direct for internal medicine". The patient gets to our ER, and is immediately deemed too sick for the ward, and ICU is consulted. The internal medicine doctor may or may not have even laid eyes on this patient, and there is no admission order. In these cases, although the medicine doctor may have written a note about seeing the patient in the ER, they never took over care/wrote orders for the patient. How are other collectors entering these patients?Mlagadi 11:38, 2019 October 1 (CDT)
    • I think this scenario is not an EMIP since the Med doc did not took over. Did the patient go to ICU - if yes then this is an ICU admission? --JMojica 17:09, 2019 October 3 (CDT)
      • This is an interesting case because the medicine service technically accepted the patient to begin with, as they came direct to medicine, and an ER physician did not see them. If medicine sees them, then it could be considered an EMIP? but if medicine doesn't see them, who decided that the patient was too sick for the ward? and consulted ICU? if it was the ER physician than I don't think it would be an EMIP. Just my two cents, it is definitely not clear cut Lisa Kaita 11:03, 2019 October 8 (CDT)
EMIP all
  • need to resolve EMIP and figure out where that info will live. Ttenbergen 11:30, 2016 December 29 (CST)
    • If a patient is still considered an ER patient in a CAU, they can potentially be an EMIP if they get accepted by internal medicine but subsequently are discharged or sent to another hospital.
      • At STB CAU contains inpatients under family Medicine (they are not under the ER physician).
        • If the CAU is considered part of ER then I guess patients that are accepted by internal medicine and go out elsewhere could be EMIP's. It depends how you view the area.
          • Is the CAU considered the same as ER or not? Management will have to determine how they want this done. Currently no one at STB collects data at all on the patients in the CAU. --LKolesar 11:49, 2017 October 27 (CDT)
EMIP Task
  • When reviewing the Cognos EPR Report I came across a few entries that were "ED Death after Arrival" (4 across sites between 2020-03-16 - 29) . Our current definition would exclude these from EMIP collection. Do we include or exclude them in practice? Is that intentional or have we just never thought about them?
EMIP Task
  • When reviewing the Cognos EPR Report I came across a few entries that were "ED Reg/Triaged/Assess LAMA" (6 across sites between 2020-03-16 - 29) . Our current definition would exclude these from EMIP collection. Do we include or exclude them in practice? Is that intentional or have we just never thought about them?
    • In both of these cases we would capture these patients if they were accepted by the medicine service prior to them dying or leaving AMA, it would show up on the discharge register, if they were not accepted by medicine then we do not include them as they were never under the care of the medicine service.
      • Yes they would show up. What I want to be sure about is whether we would collect them when we see them show up. If so, then we need one more bullet above, or we need to add the AMA option to the Home option, since they are kind of the same thing. As it stands now, if someone strictly follows the instructions they would exclude AMAs because they are not on our list.
Employee Assistance Program Trish Emailed Trish to fill this in. Ttenbergen 16:26, 2017 June 22 (CDT)
Encounter processing Pagasa
  • says inactive, but do you actually do this? Is there anything else to it? Do we have, and do you run any multi-encounter checks yet? I guess a lot of the PLs kind of are those...
EPR Lists all Are these the manual lists where you have to add patients? Instructions almost look like it's a counterpart to EPR Reports instead. Are these even still available? What are the advantages / disadvantages for this vs EPR Reports?
EPR Lists all who uses this?
  • uses:
    • names?
  • doesn't use:
    • names?
EPR Lists all Would it be correct to say that the lists are manually populated based on EPR Reports?
EPR Reports Integrator all
  • 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)
Error: There isn't enough free memory to update the display. Close unneeded programs and try again. all Please enter your laptop and under what circumstances you have seen this error below.
Exporting EPR Reports for EPR Reports Integrator all
  • Filter the report; Val/Michelle, could you provide details for what filtering you used for this, if it is other than what was given in those three pages? If same just take out question....
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)
GRA 2S all
  • Is there workload splitting for this location?
GRA 2S all
  • Will that also be used for this location?
GRA Boarding Locations all
  • PACU? Anything else?
GRA CAU Trish
  • We made GRA_CAU available as dispo, but this raises questions about how the field should be treated in reporting. Trish emailed Mary Anne Lynch to find out how these units are actually intended to be used now. Ttenbergen 11:35, 2018 March 8 (CST)
    • Trish, did you ever get an answer for this? Ttenbergen 10:18, 2019 November 5 (CST)
GRA ER use as borrow location all
  • Do we need to add the option to track these for other sites?
    • this is an ER wait/delay case and not to be included in the Project Boarding Loc. The ECIP case is a whole stay in ER but under the Critical Care attending Physician.
GRA ER use as borrow location all
GRA ER use as borrow location all
  • There is a strange thing going on at the Grace that leads to situations similar to ECIP.... Made this page to consolidate details here.
GRA ER use as borrow location all Do we need to change our EPR Report / identification process to make sure we capture these? Just for Grace or for all sites?
GRA General Collection Guide all
  • is this what you would enter as "GRA Ambulatory Care"? Or how do you enter this? Ttenbergen 21:42, 2020 April 5 (CDT)
GRA Medical Records requests all Is there anything else a collector new to GRA would need to know to do this right so we don't lose the good will of MedRec tehre? Ttenbergen 13:58, 2019 December 11 (CST)
GRA Medicine Collection Guide all
GRA PACU all Leaving content from GRA_MICU for now although this is almost certainly wrong, could someone please clean it up?
Grace Hospital Contacts all Where is that form? Is there a link?
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?
HSC D4 pre COVID Tina
  • Hi Tina, I am trying to fix up the collection guide for D4, but realized there is no page for D4. Should I be creating a new page, or using this precovid page to update information? I am not savvy enough to create a new page, so I will need some guidance...
    • Please put the instructions on this page. If they need to move I will take care of that. And yes, we need to start our post-COVID cleanup of some of this, at risk of jinxing ourselves. We are discussing in the office what we will need to do to clean all this up on the wiki. For now, you can take out this discussion if your question is answered, we will catch the page for covid cleanup because it is linked from other pages. Thanks Michelle! Ttenbergen 11:23, 2020 July 9 (CDT)
HSC EMIP all
  • Is this still the same split with understaffing? Ttenbergen 11:33, 2020 April 9 (CDT) Ttenbergen 16:52, 2020 June 5 (CDT)
HSC HOBS all
  • Is the unit info above still correct once this moves back to H7?
HSC HOBS all needs detail
HSC MICU Collection Guide all
  • I have spoken to the clerks in MICU and they do order their own TISS forms and Green sheets. Is it not possible to have SICU and IICU order their own as well? --Jvelasco 11:57, 2020 February 28 (CST)
    • will check this out with Pagasa and printshop. If we made changes to the form then unit would not get most current. Trish Ostryzniuk 14:44, 2020 February 28 (CST)
    • Which Cost Center they are charging to?
      • I do not know. --Jvelasco 15:14, 2020 April 7 (CDT)
HSC MICU Collection Guide all Another question: Since we are not to go to the units during the COVID outbreak, how do we supply the ICU's with TISSs and Green sheets? For sure SICU and IICU will need to be restocked. MICU seems to restock their own according to the ward clerks, but that does not seem to be verified so far...--Jvelasco 15:14, 2020 April 7 (CDT)
  • when was the last time you request TISS form for SICU or IICU guys? Pagasa say HSC has not requested any for long time since Oct 2019 actually. Trish Ostryzniuk 17:19, 2020 April 15 (CDT)
    • We do not request TISS forms/Green sheets for SICU or IICU. We go to your office and Pagasa gives us a stack of both. Or we email Pagasa when the supply is running low in our office, she brings them here and we then deliver some to both units. --Jvelasco 13:26, 2020 April 17 (CDT)
HSC MS3 all Please fill in
HSC Unknown Service all
  • So if Lisa had to cover for one of you while you are aware, how would she know which ones to pick up. Do you have a method for splitting these?
HSC WRS3 all
  • Will this location profile be identical to what HSC_D5 was before?
Iatrogenic, 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 Curriculum all Any other links that would be helpful to new ICU collectors at all sites? --Jvelasco 15:04, 2020 July 6 (CDT)
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 patients in boarding locations all
Identifying patients in boarding locations all We need to make sure nothing in here is inconsistent with the following:
L ICD10 APACHE Dx query Julie
  • You and Allan discussed what should be on the list. At some point we will need to integrate the result into this query. Did you end up including Acquireds? Since the first 24hrs might include them, but they might happen later, and the difference is not clear from Dx_Date? Ttenbergen 20:20, 2018 November 24 (CST)
Lab identification in the DSM data all
  • We should change this; however, do we only change it going forward or do we also re-import back data? Julie is about to re-import back data until 2019-01-01, so maybe we should reimport back data for all that far?
    • shouldn't it be Accept_DtTm and use Arrive_DtTm if Accept_DtTm is blank. We have discussed that in the Project Boarding Loc, we can still determine the counts in between Accept_DtTm and Arrive_DtTm if needed. --JMojica 10:25, 2019 December 10 (CST)
      • That is pretty much what I mean, it should be as you say. Do we want to do this going back in data as you re-import, or just going forward for future imports? Ttenbergen 09:41, 2019 December 11 (CST)
Length of Stay (ICU Report) Julie Right now this is slightly inconsistent with Definition of an ICU admission which doesn't explicitly exclude the ER pts. I have flagged that page for task review. Once that is done, can we just use that definition here as well to ensure consistency?
Length of Time for Transfer from ED to ICU within same facility Julie No significance in your ppt?
Length of Time for Transfer from ED to ICU within same facility Julie What are the details?
Link suspect mismatch to ours incomplete query Pagasa
  • There is a query Link suspect mismatch to ours incomplete2 (with a 2 at the end) in CFE. What is the story, and which one do you actually use?
Link suspect transfer ready before arrive date Pagasa
  • Someone could be transfer ready before theArrive_DtTm , if they become transfer ready after the Accept_DtTm. Is this really a good check to do? It sounds like it would have plenty of false positives. Should it be Accept_DtTm instead?
LOS Julie LOS Medicine per hospital admission and LOS Medicine per ward stay may duplicate content above. Do they? If we ever split these out into reporting documentation indicator pages we will need to make sure these are not duplicated.
LOS Medicine per hospital admission Julie "None yet." What does that mean in the context of "Target"? And how does "Target" fit in with the structure you described in Template:Reporting Indicators?
LOS Medicine per hospital admission Julie Does this mean time spent in an ICU between wards is included in the LOS? If not, can we tweak the text so that is clearer?
LOS Medicine per hospital admission Julie is this Arrive DtTm or Accept DtTm?
LOS Medicine per hospital admission Julie this still talks about TMSX... what is the new status of this field?
LOS Medicine per hospital admission Julie p:Dr. Dan Roberts You had this as "PRESCRIBED BY: "; which is not how you set it in Template:Reporting Indicators. Also, Dan is likely no longer the user of this, so it should probably be updated. If we use a title rather than a name it will be self updating.
LOS Medicine per ward stay Julie Hi Dr. Garland,A thought came up after the last Task meeting related to the discussion on using Service LOS vs. Physical bed LOS (location). We also have A/D/H service patients go to the ward D5. This ward is typically less acute and patients will transfer to D5 from all of the medicine wards (A4/H4/D4/B3/H7). The patients retain their service (A/D/H) while they are on D5, some patients will switch attending (to the D5 Attending), others will stay with the same Attending they had prior to arrival on D5, but the service will remain the same. The Attendings on D5 do not have a specific service and, there is no rule as to which patients switch to the D5 attending. Some patients will be discharged from D5 still under the same Attending that cared for them prior to arrival on D5.

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

  • AG THOUGHTS -- given the variability in where a ward patients is/goes and which service takes care of them, dealing with this issue requires us to know what the powers that be want as respect to how we keep track of LOS. Do they WANT by physical ward, or service, or something else?
LOS Medicine per ward stay Task ward LOS vs Service LOS - Val Penner - HSC-D5 follow up from May 7 task meeting- May 16.19
Manitoba Health Crosschecking Background Julie
  • Need to know how this arrives to set up processing. Where will this data live? Ttenbergen 16:11, 2014 August 25 (CDT)
    • Actually, I think you have not been getting those for ages, right? We would just need to update that. We may or may not blow away this page, depending on whether we think we will ever get this again.
MediaWiki:Common.js all ", post: "
MediaWiki:Common.js Allan ", post: "
MediaWiki:Common.js Task ", post: "
MediaWiki:Common.js Tina ", post: "
Medical Assistance In Dying Julie
  • When we started out this dx used code U23, but then as of 2018-07-17 ICD10 actually added a code for this so we changed ours to that code. I don't really think we are interested in keeping that very early test data, so this comment can probably just go, and we can delete them. I am removing the code from our s_ICD10 table.
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?
Nephritic syndrome, acute all Lisa had added the following content to each nephritic dx page, because this template was invisible. I have made the template visible, but now there is likely duplication. Can someone medical please integrate Lisa's content with the stuff below that was here already? Between the lines is Lisa's content:
Nephritic syndrome, chronic all Lisa had added the following content to each nephritic dx page, because this template was invisible. I have made the template visible, but now there is likely duplication. Can someone medical please integrate Lisa's content with the stuff below that was here already? Between the lines is Lisa's content:
Nephritic syndrome, NOS all Lisa had added the following content to each nephritic dx page, because this template was invisible. I have made the template visible, but now there is likely duplication. Can someone medical please integrate Lisa's content with the stuff below that was here already? Between the lines is Lisa's content:
Nephritic syndrome, rapidly progressive all Lisa had added the following content to each nephritic dx page, because this template was invisible. I have made the template visible, but now there is likely duplication. Can someone medical please integrate Lisa's content with the stuff below that was here already? Between the lines is Lisa's content:
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 all
  • Lisa, you changed this from "the service at the sending facility". I think the new definition is inconsistent with what is said in Previous Service field which seems to say to enter "Not Applicable". Am I missing something? Ttenbergen 10:43, 2020 July 9 (CDT)
Patient Viewer Tab Cognos ADT all
  • My patients coming from ER have a different Accept DtTm on EPR Reports than what shows up in Cognos ADT. Cognos seems to use the same DtTm as Unit Start. Right now I'm changing it to what EPR Reports shows. --Jvelasco 13:13, 2020 June 12 (CDT)
    • I am looking into that now... Ttenbergen 10:15, 2020 June 17 (CDT)
Patient Viewer Tab Cognos ADT Tina
  • I already know the following:
    • At least some patients show duplicate lines in the Cognos list
PatientFollow Project all
  • The list would need to be exported on a regular basis and then made available to collectors. How would this best be done?
  • There was talk about EPR lists to help collectors keep track of their patients. If we use that method then how will we handle it when there needs to be coverage?
  • How do we make sure no pts are missed?
  • How do we make sure no pts are duplicated?
PatientFollow Project all
PatientFollow Project all
  • It should be questioned then whether amalgamating all data collection units within a site for example there are 4 medicine collection units at STB + EMIPs how to possibly track and reconcile all these lists with any semblance of accuracy. This would be a very labor/time intensive and complicated process, as well as a significant logistical challenge. Use of EPR lists to create further lists/spreadsheets in Excel seems redundant and a risky proposition in terms of inclusion and accuracy. There are also potential PHIA considerations whereas patient information on laptops is currently stored/accessed through a separate program, what are the implications for "personal" and/or redundant storage of patient information on data collector accounts? Pamela Piche 10:19, 2019 September 5 (CDT)
PatientFollow Project all The potential to either, have multitudes of patients duplicated, or more importantly, patients missed seems astronomical. Inadvertently duplicating patients will end up being way more work for data collectors. How will we, as data collectors even know that we have duplicated a patient that another data collector has already done? Or conversely, how will we know if we have missed a patient?
PHIA policy Trish Trish will put link.
PL missing L Tables content all Have there been more since?
PL missing L Tables content Pagasa
  • Pagasa, could you please log here when this query lists errors, and what was found to be the problem (ie whether there was data in CCMDB.accdb that didn't make it, or no data in first place.
Pneumothorax, nontension, nontraumatic Tina find page for general rule of not coding iatrogenic events as traumas
Pneumothorax, nontraumatic, NOS Tina find page for general rule of not coding iatrogenic events as traumas
Pneumothorax, tension, nontraumatic Tina find page for general rule of not coding iatrogenic events as traumas
Pre op Admit-Cardiovasc Patient Julie This is not coded under ICD10 or CCI. Do we report this, and therefore need to accommodate otherwise, or how will we treat this? We have Preparatory care (incl preop optimization) but that doesn't capture the full concept. Ttenbergen 22:45, 2018 November 27 (CST)
Pre-linking checks Pagasa This automatic list includes an PL missing L Tables content - where does it fit in into the order in which you run these above? It is likely a very first thing, right?
Pre-OP Admit - Research Patient - Cardiovascular Julie This is not coded under ICD10 or CCI. Do we report this, and therefore need to accommodate otherwise, or how will we treat this? We have Preparatory care (incl preop optimization) but that doesn't capture the full concept. Ttenbergen 22:45, 2018 November 27 (CST)
Previous Location field Julie
  • In the event that both the bed and the service are borrowed: ie. STB MICU borrows a bed in CICU under CICU service then patient is transferred to STB medicine units-for the medicine profile does the Previous Location mean Pre Admit Inpatient Institution ie. STB_MICU? Does previous service mean Critical care in these instances?
    • Good question. I think for the service borrowed, we still need to use the collection location for the Previous Location is equal to Pre-admit Inpatient Institution. For the Previous Service, I am not so sure but for your example the Critical Care makes more sense to enter than Cardiac surgery and so we need to check with Tina if this is allowed in her integrity checks. --JMojica 09:59, 2020 January 23 (CST)
      • If I understand you right you suggest that the first entry will be Service/Location STB_MICU with a Boarding Loc entry telling that they are in CICU, and the second entry will be Service/Location STB_MICU and Previous Service would be "Critical Care". If so, that is the same as any normal STB_MICU patient, no? So, yes this should work as far as queries are concerned. But is this really the thing we want to enter? How is this patient at all still a STB_MICU patient if both service and bed have moved on? How is this not a transferred patient?
Previous Service field all
  • As per last Task Meeting - is this correct or do we need to discuss further? --Jvelasco 14:39, 2019 June 26 (CDT)
    • Good question. 6 months later, what do people think?
Previous Service field Task
  • The Registry Patient Type field was replaced by the Previous Service field, how will the patient types be derived from the previous service field? the s_previous_service table must have a column defining the patient type.
    • Patient Type is Surgical if previous service is Cardiac Surgery, General surgery ,etc.,
    • Patient type is Cardiac if previous service is Cardiology,
    • what about Patient type Medical? if Ob/Gyne or Emergency Medicine, is it Medical type? how about critical care?
    • It was also mentioned earlier to use the diagnosis instead, can we begin working on this? --JMojica 15:48, 2019 May 21 (CDT)
    • If I remember right it the Registry Patient Type data was supposed to be inferred from several fields, not just Previous Service field, but I can't remember the details either. We can absolutely add a column for this to s_previous_service table once we know what we need. Ttenbergen 12:49, 2019 June 4 (CDT)
Procedure when there are differences between L Log and L PHI Pagasa Why, what does that tell you? The only way I can imagine this would happen is if the record was deleted in centralized L_Log. In that case, if you are lucky and there is still a ccmdb_data with the completed/sent record, you can follow the Re-sending data process. If not, find it in a previous version of Centralized data.mdb, print or write down all data for the record, and manually re-enter it in a CCMDB.accdb and follow the Re-sending data process. Or what do you do? Ttenbergen 21:38, 2019 February 6 (CST)
Processing errors in patient data Pagasa
Project Borrow arrive Julie did they ever get back to us? no response from HSC SICU --JMojica 10:14, 2019 May 6 (CDT)
Project Discharge Documentation all I could set up a query in CFE to dump this to keep it off Julie's desk. This user might find speed more important than quality? If needed, let me know.
Project Discharge Documentation all Will these documents be retained on charts once they hit med records?
Project Discharge Documentation Julie pls fill in once you set it up
Property:Collection Location Service Type Trish What is CTE? I am adding it for now because not having it is breaking SMW, but we really should not have it here if it isn't defined.
Psychoactive substance NOS, chronic abuse/dependence/addiction Task We were wondering if we should ever be using any of the chronic abuse codes as an admit diagnosis. For example, some of our patients are being followed by an Addictions service on the wards. Some are started on the methadone program, others get discharged to an addictions unit. If it is actively being treated on our unit, then should we code it as an admit, as well as a comorb?Mlagadi 10:20, 2020 May 15 (CDT)
    • This is about any of the codes in Category:Addiction and any outcome should likely live in Template:ICD10 Guideline Chronic Substance Abuse. I moved the question here from the category because (a) categories should only contain info about what would qualify a page to be in the category and (b) some of the queries and templates don't work the same with categories. This way it will show up on the task agenda. Ttenbergen 22:06, 2020 May 18 (CDT)
QA Infection VAP Julie will we still need to collect this in ICD10, since I think all the data now lives in the dx codes as well. I am holding off on implementing Query s tmp QAInf tmp no dx until resolved. same reply as in QA CLI. --JMojica 12:04, 2018 December 27 (CST)
QA Septic Shock Julie If we ever pick this back up we need to answer: Is "Every entry for project QA Septic must have either a date or a time." a request for a cross check? or does that check exist already?
Quarterly report Julie What is the Quarterly report report?
Query check CCI must have entry Pagasa
  • Patients without CCI entries are slipping through and found by PL missing L Tables content , must fix PTorres 09:42, 2019 February 7 (CST)
    • I seem to remember discussing this with Pagasa. There was a misconception that a "no CCIs" had to be present in both component and picklist, but that is not true: it only needs to be in the Picklist. Is this still a problem? If so, please tell me an example when one comes up.
    • Michelle sent email 2019-10-31 that she was able to click "D" with no CCIs entered. I tested on my copy and got an error when I tried. Will need more info about the scenarios where this can slip through.
Query check ICD10 ESRD and AKI only if transplant Allan Would the past history really allow for this? i think only a CCI makes it OK to have both an ESRD and an AKI dx in same patient.
Query check long transfer delay all
  • Requiring notes to have content is really a very soft error check... do we need to consider something better?
Query check long transfer delay all
Query check long transfer delay all At the meeting about cross checks it was decided to change the cut-off to SD*3; will need to get that from Julie if we ever address the other questions.
Query Import request matcher all This one is fairly easy, Pagasa will try to make it.
Query NDC Bad Postal Code Pagasa You mentioned that you occasionally got patients with letters rather than numbers; if that happens again, pls let me know.
Query NDC CLI vs DX but no TISS17 CentralLine Pagasa
  • It said here that this should be retired, but this is still relevant, no? We stopped tmp, but the dc and the TISS entry still exist... Do you still run this tests?
Query NDC VAP no TISS Julie FYI Maybe
Query NDC zCRRT TISS no tmp Tina _dev_CFE - remove this and *old
Query NDC zCRRT tmp no TISS Tina _dev_CFE - remove this and *old
Query s ICD10 Chapter block dxs Julie any other plans for these?
Query 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
Renal Coding Considerations for ICD10 all Lisa had added the following content to each nephritic dx page, because this template was invisible. I have made the template visible, but now there is likely duplication. Can someone medical please integrate Lisa's content with the stuff below that was here already? Between the lines is Lisa's content:
Reporting from ICD10/CCI Julie
  • Different procedures would be listed with the same CCI code; will Julie easily interpret and utilize CCI codes for reporting?
  • Do we care that we will not be able to differentiate between a Blakemore tube from an Upper GI scope with banding or hemostasis, when in CCI they both look the same: (T) Stomach, pylorus... and Control of Bleeding. --LKolesar 14:11, 2018 May 1 (CDT)
    • discussed at task 14:08, 2018 June 20 (CDT), Julie to review what she needs and we will discuss again Ttenbergen 14:08, 2018 June 20 (CDT)
Requested CCMDB changes for the next version all
Requested TISS changes for the next version Julie What is the intended use of these reports?
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?
Severe Sepsis Julie I don't think this was ever implemented, can't find any evidence of it. Do we need it? Ttenbergen 11:04, 2018 September 25 (CDT)
Severity of illness Julie Is this average as in description or mean as in definition?
Severity of illness Julie What are the details?
SOFA scoring Task Z) decided to revisit 6 months after ICD10
Staphylococcus aureus Allan z "It was decided that Allan with contact Dr. Embil and see if we can obtain this data from Infection Control. If so, we could import it into the database, and have our data collectors cease obtaining it." - did anything come of that?
Statistical Analysis Julie This article will likely be one of the more common landing points for external users. What do we want to tell them? Do we have any project articles we want to link in that especially highlight what we can do? ALERT Scale?Ttenbergen 22:50, 2017 June 7 (CDT)
StatusReport.bat Pagasa
  • have we got rid of all these old files? IF so we can delete these articles, but if they are still around we might want to keep them... I think we should just get rid of the files, though. Ttenbergen 22:42, 2017 June 7 (CDT)
    • confirmed that X:\PAGASA\STATUS_REPORT still exists; can we clean that up?
STB ACCU Collection Guide all
  • Is this still done? How does this actually impact collection, ie why would these pts be marked so?
STB B5 all If you check Definition of a Medicine Service admission is that still true? Ttenbergen 21:07, 2018 November 24 (CST)
STB Boarding Locations all
  • Any other boarding locs for STB Med?
STB Boarding Locations all
  • PACU? Anything else?
STB E5 all Is that exception about radiology still true? Ttenbergen 21:03, 2018 November 24 (CST)
STB E6 C all This is probably all wrong now, please update
STB Electronic Patient Record all
  • "...Also, the "APACHE" score for medicine is not dependent upon the first 24 hours of vital signs and labs so exact accuracy here is less important. --LKolesar 06:44, 2019 October 24 (CDT)"
    • We don't do an apache score for medicine at all, so I am not sure what you mean here. AFAIK the instructions how to collect e.g. WBC are the same for medicine and ICU, no? In any case, I think it's separate from the purpose of this page, how EPR is used at STB. If you agree, can you please take out this whole Discussion? Ttenbergen 11:31, 2019 October 30 (CDT)
STB General Collection Guide all Are gloves no longer to be supplied? With regular/ongoing occupancy of Medicine office for orientation starting July, will masks be provided?
STB Medical Records requests all If I was a new collector, how would I find that shelf?
STB Medicine Collection Guide all will any med collectors be on site at intervals like STB_Critical_Care_Collection_Guide#IMPORTANT_INFORMATION_DURING_COVID_PANDEMIC?
STB Medicine workload splitting all
STB Medicine workload splitting Julie
  • How does that work for Julie's reporting?
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
Switching to a single serial pool per laptop all
  • Do you think there would be a problem with your collection work flow if you moved to automatically assigned serials from a single number pool? Are there processes identifying patients or similar (ie processes that are not on the laptop) that would be confused by this? Ttenbergen 21:16, 2020 April 26 (CDT)
    • The only problem that I can see is that the numbers help us figure out which patients are in High Obs, or which patients are EMIP's. We could fix that problem by entering a location in the Record field.Mlagadi 07:50, 2020 April 27 (CDT)
      • Due to space restrictions we initially didn't include the location as a column on the Patient List, but we did set up colors per unit. I just realized I didn't initially document this on the wiki, but I now have, see Patient_List#Row_colours_on_Patient_List. Would that be an alternative to using the serial to figure out the unit? Ttenbergen 12:11, 2020 April 28 (CDT)
      • I could also add a button to sort by unit, even if it's not displayed. Let me know if that would be helpful. Ttenbergen 12:11, 2020 April 28 (CDT)
Switching to a single serial pool per laptop all
  • Moving here from a page where it didn't fit in:
  • "One more point, D5 & B3 use consecutive numbers also. These would be hard to keep track of without a paper log for the really quick admissions & discharges that are sometimes seen on B3.--CMarks 13:22, 2012 October 1 (CDT)"
    • Iris, is that still a thing, and will it make any difference if we change these to a single pool? If not, please remove this discussion. Ttenbergen 16:30, 2020 April 29 (CDT)
Task Team Meeting - Rolling Agenda and Minutes 2019 Julie Actually, I think Julie decided to re-claim these from backups, no?
Task Team Meeting - Rolling Agenda and Minutes 2020 all
Task Team Meeting - Rolling Agenda and Minutes 2020 all
  • Will this mean entering and possibly later changing Service/Location and therefore D_ID of patient records?
Task Team Meeting - Rolling Agenda and Minutes 2020 Allan
Task Team Meeting - Rolling Agenda and Minutes 2020 Allan
Template:ICD10 Guideline Como vs Admit Allan Como Admit Acquired Primary Limits - this is part of that discussion - if we limit which admits will count as comos we need to review
Template:ICD10 Guideline Iatrogenic Pneumothorax Tina find page for general rule of not coding iatrogenic events as traumas
Template:ICD10 Guideline MRSA Allan z "It was decided that Allan with contact Dr. Embil and see if we can obtain this data from Infection Control. If so, we could import it into the database, and have our data collectors cease obtaining it." - did anything come of that?
Template:ICD10 Guideline Nephritic Syndrome all Lisa had added the following content to each nephritic dx page, because this template was invisible. I have made the template visible, but now there is likely duplication. Can someone medical please integrate Lisa's content with the stuff below that was here already? Between the lines is Lisa's content:
Template:ICD10 Guideline Transplant Failure Julie
  • Is "don't code history of transplant when coding transplant rejection because it's implied" something you are aware of? It's not something I would have thought of if you had asked me to write a query that lists all records with previous transplants. If we want to change this could you bring it to task meeting? Ttenbergen 16:41, 2020 January 31 (CST)
Template:Newsflash Tina needs troubleshooting
Temporary page to list dxs documented as requiring treatment to be coded Trish
  • Tina -- to deal with these, let's make a template and put it in all the ICD10 pages that link to the list right below here. That template to say: This is an entity which you SHOULD code even if it is not being treated.
    • I have made Template:ICD10 Guideline code even if not treated; should it be applied to the new codes or only those old pages?
      • We need to decide were to put that info; adding it to old pages is probably not the right place. ICD10 collection might be it - will people look there?
        • Emailed Trish about this. Ttenbergen 09:07, 2019 April 30 (CDT)
TISS Form (TISS28) Pagasa what actually needs to be specified when ordering?
TISS Form (TISS28) Pagasa where does one get that requisition form?
TISS form audit Task
  • Tina, there is one more item we need here - No error or one item wrong for the day in case in a form with errors, some days are correct. --JMojica 09:16, 2020 June 5 (CDT)
    • I added this to not leave collectors in a lurch, but I don't think it is actually needed and we should stop doing it. We added "no errors on form" in order to know our n; we know how many days on a form should be entered because of the L_Log content (even if incomplete). So, I don't think we need to collect this. Ttenbergen 14:01, 2020 June 9 (CDT)
TISS28 backup and start.vbs Pagasa Do you still use this? It is not linked, so as part of what process?
TISS28 Form Scanning Pagasa
  • If a frozen version is kept available during TISS scanning anyways then there is no reason to not do these checks in CFE, is there? Or rather, collectors sending would not be the reason. Pagasa, let's talk about this. Maybe we can make this more convenient for you. Or write down the actual reason why it can't be done. Ttenbergen 00:34, 2017 November 12 (CST)
    • Discussed this with Pagasa. It would mean doing scanning during send time, and likely doing all fixes during pull time, so all checks could actually be done form CFE. Discussed also w Pagasaa that we would delete the error checks from TISS so there is no duplicates getting out of sync.
      • Do we want to make this change then, Pagasa? You would be the only one who would be affected, so mostly up to you. Maybe confirm with Trish.
Transfusion of platelets Task There are conflicting and misleading instructions here. We might need to take out Template:CCI Collection Mode since this is a one-of. Same for Template:CCI Guideline Transfusions.
Update of D ID exclude service/location all
  • can someone else think of how this might not work out right?
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?
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Questions&oldid=143064"