New pages

16 December 2025

• 11:5011:50, 16 December 2025 Tweaking the Interface to Fit the Work (hist | edit) [4,224 bytes] Ttenbergen (talk | contribs) (Created page with "Collectors spend hours a day inside CCMDB.accdb. Small interface friction adds up fast. The interface is not sacred. It is allowed to be shaped to fit the work. This page describes how to safely tweak the interface, how to tell whether a tweak is “just for you” or might help others, and how to coordinate rolling a good change back into the shared version so it doesn’t get wiped. == Why you might want to tweak the interface == Typical reasons: * Reducing scrol...")
• 11:4911:49, 16 December 2025 Do you want to save changes (hist | edit) [874 bytes] Ttenbergen (talk | contribs) (Created page with "Sometimes when you close something in Access (eg. a form in CCMDB.accdb you get a message "Do you want to save changes to the design of ...", listing the type of Access object (eg. table, form...) and its name next. * Almost always: click "No", close out of the program and restart. Or, to be certain, consider Copying down a clean version of CCMDB.accdb ** a part of CCMDB was somehow changed and Access is asking if you want to make it permanent. This is almost a...")

27 November 2025

• 18:3718:37, 27 November 2025 Collection of data on homelessness (hist | edit) [4,183 bytes] Ttenbergen (talk | contribs) (Created page with "This is an index and change explainer for the collection of data on homelessness. == Problems with the way we currently collect this == Homelessness was considered as part of Data definition for factor candidates for the Overstay2 project, including a definition of how we would derive it from collected data. == Current data == * Pre acute living situation field * Project NonTradLoc * Postal Code field * Pre acute living situation field - has spec...")
• 17:3717:37, 27 November 2025 Transfer for bed management (hist | edit) [3,056 bytes] Ttenbergen (talk | contribs) (Created page with "{{ICD10 dx | ICD10 Code=Z75.3 | StartDate=2025-11-28 }} {{ICD10 category|Misc}} {{ICD10 category|Healthcare contact}} == Additional Info == * This is to distinguish transfers for bed management reasons (e.g. to clear a bed from the sending unit so it can admit a patient), as opposed to transfers for medical reasons (e.g. patient transferred from Grace ICU to MICU because she needs dialysis) * It should be coded as: ** An Acquired Diagnosis from a collection unit th...")
• 16:4516:45, 27 November 2025 Medicine records (hist | edit) [78 bytes] Ttenbergen (talk | contribs) (Redirected page to Definition of a Medicine Program Admission) Tag: New redirect
• 16:4516:45, 27 November 2025 Critical Care records (hist | edit) [83 bytes] Ttenbergen (talk | contribs) (Redirected page to Definition of a Critical Care Program Admission) Tag: New redirect
• 16:4416:44, 27 November 2025 Service tmp post-send consistency checks (hist | edit) [954 bytes] Ttenbergen (talk | contribs) (Created page with "{{Data Integrity Check |DIC_summary=Service tmp entry consistency across records |DIC_related_concepts=Service tmp entry |DIC_firmness=soft check |DIC_coding= |DIC_implementation_date= |DIC_status= |DIC_app= |DIC_backlogged= }} == Medicine records == For Medicine records, ... {{DJ | * As discussed at JALT Meeting - Rolling Agenda and Minutes 2025#JALT 2025-11-27: Do we need any post-send, cross-record checks relating to Service tmp entry? ~~~~ }}...")

18 November 2025

