Questions: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
Line 6: Line 6:
|format=count
|format=count
|limit=2000
|limit=2000
|link=all
}} questions on this wiki. '''
|headers=show}} questions on this wiki. '''


{{#ask: [[Category:Questions]]  
{{#ask: [[Category:Questions]]  

Revision as of 22:11, 2019 March 25

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 13 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
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
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)
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)
High-Obs WardsTina to add.
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?
Pneumonia, ventilator-associated (VAP)


Does this rule still apply since we no longer require an organism for a VAP, if someone is admitted with a CAP and later meets the criteria with the same bug, with our new guidelines would this not be considered a VAP? Lisa Kaita 11:16, 2024 July 24 (CDT)

  • This will be carried over to next TASK (Sept12, 2024) Lisa Kaita 12:21, 2024 August 1 (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)
  • 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)