User:Ttenbergen: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older editNewer edit →
mNo edit summary
Line 2: Line 2:


== catchup ==
== catchup ==
09:57, 2019 October 24 (CDT)
12:57, 2019 October 30 (CDT)


== Testing to see if shows in recent changes ==
== Testing to see if shows in recent changes ==

Revision as of 12:57, 30 October 2019

catchup

12:57, 2019 October 30 (CDT)

Testing to see if shows in recent changes

"need collector input"

changing mediawiki appearance

Questions for Tina

  • current # of questions: 20
edit page question
edit PowerBI Data Model for CCMDB ER 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.
edit DSM Lab Extract
edit Overstay2 Screening Reports
  • According to the draft SOPs we are to provide communication of the results as below. Andrea Thiessen explained that they would want something like a list split by colour. Then people would start manually populating other documents with this. I should follow up to determine the details and possibly set up a better way.
  • 2025-07-03 TT emailed to Katherine Graham and Kathy Kwiatkowski how they will use it (include Andrea Thiessen)
edit Query check ACP Status Collection
  • add "date of first should be before last"
edit Overstay2 data processing and reporting in CFE
  • add functions/subs when I finalize this
edit Chronic Health Facility
edit Awaiting/delayed transfer to long-term care/PCH inside or outside of Winnipeg
  • I just saw this line, its probably been there for a while, but just thinking that in our definition of community living with support, in Pre acute living situation, we include assisted living, supportive housing, AIA, lennox bell, and 1010 Sinclair, we currently do not use this code for these dispo locations, should we include them or we should rethink this Lisa Kaita 21:24, 10 June 2025 (CDT)
    • I actually just don't understand what this means... is the full statement "This includes those living in a community facility with support and being panelled for PCH" or what? In any case, yes, judging by how often this comes up in a search, we should likely make a page for community facility with support and store the details there to be back-linkable if we mess with the concept anywhere. Possibly that should be a template:community facility with support instead or in addition, depending on the details we need. But have a look at the search link above and let's make sure we pick the right solution that can tie in to everywhere the concept is used. Ttenbergen 00:42, 11 June 2025 (CDT)
edit Link suspect visitAdmitDtTm mult to-from-home query
  • implement this
  • with L_Problems tie in
  • tell Pagasa it exists
edit Chronic Health Facility
  • review, that might need to be consolidated with this page as well.
edit Chronic Health Facility
  • These should be made consistent with [[Template:PCH Riverview Deer Lodge (DLC)]] 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)
  • that template does not exist or I can't find it Lisa Kaita 14:56, 25 June 2025 (CDT)
edit 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)
edit Query s tmp check combined Boarding Loc and TransferReadyDtTm
  • This doesn't catch duplicate Transfer Ready DtTm tmp entry for Boarding Loc on incompletes. That is probably fine since we don't use the incompletes, but it could be added the next time the check is worked on anyway.
edit Postal Code field
  • this is related to Minimal Data Set and when it's used... do we document this as a concept?
edit Chronic Health Facility
  • This issue raised a problem with medicine data recently, and we will review again if this needs to be coded more granular after all,
  • dicussed at JALT June 25, 2025 while Bojan would like this it is not possible to keep track of unit changes and not always easy to tell which unit they arrive from so leave a Riverview and Deer Lodge (DLC), with the exception of the PCH units in each facility.Lisa Kaita 14:52, 25 June 2025 (CDT)
edit Selkirk Mental Health Centre
  • I am unclear with these instructions, if indirect code as applicable? if we are using chronic care facility, like we do for Riverview and Deer Lodge (DLC), we have Riverview as an option for if they arrive as a direct or indirect, but now Deer Lodge (DLC) and Selkirk mental health are not an option, shouldn't we be treating these all the same? There is a question on the Chronic Health Facility Lisa Kaita 17:50, 16 June 2025 (CDT)
