Search by property

Jump to navigation Jump to search

This page provides a simple browsing interface for finding entities described by a property and a named value. Other available search interfaces include the page property search, and the ask query builder.

Search by property

A list of all pages that have property "DiscussQuestion" with value " * There was a comment on [[Chronic Health APACHE]] about extracting the APACHE Comos from comorbid diagnoses instead using the ranges Allan provided. Provided this list is updated to the newest ranges Allan has provided, do you see a problem with using this approach instead and stopping collection of the [[Chronic Health APACHE]] field going forward? ". Since there have been only a few results, also nearby values are displayed.

⧼showingresults⧽

View (previous 1,000 | next 1,000) (20 | 50 | 100 | 250 | 500)


    

List of results

     ( * There was a comment on [[Chronic Health APACHE]] [[Chronic Health APACHE]] field going forward? )
    • Service/Location field  + ( * Hey T, this page is for the Service loc</br>* Hey T, this page is for the Service location field in the demographics Tab correct? not sure why we have this as a legacy field? Or am I misunderstanding this?[[User:Lkaita|Lisa Kaita]] 15:11, 2024 March 6 (CST) </br>** I think that was written when we first changed and decided to only have <site>_<program>, ie before we split the CC program back up. In a way it is still legacy as that meaning, because now the meaningful info should live in Service and Unit entries in tmp. Between this and your question below about where that info should live, we may want to make an overarching page for the three concepts. I was wondering if we already have one, but the closest thing is [[Change from Service Location to Service, Boarding Loc and Transfer Ready DtTm tmp entry]] and that's not quite it. The cleanest way to to it might be to make a new page of the current [[Collection instructions for Service/Location vs Boarding Loc vs Service]] page, interlink it with the change page, and then keep only the current state/collector instruction in the "collection instructions..." page and the history in the "Change..." page. This is one of those things that are difficult to document because we need both the current state for collection and the complete history for interpretation. Having two pages like that should do it. [[User:Ttenbergen|Ttenbergen]] 16:30, 2024 March 6 (CST)</br>** I am not entirely clear on your instructions, or how to go about doing some of this, maybe when you have time we can chat about it, no rush [[User:Lkaita|Lisa Kaita]] 12:25, 2024 March 12 (CDT)</br>*** Are you in today to chat? [[User:Ttenbergen|Ttenbergen]] 11:22, 2024 March 21 (CDT)</br>[[User:Ttenbergen|Ttenbergen]] 11:22, 2024 March 21 (CDT) )
    • ER Delay  + ( * I have re-updated [[Created_Variables_Common_maker_2021 query]]</br>* 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. [[User:Ttenbergen|Ttenbergen]] 13:25, 2022 June 28 (CDT)</br>** emailed Tina some inconsistencies found in ER Delays Aug 15,2022. --[[User:JMojica|JMojica]] 13:21, 2022 August 29 (CDT)</br>[[User:JMojica|JMojica]] 13:21, 2022 August 29 (CDT) )
    • Query NDC Bad Postal Code  + ( * I think this is the process where you s</br>* 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. [[User:Ttenbergen|Ttenbergen]] 15:45, 2022 March 17 (CDT)</br>** 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. [[User:Ttenbergen|Ttenbergen]] 16:23, 2022 March 17 (CDT)</br>*** 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. [[User:Ttenbergen|Ttenbergen]] 15:36, 2022 March 24 (CDT)</br>[[User:Ttenbergen|Ttenbergen]] 15:36, 2022 March 24 (CDT) )
    • ABG Data  + ( * Identified as something we should do to</br>* 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 </br>** Allan will revisit with Lab people whether this is obtainable now [[User:Ttenbergen|Ttenbergen]] 11:34, 2022 February 9 (CST)</br>*** Allan is negotiating inclusion of Labs data with Grace hospital as per [[Task_Team_Meeting_-_Rolling_Agenda_and_Minutes_2023#ICU Database Task Group Meeting – April 19, 2023]], leaving this flagged to ensure update. [[User:Ttenbergen|Ttenbergen]] 14:00, 2023 May 17 (CDT)</br>User:Ttenbergen|Ttenbergen]] 14:00, 2023 May 17 (CDT) )
    • Changing D IDs  +
    • "cannot open any more tables" in Access  + ( *After 24 rows, open and closed assigning</br>*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. [[User:PTorres|PTorres]] 16:09, 2022 June 14 (CDT)</br>** Is it the "cannot open..." error or the "enter parameter..." error you get at this point? Emailed Pagasa... [[User:Ttenbergen|Ttenbergen]] 10:49, 2022 November 16 (CST) </br>*** 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.</br>*** 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.[[User:PTorres|PTorres]] 14:42, 2022 November 30 (CST)</br></br>**** 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? [[User:Ttenbergen|Ttenbergen]] 13:48, 2022 November 29 (CST)</br>*** Yes, I am. I am clicking and assigning the new Pseudo Phin and not moving. [[User:PTorres|PTorres]] 14:47, 2022 November 30 (CST)</br>[[User:PTorres|PTorres]] 14:47, 2022 November 30 (CST) )
    • Cardiac/cardiovascular drug NOS, overdose/toxicity  +
    • Opioid/narcotic, overdose/toxicity  +
    • Benzodiazepine, overdose/toxicity  +
    • Tricyclic antidepressant, overdose/toxicity  +
    • Antidepressant drug NOS, overdose/toxicity  +
    • Psychiatric drug NOS, overdose/toxicity  +
    • Beta-blocker, overdose/toxicity  +
    • Anticoagulant, overdose/toxicity  +
    • Calcium channel blocker, overdose/toxicity  +
    • Drug or biological substance/agent NOS, overdose/toxicity  +
    • Iatrogenic, complication of medical or surgical care NOS  +
    • Anesthetic gas, overdose/toxicity  +
    • Sedative or hypnotic, overdose/toxicity  +
    • Thrombolytic drug, overdose/toxicity  +
    • Antineoplastic/chemotherapy or immunosuppressive drugs, overdose/toxicity  +
    • Neuromuscular blocker/paralytic, overdose/toxicity  +
    • Cocaine, overdose/toxicity  +
    • Acetaminophen (tylenol, paracematol), overdose/toxicity  +
    • Aspirin or other salicylate or NSAID, overdose/toxicity  +
    • Hormone or hormone agonist NOS, overdose/toxicity  +
    • Antibiotic/antimicrobial, overdose/toxicity  +
    • Hallucinogen, overdose/toxicity  +
    • SBGH Swing Beds  + ( * to be sure, if I remember right STB ICU</br>* to be sure, if I remember right STB ICU does that for ALL [[Boarding Loc]] entries, not just swing beds, right? Just trying to confirm, because if that's true then it's not a swing bed instruction but instead a [[STB Critical Care Collection Guide]] instruction (or possibly a [[Boarding Loc]] one). [[User:Ttenbergen|Ttenbergen]] 11:33, 2022 January 27 (CST)</br>** Yes, the arrive time for all ICU patients is taken from the ICU flow sheets</br>*** Then we should remove this info from here and from [[STB CICU Collection Guide]] and put it into [[STB Critical Care Collection Guide]] instead. I can do that, any objections? [[User:Ttenbergen|Ttenbergen]] 15:57, 2023 May 24 (CDT)</br>** I have done this Tina can we delete this page? [[User:Lkaita|Lisa Kaita]] 11:36, 2024 March 12 (CDT) I haven't done anything with the background or related articles etc</br>with the background or related articles etc )
    • Change of remaining location names from "our" names to EPR/Cognos names  + (JALT - Is there anything here we want to dJALT - Is there anything here we want to do before SF? Or that still needs to be done at all? [[User:Ttenbergen|Ttenbergen]] 09:42, 2023 July 6 (CDT)</br>* What happens to the ICU [[Previous Location]], [[Pre-admit Inpatient Institution]], [[Dispo]] or even [[Service Location]] - should they be changed too by the new COGNOS ICU locations? Example current STB_ACCU is SBGH-CCUO in COGNOS, STB_CICU is SBGH_ICCS, STB_MICU is SBGH_ICMS. Should the old labels remain? We need to think hard for its implications to queries of linking and/or matching tables before implementing any change. --[[User:JMojica|JMojica]] 16:33, 2022 February 2 (CST) </br>** It would be nice to have this consistent, and yet you are correct that this would tie into a lot of things. I think the benefits of making it consistent win out, though especially when it comes to also thinking about this in terms of that metadata we discussed the other day. Even if we keep the (possibly identical) data in both s_tmp and s_dispo for now, we would then be able to use that metadata table for both. This would require thinking through the details. Julie, I think it only involves you and me, so maybe we should discuss at our wiki meetings? [[User:Ttenbergen|Ttenbergen]] 13:44, 2022 February 8 (CST)</br>*** Julie and Tina discussed: </br>:::* We use the 4 fields [[Previous Location]], [[Pre-admit Inpatient Institution]], [[Dispo]] and [[Service/Location]] also to map patient flow between laptops, and we very much don't use Cognos values for this (e.g. HSC_Med). We need to retain this ability to use the entries for linking but would also make them the same as Cognos where possible. So we need to keep our "own" values for this for locations where we collect. </br>:::* We decided to use manually split CC entries e.g. HSC_MICU vs HSC_SICU since Julie reports in those increments, ie it is hard to pull apart a stay in two ICU types if it is collected as one record. We don't want to lose that. </br>:::* We would still like to change these own values to the "modern" values where we use legacy terms, eg. STB ICMS vs STB MICU. As long as we make a clean transition between old and new, or change all old, that should not be a problem, but we need to account for it. </br>:::* We could use the Cognos values for all places where we don't collect, e.g. if a pt comes from Ward HSC_A1 and Cognos lists that as HSC-GA1, we could just enter that. However, for locations we don't collect we currently aggregate this to HSC_ward. Do we want the extra detail? It would be easier to enter but might be harder to interpret and possibly even harder to work with for collectors. </br>:::* If we want to keep our proprietary value for locations where we collect, and keep aggregate ones for locations where we don't collect, I am not sure which locations that then leaves where we would use the Cognos values? </br>*** Julie, do you agree to that summary? If so, there may be nothing to discuss with Lisa, since we will need to leave this as is. If I am missing something pls update and then pass on to Lisa for her take. [[User:Ttenbergen|Ttenbergen]] 16:56, 2022 March 23 (CDT) </br>**** agree. pass to lisa. --[[User:JMojica|JMojica]] 15:27, 2022 June 8 (CDT)</br>*I think this is no longer an issue, unless we are looking to change how we collect this, which I am not in favor of [[User:Lkaita|Lisa Kaita]] 12:23, 2022 August 24 (CDT)</br>** Even though this is no longer an issue, we should keep the above 5 summary issues here for future reference. --[[User:JMojica|JMojica]] 13:38, 2024 March 12 (CDT)[[User:JMojica|JMojica]] 13:38, 2024 March 12 (CDT))
    • Toxicology, blood, opiates, positive  +
    • Skin, rash NOS  +
    • Cerebrospinal fluid (CSF) tests, abnormal  +
    • Fecal occult blood test, positive  +
    • Hyperglycemia  +
    • Urinary organs/tract, diagnostic imaging, abnormal  +
    • Hemoglobinuria  +
    • Myoglobinuria  +
    • Brain,function test, abnormal  +
    • Red blood cell, abnormal shape or volume  +
    • Abnormal blood chemistry NOS  +
    • Proteinuria  +
    • Template:ICD10 Guideline MRSA  + (z "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?)