Questions

From CCMDB Wiki
Jump to navigation Jump to search

Lists all pages in . For those that were added with Template:Discuss it also lists the question. The old ones added with Template:Discussion only list the page.

There are currently 28 questions on this wiki.

 Summary
"cannot open any more tables" in Access
  • After 24 rows, open and closed assigning Pseudo Phin an error message pop up then I cannot assign Phin anymore. I closed CFE then open then I am good to go again. The second time the error message pop up not 24 rows it less than 24 like 15 rows then it will show again the error message. PTorres 16:09, 2022 June 14 (CDT)
    • Is it the "cannot open..." error or the "enter parameter..." error you get at this point? Emailed Pagasa... Ttenbergen 10:49, 2022 November 16 (CST)
      • Still shows "cannot open "so I clicked ok then it says run time error 3014 cannot open any more tables. Closed the CFE then log back in.
      • After I continue assigning Pseudo Phin after 25 rows "cannot open" showed up again I clicked ok then error message shows again. Closed CFE then log back in.PTorres 14:42, 2022 November 30 (CST)
        • Are you following the steps in Generating PseudoPHINs when this goes wrong? Which step in those instructions are you at when it stops responding and you need to restart the program? Ttenbergen 13:48, 2022 November 29 (CST)
      • Yes, I am. I am clicking and assigning the new Pseudo Phin and not moving. PTorres 14:47, 2022 November 30 (CST)


  • Assigning Pseudo Phin or working on the queries if I worked long enough opened closed it then the error message pop up "Enter Parameter Value". PTorres 17:01, 2022 April 14 (CDT)
    • What is the specific action or button press after which this happens? I.e. which step in Generating PseudoPHINs? Ttenbergen 10:49, 2022 November 16 (CST)
      • When I click the pseudo button to the left of the PHIN field label, nothing is moving.PTorres 15:23, 2022 November 30 (CST)
        • I don't understand what you mean by that. What is the last thing you do before the "Enter Parameter Value" error happens? As in, what is the last button you click or last field you enter? Ttenbergen 12:15, 2022 December 7 (CST)
ABG Data
ALERT Scale Use
  • that is interesting; would that include pts discharged to ICU after > 2 days?
APACHE Acute Dxs in ICD10 codesYou asked for a spot for this info
Adding a drug to pharmacy collection
  • This needs cleanup, just putting it here instead of email
Awaiting/delayed transfer to long-term care/PCH inside or outside of Winnipeg
  • These should be made consistent with Template:PCH Riverview Deer Lodge and should probably use that template to enforce consistent use. Ttenbergen 14:23, 2024 October 16 (CDT)
    • and I have lost track of the details Ttenbergen 10:45, 2024 November 1 (CDT)
      • There might be an easy way out of this question. We now only have one awaiting code; if waiting for any of them qualifies for this code then we may not need to know about the level of care. But then again, some of those sites also have acute/LAU type settings so we may need to figure this out after all...Ttenbergen 20:27, 2024 December 11 (CST)
Chronic Health Facility
  • Is St. Amant still relevant in this list in its new functionality? If not we should move it to a legacy section on this page, since the info is still relevant for legacy data. Ttenbergen 14:21, 2024 October 16 (CDT)
  • Yes it is still relevant in this list Lisa Kaita 20:47, 2024 December 3 (CST)


  • These three need to become consistent and non-repetitive so they can't get out of synch. Ttenbergen 14:21, 2024 October 16 (CDT)
ClientGUID field
  • Lisa, any idea why this might be happening from a collection perspective? Is the problem in what we receive the right info from Cognos, or is there an issue in the collection process that makes this happen? Ttenbergen 09:52, 2024 December 5 (CST)
  • Julie, do we need to flag anywhere further that this data is suspect? Ttenbergen 09:52, 2024 December 5 (CST)
Created TransferReady queryStill need to import this into master CFE, the version I have right now is messed up. Here it is:
DSM Lab Extract
DSM Labs data.accdbEmailed Julie:
  • found overlap in old file, what does it mean
  • proposed using labDtTm for split threshold
Ttenbergen 16:51, 2024 May 2 (CDT)
Decubitus (pressure) ulcer, stage not indicatedJALT Met with Andie and she asked if we can add deep tissue injury as a category for pressure ulcers, and also if we can add the options of a location with each stage, coccyx/buttocks, heels, and other. SICU has just finished a project looking at pressure injuries and the use of a preventative drsg. SBGH/MICU/IICU are also planning to adopt this drsg and would like this data. Lisa Kaita 11:58, 2024 December 20 (CST)
Dispo field
  • you removed '"`UNIQ--nowiki-00000109-QINU`"'; that template is also linked from Chronic Health Facility. The two will now show inconsistent content. When content is driven by a template like that it is always so it stays consistent across the wiki. Pls have a look at Template:PCH Riverview Deer Lodge and Chronic Health Facility to consider if (a) the two should really be inconsistent now or (b) we should re-instate the template and fix its content. Catch me on teams if you want more information or help with this. Ttenbergen 14:05, 2024 October 16 (CDT)
  • Lets set up a time to discuss this, I don't think I knew they were templates, I thought I was editing an article Lisa Kaita 13:16, 2024 October 31 (CDT)
  • we have pts discharged to AIA (alternative integrated accommodation) located at 698portage ave, opened April 15, 2024, should we add this as an option to the dispo dropdown? Lisa Kaita 08:39, 2024 December 17 (CST)