• 12:2612:26, 18 November 2025 New unit or service encountered during Cognos data import (hist | edit) [305 bytes] Ttenbergen (talk | contribs) (Redirected page to Https://ccmdb.kuality.ca/index.php?title=Cognos data import#Newly encountered units or services) Tag: New redirect

10 November 2025

• 13:4913:49, 10 November 2025 Project NonTradLoc (hist | edit) [3,158 bytes] Ttenbergen (talk | contribs) (Created page with "{{Project |ProjectActive=planned |ProjectRequestor=internal |ProjectCollectionStartDate= |ProjectCollectionStopDate= |Project={{PAGENAME}} }} {{Discuss| This is not live yet, start date not set, just keeping notes here for now. }} Collection of data to help decision of how we will improve Collection of locations on the spectrum between home and PCH. We know that there are Dispo locations that are sort of between what we traditionally think of as "home" and...")
• 10:5510:55, 10 November 2025 Trusted Locations (hist | edit) [87 bytes] Ttenbergen (talk | contribs) (Redirected page to Managing Trusted Locations to enable VBA in our Microsoft Access programs) Tag: New redirect
• 10:5510:55, 10 November 2025 Managing Trusted Locations to enable VBA in our Microsoft Access programs (hist | edit) [1,380 bytes] Ttenbergen (talk | contribs) (Created page with "Over time Microsoft and eHealth and Shared Health and Digital Health etc have tightened the default settings to prevent harmful macros from running. We use macros, and the following enables running them, but only for files in specific directories. == Instructions == * open one of our Microsoft Access programs * click on '''file''' (top left corner), '''options''' * '''If this error is preventing you from accessing the options menu, close the program. Open Access from th...")

30 October 2025

• 13:4513:45, 30 October 2025 HSC Virtual Ward (hist | edit) [5,462 bytes] Ttenbergen (talk | contribs) (Created page with "The {{PAGENAME}} is an internal medicine service where hospital physicians follow patients who are sent home with special supports. For now this is just a placeholder / link anchor for this, decisions around collection are not 100% clear. Even if we don't collect the actual records, we need to decide how we will code patients who come from or go there: * Pre-admit Inpatient Institution are these in-patients for the purpose of * Previous Location / * Dispo...")

29 October 2025

• 14:4014:40, 29 October 2025 St.Amant (hist | edit) [2,796 bytes] Ttenbergen (talk | contribs) (Created page with "[https://stamant.ca/about-us/ St.Amant] supports over 5,000 people in Manitoba with developmental disabilities, autism and acquired brain injury. They provide a variety of services, but in the context of our data collection we are usually considering their [https://stamant.ca/services/adult-seniors/residential/community-residential-program/ community residential program]. {{Discussion | * Is that actually true, that we use the code for patients in one of their reside...")
• 14:3914:39, 29 October 2025 St. Amant (hist | edit) [143 bytes] Ttenbergen (talk | contribs) (Redirected page to St.Amant) Tag: New redirect
• 08:3908:39, 29 October 2025 Panelling (hist | edit) [40 bytes] Ttenbergen (talk | contribs) (Created page with "spelling re-direct Category:Paneling")
• 08:3808:38, 29 October 2025 Paneling (hist | edit) [2,311 bytes] Ttenbergen (talk | contribs) (Created page with "Paneling is the process of getting permission to send a patient to PCH (roughly speaking). The concept is relevant because the process causes delays in discharging patients who are otherwise medically ready for discharge (e.g. have a Transfer Ready DtTm). We don't collect paneling directly, but we do collect some adjacent points we have used to tag patients being paneled in our data. * Pre acute living situation.loc_type != PCH S pre acute living situatio...")

28 October 2025

• 08:4708:47, 28 October 2025 2025-10-28,9 SMWCon Notes (hist | edit) [309 bytes] Ttenbergen (talk | contribs) (Created page with "“Spinach wikidata bot” mentioned by Yaron Mediawiki chatbots Hubot integration framework Teams setup not pleasant experience Azure bot services, application, framework, sounds like horrible experience Mediawiki AI Chatbot Glossary like lingo RAG system Ionos AI hub, Microsoft openAI hub Chunking size")

23 October 2025

• 23:0923:09, 23 October 2025 Setting up a new CCMDB Data Integrity Check (hist | edit) [1,479 bytes] Ttenbergen (talk | contribs) (Created page with "This page gives some very basic starting points of how to set up new CCMDB.accdb Data Integrity Checks. Soft checks are checks that flag a possible error but still allow the collector to send. Category: Data Integrity Checks")
• 22:5522:55, 23 October 2025 Separation of date and time fields (hist | edit) [677 bytes] Ttenbergen (talk | contribs) (Created page with "This page explains why we encode date and time in separate fields for some values. == Reasons == * our legacy PDA data collection tool implemented date and time as two separate fields * there are more convenient user interface elements in MS Access to enter the two separately * they can easily be combined during analysis == values affected == * L_Log.Start Date field / Start Date field / Start Date and Time * L TmpV2.obsdate and obstime * L Tmp...")
• 22:2622:26, 23 October 2025 Dropdown-like user experience for tmp projects (hist | edit) [2,223 bytes] Ttenbergen (talk | contribs) (Created page with "This page explains how to set up a new tmp project that works like a dropdown or selection box. The Entity–attribute–value model of the L Tmp V2 table provides a mechanism to store temporary data. It always stores a '''project''' and an '''item''', and can store other data types as well as detailed in L_TmpV2 table. The generic GUI in Patient Viewer Tab Tmp implements the project and item fields as drop-downs, where en...")
• 16:1516:15, 23 October 2025 Sub add automatic tmp entries (hist | edit) [794 bytes] Ttenbergen (talk | contribs) (Created page with "{{DISPLAYTITLE:Sub add_automatic_tmp_entries}}Sub in _Unique_CCMDB module that handles Automatic Generation of TMP entries in the L TmpV2 table to facilitate Tmp Project Collection of data under the Entity–attribute–value model of the L Tmp V2 table. Category:CCMDB.accdb Category:Tmp Project Infrastructure")
• 15:4815:48, 23 October 2025 Temporary data collection (hist | edit) [1,516 bytes] Ttenbergen (talk | contribs) (Created page with "When the data we collect continuously (see Auto Data Dictionary) doesn't include information of interest, the Critical Care and Medicine Database has a flexible method of quickly adding additional values required for a period of time. For examples of data like this, see Projects. Depending on complexity, capacity and collection effort we can usually set up the collection of such data within a week or two. To request collection of additional data, fill out a ...")
• 14:4214:42, 23 October 2025 Decubitus ulcer collection summary (hist | edit) [1,887 bytes] Ttenbergen (talk | contribs) (Created page with "We collect data about decubitus ulcers (pressure ulcers, pressure injuries, pressure sores, bed sores) because they are iatrogenic hospital-acquired complications associated with preventable harm, poor patient outcomes, and are key indicators of quality and safety in clinical care. We collect Comorbid Diagnosis, Admit Diagnosis and Acquired Diagnosis / Complication as the following ICD10 Diagnoses; see the links for definitions...")

17 October 2025

• 16:1416:14, 17 October 2025 Checklist when changing or adding a variable or tmp project (hist | edit) [1,695 bytes] Ttenbergen (talk | contribs) (Created page with "Setting up a new tmp project * ")

30 September 2025

• 10:2910:29, 30 September 2025 Avg n dx types per laptop (hist | edit) [762 bytes] Ttenbergen (talk | contribs) (Created page with "Ad-hoc query to get the average number of Dx Types per D_ID across laptops. We wouldn't expect this to be a perfect match, and some differences between sites and certainly between programs would be expected, but large differences might point to collection differences. Discussed with Lisa, documenting query here for future use. SELECT Left([l_Log].[D_ID],2) AS lt, L_Log.D_ID, Sum(IIf([Dx_Type]="comorbid",1,0)) AS como, Sum(IIf([dx_type]="admit",1,0)) AS adm, Sum(II...")

26 September 2025

• 20:1920:19, 26 September 2025 S dispo.meanLOS3STD (hist | edit) [1,396 bytes] Ttenbergen (talk | contribs) (Created page with "{{Data element |field_name=program |in_table=s_dispo table |data_type= |datafield_length= |program_collecting=Med and CC |created_raw=Raw |data_element_start_date=2016-07-01 <!-- maybe? --> |data_element_sort_index=17 |element_description=mean LOS plus 3*STD for the location used by Function long LOS() for soft-check on long LOS admissions. }} {{DISPLAYTITLE:s_dispo.meanLOS3STD}} == Use == See Function long LOS() for how the values are used. === Values...")
• 13:2113:21, 26 September 2025 Change Explainer Pages (hist | edit) [911 bytes] Ttenbergen (talk | contribs) (Created page with "As part of Communication for the CCMDB on this wiki we usually put details about changes we make on the pages that describe the thing we are changing. Sometimes a change affects multiple concepts, and we need a place to integrate the information. When that happens we create change explainer pages that provide the timing and implications of changes, and then only link to those pages from the individual concept pages. The pages can be found in :category:Change expl...")

25 September 2025

• 23:4823:48, 25 September 2025 "Teams Chat" button (hist | edit) [402 bytes] Ttenbergen (talk | contribs) (Created page with "Click on the {{PAGENAME}} on the Main Form (CCMDB.accdb) to start a chat with the CCMDB Team in Microsoft Teams. Actually, it generates a "CCMDB Teams Chat" shortcut on your desktop and launches it, so alternatively you can launch the chat from that shortcut after initial use. == Related articles == {{Related Articles}} Category:CCMDB.accdb Category:Main Form Category:Forms")
• 09:5909:59, 25 September 2025 Intended1stSrvc (hist | edit) [7,877 bytes] Ttenbergen (talk | contribs) (Created page with "{{Project |ProjectActive=proposed |ProjectProgram=CC |ProjectRequestor= |ProjectCollectionStartDate= |Project={{PAGENAME}} }} == Data Collection Instructions == This is a project that tracks (tags) any ICU patients' that technically '''would have been''' under the care of one ICU but ended up under the care of another. This is a case of both '''borrowed''' bed and service. Use tmp fields: * Project: {{PAGENAME}} <!-- leave this, it resolves to page name --> * Item:...")