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).
- 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...")