ER Delay
  • I have re-updated Created_Variables_Common_maker_2021 query, for some reason the change I had made was not reflected in the master version. Ready to test. Ttenbergen 13:25, 2022 June 28 (CDT)
    • emailed Tina some inconsistencies found in ER Delays Aug 15,2022. --JMojica 13:21, 2022 August 29 (CDT)
      • are these still an issue? Ttenbergen 11:15, 2024 May 1 (CDT)
        • I will re-check again. Can't remember if have been resolved. --JMojica 14:40, 2024 October 2 (CDT)


  • I just had a look at that sas file (they open as text files) to see how you define transfer delay. If that file is still being used we may have a problem, it still defines tdelay different if a pt goes to a higher level of care, goes AMA or dies, and we changed that some time ago. So is this still the reference of how you calculate this? Ttenbergen 22:50, 2024 November 16 (CST)


  • This data is problematic before 2011-Q2,the only reason there are any is because it derives them for EMIPs. Some data may be available in Moves for Medicine, but that would still leave a gap. Ttenbergen 23:09, 2024 November 16 (CST)
    • OK, will be working on this getting data from Moves for Medicine from period Sept 2007 to June 3, 2011. will give to Pagasa for upload to Arrive DtTm field. I will update the WIKI as soon as done. Conclusion: for Medicine, prior Sept 2007, no ER delay while for Critical Care, no ER Delay prior July 1, 2016 -- these are treated as missing. --JMojica 16:35, 2024 December 11 (CST)
Error "Invalid SQL statment..." when sending
  • I have a hunch that this error may be related to a send failing for one collector and a second collector then also sending, leading to problems with the lock file.

So, when the error happens, please have a look at Regional Server\/output (full address: \\ad.wrha.mb.ca\WRHA\REGION\SHARED\ICU_DATA_COLLECTION\/output) and see if there is a second centralized_data file there with an extension .lccdb. See Lccmdb and ldb files for details. Please log here about what you find. Ttenbergen 10:41, 2024 November 30 (CST)

Gastrointestinal (GI) tract, foreign body in
High-Obs WardsTina to add.
HospiceHow about Jocelyn House?
ICD10 Guideline MRSAz "It was decided that Allan with contact Dr. Embil after COVID is over 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?
Instructions for importing a batch of DSM Data
Level of care hierarchyJALT
  • should Brandon ICU be considered a stepdown? Lisa Kaita 08:42, 2024 December 17 (CST)
PCH Riverview Deer Lodge
  • we may want to consider a third level heading section with this content so the whole context can be given wherever this is used. Ttenbergen 14:24, 2024 October 16 (CDT)
    • PowerBI Data Model for CCMDBER Delay and Overstay

    Note from email from Julie 2024-20-24:

    I do not use any cut-off e.g. 2020-10-15 because the tmp has been populated by boarding data since July 2018 for ICU and Sept 2019 for Med. The cut-off Oct 2020 Patient Follow only applies for tmp Service but not for tmp Boarding loc. By the way. the patient follow started early at Grace Oct 1, 2020 (they piloted it), while HSC and STB started Oct15, 2020. Similar with EMIPs, I have two sources of ER-delay namely 1. from Accept and Arrive 2. from Tmp : first boarding dttm and second boarding dttm. If both have values, I use the one from the tmp source.
    Pre-admit Inpatient Institution fieldHey T/Julie, I recently admitted a pt from day sx and did as the wiki instructions on Previous Location and put HSC_ward, which according to the article is not an inpt location, so put NA for pre admit pt institution, however I got an error saying previous loc and pre-admit must be the same if coming from an inpt location. Should we change the instruction and use HSC ambulatory care instead of HSC ward?, or do we need to rethink this? Lisa Kaita 13:04, 2024 October 16 (CDT)
    Query NDC Bad Postal Code
  • I think this is the process where you said you are having problems with copy/pasting. Copy pasting isn't even mentioned here, so maybe update the process to show how you actually do this, so that someone like Sheila Rusnak would be able to follow the instructions. Ttenbergen 15:45, 2022 March 17 (CDT)
    • Do you create that query each time? Would we be able to update the NDC query that finds these in the first place to include the info you need? We can discuss at our next meeting. Ttenbergen 16:23, 2022 March 17 (CDT)
      • Taking this off Pagasa's list for now, since if we can get this data from DSS we won't need to do this any more. Ttenbergen 15:36, 2022 March 24 (CDT)
    • Query check has transfer ready date or checkbox
    • This check doesn't seem to catch when a time is entered without a date. It would be good to update that. Don't have time right now, so leaving a note. Email exchange 2024-11-14. Ttenbergen 12:12, 2024 November 15 (CST)
    Questions
    Service/Location fieldLKTT
    • Now that we have decided to leave this as separate wiki pages, should we remove the above line? Lisa Kaita 06:45, 2024 April 11 (CDT)
      • How about this. But we still have a problem: what do we put into the element_description for this in the template call? That's kind of important since it drives the auto data dictionary. Ttenbergen 17:22, 2024 April 11 (CDT)
      • need to chat about this T Lisa Kaita 14:38, 2024 October 2 (CDT)
        • Do you want to book a time for that conversation? I usually work HSC Wed and Thu. Also, to easily add things to "our" list, I added an LKTT which would allow filtering Questions for these. Ttenbergen 12:48, 2024 October 3 (CDT)
    Retrieved from "https://ccmdb.kuality.ca/index.php?title=Questions&oldid=136732"