edit Overstay2 Screening Reports
  • The DPST SOP (live temp limited access, also see uploaded copy, might be outdated) says that we will provide a report or patient colours. The details need to still be worked out.
      • I need to work with Andrea and Katherine Graham on overall reporting, so please don't do a separate approach on this. Separate emails are awkward for them, I asked to do it like that for now because it's low effort on collector part and you said you are already overwhelmed by all the changes. Ttenbergen 12:12, 3 July 2025 (CDT)
  • If this remains in email form there may end up being a mailing list for this.

Once the final reports are figured out collectors may or may not be involved in providing these. Ttenbergen 00:11, 2 July 2025 (CDT)

    • As of July25,2025 collectors were advised they can stop sending the automatically generated emails to Andrea, so we have, TT removed this function Sept 5, 2025 Lisa Kaita 07:28, 6 September 2025 (CDT)
edit Postal Code field do we have a page for that to also include instructions about province etc. like we have for homeless...
edit Unique CFE module fill in
edit Community Nursing Home Location Helper flagging this because it's a close sibling to the idea of getting a listing of shelter PCs to cross check (or facilitate entering maybe? homeless status in Pre acute living situation field. See Community and Long Term Care Master List.
edit LAU Public Trustee I also used this field for FORM 21 but documented it in the Q column, should we take this out? I think there were a handful of these Lisa Kaita 07:27, 11 April 2025 (CDT)
edit Data definition for factor candidates for the Overstay2 project Integrate these better
edit Created TransferReady query Still need to import this into master CFE, the version I have right now is messed up. Here it is:
edit Re-analysis and generation of Overstay2 model still needs to be set up by Tina...
edit Geri Rehab this is one of the things we needed to discuss further, currently we capture RR5 as HSC_ward, but it is a combination of spinal cord rehab, NMSK rehab, amputation rehab, Riverview has stroke rehab, Deer Lodge (DLC) has Geri rehab, If we are capturing these rehab wards for CGH, SOGH and VGH should we not be capturing this for all dispo locations that are rehab? Lisa Kaita 13:11, 8 April 2025 (CDT)
edit High-Obs Wards Tina to add.
edit Chronic Health Facility We have discussed lately that we might want to become more nuanced about some chronic care locations (Deer Lodge (DLC) and Riverview). I have removed the details from the above linked fields and consolidated here. Once this page is cleaned up this discussion entry can be removed.

SMW stuff

full text search link https://ccmdb.kuality.ca/index.php?title=Special%3AAsk&q=%5B%5BCategory%3AICD10+Diagnosis%5D%5D%0D%0A%5B%5B%7E%7Epneumothorax%5D%5D&po=&eq=yes&p%5Bformat%5D=broadtable&sort_num=&order_num=ASC&p%5Blimit%5D=500&p%5Boffset%5D=&p%5Blink%5D=all&p%5Bsort%5D=&p%5Bheaders%5D=show&p%5Bmainlabel%5D=&p%5Bintro%5D=&p%5Boutro%5D=&p%5Bsearchlabel%5D=...+further+results&p%5Bdefault%5D=&p%5Bclass%5D=sortable+wikitable+smwtable&p%5Bsep%5D=&eq=yes

table side by side vs right justified

title 1
line | 1
title 2
line | 2

ReplaceText

Special:ReplaceText Can use regExps if you check use regular expressions such as [[Category: ?TISS76 ?]] to allow spaces or not.

job queue

http://ccmdb.kuality.ca/api.php?action=query&meta=siteinfo&siprop=statistics&format=jsonfm

Magic words

e.g. {{CURRENTYEAR}} to get : 2025 see https://www.mediawiki.org/wiki/Help:Magic_words

transcluding subheadings...

Doesn't work, sucks in whole article

wiki testing, syntax and tricks

Parser Functions

lowercase works so hopefully so do the others... http://en.wikipedia.org/wiki/Help:Parser_function

  • try this
  • no
  • 1
  • yes

Viki

As from Cindy Cicalese: Graph This Page

Transclusion vs Substitution

Transclusion is calling content from a page or template, substitution is copying it.

Testing collapsing

...test content...
Retrieved from "https://ccmdb.kuality.ca/index.php?title=User:Ttenbergen&oldid=140464"