User:Ttenbergen

• Also see: p:Tina Tenbergen

Testing to see if shows in recent changes

"need collector input"

changing mediawiki appearance

• See where all the mediawiki pages are editable: http://ccmdb.kuality.ca/index.php?uselang=qqx
• to edit them: go to http://ccmdb.kuality.ca/index.php?title=MediaWiki:<name listed above>

Questions for Tina

• current # of questions: 20

	Question	Modification date"Modification date" is a predefined property that corresponds to the date of the last modification of a subject and is provided by Semantic MediaWiki.
PowerBI Data Model for CCMDB	ER Delay and Overstay Need to make sure I do things this way and include this in the right pages, possibly Change from Service Location to Service, Boarding Loc and Transfer Ready DtTm tmp entry but a lot of other pages touch on this, so maybe it needs to be a template? It may not be consistent everywhere: 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.	12 December 2024 00:11:55
DSM Lab Extract	A possibility to change the current Chart entry to be the same with SH format (see #DSM Inclusion Criteria/ Process for reason why in details).	30 July 2025 16:32:23
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) 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)	6 September 2025 12:28:06
Postal Code field	do we have a page for that to also include instructions about province etc. like we have for homeless... I understand the sentiment in the following, but this should either be rules or not mentioned at all, or it will cause confusion, since it would be relevant specifically in the edge cases when it would fall apart. So it might be better to address the specific edge cases and make a rule and cross check where relevant. Where this bears on data use, we should make sure we define once what we will check for and how we adjudicate or interpret inconsistencies, like we did for homeless patients. Ttenbergen 16:10, 11 July 2025 (CDT) Relationship between Province, PHIN and Postal code When collecting Postal Code, PHIN number and Province, think about the relationship of this information when you are collecting it. if patient has a MB PHIN number, then Province code should be MB and the postal code should be for MB (MB postal codes start with an "R"). if Province code is not MB then the postal code should not be a MB postal code. Enter "not applicable" or the out of province postal code if available, and also, there should not be a PHIN number. CCMDB have pre_acute_living_situation field homeless with Postal Code, should the Postal code be ignored and replaced by N/A. Should the R_Province entry be affected by Postal Code N/A? --JMojica 10:54, 24 June 2025 (CDT) We are currently reviewing some of the definitions of homelessness. It is possible that details will change as outcome from that. The concept has been broadened to include some ambiguous states and terminology changed to houselessness. Next meeting later this week about that. I don't expect that it would change instructions of how to code Postal Code; so, it makes sense to me to update vetted data for postal code to "N/A" if the Pre acute living situation is "homeless". Also, we have discussed whether it would be better to do this as an actual change in data, or as an logical change by function or encoded data in the Data Meaning Layer. Julie, you already do some other things in that layer to re-write data, if I interpret your SAS code correctly. Ttenbergen 17:11, 18 July 2025 (CDT) once this settles we should ensure we have Data Integrity Checks to flag entries like that (related: Community and Long Term Care Master List) Data definition for factor candidates for the Overstay2 project#??? is updated accordingly this is related to Minimal Data Set and when it's used... do we document this as a concept?	11 August 2025 14:48:50
Chronic Health Facility	review, that might need to be consolidated with this page as well. Discussed this at JALT Meeting - Rolling Agenda and Minutes 2025#JALT 2025-03-11 but I don't remember if we came to an answer or next step. Just found a note to add that we will also need to decide if any of these are in-patient locations. This would make them collectable as Pre-admit Inpatient Institution, and is relevant as per Pre-admit Inpatient Institution field#Data Use / Purpose. are you referring to PCH's because they are not inpt locations or are you referring to chronic health facilities? Lisa Kaita 14:52, 25 June 2025 (CDT) 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) 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. Discussed at Task Team Meeting - Rolling Agenda and Minutes 2025#CHF4 Task Team Meeting - Rolling Agenda and Minutes 2025#CHF3 JALT Meeting - Rolling Agenda and Minutes 2025#CHF2 Task Team Meeting - Rolling Agenda and Minutes 2025#CHF1 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)	6 August 2025 05:02:14
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)	11 June 2025 05:43:19
Overstay2 data processing and reporting in CFE	Nothing yet, fill in as it becomes available. add functions/subs when I finalize this	23 February 2025 22:13:18
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)	15 November 2024 18:12:47
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.	27 June 2025 14:08:32
Re-analysis and generation of Overstay2 model	still needs to be set up by Tina... Still needs: considerations values we considered and rejected minimize duplication of Data definition for factor candidates for the Overstay2 project, things that users of the data need to know going forward need to live there, decisions taken that don't affect ongoing process should be documented here. When I looked at your code that breaks out Location / living arrangement into groupings and measures it seemed to me that it was mixing up data cleaning and validation with measure definition and it might be good to keep those separate. Cleaning and validation should apply to the data in general, not just this model, no? It would make sense to document the steps taken and things found and remedies implemented on this page, but having them part of the definition seems problematic. I think I sent that as an email, but I think it would be better to track this on the wiki to have a trail for the decisions. Ttenbergen 12:03, 25 June 2025 (CDT) leaving these here as examples how to link to the definitions on Data definition for factor candidates for the Overstay2 project. The currently used definition should live there, but changes and reasons should probably live here. We can change that format, talk to me if needed. Ttenbergen 11:35, 25 June 2025 (CDT)	12 August 2025 20:43:59
Query check ACP Status Collection	add "date of first should be before last"	30 July 2025 16:55:28
Link_suspect_visitAdmitDtTm_mult_to-from-home query	implement this with L_Problems tie in tell Pagasa it exists	23 July 2025 04:15:01
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) I agree we should treat them the same. Also, there is now Eden Mental Health Centre in Winkler, which is listed together with Selkirk on the File:GRA ALC Form.pdf; we should likely treat it the same as well. Ttenbergen 22:30, 25 June 2025 (CDT)	23 July 2025 19:13:07
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)	3 May 2025 05:39:57
Data definition for factor candidates for the Overstay2 project	Integrate these better re pre admit for outside Winnipeg facility discussion, change from getting from Previous Location only to getting it from both Previous Location and Pre-admit Inpatient Institution; this was missed before because we based the initial fields on the last overstay project, and back then these two fields were still combined re-institute amputation; before we were only looking at the CCI code, but we should consider Past history, loss of limb(s) as well	31 July 2025 14:29:57
Created TransferReady query	Still need to import this into master CFE, the version I have right now is messed up. Here it is:	22 November 2024 06:08:24
High-Obs Wards	Tina to add.	20 March 2025 17:17:20
_Unique_CFE module	fill in	30 June 2025 16:57:40
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.	18 July 2025 22:35:02
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)	30 July 2025 16:33:58

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

• Transclusion of an article: {{:articlename}}
• emailing lists: email the CC data collectors (see also p:Category:Critical Care Data Collectors)
• sorted table: see Drugs Collected
• file/UNC linking doesn't work because browsers disallow it as unsafe
• comments in wiki articles that won't show in normal view, only edit:
  • <!-- This is a comment, too -->
• table generator: File:Wiki_Tables.xls, originally from here

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.

• http://www.mediawiki.org/wiki/Transclusion - e.g. {{templatename}}
• http://www.mediawiki.org/wiki/Manual:Substitution - e.g. {{subst:templatename}}

Testing collapsing

...test content...