All public logs
Jump to navigation
Jump to search
Combined display of all available logs of CCMDB Wiki. You can narrow down the view by selecting a log type, the username (case-sensitive), or the affected page (also case-sensitive).
- 12:46, 2024 April 25 Ttenbergen talk contribs created page Template:ICD10 Hypothermia (broke out for consistency)
- 16:47, 2024 April 24 Ttenbergen talk contribs moved page Query check CCI imaging count vs LOS to Query check CCI each count vs LOS without leaving a redirect
- 15:58, 2024 April 24 Ttenbergen talk contribs created page Template:CCIPick ByCode (Created page with "<noinclude> This template resolves a CCI Picklist code to "CCI page name (dx code)" To use: ::<nowiki>{{</nowiki> {{PAGENAME}} |the code}}</pre> Category:CCI wiki infrastructure ---- </noinclude>{{#ask: [[Has CCI Picklist Code::{{{1}}}]]}} ({{{1}}})")
- 15:00, 2024 April 24 Ttenbergen talk contribs moved page Query check CCI CXR vs LOS to Query check CCI imaging count vs LOS without leaving a redirect (Text replacement - "Query check CCI CXR vs LOS" to "Query check_CCI_imaging_count_vs_LOS")
- 13:15, 2024 April 24 Ttenbergen talk contribs deleted page Myocardial infarction, acute (AMI), transmural (Q-wave) (content was: "#REDIRECT Myocardial infarction (STEMI), acute (AMI), transmural (Q-wave)", and the only contributor was "Lkaita" (talk))
- 21:59, 2024 April 23 Ttenbergen talk contribs deleted page Drawio:Test tool (content was: "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAI8AAACiCAYAAAB4UZ57AAAHYXRFWHRteGZpbGUAJTNDbXhmaWxlJTIwaG9zdCUzRCUyMmVtYmVkLmRpYWdyYW1zLm5ldCUyMiUyMG1vZGlmaWVkJTNEJTIyMjAyNC0wNC0yNFQwMiUzQTQ1JTNBNDMuMTUzWiUyMiUyMGFnZW50JTNEJTIyTW96aWxsYSUyRjUuMCUyMChXaW5kb3dzJTIwTlQlMjAxMC4wJTNCJTIwV2luNjQlM0IlMjB4NjQlM0IlMjBydiUzQTEyNC4wKSUyMEdlY2tvJTJGMjAxMDAxMDElMjBGaXJlZm94JTJGMTI0...", and the only contributor was "Ttenbergen" (talk))
- 21:45, 2024 April 23 Ttenbergen talk contribs created page Drawio:Test tool (Created page with "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAI8AAACiCAYAAAB4UZ57AAAHYXRFWHRteGZpbGUAJTNDbXhmaWxlJTIwaG9zdCUzRCUyMmVtYmVkLmRpYWdyYW1zLm5ldCUyMiUyMG1vZGlmaWVkJTNEJTIyMjAyNC0wNC0yNFQwMiUzQTQ1JTNBNDMuMTUzWiUyMiUyMGFnZW50JTNEJTIyTW96aWxsYSUyRjUuMCUyMChXaW5kb3dzJTIwTlQlMjAxMC4wJTNCJTIwV2luNjQlM0IlMjB4NjQlM0IlMjBydiUzQTEyNC4wKSUyMEdlY2tvJTJGMjAxMDAxMDElMjBGaXJlZm94JTJGMTI0LjAlMjIlMjB2ZXJzaW9uJTNEJTIyMjQuMi44JTIyJTIwZXRhZyUzRCUyMkdXZHMxZHM5SkFiR1ZLT00zenJHJTIyJTIwdHlwZSUzRCUyM...")
- 11:26, 2024 April 8 Ttenbergen talk contribs created page OIT Report (Redirected page to Critical Care Program Quality Indicator Report) Tag: New redirect
- 21:29, 2024 March 29 Ttenbergen talk contribs deleted page Urine Output field (field is gone and nothing links to it.)
- 11:09, 2024 March 21 Ttenbergen talk contribs created page Category:ANCA-associated Vasculitis (AAV) (Created page with "Category:ICD10 Diagnosis Category:Vasculitis")
- 12:37, 2024 January 24 Ttenbergen talk contribs created page Details U of M needs to know to consider Database solution for us (Created page with "This is an index for content relevant to the U of M IT team in proposing a solution for hosting our database. * 15-20 users on laptops * system of intermittently linked MS Access databases with a fair bit of automation * facilitated interfaces with Shared Health systems (we request and receive data in files that we import as either temporary or permanent data) * Approximately 1.1GB (core) + 200MB (PHI) + (1.2+0.36GB) (Labs) + est 500MB assorted legacy data * CCMDB_D...")
- 12:23, 2024 January 15 Ttenbergen talk contribs created page Culling backups (Created page with "We will only keep backups from major change versions long term. == push/pull backup culling == Only the last month of backups generated by Pull down centralized data.vbs and Push up centralized data.vbs should only be kept, so about once a month records older than one month should be deleted from: * \\ad.wrha.mb.ca\wrha\HSC\shared\WRHA\WRHA_CCMED\Backup\PHI (do phi first, it's faster) * \\ad.wrha.mb.ca\wrha\HSC\shared\WRHA\WRHA_CCMED\Backup\Centralized_data (th...")
- 22:01, 2024 January 2 Ttenbergen talk contribs recreated the Cargo table ICD10_Dx
- 21:35, 2024 January 2 Ttenbergen talk contribs recreated the Cargo table ICD10_Category
- 21:33, 2024 January 2 Ttenbergen talk contribs recreated the Cargo table Discussions
- 21:32, 2024 January 2 Ttenbergen talk contribs recreated the Cargo table CollectionLocation
- 20:44, 2024 January 2 Ttenbergen talk contribs recreated the Cargo table ToDo
- 20:44, 2024 January 2 Ttenbergen talk contribs recreated the Cargo table TISS_Items
- 20:44, 2024 January 2 Ttenbergen talk contribs recreated the Cargo table Reports
- 20:44, 2024 January 2 Ttenbergen talk contribs recreated the Cargo table Publications
- 20:44, 2024 January 2 Ttenbergen talk contribs recreated the Cargo table Indicators
- 20:44, 2024 January 2 Ttenbergen talk contribs recreated the Cargo table ICD10_Dx
- 20:44, 2024 January 2 Ttenbergen talk contribs recreated the Cargo table ICD10_Category
- 20:44, 2024 January 2 Ttenbergen talk contribs recreated the Cargo table Drugs_Included
- 20:44, 2024 January 2 Ttenbergen talk contribs recreated the Cargo table Discussions
- 20:44, 2024 January 2 Ttenbergen talk contribs recreated the Cargo table Data_Element
- 20:44, 2024 January 2 Ttenbergen talk contribs recreated the Cargo table DataIntegrityChecks
- 20:44, 2024 January 2 Ttenbergen talk contribs recreated the Cargo table CollectionLocation
- 20:39, 2024 January 2 Ttenbergen talk contribs recreated the Cargo table _ganttData
- 20:39, 2024 January 2 Ttenbergen talk contribs recreated the Cargo table _bpmnData
- 20:39, 2024 January 2 Ttenbergen talk contribs recreated the Cargo table _fileData
- 20:38, 2024 January 2 Ttenbergen talk contribs created the Cargo table foreign_keys
- 20:38, 2024 January 2 Ttenbergen talk contribs deleted the Cargo table foreign_keys
- 12:55, 2024 January 1 Ttenbergen talk contribs created page Category:Change to having each collector collect both programs on the same laptop (Created page with "Pages related to Change to having each collector collect both programs on the same laptop.")
- 12:14, 2024 January 1 Ttenbergen talk contribs created page CCMDB.accdb Change Log 2024 (Created page with "__NOTOC__ <!-- This hides the table of contents so collectors can immediately see the most recent change without scrolling. --> See Log (disambiguation) for other uses of the term "Log". See the Development Documentation Category for other development logs''. See Rolling out changes for the process of rolling out changes. See also '''requested CCMDB changes for the next version''' and '''CCMDB.accdb Data Integrity...")
- 11:47, 2024 January 1 Ttenbergen talk contribs created page Task Team Meeting - Rolling Agenda and Minutes 2024 (Created page with "__NOTOC__ == List of items to bring to task meeting == Add to this by adding the following '''to the article where the problem is documented''': <pre>{{DiscussTask | explanation}}</pre> {{#cargo_query: tables=Discussions, _pageData |join on=Discussions._pageName=_pageData._pageName |fields=Discussions._pageName=wiki page, question, _modificationDate=Last modified |where=_pageData._pageName<>"MediaWiki:Common.js" and who="Task" |limit=1000 |rows per page=200 |default=...")
- 11:29, 2024 January 1 Ttenbergen talk contribs created page JALT Meeting - Rolling Agenda and Minutes 2024 (Created page with "__NOTOC__ == List of items to bring to JALT meeting == Add to this by adding the following '''to the article where the problem is documented''': <pre>{{DiscussTask | JALT * <question details>}}</pre> (this will bring it to Task if not addressed at JALT) or <pre>{{Discuss | JALT * <question details>}}</pre> (this will not bring it to Task) {{#cargo_query: tables=Discussions, _pageData |join on=Discussions._pageName=_pageData._pageName |fields=Discussions._pageNam...")
- 10:54, 2023 December 13 Ttenbergen talk contribs created page HSC Stepdown Units (Created page with "*HSC has 3 stepdown units, A3 stepdown, A5 stepdown and D3 stepdown * Previous Location would be HSC_<stepdown unit> *As of December 2023 the A5 stepdown (8 beds) has expanded their capacity permanently to include the HSC ward location GB5B (4 beds) for a total of 12 beds. Note: internal medicine patients sometime overflow to these beds on B5B so check service to determine if it is an overflow patient, patients coming from or discharged to B5B should use HSC_A5S st...")
- 11:26, 2023 November 25 Ttenbergen talk contribs moved page Query check CCI TISS Errors CAM positive vs Dx to Query check CCI TISS CAM positive vs Dx without leaving a redirect
- 11:25, 2023 November 25 Ttenbergen talk contribs deleted page Query check TISS Errors CAM positive vs Dx (content was: "#REDIRECT Query check CCI TISS Errors CAM positive vs Dx", and the only contributor was "Ttenbergen" (talk))
- 11:25, 2023 November 25 Ttenbergen talk contribs moved page Query check TISS Errors CAM positive vs Dx to Query check CCI TISS Errors CAM positive vs Dx
- 11:24, 2023 November 25 Ttenbergen talk contribs moved page Query TISS Errors CAM positive vs Dx to Query check TISS Errors CAM positive vs Dx without leaving a redirect
- 11:20, 2023 November 25 Ttenbergen talk contribs moved page Query check CCI Picklist no admin entries to Query check CCI Picklist if no admin entries without leaving a redirect (consistency)
- 11:54, 2023 November 3 Ttenbergen talk contribs created page Function admission program(Pat ID) (Created page with "Function admission program(Pat ID) returns the program that an admission ID is part of. This used to be provided by Settings (CCMBD.mdb), but that was per-laptop, and Change to having each collector collect both programs on the same laptop meant that we needed to have a per-admission based program definition. == Related articles == {{Related Articles}} Category:CCMDB.accdb")
- 11:54, 2023 November 3 Ttenbergen talk contribs created page Query admission program (Created page with "Query admission_program provides the program for each Pat_ID based on the Service/Location's value for program in S dispo table. == Related articles == {{Related Articles}} Category:CCMDB.accdb")
- 13:21, 2023 November 1 Ttenbergen talk contribs changed group membership for Blezak from CCMDB_legit to CCMDB_legit, administrator, bureaucrat, suppressor, administrator (Semantic MediaWiki), curator (Semantic MediaWiki) and editor (Semantic MediaWiki)
- 13:20, 2023 November 1 Ttenbergen talk contribs changed group membership for Lkaita from CCMDB_legit to CCMDB_legit, administrator, interface administrator, bureaucrat, suppressor, administrator (Semantic MediaWiki), curator (Semantic MediaWiki) and editor (Semantic MediaWiki)
- 16:07, 2023 September 27 Ttenbergen talk contribs deleted page CFE log (unlinked redirect)
- 15:55, 2023 September 27 Ttenbergen talk contribs deleted page ECHMO (unlinked redirect)
- 11:19, 2023 August 2 Ttenbergen talk contribs created page Change to having each collector collect both programs on the same laptop (Created page with "== Collector instructions == yet to come == Implementation == === News and backup === === CCMDB.accdb === Start by passing a parameter to the program as a command line switch from the starter icon. /cmd c:\ccmdb_data\ccmdb_data_m.mdb It can then be read from VBA using Command(). ==== Paths not taken ==== {{Collapsable | always=collecting programs in same Access DB | full= * This would require major changes to cross checks, form hiding and other places, and since w...")
- 11:34, 2023 July 27 Ttenbergen talk contribs moved page Heart, coronary arteries, diagnostic imaging, abnormal to Heart and/or coronary arteries, diagnostic imaging, abnormal without leaving a redirect (remove ambiguity if this includes heart muscle)
- 12:03, 2023 July 12 Ttenbergen talk contribs created page Query cardiac arrest throughout admission (Created page with "{{Data Integrity Check | DIC_summary = | DIC_firmness = hard check | DIC_timing = | DIC_app = | DIC_coding = | DIC_status = | DIC_implementation_date = }} Any admission with Service tmp entry "SBGH Cardiac / Cardiac Surgery" Or "SBGH Critical Care / Cardiac Surgery" must have exactly one EuroSCORE II entry. If this ever changes, consider also Query s_tmp_ABO_TEE_checks == Definition == For any patient who * is admitted to the Medicine program and...")
- 10:55, 2023 July 12 Ttenbergen talk contribs created page Query s tmp EuroSCORE II checks (Created page with "{{Data Integrity Check | DIC_summary = Each of the three ABO TEE project entries must have one entry and the float_var must be between 0 and 1 if RecordStatus is complete | DIC_related_concepts = EuroSCORE II; Service/Location field | DIC_firmness = hard check | DIC_timing = complete | DIC_app = CCMDB.accdb | DIC_coding = query ''s_tmp_EuroSCORE_II_checks'' | DIC_status = implemented | DIC_implementation_date = 2023-07-12 }} Any admission with Service tmp entry...")
- 11:39, 2023 July 6 Ttenbergen talk contribs moved page Project Legacy HSC CCU Location to Project Legacy HSC CCU Loc without leaving a redirect (too long for field)
- 11:28, 2023 July 6 Ttenbergen talk contribs moved page Project Legacy Filter H B to Project Legacy HSC CCU Location without leaving a redirect (name as suggested by Julie)
- 11:14, 2023 July 6 Ttenbergen talk contribs created page Project Legacy Filter H B (Created page with "{{Project|}}")
- 11:14, 2023 July 6 Ttenbergen talk contribs created page Project Legacy Co-managed (Created page with "{{Project|}}")
- 09:53, 2023 July 6 Ttenbergen talk contribs created page Adding a new ICD10 code (Created page with "This page describes the process and considerations when adding a new ICD10 code. == Considerations before adding == * Is is a Non-standard ICD10 Diagnoses, and if so would it be part of any of one of the following, or others lot listed here yet: ** Charlson Comorbidities in ICD10 codes ** APACHE Comorbidities in ICD10 codes ** APACHE Acute Dxs in ICD10 codes == Adding to s_ICD10 table == * add line with new code * set active_start to date when cha...")
- 15:28, 2023 June 28 Ttenbergen talk contribs created page EuroSCORE II (Created page with "{{Project |ProjectActive=planned |ProjectProgram=CC |ProjectRequestor=Dr. Rizwan Manji |ProjectCollectionStartDate=2023-06-03 |ProjectCollectionStopDate= |Project={{PAGENAME}} }} The EuroSCORE is a risk stratification system used by cardiac surgeons. See The [http://www.euroscore.org/ EuroScore Website] for more information. We will collect this for all patients... {{Discuss | What are the inclusion criteria? ~~~~}} == Data Collection Instructions == === How to enter...")
- 10:47, 2023 June 27 Ttenbergen talk contribs deleted page Atrial Ablation (made sure the term was included on the relevant CCI code Destruction)
- 10:45, 2023 June 27 Ttenbergen talk contribs deleted page MAZE procedure (made sure the term was included on the relevant CCI code Destruction)
- 15:24, 2023 June 8 Ttenbergen talk contribs created page Template:Benzodiazepines (Created page with "<noinclude>template to ensure same list is used in multiple ICD10 pages. </noinclude>*Alprazolam (Xanax®) *Clobazam (Onfi®, Sympazan®) *Clonazepam (Klonopin® *Clorazepate (Tranxene®) *Diazepam (Diastat®, Valium®, Valtoco®) *Estazolam (ProSom®) *Flurazepam (Dalmane) *Lorazepam (Ativan®, Loreev®) *Midazolam (Nayzilam®, Seizalam®, Versed®) *Oxazepam (Serax®) *Quazepam (Doral®) *Remimazolam (Byfavo®) *Temazepam (Restoril®) *Triazolam (Halcion®)")
- 16:35, 2023 May 31 Ttenbergen talk contribs created page Category:SL tables (Created page with "{{DISPLAYTITLE:sL tables}} Category:Data structure")
- 16:34, 2023 May 31 Ttenbergen talk contribs created page SL AaDO2 table (Created page with "{{DISPLAYTITLE:sL_AaDO2 table}} <onlyinclude>'''{{PAGENAME}}''' is an administrative-only, temporary table in CCMDB_data.mdb. It contains data generated by the ABG Helper button.</onlyinclude> == Data Structure == {| class="wikitable" |- ! Field Name !! Data Type !! Length |- | HospitalMRN || String|| 255 |- | Service || String|| 255 |- | Service_StartDtTm || date || |- | Service_EndDtTm || date || |} == Related articles == {{Related Articles}} Categor...")
- 16:34, 2023 May 31 Ttenbergen talk contribs created page SL BPs table (Created page with "{{DISPLAYTITLE:sL_BPs table}}<onlyinclude>'''{{PAGENAME}}''' is an administrative-only, temporary table in CCMDB_data.mdb. It contains data generated by the ABG Helper button process. </onlyinclude> == Data Structure == {| class="wikitable" |- ! Field Name !! Data Type !! Length !! Description |- | BP_ID || String|| 255 || |- | Pat_ID || String|| 255 || |- | DBP || long || || corresponds to AP Dias BP Field |- | SBP || long || || corresponds to AP Sys...")
- 14:43, 2023 May 24 Ttenbergen talk contribs created page Soft checks (Created page with "Some of our cross checks are implemented as "soft checks", where the collector can still send data even if a check is triggered. These are for scenarios where a trigger usually means that something went wrong, but there are scenarios where the entry is actually correct. == When multiple soft checks trigger, only one will be visible == One of the problems with our current implementation is that, if there is more than one triggered soft check, only one will be visible. T...")
- 10:57, 2023 May 18 Ttenbergen talk contribs deleted page File:Link tester.svg (was a test upload)
- 10:37, 2023 May 18 Ttenbergen talk contribs uploaded a new version of File:Link tester.svg
- 10:31, 2023 May 18 Ttenbergen talk contribs uploaded a new version of File:Link tester.svg
- 10:19, 2023 May 18 Ttenbergen talk contribs uploaded a new version of File:Link tester.svg
- 10:19, 2023 May 18 Ttenbergen talk contribs created page User:Ttenbergen/svg testing (Created page with "* https://ccmdb.kuality.ca/index.php?title=Quality_Assurance * Quality_Assurance 300px")
- 10:18, 2023 May 18 Ttenbergen talk contribs created page File:Link tester.svg
- 10:18, 2023 May 18 Ttenbergen talk contribs uploaded File:Link tester.svg
- 17:27, 2023 May 17 Ttenbergen talk contribs deleted page Importing data into MS Access (Not linked to anything, and there is no reason to document this.)
- 17:26, 2023 May 17 Ttenbergen talk contribs deleted page Validating Data Importing (nope it won't)
- 16:12, 2023 May 17 Ttenbergen talk contribs deleted page S Priorities (evil twin of S Priorities table)
- 16:08, 2023 May 17 Ttenbergen talk contribs moved page S Tmp to S tmp table over a redirect without leaving a redirect
- 16:08, 2023 May 17 Ttenbergen talk contribs deleted redirect S tmp table by overwriting (Deleted to make way for move from "S Tmp")
- 12:34, 2023 May 16 Ttenbergen talk contribs created page Template:ICD10 CAR-T Details (Created page with "<noinclude>Template to make sure the same info is used in two places. </noinclude> *A type of treatment in which a patient's T cells (a type of immune system cell) are changed in the laboratory so they will attack cancer cells. T cells are taken from a patient’s blood. Then the gene for a special receptor that binds to a certain protein on the patient’s cancer cells is added to the T cells in the laboratory. The special receptor is called a chimeric antigen receptor...")
- 13:22, 2023 May 9 Ttenbergen talk contribs created page S Standard emails table (Created page with "The '''S_Standard_emails table''' in Centralized_data.mdb contains the standard text for emails that the Data processor sends out as part of Vetting. == Data Structure == {| class="wikitable sortable" |- !| field !| type !| description |- || '''subject''' || short text || subject line for the automated email |- || '''body''' || long text || body for the automated email |} == Related articles == {{Related Articles}} Category: Data structure")
- 13:19, 2023 May 9 Ttenbergen talk contribs created page S Priorities table (Created page with "The '''s_priorities table''' in CCMDB.accdb contains numbers between 0 and 20, and 0.5; this is used to populate priority dropdowns. == Data Structure == {| class="wikitable sortable" |- !| field !| type !| description |- || '''d''' || date_time || dates between 1930-01-01 and 2029-12-31 |} == Related articles == {{Related Articles}} Category: Data structure")
- 13:16, 2023 May 9 Ttenbergen talk contribs created page Dates table (Created page with "The '''s_dates table''' in Centralized_data_front_end.accdb contains all dates between 1930-01-01 and 2029-12-31; this is used to populate dropdowns. == Data Structure == {| class="wikitable sortable" |- !| field !| type !| description |- || '''d''' || date_time || dates between 1930-01-01 and 2029-12-31 |} == Related articles == {{Related Articles}} Category: Data structure Category: PatientFollow Project")
- 13:10, 2023 May 9 Ttenbergen talk contribs moved page S RecordStatus to S RecordStatus table without leaving a redirect (consistency for table pages)
- 12:36, 2023 May 9 Ttenbergen talk contribs created page Strange data structures in CCMDB (Created page with "Some portions of CCMDB don't really fit into the * Entity–attribute–value model of the L Tmp V2 table * Charlson Comorbidity scoring in ICD10 codes * APACHE Acute Diagnoses * APACHE Comorbid Diagnoses == Related articles == {{Related Articles}} Category:Data Use")
- 13:45, 2023 May 4 Ttenbergen talk contribs deleted page Drug-induced immunosuppression (no longer in dataset)
- 12:02, 2023 May 4 Ttenbergen talk contribs deleted page FinalCheck field (no longer in dataset)
- 12:01, 2023 May 4 Ttenbergen talk contribs deleted page ApLab Complete (no longer in dataset)
- 12:00, 2023 May 4 Ttenbergen talk contribs deleted page Room nr (no longer in dataset)
- 11:50, 2023 May 4 Ttenbergen talk contribs deleted page EPR Admit DtTm field (no longer in dataset)
- 11:50, 2023 May 4 Ttenbergen talk contribs deleted page EPR Admit DtTm (no longer in dataset)
- 11:48, 2023 May 4 Ttenbergen talk contribs deleted page Pharm Flow Complete (no longer in dataset)
- 10:34, 2023 April 27 Ttenbergen talk contribs moved page Query S CCI Categories sort missing to Query s CCI Categories sort missing without leaving a redirect
- 10:29, 2023 April 27 Ttenbergen talk contribs moved page S CCI Categories sort missing to Query S CCI Categories sort missing without leaving a redirect
- 10:29, 2023 April 27 Ttenbergen talk contribs created page S CCI Categories sort table (Created page with "The '''s_CCI_Categories_sort''' in CCMDB.accdb contains a list of CCI categories drawn from s_CCI_Categories table. It is used as part of Re-importing CCI and IDC10 categories from wiki to CCMDB.accdb. == Data Structure == {| class="wikitable sortable" |- !| field !| type !| description |- || '''category''' || Text (50) || category as from s_CCI_Categories table |- || '''sortOrder''' || single || sort order |} == Related articles == {{Related Articles}...")
- 10:28, 2023 April 27 Ttenbergen talk contribs created page S CCI Categories sort missing (Created page with "The '''s_CCI_Categories_sort''' in CCMDB.accdb contains a list of CCI categories drawn from s_CCI_Categories table. It is used as part of Re-importing CCI and IDC10 categories from wiki to CCMDB.accdb. == Data Structure == {| class="wikitable sortable" |- !| field !| type !| description |- || '''category''' || Text (50) || category as from s_CCI_Categories table |- || '''sortOrder''' || single || sort order |} == Related articles == {{Related Articles}...")
- 17:47, 2023 April 19 Ttenbergen talk contribs created page Entity Relationship Diagram for the Critical Care and Medicine Database (Created page with "{{#display_diagram:Mermaid:Test_w_explicit}} == Implementation == This is generated using [https://www.mediawiki.org/wiki/Flex_Diagrams mediawiki extension Flex Diagrams]. The diagram is encoded at Mermaid:Test w explicit. == Related articles == {{Related Articles}}")
- 17:08, 2023 April 19 Ttenbergen talk contribs deleted page Category:Created Variables Common table (see Category:Created Variables Common table)
- 16:58, 2023 April 19 Ttenbergen talk contribs deleted page Created Variables Common maker query (see Created Variables Common maker 2021 query)
- 16:56, 2023 April 19 Ttenbergen talk contribs deleted page Created Variables Common table (see Created Variables Common 2021 table)
- 15:54, 2023 April 19 Ttenbergen talk contribs deleted page Created Variables CC table (see Created Variables CC 2021 table)
- 15:47, 2023 April 19 Ttenbergen talk contribs created page Category:Created Variables Common 2021 table (Created page with "Articles related to the Created_Variables_Common_2021 table. Category:Data structure Category:Centralized_data_front_end.accdb Category:Created Variables")
- 15:47, 2023 April 19 Ttenbergen talk contribs created page Category:Created Variables 2021 (Created page with "Pages related to the concept of "Created Variables" in CFE. Category:Data Use Category:Data structure")
- 15:46, 2023 April 19 Ttenbergen talk contribs deleted page Category:Created Variables CC table (see Category:Created Variables CC 2021 table)
- 15:42, 2023 April 19 Ttenbergen talk contribs deleted page Created Variables CC maker query (replaced by Created Variables Common maker 2021 query)
- 15:12, 2023 April 19 Ttenbergen talk contribs created page Category:Created Variables CC 2021 table (Created page with "Pages about the Created_Variables_CC 2021 table and its contents. Category:Centralized data front end.accdb Category:Data structure Category:Created Variables")
- 09:49, 2023 April 19 Ttenbergen talk contribs created page Calc created variables button (Created page with "The '''Calc created variables''' button on the main page of Centralized data front end.accdb runs Created Variables CC maker 2021 query and Created Variables Common maker 2021 query. == Related articles == {{Related Articles}} Category:Centralized data front end.accdb Category:Data Processing Category:Statistical Analysis")
- 14:44, 2023 April 12 Ttenbergen talk contribs created page User:Ttenbergen/Flex Diagram testing (Created page with "Trying to output results of a Cargo query to Flex Diagrams. === Set of Cargo queries === {{#cargo_query: tables=foreign_keys |fields= CONCAT(foreign_key_table,"[", foreign_key_table," table] -->{{!}}\"",foreign_key_field," to #8734; ", primary_key_field, "\"{{!}} ", primary_key_table) |delimiter=<br> }} {{#cargo_query: tables=foreign_keys |fields=CONCAT("click ", foreign_key_table, " \"https://ccmdb.kuality.ca/index.php?title=", foreign_key_table, "\" \"open table pa...")
- 14:37, 2023 April 12 Ttenbergen talk contribs created page Mermaid:Test w explicit (Created page with "%% Test to run w Template:ER Mermaid graph LR L_Log[L_Log table] s_dispo[s_dispo table] -->|"dispo_ID to #8734; Dispo"| L_Log s_dispo[s_dispo table] -->|"dispo_ID to #8734; Pre-admit Inpatient Institution"| L_Log s_dispo[s_dispo table] -->|"dispo_ID to #8734; Previous Location"| L_Log click s_dispo "https://ccmdb.kuality.ca/index.php?title=s_dispo" "open table page" click L_Log "https://ccmdb.kuality.ca/index.php?title=L_Log" "open table page"")
- 14:36, 2023 April 12 Ttenbergen talk contribs created page Mermaid:Test w Cargo (Created page with "{{#cargo_query: tables=foreign_keys |fields= CONCAT(foreign_key_table,"[", foreign_key_table," table] -->{{!}}\"",foreign_key_field," to #8734; ", primary_key_field, "\"{{!}} ", primary_key_table) |delimiter=<br> }} {{#cargo_query: tables=foreign_keys |fields=CONCAT("click ", foreign_key_table, " \"https://ccmdb.kuality.ca/index.php?title=", foreign_key_table, "\" \"open table page\"<br>") |group by=foreign_key_table |delimiter= }} {{#cargo_query: tables=foreign_keys |...")
- 14:35, 2023 April 12 Ttenbergen talk contribs moved page Mermaid:Test to Mermaid:Test w template without leaving a redirect
- 14:33, 2023 April 12 Ttenbergen talk contribs created page Template:ER Mermaid (Created page with "s_dispo[s_dispo table] -->|"dispo_ID to #8734; Dispo"| L_Log")
- 14:18, 2023 April 12 Ttenbergen talk contribs recreated the Cargo table foreign_keys
- 12:26, 2023 April 12 Ttenbergen talk contribs created page Drawio:Test (Created page with "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAANMAAAEFCAYAAAB5F9JfAAAJvnRFWHRteGZpbGUAJTNDbXhmaWxlJTIwaG9zdCUzRCUyMmVtYmVkLmRpYWdyYW1zLm5ldCUyMiUyMG1vZGlmaWVkJTNEJTIyMjAyMy0wNC0xMlQxNyUzQTI2JTNBMzEuMDQ4WiUyMiUyMGFnZW50JTNEJTIyTW96aWxsYSUyRjUuMCUyMChXaW5kb3dzJTIwTlQlMjAxMC4wJTNCJTIwV2luNjQlM0IlMjB4NjQlM0IlMjBydiUzQTEwOS4wKSUyMEdlY2tvJTJGMjAxMDAxMDElMjBGaXJlZm94JTJGMTExLjAlMjIlMjB2ZXJzaW9uJTNEJTIyMjEuMS43JTIyJTIwZXRhZyUzRCUyMnpEcFAwd3VwbHMxWENpQ0J0RmU5JTIyJTIwdHlwZSUzRCUyM...")
- 12:25, 2023 April 12 Ttenbergen talk contribs created page Mermaid:Test (Created page with "graph LR A[Square Rect] -- Link text --> B((Circle)) A --> C(Round Rect) B --> D{Rhombus} C --> D")
- 12:20, 2023 April 12 Ttenbergen talk contribs recreated the Cargo table foreign_keys
- 12:17, 2023 April 12 Ttenbergen talk contribs created the Cargo table foreign_keys
- 12:11, 2023 April 12 Ttenbergen talk contribs created page Category:Data structure wiki infrastructure (Created page with "Pages that encode the data structure of our database.")
- 12:10, 2023 April 12 Ttenbergen talk contribs created page Template:Foreign key (Created page with "<noinclude>This template tags L-tables and S-tables that have foreign keys to other tables. An example would be the L CCI Component table with respect to the L_Log table. To use: {<nowiki>{</nowiki>Foreign key | foreign_key_table=table page | foreign_key_field=field name | primary_key_table=table name | primary_key_field=field name <nowiki>}</nowiki>} ===Cargo declaration=== {{#cargo_declare: _table = foreign_keys | foreign_key_table=page | f...")
- 11:56, 2023 April 12 Ttenbergen talk contribs created page BPMN:Test (Created page with "<?xml version="1.0" encoding="UTF-8"?> <bpmn:definitions xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:bpmn="http://www.omg.org/spec/BPMN/20100524/MODEL" xmlns:bpmndi="http://www.omg.org/spec/BPMN/20100524/DI" xmlns:dc="http://www.omg.org/spec/DD/20100524/DC" xmlns:di="http://www.omg.org/spec/DD/20100524/DI" id="Definitions_1" targetNamespace="http://bpmn.io/schema/bpmn"> <bpmn:process id="Process_1" isExecutable="false"> <bpmn:startEvent id="StartEve...")
- 16:34, 2023 April 11 Ttenbergen talk contribs deleted page VIKI (extension is defunct, see Mediawiki extension Network)
- 21:22, 2023 April 5 Ttenbergen talk contribs deleted page Backup Checker.vbs (deleted file after confirming with Pagasa that it has not been used in a long time)
- 21:16, 2023 April 5 Ttenbergen talk contribs moved page Transfusion of FFP to Transfusion of plasma products without leaving a redirect (not FFP any more)
- 21:01, 2023 April 5 Ttenbergen talk contribs created page Template:ICD10 Guideline congenital blindness (Created page with "<noinclude> Template to make sure congenital blindness is coded consistently. Category:ICD10 wiki infrastructure ---- </noinclude> === Congenital Blindness === Congenital blindness can occur due to actual eye problems or due to problems with the visual nerves or brain. Thus, for this relatively rare entity, code Combined ICD10 codes of Blindness, both eyes (or if appropriate Blindness, one eye) and Malformation/disorder NOS, congenital. }}")
- 20:29, 2023 April 5 Ttenbergen talk contribs deleted page File:MED Master Data Collection LOG.pdf (Form that is no longer used and not relevant do continuing data.)
- 15:28, 2023 March 16 Ttenbergen talk contribs created page Template:ICD10 Secondary infections of aspiration (duplication of this content on Pneumonia, ventilator-associated (VAP) and Aspiration pneumonitis)
- 10:05, 2023 March 8 Ttenbergen talk contribs created page Mermaid bug example (Created page with "This page demos strange behaviour of mermaid links on mediawiki. It has been posted as a bug in [https://github.com/knsv/mermaid/issues/844#issuecomment-498946915 Bug report to Mermaid base code]. == Strange behaviour of Mermaid links == When given a page name as input to the "click" command, the mermaid extension doesn't use the base URL of the wiki correctly, it simply uses the domain name. This means that the index.php part is missing and the link doesn't work. {{#...")
- 10:52, 2023 March 1 Ttenbergen talk contribs moved page Primary Biliary Cirrhosis (PBC) to Primary Biliary Cholangitis (PBC) without leaving a redirect (Text replacement - "Primary Biliary Cirrhosis (PBC)" to "Primary Biliary Cholangitis (PBC)")
- 11:27, 2023 February 22 Ttenbergen talk contribs deleted page File:Screen settings.png (not used, old)
- 11:25, 2023 February 22 Ttenbergen talk contribs deleted page File:Construc.gif (not used)
- 11:25, 2023 February 22 Ttenbergen talk contribs deleted page File:March 5.13 TISS28 FINAL changes Yellow.pdf (not used)
- 11:23, 2023 February 22 Ttenbergen talk contribs deleted page File:Edit vacation.png (not used)
- 11:23, 2023 February 22 Ttenbergen talk contribs deleted page File:Thumbsup.gif (not used)
- 11:21, 2023 February 22 Ttenbergen talk contribs deleted page File:CCMDB door.pdf (unused)
- 17:41, 2023 February 15 Ttenbergen talk contribs created page Query check CCI no admin entries (Created page with "This query was split in two: * Query check_CCI_Picklist_no_admin_entries * Query check_CCI_Component_no_admin_entries")
- 17:38, 2023 February 15 Ttenbergen talk contribs created page Query pre ICD10 Charlson score (Created page with "Query L_ICD10_Charlson_score in Centralized data front end.accdb is part of Charlson Comorbidity scoring in ICD10 codes. Its counterpart is Query L_ICD10_Charlson_score. == Related articles == {{Related Articles}} Category:Charlson Comorbid Diagnosis")
- 12:28, 2023 February 8 Ttenbergen talk contribs created page Query check CCI Component no admin entries (Created page with "{{Data Integrity Check | DIC_summary = There must be no No procedure entered/Blank procedure entry in CCI Component. | DIC_related_concepts = CCI Component; No procedure entered; Blank procedure entry | DIC_firmness = hard check | DIC_timing = complete | DIC_app = CCMDB.accdb | DIC_coding = query ''check_CCI_Component_if_no_admin_entries'' | DIC_status = implemented | DIC_implementation_date = 2018-10-14 }} == Log == * 2023-02-08 - broke original query in t...")
- 12:24, 2023 February 8 Ttenbergen talk contribs moved page Query check CCI no admin entries to Query check CCI Picklist no admin entries without leaving a redirect (split in two)
- 10:59, 2023 February 2 Ttenbergen talk contribs created page Query s como (Created page with "Query ''s_como'' in Centralized data front end.accdb is part of Charlson Comorbidity scoring in pre-ICD10 codes, where it provides the subset of s_AllDiagnoses table that contributes to the Charlson score. == Related articles == {{Related Articles}} Category:Charlson Comorbid Diagnosis")
- 10:53, 2023 February 2 Ttenbergen talk contribs created page Query Charlson Score pre and ICD10 (Created page with "{{PAGENAME}} is part of the Charlson Comorbidity Index, where it combines the scores derived from our pre-ICD10 and ICD10 Comorbid diagnoses. == Related articles == {{Related Articles}} Category:Charlson Comorbid Diagnosis")
- 10:51, 2023 February 2 Ttenbergen talk contribs deleted page Charlson Comorbid Score query (see query Charlson_Score_pre_and_ICD10)
- 16:30, 2023 February 1 Ttenbergen talk contribs created page Charlson Comorbidity scoring in pre-ICD10 codes (Created page with "This page explains how the actual Charlson Comorbidity Index is derived from the pre-IDC10 dx codes need to link. === Short version === To get the Charlson comorbid points for a patient, use query pre_ICD10_Charlson_Score === Long version === Points are not included in the listings because the score depends on the combination of diagnoses. For example, if a patient has two diagnoses from the same Charlson component, they are only counted once. Also, if a pa...")
- 16:23, 2023 February 1 Ttenbergen talk contribs moved page S charlson dxs to S charlson dxs table without leaving a redirect (consistency for table pages)
- 15:35, 2023 February 1 Ttenbergen talk contribs created page Query L ICD10 Charlson score (Created page with "{{PAGENAME}} in Centralized data front end.accdb is part of Charlson Comorbidity scoring in ICD10 codes. == Related articles == {{Related Articles}} Category:Charlson Comorbid Diagnosis")
- 14:53, 2023 February 1 Ttenbergen talk contribs deleted page Query s ICD10 Charlson score (query doesn't exist, see query s_ICD10_Charlson_Comorbids for likely angelic twin)
- 16:16, 2023 January 26 Ttenbergen talk contribs deleted page Database utilization status report (evil twin of Data Request Status ICU/Med)
- 10:56, 2023 January 26 Ttenbergen talk contribs created page Occupancy For Bed Held (Created page with "{{Reporting Indicators | description = Actual extra hours occupying a bed per day for each patient with bed held from Dispo DtTm to BedHeldEnd DtTm | indicator_name = {{PAGENAME}} | created_raw = Created | program = Critical Care and Medicine | indicator_start_date = 2023-01-01 | indicator_end_date = }} ===QI domain=== *Timely *Efficient ==Significance== A bed that is held is empty and could contain a patient. ==Sampling Plan / Procedure== **If bed held dat...")
- 14:24, 2023 January 25 Ttenbergen talk contribs moved page DtTm for Frist Boarding Loc and First Service to DtTm for First Boarding Loc and First Service without leaving a redirect (typo)
- 14:14, 2023 January 25 Ttenbergen talk contribs deleted page Template:First Service and Boarding Loc same (moved to DtTm for Frist Boarding Loc and First Service)
- 13:15, 2023 January 25 Ttenbergen talk contribs created page DtTm for Frist Boarding Loc and First Service (Created page with "Work in progress to replace Template:First Service and Boarding Loc same ~~~~ ---- When data is first entered as per Using Cognos2 to keep track of patients, the Service tmp entry is entered as in the Cognos2 data. This is so the data can be compared to new entries in CSS and CE. Once the patient is discharged for a given record, the first Boarding Loc DtTm to be consistent with the first Service tmp entry; see . This is because we do...")
- 11:53, 2023 January 25 Ttenbergen talk contribs created page CCI Picklist tab is slow (Created page with "{{Bug needing input}} There have been reports of the Patient Viewer Tab CCI Pick being slow to switch to, at least on HSC laptops. == Log === * I just downloaded H8 to replicate this, and it is fast for me both on patients with and without records in picklist. I might not be looking at the right thing, could someone please add detailed steps to replicate what is slow? Thanks! ~~~~")
- 10:45, 2023 January 11 Ttenbergen talk contribs created page Query check tmp BedHeld (Created page with "{{Data Integrity Check |DIC_summary=Validates that the DtTm for the first Service tmp entry is the same as that for the first Boarding Loc entry |DIC_related_concepts=BedHeldEnd DtTm; Dispo DtTm |DIC_firmness=hard check |DIC_timing=complete |DIC_coding= query ''XXXXX'' |DIC_implementation_date= |DIC_status= |DIC_app=CCMDB.accdb }} Required checks as per Julie: # for AMA AWOL or procedure, bed held end dttm must always be after dispo dttm. # if bed held end dt...")
- 11:35, 2023 January 4 Ttenbergen talk contribs created page Task Team Meeting - Rolling Agenda and Minutes 2023 (Created page with "__NOTOC__ == List of items to bring to task meeting == Add to this by adding the following '''to the article where the problem is documented''': <pre>{{DiscussTask | explanation}}</pre> {{#cargo_query: tables=Discussions, _pageData |join on=Discussions._pageName=_pageData._pageName |fields=Discussions._pageName=wiki page, question, _modificationDate=Last modified |where=_pageData._pageName<>"MediaWiki:Common.js" and who="Task" |limit=1000 |rows per page=200 |default=...")
- 11:31, 2023 January 4 Ttenbergen talk contribs created page Centralized data front end.accdb Change Log 2023 (Created page with "__NOTOC__ <!-- This hides the table of contents so collectors can immediately see the most recent change without scrolling. --> ''see the Development Documentation Category for other development logs'' This article is the change log for Centralized data front end.accdb. Also see Centralized data front end.accdb Change Request and CFE Data Integrity Checks. == Log == === 2022-12-08 === not rolled out yet User:Ttenb...")
- 11:24, 2023 January 4 Ttenbergen talk contribs created page JALT Meeting - Rolling Agenda and Minutes 2023 (Created page with "__NOTOC__ == List of items to bring to JALT meeting == Add to this by adding the following '''to the article where the problem is documented''': <pre>{{DiscussTask | JALT * <question details>}}</pre> (this will bring it to Task if not addressed at JALT) or <pre>{{Discuss | JALT * <question details>}}</pre> (this will not bring it to Task) {{#cargo_query: tables=Discussions, _pageData |join on=Discussions._pageName=_pageData._pageName |fields=Discussions._pageNam...")
- 11:15, 2023 January 4 Ttenbergen talk contribs created page CCMDB.accdb Change Log 2023 (Created page with "__NOTOC__ <!-- This hides the table of contents so collectors can immediately see the most recent change without scrolling. --> See Log (disambiguation) for other uses of the term "Log". See the Development Documentation Category for other development logs''. See Rolling out changes for the process of rolling out changes. See also '''requested CCMDB changes for the next version''' and '''CCMDB.accdb Data Integrity...")
- 13:34, 2022 December 29 Ttenbergen talk contribs moved page LOS per Service to LOS Per Service without leaving a redirect (Text replacement - "LOS per Service" to "LOS Per Service")
- 13:07, 2022 December 29 Ttenbergen talk contribs deleted page Care levels in the community (nothing left here, all on Pre acute living situation field now.)
- 11:33, 2022 December 29 Ttenbergen talk contribs deleted page Supportive Housing (content was not relevant to collection, and more so because this field has been merged into option "Community Facility with support")
- 13:13, 2022 December 8 Ttenbergen talk contribs moved page AMA DtTm to BedHeldEnd DtTm without leaving a redirect
- 13:04, 2022 December 8 Ttenbergen talk contribs created page AMA DtTm (Created page with "{{Project |ProjectActive=planned |ProjectProgram=CC and Med |ProjectRequestor=??? |ProjectCollectionStartDate=2023-01-01 |Project={{PAGENAME}} }} ==Collection Instructions== * Project :'''AMA_DtTm''' * Item: '''AMA_DtTm''' * Date (field E): Date of ___ * Time (field M): Time of ___ ==Background== As discussed at JALT ... ==Collection parameters== * Collected only at STB CICU...")
- 12:02, 2022 December 8 Ttenbergen talk contribs created page Visit Admit DtTm differences within same admission (Created page with "Julie identified at 2022-07-13 Task that sometimes the Visit Admit DtTm in Cognos is different for records within a single hospitalization. This is clearly an error and we need to know why it happens. Since we use the Visit Admit DtTm to define hospitalizations, we can't really check the Cognos Data for this issue unless we have an example. It was decided th...")
- 14:29, 2022 November 29 Ttenbergen talk contribs moved page CCMDB.accdb flickers or flashes at times to CCMDB.accdb flickers or flashes without leaving a redirect
- 14:27, 2022 November 29 Ttenbergen talk contribs moved page User:Cross Check Engine to Cross Check Engine without leaving a redirect
- 14:27, 2022 November 29 Ttenbergen talk contribs moved page User:Ttenbergen/Cross Check Engine to User:Cross Check Engine without leaving a redirect
- 14:26, 2022 November 29 Ttenbergen talk contribs created page CCMDB.accdb flickers or flashes at times (Created page with "{{Bug}} If this happens when you first open a record, or as you close it, then it’s because of all the cross checks we run. There are a bunch of screen re-freshes in the process, because some checks can run at different times and we need to make sure the screen is refreshed at least once. I have a long-term goal to change how we do the cross checks, they have sort of grown as we have built the program and have not been re-factored in over 10 years.")
- 17:26, 2022 November 24 Ttenbergen talk contribs created page Category:Annual Baking Event (Created page with "Pages about our annual baking events, possibly the most important thing we do all year.")
- 17:26, 2022 November 24 Ttenbergen talk contribs created page Second Annual Baking Event (Created page with "This is the second iteration of the First Annual Baking Event. == Additional Info == *EVERYONE from all data collection sites is invited to participate *TIME: TBA, Tina is sending out a doodle poll *PLACE: Data collector's room at HSC, GF-216 *REQUIREMENT: Something home-baked (no store bought allowed) *ORIGIN OF THE IDEA: It comes from Allan Garland, based on the baking contest that used to occur in ICMS at St. B. He is making his grandmother's recipe for cho...")
- 12:49, 2022 November 24 Ttenbergen talk contribs deleted page Battery disposal (wasn't being updated, so deleting the page.)
- 15:54, 2022 November 16 Ttenbergen talk contribs created page JALT Meeting - Rolling Agenda and Minutes (Redirected page to JALT Meeting - Rolling Agenda and Minutes 2022) Tag: New redirect
- 15:46, 2022 November 16 Ttenbergen talk contribs created page JALT Meeting - Rolling Agenda and Minutes 2022 (Created page with "__NOTOC__ == List of items to bring to JALT meeting == Add to this by adding the following '''to the article where the problem is documented''': <pre>{{DiscussTask | JALT * <question details>}}</pre> (this will bring it to Task if not addressed at JALT) or <pre>{{Discuss | JALT * <question details>}}</pre> (this will not bring it to Task) {{#cargo_query: tables=Discussions, _pageData |join on=Discussions._pageName=_pageData._pageName |fields=Discussions._pageNam...")
- 17:55, 2022 November 3 Ttenbergen talk contribs created page Template:PCH Riverview Deer Lodge (Created page with "<noinclude> to keep instructions consistent If a patient is discharged to a PCH bed at Deer Lodge or Riverview, then the option "Winnipeg PCH" should be used in the Dispo field. </noinclude>")
- 17:44, 2022 November 3 Ttenbergen talk contribs deleted page Team meeting 2023-01-24 (inconsistent naming so I didn't see it and created a twin, see Team Meeting 2023-01-24)
- 17:43, 2022 November 3 Ttenbergen talk contribs deleted page Battery Capacity on Laptops (content was: "At some point battery life on the laptops was a real concern. As of 2022-09-20 battery life seems to be sufficient for collection work if the battery is in good condition. {{Discuss | who = Lisa | question = * This page was written when we first moved to laptops and battery life was a general concern. I don't think it is any longer, so we could probably delete the page. Do you agree? Ttenbergen 09:50, 2022 September 20 (CDT) * I agree User:Lkaita|Lisa K...")
- 17:40, 2022 November 3 Ttenbergen talk contribs created page Category:2023 Data Collection Team Meetings (Created page with "Category:Data Collection Team Meetings")
- 17:39, 2022 November 3 Ttenbergen talk contribs created page Team Meeting 2023-01-24 (Created page with "1. '''Call to Order''' 2. '''Action Plans''' 3. '''Business Arising''' 4. '''New Business''' 5. '''Round Table Items''' 6 '''Date of Next Meeting: ''' == Related articles == {{Related Articles}} Category: 2023 Data Collection Team Meetings")
- 16:27, 2022 October 27 Ttenbergen talk contribs created page Query L Log ownercheck maker (Created page with "Query '''L_Log_ownercheck_maker''' creates temporary table L_Log_ownercheck as part of sending. That table is then uses by query send_check_centralized_is_owner. It was set up as a table rather than a view because it's a huge slow query running over VPN and this made it somewhat more reliable. == Related articles == {{Related Articles}} Category:Sending Category:CCMDB.accdb")
- 15:05, 2022 October 26 Ttenbergen talk contribs created page Recreate CCMDB.accdb (Created page with "Things go wrong with CCMDB, such as suddenly showing the password on exit. Compact restore sometimes fixed things, but the password one isn't usually fixed that way. Also, other garbage stays behind that isn't addressed. == Steps == * make new Access program * open in exclusive mode and apply password ** file open, browse (to open window that gives exclusive option), * encrypt w password ** file, encrypt, ignore row message == Log == * 2022-10-26 - doing this because...")
- 15:05, 2022 October 26 Ttenbergen talk contribs deleted page SL EPR Exclusions table (table is no more, and no references to it remain)
- 10:17, 2022 October 19 Ttenbergen talk contribs created page Validating new types of DSM results (Created page with "Occasionally new types of lab results are encountered in the DSM data in the process of Instructions for importing a batch of DSM Data. This page explains what to do when these arrive, and logs the state of what we are doing. == Process == {{DA | JALT * There is a long-outstanding request to Allan to map the new labs that have come in in the last few months. I emailed a list this evening to get this done. This is currently on the agenda for the Task meeting a...")
- 13:45, 2022 October 13 Ttenbergen talk contribs created page HSC-GA7S (Created page with "{{Collection Location | Collection StartDate = 18 October 2004 | Collection EndDate = | Collection Program = Medicine | Collection Hospital = HSC | Collection Bed Nrs = | Collection Unit Phone = | Collection Unit Fax = | Collection Unit Manager = | Collection Unit Manager Phone = | Collection Unit Clerk = }} == Location profile == {{Discuss | * Is this a unit we currently collect on? What is it now? ~~~~ }} == History == We have records with this unit as a...")
- 12:07, 2022 October 5 Ttenbergen talk contribs moved page Combiner tab resorts after entering to Combiner tab re-sorts after entering without leaving a redirect (Text replacement - "Combiner tab resorts after entering" to "Combiner tab re-sorts after entering")
- 17:26, 2022 September 29 Ttenbergen talk contribs deleted page Setting up CCMDB.accdb and CCMDB data.mdb on a new computer (consolidated in Laptop Setup)
- 17:16, 2022 September 29 Ttenbergen talk contribs deleted page CCMDB laptop setup instructions (merged with Laptop Setup)
- 14:34, 2022 September 28 Ttenbergen talk contribs created page Query check ICD10 trach has trach but no TISS (Created page with "{{Data Integrity Check | DIC_summary = if there is a {{ICD10WithCode|Tracheostomy, has one}} ICD10, there needs to be a {{TISS w Nr | Trach Tube Present (TISS Item)}} for at least the first day | DIC_related_concepts = Tracheostomy creation; Trach Tube Present (TISS Item) | DIC_firmness = soft check | DIC_timing = | DIC_app = CCMDB.accdb | DIC_coding = Query ''check_ICD10_trach_has_trach_but_no_TISS'' | DIC_status = ready to implement | DIC_implementation_date = 2022-09...")
- 10:53, 2022 September 28 Ttenbergen talk contribs created page Query check ICD10 trach create but no TISS (Created page with "{{Data Integrity Check | DIC_summary = If there is an acquired Tracheostomy creation there also has to be a Trach Tube Present (TISS Item) | DIC_related_concepts = Tracheostomy creation; Trach Tube Present (TISS Item) | DIC_firmness = hard check | DIC_timing = | DIC_app = CCMDB.accdb | DIC_coding = Query ''check_ICD10_trach_create_but_no_TISS'' | DIC_status = ready to implement | DIC_implementation_date = 2022-09-28 }} If there is an Acquired Procedure of {...")
- 09:58, 2022 September 28 Ttenbergen talk contribs created page 2022 SICU Trauma Day Poster (Created page with "{{DiscussTask | 2022 SICU Trauma Day is Nov 4. They discuss things we have data on, and we might want to improve awareness of our database there. They don't have a slot for us to present, but we could put up a poster. Should we? }} Category:Outreach")
- 15:25, 2022 September 20 Ttenbergen talk contribs deleted page Created transferDelay int query (no longer used as it would no thave worked without combiners that the early patient follow records didn't have. See Created BoardingLoc plus historical query instead)
- 14:11, 2022 September 20 Ttenbergen talk contribs created page Tina Tenbergen (Created page with "see Priv:Tina Tenbergen")
- 15:20, 2022 September 7 Ttenbergen talk contribs moved page Guidelines around coding sex and gender to Guidelines for coding sex and gender without leaving a redirect
- 12:03, 2022 September 7 Ttenbergen talk contribs created page Guidelines around coding sex and gender (Created page with "Starting point only for now. Should mention * Past history, removal of organ NOS for hysterectomy if appropriate. We discussed whether removed testicles should be included in this; if so it needs to be added to that page as well * Past history, removal of breast (mastectomy) if appropriate * Sex field which needs to include a distinction to gender, and how we code if it changes over time * Gender identity disorder and that we removed it and why G...")
- 09:41, 2022 September 7 Ttenbergen talk contribs created page Level of care (Redirected page to Level of care hierarchy) Tag: New redirect
- 09:22, 2022 September 7 Ttenbergen talk contribs created page Created BoardingLoc plus historical query (Created page with "The query created_BoardingLoc_plus_historical in CFE contains the Boarding Locs and their equivalent Service/Location entries including their level of care. == Log == 2022-09-06 - created query == Related articles == {{Related Articles}} Category: Data structure")
- 15:36, 2022 August 25 Ttenbergen talk contribs moved page ClientVisitGUID to ClientVisitGUID field without leaving a redirect (Text replacement - "ClientVisitGUID" to "ClientVisitGUID field")
- 15:42, 2022 August 15 Ttenbergen talk contribs created page 2022-08 sending issues (Created page with " == outstanding tasks == * check backup logs to see if those files can be sent * process phi csvs * set file location back to RS * roll all newest versions (after I hear from Pagasa that she has copied legacy) == Background == Wednesday 2022-08-10 Tina did some updates to Centralized_data.mdb and rolled them out, but the change was accidentally done on an outdated file. That file was returned to the server and collec...")
- 16:22, 2022 August 10 Ttenbergen talk contribs moved page Table Postal Code Master to Postal Code Master table without leaving a redirect (Text replacement - "Table Postal Code Master" to "Postal_Code_Master table")
- 15:31, 2022 August 10 Ttenbergen talk contribs created page Changes to make Centralized data smaller (Created page with "As of 2022-08-10 Centralized data.mdb was 1.348GB . This is large and slowly approaching MS Access' 2GB limit. The size also makes it slow to copy down, and even slower to copy up. This page is about attempts to make the file smaller. === L_Dxs table and L_Como table === We can reduce the file size to 0.810GB by moving the legacy tables L_Dxs table and L_Como table to Legacy TMS Data.mdb. These tables are “stale” and no longer change, so we...")
- 16:34, 2022 August 9 Ttenbergen talk contribs deleted page BU Comparer.accdb (Discussed with Pagasa, this is no longer used and has not in a long time. Both the program and the wiki pages can be cleaned up. Emailed P to delete file if she still has it)
- 11:04, 2022 August 5 Ttenbergen talk contribs created page L Log+ query (Created page with "A helper query that combines L_Log table with the Admit DtTm concept.")
- 16:27, 2022 August 3 Ttenbergen talk contribs created page Created TransferReady cc query (Created page with "Created_TransferReady_cc query pulls together the first Transfer Ready dates from Transfer Ready DtTm field or Transfer Ready DtTm tmp entry according PatientFollow Project#Transition dates, for use by Transfer Delay (CC). == Log == * 2022-07-? created query == Related articles == {{Related Articles}} Category:Centralized data front end.accdb")
- 09:45, 2022 August 3 Ttenbergen talk contribs created page Abscess coding guideline for ICD10 (Created page with "Abscesses should be coded as follows: *One of the abscess codes (include automated list) eg Skin abscess {{#ask: ~*abscess*||~*Abscess* |default=none found |order=Ascending |format=list |limit=100 |link=none }} * If not available, <location infection>, NOS / *itis (eg Sinusitis, acute) * If not available, as <organ disorder or similar>), NOS combined with Infectious disease NOS == Related articles == {{Related Arti...")
- 11:21, 2022 July 28 Ttenbergen talk contribs created page Collection of TISS data in CCI Picklist (Created page with "== Collection instructions == You can filter the Patient Viewer Tab CCI_Pick for only TISS entries using the "TISS" button in the bottom left corner. The easiest way to enter a new TISS item is to use the corresponding button in the row of numbered buttons on the bottom of the screen. If you can't remember the item numbers, then (a) hovering over the button will give you the descriptions or (b) you can click on the wiki link just to the left of the numbered buttons...")
- 11:38, 2022 July 13 Ttenbergen talk contribs created page Template:ICD10 Guideline Regional Ischemia (Created page with "* Compartment Syndrome * crushing injury (codeS?) * Limb ischemia (upper or lower) * Atherosclerosis of arteries of arms or legs * on pressors (codes?) Need to write this up better, then get Allan to update it, then make sure This also relates to Template:ICD10 Guideline ischemic gut")
- 09:29, 2022 July 13 Ttenbergen talk contribs moved page Check BL TR combiner null to Query Check BL TR combiner null without leaving a redirect (consistency)
- 09:17, 2022 July 13 Ttenbergen talk contribs created page Check BL TR combiner null (Created page with "{{Data Integrity Check |DIC_summary=Checks that all Boarding Loc / Transfer Ready DtTm tmp entry pairs have a non-null combiner integer. |DIC_related_concepts= Transfer Ready DtTm tmp entry; Boarding Loc |DIC_firmness=hard check |DIC_coding=Query check_BL_TR_combiner_null |DIC_status=ready to program |DIC_app=CCMDB.accdb |DIC_backlogged=No }} Checks that all Boarding Locs and Transfer Ready DtTm tmp entrys have non-null combiners. Query check transfer...")
- 16:13, 2022 June 30 Ttenbergen talk contribs deleted page Contacting Quality Officer and Manager for VAPs and CLIs (Only STB ICU does this now, so moved the details into STB Critical Care Collection Guide)
- 15:37, 2022 June 30 Ttenbergen talk contribs deleted page Process for bad data in Cognos (deleted page after link cleanup; this process never took off)
- 15:29, 2022 June 30 Ttenbergen talk contribs deleted page Project CognosDataEmail (project was aborted; asked Pagasa to eliminate the small number of records that were entered.)
- 14:48, 2022 June 30 Ttenbergen talk contribs deleted page Cognos2 Hospital Discharge query (backlog done, no longer needed.)
- 12:02, 2022 June 30 Ttenbergen talk contribs created page Template:ICD10 Rectal Varices (made template to keep this consistent on change)
- 11:08, 2022 June 30 Ttenbergen talk contribs created page User:Maintenance script (Created page with "This "user" shows up in Special:RecentChanges when certain Cargo commands are run via crontab on the server that hosts our wiki. The entry in Recent Changes can be ignored.")
- 10:40, 2022 June 30 Ttenbergen talk contribs created page Ap Chronic (Redirected page to Chronic Health APACHE) Tag: New redirect
- 14:29, 2022 June 28 Ttenbergen talk contribs moved page Created transferReady query to Created TransferReady query without leaving a redirect (Text replacement - "Created transferReady query" to "Created_TransferReady query")
- 11:37, 2022 June 28 Ttenbergen talk contribs created page Query created PatientFollow (Created page with "The query created_PatientFollow in CFE contains a definition of whether the record was set up under the rules following PatientFollow Project or before. The concept is used in many places so a single query was implemented to make sure this is done consistently everywhere. == Log == 2022-06-28 - created query == Related articles == {{Related Articles}} Category: Data structure")
- 10:48, 2022 June 23 Ttenbergen talk contribs deleted page Template:CRF vs ARF (If this will be revived at all it should be at the original template, which I have restored to do it: Template:ICD10 Guideline ESRD vs Acute renal failure)
- 10:43, 2022 June 23 Ttenbergen talk contribs undeleted page Template:ICD10 Guideline ESRD vs Acute renal failure (23 revisions)
- 10:24, 2022 June 23 Ttenbergen talk contribs created page Template:CRF vs ARF (Created page with "<noinclude> There have been different rules for this over time and they keep changing. This template shows the current rule and an expandable for the baggage. Category:Transplant Category:ICD10 wiki infrastructure Category:APACHE II </noinclude>=== CRF vs ARF ===")
- 15:55, 2022 June 22 Ttenbergen talk contribs deleted page Base Population for Research (Page used to be linked from old image on main page. That isn't used any more so no longer needed.)
- 15:41, 2022 June 22 Ttenbergen talk contribs moved page STB ICUs CAM Rate, VAP Rate, CLIBSI Rate Summary to STB ICUs VAP Rate, CLIBSI Rate Summary without leaving a redirect (Text replacement - "STB ICUs CAM Rate, VAP Rate, CLIBSI Rate Summary" to "STB ICUs VAP Rate, CLIBSI Rate Summary")
- 16:15, 2022 June 16 Ttenbergen talk contribs created page Created transferDelay table (Created page with "Created_transferDelay table stores that calculated Transfer Delay (Medicine). == Related articles == {{Related Articles}} Category:Centralized data front end.accdb")
- 16:14, 2022 June 16 Ttenbergen talk contribs created page Created transferDelay int query (Created page with "Query that supplies Sub populate_created_transferDelay() with values to iterate through to calculate Transfer Delay (Medicine). == Related articles == {{Related Articles}} Category:Centralized data front end.accdb")
- 16:13, 2022 June 16 Ttenbergen talk contribs created page Created transferReady query (Created page with "Query that pulls together Transfer Ready DtTms according to their various definitions over time, for use by Transfer Delay (Medicine). {{Todo | who = Tina | todo_added = 2022-06-16 | todo_action = 2022-06-16 | question = Need to also set this up to be used by Created Variables CC maker 2021 query. ~~~~ * }} == Related articles == {{Related Articles}} Category:Centralized data front end.accdb")
- 16:09, 2022 June 16 Ttenbergen talk contribs created page Sub populate created transferDelay() (Created page with "Function that generates Transfer Delay (Medicine). == Related articles == {{Related Articles}} Category:Centralized data front end.accdb")
- 16:08, 2022 June 16 Ttenbergen talk contribs deleted page Created TransferDelay (Now that Med and CC use different definitions there is no reason for this to have its own page .)
- 10:28, 2022 June 16 Ttenbergen talk contribs created page Category:Cognos import3 table (Created page with "Articles related to the Cognos_import3 table. Category:Data structure")
- 16:54, 2022 June 15 Ttenbergen talk contribs created page TISS Item Specific Interventions (outside the ICU) (creating cci category page for completeness to avoid redlinks)
- 16:54, 2022 June 15 Ttenbergen talk contribs created page TISS Item At 2300 Hours (creating cci category page for completeness to avoid redlinks)
- 16:51, 2022 June 15 Ttenbergen talk contribs deleted page Template:MainPageLink (this template used to be used on pages linked from the image map on our main page. That map is gone and the template no longer used.)
- 10:41, 2022 June 15 Ttenbergen talk contribs created page Blue button in CCI Picklist (Created page with "The "blue button" next to the "x2" button in the Patient Viewer Tab CCI Pick will replicate the current CCI Picklist line for a range of dates. == Instructions == When the button is clicked, a calendar entry control button shows up just to the right of it. Click that button and choose the end date of the range. The program will then generate copies of the current CCI Picklist entry for all dates between that entry's date and the date chosen. == Related articles...")
- 15:51, 2022 June 14 Ttenbergen talk contribs deleted page CTE (one-of concept description, now just treated on the page that includes it)
- 15:48, 2022 June 14 Ttenbergen talk contribs deleted page ICD/CCI remove once old pt gone (this is already listed on the actual table pages, so having it listed here adds nothing)
- 15:42, 2022 June 14 Ttenbergen talk contribs deleted page HSC CC (we didn't end up using HSC_CC and continued to use HSC_MICU, HSC_SICU, HSC_IICU instead, so deletin this page)
- 15:34, 2022 June 14 Ttenbergen talk contribs moved page Query NCD dx implying death across encounters to Query NDC dx implying death across encounters without leaving a redirect (Text replacement - "Query NCD dx implying death across encounters" to "Query NDC_dx_implying_death_across_encounters")
- 15:29, 2022 June 14 Ttenbergen talk contribs created page Template:Organ donor inconsistencies (Created page with "=== Organ donor inconsistencies === We have Guideline for coding organ donation after death which might lead to some cross checks flagging an error for patient transfers. This situation is somewhat complex, so instead of changing queries to exclude these cases, just add them to L Problem table as usual after confirming that transfer info was indeed as entered.")
- 14:59, 2022 June 14 Ttenbergen talk contribs deleted page Completeness of TISS records (This unlinked page was about some concerns that were initially raised when we moved TISS to CCI; they have been addressed elsewhere, and often different than discussed here, so deleting the page.)
- 10:57, 2022 June 9 Ttenbergen talk contribs created page Created FirstER BoardingLoc query (Created page with "The query Created_FirstER_BoardingLoc in CFE contains the first ER Boarding Loc dttm for each profile. It's used in calculating the ER Delay. == Log == == Related articles == {{Related Articles}} Category: Data structure")
- 09:10, 2022 June 9 Ttenbergen talk contribs deleted page TISS28 data use (deleting as discussed with Julie. The page used to be linked from the picture on our front page that is no longer accurate or used.)
- 09:07, 2022 June 9 Ttenbergen talk contribs deleted page Chart Review Lists (deleting as discussed with Julie. The page used to be linked from the picture on our front page that is no longer accurate or used.)
- 09:04, 2022 June 9 Ttenbergen talk contribs deleted page Resource Use (deleting as discussed with Julie. The page used to be linked from the picture on our front page that is no longer accurate or used.)
- 09:26, 2022 June 2 Ttenbergen talk contribs created page High-Obs Wards (Created page with "WRHA HOB Medicine wards: * HSC-H4H (original) - May 1, 2005 to June 1, 2010 * HSC-GH7S ** June 1, 2010 to April 14, 2020 ** Aug 7,2020 to present * HSC-GB2 - April 7, 2020 to Aug 7, 2020 * SBGH-L2ME - Oct 1, 2018 to April 1,2019")
- 09:23, 2022 June 2 Ttenbergen talk contribs deleted page HOBs (unneeded redirect)
- 08:17, 2022 June 2 Ttenbergen talk contribs created page Transfer Delay CC (Redirected page to Transfer Delay (Critical Care)) Tag: New redirect
- 20:54, 2022 June 1 Ttenbergen talk contribs created page Run-time error when closing CFE (Created page with "{{Bug needing input}} Pagasa gets a run-time error 3014 when closing CFE every once in a while, often after opening and closing something a bunch of times. Need more input to fix. Could it be that we are now getting too big? {{Discuss | who = Pagasa |question = * Pagasa, do you have more details about this? ~~~~ }}")
- 10:28, 2022 May 31 Ttenbergen talk contribs deleted page Laptop prep.vbs (file no longer exists and hasn't been used in 7years, so deleting)
- 09:11, 2022 May 26 Ttenbergen talk contribs deleted page Minimalbreak (test page no longer needed)
- 16:20, 2022 May 19 Ttenbergen talk contribs created page The "make loc" button will sometimes enter a different record than the line that it is clicked on. (Created page with "{{Bug}} The "make loc" button in Patient Viewer Tab Cognos ADT2 will sometimes enter a different record than the line that it is clicked on. This is the final symptom that collectors have reported, but what actually goes on seems weirder: When # a service tmp entry is entered initially (or the service area is even just clicked into) # there are more records in the Cognos Units portion of the form # one then tries to scroll through that form then # one can mo...")
- 09:30, 2022 May 19 Ttenbergen talk contribs created page Saluvision (Created page with "{{PAGENAME}} (http://saluvision.manitoba-ehealth.ca) is a software that all deaths are now being scanned and loaded to Saluvision at HSC. {{Discuss | Is it only at HSC?}} See HSC Medical Records requests for how we use this. == Getting access to Saluvision == * A request to access Saluvision can be submitted to the manager of health records, the form is available in the audit room. == Related articles == {{Related Articles}} Category:Health Sciences Center Of...")
- 16:59, 2022 May 18 Ttenbergen talk contribs created page "MR Organizer" button (Redirected page to MR Organizer form) Tag: New redirect
- 11:01, 2022 May 18 Ttenbergen talk contribs created page MR Organizer form (Created page with "{{Todo | who = Tina | todo_added = 2022-05-18 | todo_action = 2022-05-18 | question = * Building it now after discussion with Collectors. }}")
- 09:34, 2022 May 11 Ttenbergen talk contribs created page Function LOS int() (Created page with "Function LOS_int() takes a Pat_ID as parameter and calculates the LOS as follows: :: LOS_int = WorksheetFunction.Ceiling((dis_dttm) - (ad_dttm), 1) == Log == * 2022-05-11 - implemented this because CCMDB was using an integer version of the function while CFE was using a three-decimal-point version; want to have both available so adding this second function. == Related articles == {{Related Articles}} Category:Length of stay")
- 11:09, 2022 May 9 Ttenbergen talk contribs moved page Created TrasferDelay to Created TransferDelay without leaving a redirect