Data Collector Portal: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
No edit summary
Line 58: Line 58:
  tables=_pageData
  tables=_pageData
  |fields=CONCAT("<li>[[",_pageName,"]]</li>")
  |fields=CONCAT("<li>[[",_pageName,"]]</li>")
  |where=_categories HOLDS "Site_Specific_Collection_Guide"
  |where=_categories HOLDS "Site_Specific_Collection_Guide" and not (_pageName like "Category:%")
  |limit=5000
  |limit=5000
  |default=none found
  |default=none found

Revision as of 21:19, 2020 May 5


Recent edits to pages with questions

  • Figured the last 7 days of pages with questions that have been edited would be manageable, but hey that's still tons! So, I arbitrarily limited them to 5 for now, but that seems arbitrary, too. Let's see further how we can make that more manageable.
  • SMW


  • Cargo


  • Categories
wiki page question Last modified LastEditor
Change of remaining location names from "our" names to EPR/Cognos names JALT - Is there anything here we want to do before SF? Or that still needs to be done at all? Ttenbergen 09:42, 2023 July 6 (CDT)
  • 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. --JMojica 16:33, 2022 February 2 (CST)
    • 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? Ttenbergen 13:44, 2022 February 8 (CST)
      • Julie and Tina discussed:
  • 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.
  • 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.
  • 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.
  • 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.
  • 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?
      • 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. Ttenbergen 16:56, 2022 March 23 (CDT)
        • agree. pass to lisa. --JMojica 15:27, 2022 June 8 (CDT)
  • 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 Lisa Kaita 12:23, 2022 August 24 (CDT)
    • Even though this is no longer an issue, we should keep the above 5 summary issues here for future reference. --JMojica 13:38, 2024 March 12 (CDT)
2024-03-12 6:38:18 PM JMojica
Hemothorax or hemopneumothorax, nontraumatic Just wondering whether this code could be combined with iatrogenic causes similar to the guideline for:

Guideline for Iatrogenic Pneumothorax

According to our general rule of not coding iatrogenic events as traumas, code an iatrogenic pneumothorax as


Iatrogenic, puncture or laceration, related to a procedure or surgery NOS

Plus the most appropriate of the following;

Pneumothorax, tension, nontraumatic

Pneumothorax, nontension, nontraumatic

Pneumothorax, nontraumatic, NOS

Thanks, Pamela Piche 08:55, 2024 March 19 (CDT)
2024-03-19 1:55:32 PM Pamela Piche
MediaWiki:Common.js ", post: " 2022-03-24 4:30:07 PM
Query cardiac arrest throughout admission JALT Review after 2023-09-15
  • Lisa flagged that, if we do this for Cardiac Arrest, we should really do it for other dxs as well. And if we did that, it could result in a lot of work since it would need to be mediated by Pagasa for now. So we decided to see where the SF implementation goes and review the definition of this check once we have a centralized tool where the data collector would not need to mediate this. Ttenbergen 15:43, 2023 July 13 (CDT)
2023-07-25 3:49:53 PM Lisa Kaita
Query check CCI CXR vs LOS
  • Just came across this... the started query includes additional dxs now, as per #CCI collect count each. Does the proposed accepted count make sense for all the dxs? Your validation table was for CXR. Ttenbergen 11:50, 2023 May 3 (CDT)
    • Did some checking on all 13 LAB Imaging from CCI picklist and found counts more than the LOS only in ECHO, AXR and CXR. Emailed Lisa and Pagasa March 14, 2024 to check if correct or not. Waiting for their feedbacks. In the email, I also propose another query (e.g. the counts per calendar day per patient must not be more than one) as alternative to the threshold limits LOS +- 3 STD shown below. --JMojica 10:55, 2024 March 18 (CDT)
      • That query is tighter and would therefore have more false positives. What does Lisa think about that? Ttenbergen 09:51, 2024 March 20 (CDT)
      • I made some limits per LOS group for CXR, AXR, ECHO and Blood gases and emailed the results to Tina and Lisa 3/25/2024 for discussion. ---JMojica 13:28, 2024 March 25 (CDT)
2024-03-25 6:28:32 PM JMojica

More...

Information for all collectors

Diagnoses
Procedures

Communication

Misc

Information for new collectors

Info about our program

Back office

Related articles

Related articles: