New pages

30 September 2025

• 11:2911: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

• 21:1921: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...")
• 14:2114: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...")
• 00:4800:48, 26 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")

25 September 2025

• 10:5910:59, 25 September 2025 Intended1stSrvc (hist | edit) [8,160 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:...")

10 September 2025

• 22:1122:11, 10 September 2025 Error "The database cannot be opened because ..." (hist | edit) [1,278 bytes] Ttenbergen (talk | contribs) (Created page with "{{Bug needing input|}} Triplet of errors. === Error 1 === '''The database cannot be opened because the VBA project contained in it cannot be read. The database can be opened only if the VBA project is first deleted. Deleting the VBA project removes all code from modules, forms and reports. You should back up your database before attempting to open the database and delete the VBA project.''' To create a backup copy, click cancel and then make a backup copy of your data...")

8 September 2025

• 16:0916:09, 8 September 2025 Team Meeting Sept 24, 2025 (hist | edit) [769 bytes] Lkaita (talk | contribs) (Created page with "1. '''Call to Order''' 2. '''Action Plans''' 3. '''Business Arising''' 4. '''New Business''' * vacant positions * Program update- We are still looking at a new platform for the program. Brandon ICU (prairie mountain health) has approved a .6 collector position. * Overstay2- 5. '''Round Table Items''' SBGH - GGH- HSC- 6 '''Date of Next Meeting: ''' == Related articles == {{Related Articles}} Category:2025 Data Collection Team Meetings")

4 September 2025

• 20:4920:49, 4 September 2025 HSC B2B (hist | edit) [556 bytes] Lkaita (talk | contribs) (Created page with "{{Collection Location | Collection StartDate = Sept 15, 2025 | Collection EndDate = | Collection Program = Medicine | Collection Hospital = HSC | Collection Service Type = CTU | Collection Service Type Legacy = No | Collection Bed Nrs = 6 | Collection Unit Phone = | Collection Unit Fax = | Collection Unit Manager = | Collection Unit Manager Phone = | Collection Unit Clerk = }} == Location profile == * This is the Kidney Transplant Unit, which was formerly on H7...")

22 August 2025

• 15:0815:08, 22 August 2025 Outlook EXO Roll-out (hist | edit) [912 bytes] Ttenbergen (talk | contribs) (Created page with "SH is about to replace our on-premises exchange server (used by Outlook email and calendar) with a cloud solution. == Related articles == {{Related Articles}} Category:IT Support Category:Laptop Category:MS Office")
• 14:3714:37, 22 August 2025 Windows 11 (hist | edit) [904 bytes] Ttenbergen (talk | contribs) (Created page with "As of summer 2025, Windows 11 is being rolled out across SH in a staged deployment. * [https://home.sharedhealthmb.ca/shared-services/administrative-services/digital-health/windows-11-upgrade/ Shared Health User Information about the roll-out] * [https://home.sharedhealthmb.ca/files/windows-11-faq.pdf FAQ] SH are also planning to roll out Outlook EXO Roll-out soon, and we are doing O365 Testing in preparation for rolling that out, so we should try to work throu...")
• 14:2614:26, 22 August 2025 O365 Testing (hist | edit) [2,228 bytes] Ttenbergen (talk | contribs) (Created page with "Support for our current Microsoft Office Version is ending in Oct 2025 so we are testing O365 which will eventually replace it. == Checklist == === CCMDB === * plain running our DB in the new version * any Macro security issues * VBA libraries we include and whether they will need to be brought to a new version * DB connectivity, we use VBA to reconnect front and back end and to send * Sending * Outlook email tie ins: email buttons and also the Cognos import === C...")

14 August 2025

• 12:1912:19, 14 August 2025 Data Semantics (hist | edit) [545 bytes] Ttenbergen (talk | contribs) (Created page with "Data Semantics refers to the meaning, interpretation, and relationships of data fields to the real-world concepts they represent. In our database, this includes how fields like biographic changes or places of care evolve over time, interact with each other, or challenge intuitive assumptions. See * Category:Data Semantics for pages addressing these concepts * Data Meaning Layer for a more integrated way in which CCMDB could approach this Category:Data Sem...")
• 12:1512:15, 14 August 2025 Collection of locations on the spectrum between home and PCH (hist | edit) [2,084 bytes] Ttenbergen (talk | contribs) (Created page with "{{Todo | who = Tina | todo_added = 2025-08-14 | todo_action = 2025-08-14 | question = Need to flesh this out more before sending as part of invite. * We collect pre-admit; we could collect previous and dispo. * If we want this granular we need to get collectors access to data, eg eHCR, long term care access tracker, ? * How would we want to use this? It's relevant for flow or patient complexity metrics }} Category:Data Semantics Category:Reporting C...")

13 August 2025

• 21:3821:38, 13 August 2025 Query Check VADT too close to first boarding loc (hist | edit) [1,704 bytes] Ttenbergen (talk | contribs) (Created page with "{{DISPLAYTITLE:Query Check_VADT_too_close_to_first_boarding_loc}} {{Data Integrity Check |DIC_summary= |DIC_related_concepts=Visit Admit DtTm field; Boarding Loc |DIC_firmness=soft check |DIC_coding=Query Check_VADT_too_close_to_first_boarding_loc |DIC_implementation_date= |DIC_status= |DIC_app=CCMDB.accdb |DIC_backlogged=No }} {{DL| {{DJ| We discussed this in our after-Task meeting 2023-07-23 and I just stumbled across it. I do not remember what this was about, nor wh...")
• 21:3221:32, 13 August 2025 Query Check from ED and prev location same site (hist | edit) [976 bytes] Ttenbergen (talk | contribs) (Created page with "{{DISPLAYTITLE:Query Check_from_ED_and_prev_location_same_site}} {{Data Integrity Check |DIC_summary= |DIC_related_concepts= |DIC_firmness=soft check |DIC_coding=Query Check_from_ED_and_prev_location_same_site |DIC_implementation_date= |DIC_status= |DIC_app=CCMDB.accdb |DIC_backlogged=No }} also see Query check_tmp_ER_Boarding_Loc_should_exist_if_from_ER The converse is not true, exceptions: * a patient could board in ER after admission, e.g. GRA ICU uses their E...")

7 August 2025

• 11:4611:46, 7 August 2025 Typing in the dx tab no longer expands to the full dx in Windows 11 (hist | edit) [464 bytes] Ttenbergen (talk | contribs) (Created page with "{{Bug needing input|}} H3 laptop updated automatically about a week ago; type recognition for diagnosis tab; works in the CCI tab I have a hunch this is related to the Microsoft Office version. For one of the affected and one of the unaffected laptops, could you follow the instructions in and update Microsoft Office version#Verified Version (that way we have it for future reference). ==Log== * 2025-08-07 - Reported by Lisa Category:CCMDB.accdb")

30 July 2025

• 14:5914:59, 30 July 2025 Patients who appear to transfer from in-patient situation to Emergency Room (hist | edit) [2,772 bytes] Ttenbergen (talk | contribs) (Created page with "Tmp.")

24 July 2025

• 17:4617:46, 24 July 2025 Query check tmp Overstay2 (hist | edit) [674 bytes] Ttenbergen (talk | contribs) (Created page with "{{DISPLAYTITLE:Query check_tmp_Overstay2}} {{Data Integrity Check |DIC_summary=Not yet filled in |DIC_related_concepts=Project Overstay2; Site; Admit DtTm; and more |DIC_firmness=hard check |DIC_timing=complete |DIC_coding=query ''check_tmp_Overstay2'' |DIC_status=needs review |DIC_app=CCMDB.accdb |DIC_backlogged=No }} Cross-checks for Project Overstay2. early notes must be for both dpst and colour entries == Consistency Checks == * must have an entry to send * dt...")

23 July 2025

• 22:1022:10, 23 July 2025 Deer Lodge (DLC) (hist | edit) [450 bytes] Ttenbergen (talk | contribs) (Created page with "Deer Lodge is a Chronic Health Facility with some Personal Care Home-type units. This is mostly a landing page for its related pages so that every mention of it will link from #Related articles. == Related articles == {{Related Articles}} Category:Pre-acute living situation Category:Admit/Discharge Category:Registry Data Category:Data Collection Guide")
• 16:2916:29, 23 July 2025 Restoring a "known good" version of the centralized data pair (hist | edit) [854 bytes] Ttenbergen (talk | contribs) (Created page with "Centralized_data.accdb and / or PHI.mdb occasionally get corrupted, usually during sending. This leads to the data processor following the instructions in Re-sending data, which may include this step. There could be other causes. == Steps == * restore Centralized_data.accdb ** Go to the backups Centralized ( S:\WRHA\WRHA_CCMED\Backup\Centralized_data ), Copy the cleaned centralized data before it gets corrupted ** Paste to the ( R:\ICU_DATA_CO...")

20 July 2025

• 01:0801:08, 20 July 2025 Query check tmp AHC (hist | edit) [1,237 bytes] Ttenbergen (talk | contribs) (Created page with "{{Data Integrity Check |DIC_summary=For patients with Previous Location ER at same site there should be a Boarding Loc ER. |DIC_related_concepts=Project AHC; Site; SentDtTm; Admit_DtTm; Dispo_DtTm |DIC_firmness=hard check |DIC_coding=query ''check_tmp_AHC'' |DIC_implementation_date= |DIC_status= |DIC_app=CCMDB.accdb |DIC_backlogged= }} Cross-checks for Project AHC. == Consistency Checks == * dttms within admission * dttms must be chronological for groupin...")

18 July 2025

• 18:0218:02, 18 July 2025 Data Meaning Layer (hist | edit) [8,674 bytes] Ttenbergen (talk | contribs) (Created page with "This page introduces the concept of the Data Meaning Layer, a shared framework for defining, tracking, and communicating the meaning of data elements and metrics in CCMDB. It serves as a central reference point for how we manage evolving definitions, support consistent interpretation, and connect meaning across tools like Access/SQL, SAS, Power BI, and the wiki. == The Problem == * We have a complex legacy dataset that has had significant data encoding changes over time...")
• 17:3917:39, 18 July 2025 Acute Care Location Master List Change Mailing List (hist | edit) [788 bytes] Ttenbergen (talk | contribs) (Created page with "Shared Health maintains data of all acute care locations to the bed level. They have a mailing list that is used for change management for this list: if anything is going to be added or removed, an email goes out to subscribers defining the change and when test data will be available. Tina and Kym are on this list because it helps us find out about potential changes before our collectors encounter them and then can't enter data. Also see [[List of Community Facilities]...")
• 17:2517:25, 18 July 2025 Community and Long Term Care Master List (hist | edit) [1,138 bytes] Ttenbergen (talk | contribs) (Created page with "Stub to index the functionalities that would use the addresses and/or postal codes and/or category of facility that correspond to a postal code, a Pre acute living situation, or a Dispo. == Use cases == * Community Nursing Home Location Helper - to cross-check Pre acute living situation against Postal code of a PCH (correctly entered, likely only soft check) * homeless / Postal Code field#Data integrity for homeless patients - to cross-...")