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...")
- 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
- 11:09, 2022 May 9 Ttenbergen talk contribs created page Created TrasferDelay (Created page with "{{Todo | who = Tina | todo_added = 2022-05-09 | todo_action = 2022-05-09 | question = _dev_CFE * Implement }} * Create a created_variables_TransferDelay table ** fields D_ID, BL, integer, TransferReady_DtTm, BL_End_DtTm * set a query BL, BL_Level, BL Start, int, TR, Dispo * VBA iterate through the query to set values for table")
- 15:09, 2022 May 4 Ttenbergen talk contribs created page Template:ICD10 Guideline Non-Iatrogenic Pneumothorax (Created page with "<noinclude> This template contains details on how to code non-iatrogenic pneumothorax. To use: <pre>{{ICD10 Guideline Non-Iatrogenic Pneumothorax}}</pre> Category:ICD10 wiki infrastructure ---- </noinclude>=== Guideline for Non-Iatrogenic Pneumothorax === When these fistulas are spontaneous (rather than caused iatrogenically or by trauma), it is due to lung infection or abscess, then that code should also be combined with the appropriate one of these. And in t...")
- 14:49, 2022 May 4 Ttenbergen talk contribs created page Template:ICD10 Guideline Decubitus Ulcer (Created page with "<noinclude> Template to make sure extra information is consistent for the various Decubitus Ulcer diagnoses. Category:ICD10 wiki infrastructure ---- </noinclude> === Coding multiple ulcers === *If there are pressure ulcers on DIFFERENT body parts (e.g. left heel, right heel, coccyx) then code them separately -- even though they will not be readily distinguishable as the code doesn't include body location. *If there are multiple pressure ulcers close to each othe...")
- 14:11, 2022 May 3 Ttenbergen talk contribs moved page Query check pairs transfer DtTm after BoardingLoc to Query check Transfer DtTm after paired BL and before later BL without leaving a redirect
- 13:33, 2022 May 3 Ttenbergen talk contribs created page Query check pairs transfer DtTm after BoardingLoc (Created page with "{{Data Integrity Check |DIC_summary=For each pair, the Transfer Ready DtTm tmp entry should never be earlier any Boarding Loc dttm, nor later than the next Boarding Loc |DIC_related_concepts=Transfer Ready DtTm tmp entry; Dispo DtTm field; Boarding Loc |DIC_timing=always |DIC_coding=query ''check_transfer_DtTm_during_admission'' |DIC_implementation_date=2022-05-03 |DIC_status=ready to implement |DIC_app=CCMDB.accdb |DIC_backlogged=No }} This check runs at pr...")
- 15:11, 2022 April 27 Ttenbergen talk contribs deleted page Created APACHEChronic comparison query (query no longer needed)
- 14:52, 2022 April 27 Ttenbergen talk contribs deleted page Query Covid rept (ended up disfunctional/not needed)
- 14:50, 2022 April 27 Ttenbergen talk contribs deleted page Form Covid rept (ended up disfunctional/not needed)
- 14:45, 2022 April 27 Ttenbergen talk contribs deleted page User:Ttenbergen/questions remaining from Cognos changes (no need for separate list)
- 14:45, 2022 April 27 Ttenbergen talk contribs deleted page User:Ttenbergen/questions remaining from COVID changes (none left)
- 11:47, 2022 April 27 Ttenbergen talk contribs moved page Team Meeting July 26, 2022 to Team Meeting 2022-07-26 without leaving a redirect (re-named for consistent naming and consistent sorting of pages)
- 16:59, 2022 April 26 Ttenbergen talk contribs deleted page "set accept DtTm to arrive DtTm" button (Button removed as part of Change to replace Accept DtTm with first Service tmp entry, and Arrive DtTm with first Boarding Loc)
- 14:20, 2022 April 26 Ttenbergen talk contribs created page Combiner tab resorts after entering (Created page with "{{Bug}}")
- 14:00, 2022 April 20 Ttenbergen talk contribs created page No longer able to edit the "Record" field in PatientList (Created page with "{{Bug}} As of version 2022-04-19 of CCMDB.accdb it is no longer possible to edit the Record field from PatientList. == Cause == This wasn't a deliberate change. We now pull the start date from first service rather than right from the L_Log table. Once it’s a query like that, the field is not editable directly. == Short-term work-around == For now, you can change the Record field by first opening the record in Patient Viewer. == What do we actu...")
- 09:46, 2022 April 20 Ttenbergen talk contribs created page "Invalid use of Null" error when going into a record after entering through CSS (Created page with "{{Bug needing input|}} Steph reported: I ran the news and backup to get the new cognos, used the css and went to go back into the patient list and got this. Exited, ran news and backup again and reopened but got the same error code (S9) People who got same error: * Steph * Lisa * Brynn People not getting this error: * Val * Mailah * Sherry * Pam")
- 10:51, 2022 April 19 Ttenbergen talk contribs deleted page "MR copy-paste" button (removing this button)
- 16:08, 2022 April 14 Ttenbergen talk contribs deleted page L First Boarding Loc Non ER query (wasn't really doing what we need it to)
- 16:00, 2022 April 14 Ttenbergen talk contribs deleted page Query s tmp Boarding Loc ER plus LT 30 (replaced by query s_tmp_Boarding_Loc_ER_delay_reasonable)
- 15:59, 2022 April 14 Ttenbergen talk contribs deleted page Query check ER Delay not too big (replaced with query s_tmp_Boarding_Loc_ER_delay_reasonable)
- 15:49, 2022 April 14 Ttenbergen talk contribs created page Query s tmp Boarding Loc ER delay reasonable (Created page with "{{Data Integrity Check |DIC_summary=Flags Boarding Loc entries for ERs where a second Boarding Loc entry exists that is less than 30 min later or more than 8 hours later for CC or more than 44 hrs later for Med |DIC_related_concepts=Boarding Loc |DIC_firmness=soft check |DIC_timing=complete |DIC_coding= query s_tmp_Boarding_Loc_ER_delay_reasonable |DIC_implementation_date=2022-04-14 |DIC_status=implemented |DIC_LProblem= |DIC_app=CCMDB.accdb |DIC_backlogged=No }}...")
- 11:20, 2022 April 13 Ttenbergen talk contribs created page "Err in Sub CognosDependentFormsRequery. No current record." when clicking "Close with updates" after entering from CSS (Created page with "{{Bug needing input|}} After entering an admission profile using CSS, when the "close with updates" button is clicked the following pop-up error message occasionally occurs: "Err in Sub CognosDependentFormsRequery. No current record." When "OK" is clicked upon, the collector is returned to the main CSS list; however, any remaining unentered admissions all disappear. {{Discuss | * Is anyone else getting this error? Does anyone have a replicable way of generating it...")
- 10:21, 2022 April 13 Ttenbergen talk contribs created page Category:Main Office Team (Created page with "Category for the main role pages of the main/back office of the database.")
- 10:14, 2022 April 13 Ttenbergen talk contribs created page Process Analyst (Created page with "{{Todo | who = Tina | todo_added = 2022-04-13 | todo_action = 2022-04-13 | question = * add links to this page to make it a portal for whoever may need to replace me }} * Cognos data import * Rolling out changes == Related articles == {{Related Articles}} Category:Contact List")
- 10:12, 2022 April 13 Ttenbergen talk contribs deleted page Category:Quality and Process Engineering Group (Empty Category)
- 17:28, 2022 April 7 Ttenbergen talk contribs created page "cannot open any more tables" in Access (Created page with "{{Bug}} Pagasa gets this error after doing a few things in CFE. Short term fix is to exit and re-enter CFE. Longer term fix is for Tina to figure out why this even happens.")
- 13:45, 2022 April 7 Ttenbergen talk contribs created page "Invalid procedure call or argument" when sending (Created page with "H5 laptop gets the following error when sending: ::"Invalid procedure call or argument" * as of 2022-04 this is our most recently re-imaged laptop * there were also some update messages that happened at the same time this started * desktop confirmed that the office install is fine and that the newest version of Windows is installed It turns out the error happens, specifically, when the collector answers the question whether the laptop is hooked up to a network cable -...")
- 10:58, 2022 April 6 Ttenbergen talk contribs created page Created APACHE Chronic query (Created page with "<onlyinclude>The Created_APACHE_Chronic query in CFE provides a replacement of the Chronic Health APACHE field to the Created_Variables_Common_maker_2021 query. </onlyinclude> {{Todo | who = Tina | question = * The query needs to eventually be triggered when the button "calc created variables" on the front screen of CFE is pressed. }} == Implementation == * For records with Dispo DtTm before '''the transition date''' it provides the con...")
- 15:34, 2022 March 31 Ttenbergen talk contribs created page Gaps and overlaps (Created page with "There are some gaps between or overlaps within Admit DtTm and Dispo DtTm in some of our older records. These were identified, but never corrected. To prevent having to re-check this data we are keeping track of this. ==Current state== Main office maintains several files that deal with known (and not fixed) gaps and overlaps. They are stored at S:\WRHA\WRHA_CCMED\GAPS_OVERLAP_OVERS . ==Future state== This information will transition to the L Problem tabl...")
- 15:05, 2022 March 31 Ttenbergen talk contribs deleted page Data Integrity Checks/review list (all questions have now been reviewed)
- 09:42, 2022 March 31 Ttenbergen talk contribs created page Query s tmp Boarding Loc ER plus LT 30 (Created page with "{{Data Integrity Check |DIC_summary=Flags Boarding Loc entries for ERs where a second Boarding Loc entry exists that is less than 30 min later |DIC_related_concepts=Boarding Loc |DIC_firmness=soft check |DIC_timing=complete |DIC_coding= query s_tmp_Boarding_Loc_ER_plus_LT_30 |DIC_implementation_date=2022-03-31 |DIC_status=ready to implement |DIC_LProblem= |DIC_app=CCMDB.accdb |DIC_backlogged=No }} The actual requested check was for the ''next'' boarding loc to be...")
- 21:35, 2022 March 24 Ttenbergen talk contribs moved page PL missing L Tables content to Reconnect check missing L Tables content query without leaving a redirect
- 20:42, 2022 March 24 Ttenbergen talk contribs moved page PL 1orphans to Reconnect check orphans query without leaving a redirect (not a PL check really, and will now be run by the reconnector)
- 16:50, 2022 March 24 Ttenbergen talk contribs moved page Check for Completes query to Reconnect check Completes query without leaving a redirect
- 16:40, 2022 March 24 Ttenbergen talk contribs created page Check for Completes query (Created page with "Query in CFE that lists pts with RecordStatus "Complete". It shows up if such files are encountered when "Re-connect Data" button is pressed. == Related articles == {{Related Articles}} Category:CCI wiki infrastructure")
- 16:39, 2022 March 24 Ttenbergen talk contribs deleted page Cleaning up a failed send (Process is now almost trivial so was just rolled in with Re-sending data)
- 16:16, 2022 March 24 Ttenbergen talk contribs created page "Re-connect Data" button (Created page with "Button on main page of CFE that disconnects and re-connects data sources used regularly by CFE. Necessary because we Push and Pull data, and tables that are connected on one user's desktop would not be properly connected on another user's desktop. Also runs some basic consistency checks. Can result in errors, see Procedure when there are differences between L Log and L PHI. == Related articles == {{Related Articles}} Category:Centralized data...")
- 15:07, 2022 March 24 Ttenbergen talk contribs moved page Link suspect mismatch pre inpt should be ours incomplete to Link suspect mismatch pre inpt should be ours incomplete query without leaving a redirect
- 15:06, 2022 March 24 Ttenbergen talk contribs created page Link suspect mismatch pre inpt should be ours incomplete (Created page with "{{Data Integrity Check |DIC_summary= What is description |DIC_related_concepts=PHIN; Arrive DtTm field; Dispo DtTm field |DIC_firmness=hard check |DIC_coding=''link_suspect_mismatch_pre_inpt_should_be_ours__incomplete'' query |DIC_status=implemented |DIC_LProblem=no |DIC_app=Centralized data front end.accdb |DIC_backlogged=No }} {{Todo | who = Tina | todo_added = 2022-03-24 | todo_action = 2022-03-24 | question = * Was added ages ago but not documented; need to...")
- 13:47, 2022 March 24 Ttenbergen talk contribs deleted page SubAcute (service type concept was discontinued)
- 13:37, 2022 March 24 Ttenbergen talk contribs deleted page Service type (No longer used so removing documentation)
- 13:33, 2022 March 24 Ttenbergen talk contribs deleted page S dispo.service type (Field eliminated since we no longer use NTU etc)
- 09:20, 2022 March 24 Ttenbergen talk contribs created page ClientGUID field (Created page with "{{Data element |field_name=ClientGUID |Rank=N/A |in_table=Cognos_Import3 |data_type=string |datafield_length=16 |program_collecting=Med and CC |created_raw=Raw |data_element_sort_index= |element_description=The unique person identifier from Cognos. }} Many patients don't have MB PHINs so we generate PseudoPHINs. I figured EPR must already solve this problem, and they use this field. We now get this as part of the Cognos data dump. If we set up the infra...")
- 17:02, 2022 March 23 Ttenbergen talk contribs moved page Capsule Endoscopy Picklist to Capsule Endoscopy without leaving a redirect (bad copy-paste)
- 16:01, 2022 March 23 Ttenbergen talk contribs created page Capsule Endoscopy Picklist (Created page with "{{CCI PickList Procedure |CCI_Picklist_Code=2.0Z.29 |CCI_Collection_Mode=CCI collect first |StartDate=2022-03-22 |CCI_Category=Diagnostic Procedure }} {{CCI category|Diagnostic Px}} ==Additional Info== {{CCI Collection Mode}} {{CCI_Therapeutic}} ==Alternate CCIs to consider coding instead or in addition== * a different code in Category:Diagnostic Px {{ListCCICategory | categoryName = Diagnostic Px}} ==Related ICD10 Codes== {{Data Integrity Check List}} == Lo...")
- 13:26, 2022 March 23 Ttenbergen talk contribs created page Query check no consecutive same BL or Service (Created page with "{{Data Integrity Check | DIC_summary = Check that there are no identical Boarding Locs or Services without a different one with a time stamp in between those two. | DIC_related_concepts = Boarding Loc; Service | DIC_firmness = hard check | DIC_timing = always | DIC_app = CCMDB.accdb | DIC_coding = query check_no_consecutive_same_BL_or_Service | DIC_status = ready to implement | DIC_implementation_date = date change was rolled out / first applied }} == Related articles...")
- 11:53, 2022 March 17 Ttenbergen talk contribs uploaded a new version of File:Legacy.svg
- 11:52, 2022 March 17 Ttenbergen talk contribs uploaded a new version of File:Legacy.svg
- 11:50, 2022 March 17 Ttenbergen talk contribs created page File:Legacy.svg
- 11:50, 2022 March 17 Ttenbergen talk contribs uploaded File:Legacy.svg
- 11:11, 2022 March 17 Ttenbergen talk contribs created page TISS28 Item (Created page with "This page is about the procedures that are part of CCI Collection in the CCI Category "[[:Category:{{PAGENAME}}|{{PAGENAME}}]]". See #Procedure list below for a list. == Procedure List == {{Category procedure list|CCI_Category={{PAGENAME}}}} [[Category:{{PAGENAME}} | *]] Category:CCI Category Category:CCI")
- 11:11, 2022 March 17 Ttenbergen talk contribs created page TISS Item Neurological Support (Created page with "This page is about the procedures that are part of CCI Collection in the CCI Category "[[:Category:{{PAGENAME}}|{{PAGENAME}}]]". See #Procedure list below for a list. == Procedure List == {{Category procedure list|CCI_Category={{PAGENAME}}}} [[Category:{{PAGENAME}} | *]] Category:CCI Category Category:CCI")
- 11:10, 2022 March 17 Ttenbergen talk contribs created page TISS Item Cardiovascular Support (Created page with "This page is about the procedures that are part of CCI Collection in the CCI Category "[[:Category:{{PAGENAME}}|{{PAGENAME}}]]". See #Procedure list below for a list. == Procedure List == {{Category procedure list|CCI_Category={{PAGENAME}}}} [[Category:{{PAGENAME}} | *]] Category:CCI Category Category:CCI")
- 11:10, 2022 March 17 Ttenbergen talk contribs created page TISS Item Renal Support (Created page with "This page is about the procedures that are part of CCI Collection in the CCI Category "[[:Category:{{PAGENAME}}|{{PAGENAME}}]]". See #Procedure list below for a list. == Procedure List == {{Category procedure list|CCI_Category={{PAGENAME}}}} [[Category:{{PAGENAME}} | *]] Category:CCI Category Category:CCI")
- 11:10, 2022 March 17 Ttenbergen talk contribs created page TISS Item Respiratory Support (Created page with "This page is about the procedures that are part of CCI Collection in the CCI Category "[[:Category:{{PAGENAME}}|{{PAGENAME}}]]". See #Procedure list below for a list. == Procedure List == {{Category procedure list|CCI_Category={{PAGENAME}}}} [[Category:{{PAGENAME}} | *]] Category:CCI Category Category:CCI")
- 11:10, 2022 March 17 Ttenbergen talk contribs created page TISS Item Metabolic Support (Created page with "This page is about the procedures that are part of CCI Collection in the CCI Category "[[:Category:{{PAGENAME}}|{{PAGENAME}}]]". See #Procedure list below for a list. == Procedure List == {{Category procedure list|CCI_Category={{PAGENAME}}}} [[Category:{{PAGENAME}} | *]] Category:CCI Category Category:CCI")
- 11:10, 2022 March 17 Ttenbergen talk contribs created page TISS Item Specific Interventions (in the ICU only) (Created page with "This page is about the procedures that are part of CCI Collection in the CCI Category "[[:Category:{{PAGENAME}}|{{PAGENAME}}]]". See #Procedure list below for a list. == Procedure List == {{Category procedure list|CCI_Category={{PAGENAME}}}} [[Category:{{PAGENAME}} | *]] Category:CCI Category Category:CCI")
- 11:10, 2022 March 17 Ttenbergen talk contribs created page TISS Item Basic Activities (Created page with "This page is about the procedures that are part of CCI Collection in the CCI Category "[[:Category:{{PAGENAME}}|{{PAGENAME}}]]". See #Procedure list below for a list. == Procedure List == {{Category procedure list|CCI_Category={{PAGENAME}}}} [[Category:{{PAGENAME}} | *]] Category:CCI Category Category:CCI")
- 11:10, 2022 March 17 Ttenbergen talk contribs created page TISS Item Other (Created page with "This page is about the procedures that are part of CCI Collection in the CCI Category "[[:Category:{{PAGENAME}}|{{PAGENAME}}]]". See #Procedure list below for a list. == Procedure List == {{Category procedure list|CCI_Category={{PAGENAME}}}} [[Category:{{PAGENAME}} | *]] Category:CCI Category Category:CCI")
- 16:25, 2022 March 16 Ttenbergen talk contribs created page Template:CCI Guideline Vasoactive Drugs TISS (Created page with "Both {{TISS w Nr | Vasoactive drug IV continuous-multiple simultaneous (TISS Item)}} and {{TISS w Nr | Vasoactive drug IV continuous-multiple simultaneous (TISS Item)}}: * do '''not include pure antiarrhythmics''' -- by which we mean agents that might not ALSO be used for cardiotonic effects (such as iv beta blockers) * include all vasoactive and cardio-active agents, including: **Catecholamines: norepinephrine, epinephrine, phenylephrine, dopamine **Other vasoconstri...")
- 16:00, 2022 March 16 Ttenbergen talk contribs deleted page Palliative (concept) (content was: "{{Reporting Indicators | description = Palliative... | indicator_name = Palliative ... | created_raw = Created | program = Critical Care | indicator_start_date = | indicator_end_date = }} {{DJ | needs content}} We currently collect this as Palliative care. ==Legacy info== We used to collect this info as Palliative Service, and also in different ways befo...", and the only contributor was "Ttenbergen" (talk))
- 15:47, 2022 March 16 Ttenbergen talk contribs moved page Palliative to Palliative (concept) without leaving a redirect
- 15:34, 2022 March 16 Ttenbergen talk contribs created page Invasive mechanical ventilation at 2300 hrs (concept) (Created page with "{{Indicator}}")
- 22:49, 2022 February 17 Ttenbergen talk contribs deleted page Requested TISS changes for the next version (Not using the TISS mdb any more, so no more changes.)
- 21:07, 2022 February 17 Ttenbergen talk contribs deleted page Directors Quarterly Report (Medicine) (see Directors Quarterly and Annual Report (Medicine))
- 18:37, 2022 February 17 Ttenbergen talk contribs deleted page Query check has service entry (Confirmed that this is take care of by query check_minimal_data_set_incomplete, so no need for this separate check.)
- 17:58, 2022 February 17 Ttenbergen talk contribs deleted page Transfer time rule (no longer done, and has no bearing on future interpretation of data, so deleting.)
- 17:20, 2022 February 17 Ttenbergen talk contribs deleted page Query check ICD10 some cant be PCAA (evil twin of Controlling Dx Type for ICD10 codes)
- 16:58, 2022 February 17 Ttenbergen talk contribs moved page Query check CD10 some cant be PCAA to Query check ICD10 some cant be PCAA without leaving a redirect (typo)
- 16:58, 2022 February 17 Ttenbergen talk contribs deleted page Query check ICD10 some cant be PCAA (Deleted to make way for move from "Query check CD10 some cant be PCAA")
- 16:57, 2022 February 17 Ttenbergen talk contribs created page Category:Pages using duplicate arguments in template calls (Created page with "This is an automatically generated category that flags pages that have tables and have had the Template:LegacyContent applied to them. The template doesn't digest tables right, so they show up as using duplicate arguments. Doesn't really need a fix.")
- 16:46, 2022 February 17 Ttenbergen talk contribs moved page Query check ICD10 some cant be PCAC to Query check CD10 some cant be PCAA without leaving a redirect (Text replacement - "Query check ICD10 some cant be PCAC" to "query check_CD10_some_cant_be_PCAA")
- 16:41, 2022 February 17 Ttenbergen talk contribs created page Query check ICD10 some cant be PCAC (Created page with "{{Data Integrity Check | DIC_summary = Some dxs can't be Primary Admit Diagnosis, Comorbid Diagnosis, Admit Diagnosis or Acquired Diagnosis | DIC_related_concepts = Primary Admit Diagnosis; Comorbid Diagnosis; Admit Diagnosis; Acquired Diagnosis | DIC_firmness = hard check | DIC_timing = | DIC_app = CCMDB.accdb | DIC_coding = query ''check_CD10_some_cant_be_PCAC'' | DIC_status = needs review | DIC_implementation_date = }} To do this check we need to det...")
- 16:36, 2022 February 17 Ttenbergen talk contribs moved page Query check ICD10 some cant be PCAC to Query check ICD10 some cant be PCAA without leaving a redirect (Text replacement - "Query check ICD10 some cant be PCAC" to "Query check ICD10 some cant be PCAA")
- 16:34, 2022 February 17 Ttenbergen talk contribs moved page Check ICD10 some cant be primary como admit acuqired to Query check ICD10 some cant be PCAC without leaving a redirect (Text replacement - "Check ICD10 some cant be primary como admit acuqired" to "query check_ICD10_some_cant_be_PCAC")
- 16:31, 2022 February 17 Ttenbergen talk contribs moved page Check ICD10 some cant be primary to Check ICD10 some cant be primary como admit acuqired without leaving a redirect (Text replacement - "Check ICD10 some cant be primary" to "Check ICD10 some cant be primary como admit acuqired")
- 16:06, 2022 February 17 Ttenbergen talk contribs created page Template:ICD10 Guideline TE fistula (Created page with "<noinclude> This template contains information specific to coding Tracheoesophageal fistula. To use: :: <nowiki>{{</nowiki>{{PAGENAME}}<nowiki>}}</nowiki> Category:ICD10 wiki infrastructure ---- </noinclude>=== Tracheoesophageal fistula Guidelines === Code [https://en.wikipedia.org/wiki/Tracheoesophageal_fistula Tracheoesophageal fistula] as the following 3 Combined ICD10 codes: * Disorder of esophagus, NOS * Disorder of upper respiratory tract, inf...")
- 15:28, 2022 February 17 Ttenbergen talk contribs moved page Supp O2 though any device, delivered via nose, mouth, ETT or trach (TISS Item) to Supp O2 through any device, delivered via nose, mouth, ETT or trach (TISS Item) without leaving a redirect (typo)
- 18:44, 2022 February 14 Ttenbergen talk contribs deleted page Logs (didn't solve the problem)
- 14:46, 2022 February 14 Ttenbergen talk contribs created page Logs (Redirected page to Log) Tag: New redirect
- 18:31, 2022 February 10 Ttenbergen talk contribs deleted page S dispo chooser (was never fully implemented and is not needed.)
- 17:21, 2022 February 10 Ttenbergen talk contribs created page "VA" button (Created page with "The "VA" button in the tmp list in Patient Viewer Tab Cognos ADT2 will fill the date and time of that line with the date and time from Visit Admit DtTm. == Related articles == {{Related Articles}} Category:CCMDB.accdb Category:Patient Viewer")
- 16:27, 2022 February 10 Ttenbergen talk contribs created page Query check CCI vs LOS count days picklist (Created page with "{{Data Integrity Check |DIC_summary=Confirm that CCI Collection Mode for CCI Picklist CCI collect count days items don't have a count > LOS. |DIC_related_concepts=LOS; Dispo DtTm; Service tmp entry; ECMO, VA; ECMO, VV; Prone positioning |DIC_firmness=hard check |DIC_timing=incomplete |DIC_coding=query ''check_CCI_vs_LOS_count_days_component'' |DIC_status=implemented |DIC_app=CCMDB.accdb |DIC_backlogged=No }} This uses Function LOS(). == Related arti...")
- 16:18, 2022 February 10 Ttenbergen talk contribs deleted page Query check CCI vs LOS count days (unlinked redirect)
- 16:18, 2022 February 10 Ttenbergen talk contribs moved page Query check CCI vs LOS count days to Query check CCI vs LOS count days component
- 14:55, 2022 February 10 Ttenbergen talk contribs created page Function LOS() (Created page with "Function LOS() takes a Pat_ID as parameter and calculates the LOS as follows: {{Todo | who = Tina | todo_added = 2021-09-08 | todo_action = 2021-09-08 | question = _dev_CCMDB * need to update to new AdmDate }} == Related articles == {{Related Articles}}")
- 14:35, 2022 February 10 Ttenbergen talk contribs created page Category:Location Information (Created page with "Pages related to or containing Location metadata storage.")
- 11:27, 2022 February 10 Ttenbergen talk contribs created page S LocationData table (Created page with "The '''s_LocationData''' table in CCMDB.accdb contains the possible values for the metadata for locations. See Location metadata storage. == Data Structure == {| class="wikitable sortable" |- !| field !| type !| description |- || '''location_name''' || text || unique ID |- || '''attribute''' || text || name of the attribute, e.g. "bed count" |- || '''value''' || text || value of the attribute, e.g. "15" in case of bed number |- || '''Start_DtTm''' || date ||...")
- 22:06, 2022 February 9 Ttenbergen talk contribs created page Template:DL (Created page with "<noinclude>using this so much I wanted a quicker way to type it. </noinclude> <includeonly>{{Discuss | who=Lisa | question = {{{1}}} }}</includeonly>")
- 22:06, 2022 February 9 Ttenbergen talk contribs deleted page Manager's list (moved content to Database Manager)
- 22:00, 2022 February 9 Ttenbergen talk contribs created page File:LK.png
- 22:00, 2022 February 9 Ttenbergen talk contribs uploaded File:LK.png
- 16:11, 2022 February 9 Ttenbergen talk contribs moved page Fournier's gangrene in a male to Fournier's gangrene without leaving a redirect (Text replacement - "Fournier's gangrene in a male" to "Fournier's gangrene")
- 16:55, 2022 February 8 Ttenbergen talk contribs created page Location metadata storage (Created page with "{{DJ | * These are some notes to discuss at our meeting tomorrow. ~~~~ }} We track locations in many fields; they are drawn from either s_tmp Boarding Loc entries or from s_dispo table. We are interested in some information about some of these locations, like their Level of care hierarchy or how many beds they have. == Flexibility for values changing over time == The actual values for some of this information change over time, e.g. a ward may cease t...")
- 15:43, 2022 February 8 Ttenbergen talk contribs created page Template:ICD10 Guideline antiseizure drug list (Created page with "<noinclude> This template contains the list of antiseizure drugs that are applicable to all antiseizure drug dxs. Category:ICD10 wiki infrastructureCategory:Drug and substance template ---- </noinclude>=== Common antiseizure drugs === * barbiturates * dilantin/hydantoin * keppra * gabapentin")
- 15:41, 2022 February 8 Ttenbergen talk contribs deleted page Antiseizure drug NOS,, adverse effect (unlinked redirect)
- 15:31, 2022 February 8 Ttenbergen talk contribs deleted page Barbituates (unlinked redirect)
- 15:39, 2022 February 2 Ttenbergen talk contribs moved page "Make loc" button to "make loc" button without leaving a redirect (Text replacement - ""Make loc" button" to ""make loc" button")
- 15:15, 2022 February 2 Ttenbergen talk contribs moved page Anti-arrythmic, overdose/toxicity to Anti-arrhythmic, overdose/toxicity without leaving a redirect (Text replacement - "arrythmic" to "arrhythmic")
- 15:15, 2022 February 2 Ttenbergen talk contribs moved page Anti-arrythmic, adverse effect to Anti-arrhythmic, adverse effect without leaving a redirect (Text replacement - "arrythmic" to "arrhythmic")
- 17:39, 2022 January 27 Ttenbergen talk contribs deleted page Identifying patients in boarding locations (No longer needed after Change of remaining location names from "our" names to EPR/Cognos names)
- 17:39, 2022 January 27 Ttenbergen talk contribs deleted page GRA Boarding Locations (No longer needed after Change of remaining location names from "our" names to EPR/Cognos names)
- 17:39, 2022 January 27 Ttenbergen talk contribs deleted page STB Boarding Locations (No longer needed after Change of remaining location names from "our" names to EPR/Cognos names)
- 10:31, 2022 January 27 Ttenbergen talk contribs deleted page Directors Annual Report (Medicine) (Replaces by directors quarterly and annual report)
- 10:30, 2022 January 27 Ttenbergen talk contribs deleted page Directors Annual Report (Critcal Care) (replaced by Directors Quarterly and Annual Report)
- 18:29, 2022 January 26 Ttenbergen talk contribs created page Query maintenance s tmp deletables (Created page with "{{PAGENAME}} in Centralized data front end.accdb checks if any active rows in s_tmp table are not currently used, and might therefore be set to "inactive". Category:IT Support")
- 14:44, 2022 January 17 Ttenbergen talk contribs deleted page Upgrading from Office/Access 2010 to 2019 (update complete for everyone, project and info no longer relevant)
- 12:03, 2022 January 13 Ttenbergen talk contribs moved page Factors predicting health- related quality of life following necrotizing fasciitis to Factors predicting health-related quality of life following necrotizing fasciitis without leaving a redirect
- 17:39, 2022 January 12 Ttenbergen talk contribs moved page Readmission Rate to MedWard to Readmission to MedWard without leaving a redirect (this is also used in lists, so shouldn't include word rate)
- 17:16, 2022 January 12 Ttenbergen talk contribs deleted page Director's Chart Report (evil twin of Critical Care Program Quality Indicator Report)
- 10:15, 2022 January 12 Ttenbergen talk contribs deleted page ZCM Agent Roll-out (no further relevance)
- 18:57, 2022 January 6 Ttenbergen talk contribs created page User:Ttenbergen/Cross Check Engine (Created page with "This are just some notes re how I might re-write how CCMDB.accdb runs the cross checks. === Definition/Data structure === * table CCE_CrossChecks ** fields: Error msg string, wiki URL, query name, soft/hard check, complete/incomplete, start_DtTm, end_DtTm * table CCE_Fields ** fields: field name, associated checkbox (can there ever be more than one?), tmpField (YN) (Need to be able to do cross checks on tmp entries, but they need to work totally differenty in terms...")
- 15:03, 2022 January 6 Ttenbergen talk contribs deleted page HSC Boarding Locations (removed as per Task_Team_Meeting_-_Rolling_Agenda_and_Minutes_2022#ICU Database Task Group Meeting – January 6, 2022)
- 17:59, 2022 January 5 Ttenbergen talk contribs deleted page Critical Care Inter-facility Transfer Report (no longer done)
- 17:21, 2022 January 5 Ttenbergen talk contribs moved page ICU Primary Diagnosis APACHE Category Rate to ICU Diagnosis APACHE Category Rate without leaving a redirect (not just primary)
- 16:19, 2022 January 5 Ttenbergen talk contribs created page Task Team Meeting - Rolling Agenda and Minutes 2022 (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> <!-- As generated by Semantic Mediawiki --> {{#ask: DiscussWho::Task | searchlabel=Task Questions | ?DiscussQuestion = Question | limit=100 | ?Modification date | format=table }} Also see Task Team Meeting - Rolling Agenda and Minutes 2020 ___TOC___ == ICU Database Task G...")
- 16:12, 2022 January 5 Ttenbergen talk contribs created page Centralized data front end.accdb Change Log 2022 (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 == ===2021-12-29=== not rolled out yet User:Ttenber...")
- 16:08, 2022 January 5 Ttenbergen talk contribs created page CCMDB.accdb Change Log 2022 (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:11, 2022 January 5 Ttenbergen talk contribs moved page MCHP Cleanup to Portal related pages with questions without leaving a redirect (Text replacement - "MCHP Cleanup" to "Portal related pages with questions")
- 12:51, 2022 January 5 Ttenbergen talk contribs moved page S AP AdmitType to S AP AdmitType table without leaving a redirect
- 10:35, 2022 January 5 Ttenbergen talk contribs deleted page Public Entrance Likely Initial Page (Main page was changed so this is no longer needed)
- 10:09, 2022 January 5 Ttenbergen talk contribs created page Team Meeting 2022-04-26 (Just starting the page as anchor for link)
- 11:42, 2022 January 4 Ttenbergen talk contribs moved page Category:2022 Data Collection Team Meeting to Category:2022 Data Collection Team Meetings without leaving a redirect
- 11:42, 2022 January 4 Ttenbergen talk contribs created page Team Meeting 2022-01-25 (Created page with "Team Meeting *Date: ??? *TIME: ??? *Place: ??? == Agenda == ?? == Next Meeting == ??? Category:2022 Data Collection Meetings")
- 16:38, 2021 December 30 Ttenbergen talk contribs created page Template:ICD10 Guideline COVID linker (Created page with "<noinclude> This template provides the link and enticement to follow it from all COVID related DX pages to ICD10 Guideline COVID. </noinclude> === COVID coding details === Coding COVID related diagnoses is complicated, and they are of special interest in our reporting, so we need to get these right. For all the COVID coding info in one place, see ICD10 Guideline COVID.")
- 16:36, 2021 December 30 Ttenbergen talk contribs created page ICD10 Guideline COVID (Created page with "{{ICD10 coding guideline}} {{DA | As mentioned in my email to you, if you agree that we should spin the interrelating bits out into their own page, this is that page. I am making Template:ICD10 Guideline COVID linker to put a link and enticement to come to this page on each of the pages in Category:COVID }} List of all COVID Related Dxs: {{ListICD10Category | categoryName = COVID }} == Related articles == {{Related Articles}} Category: ICD10 Coding Guid...")
- 16:31, 2021 December 30 Ttenbergen talk contribs moved page Renal Coding Considerations for ICD10 to ICD10 Guideline for Renal Coding without leaving a redirect (Text replacement - "Renal Coding Considerations for ICD10" to "ICD10 Guideline for Renal Coding")
- 16:13, 2021 December 30 Ttenbergen talk contribs created page Category:COVID (Created page with "Category:ICD10 Diagnosis Category:Misc Category:Infectious disease")
- 16:11, 2021 December 30 Ttenbergen talk contribs created page Past history of Covid-19 infection (Created page with "{{ICD10 dx |ICD10 Code=U07.4 |StartDate=2021-01-22 }} {{ICD10 category|Misc}}{{ICD10 category|COVID}} == Additional Info == == Alternate ICD10s to consider coding instead or in addition == == Candidate Combined ICD10 codes == == Related CCI Codes == == Reporting == {{Data Integrity Check List}} == Related Articles == {{Related Articles}} {{ICD10 footer}} {{EndPlaceHolder}}")
- 17:55, 2021 December 29 Ttenbergen talk contribs created page Created FirstTransferReady query (Created page with "The query created_FirstTransferReady in CFE contains the first time a patient was transfer ready for a given profile according to the different definitions used over time. That is: Nz([FirstService_DtTm],Nz([Accept_dttm],[Arrive_Dttm])), where FirstService_DtTm is the earliest Service tmp entry DtTm for the profile as taken from Created_FirstService query . Transfer Ready DtTm tmp entry == Related articles == {{Related Articles}} Category:Data str...")
- 17:32, 2021 December 29 Ttenbergen talk contribs created page Created Variables CC 2021 table (Created page with "The Created_variables_CC table in CFE contains most of the profile-level derived Indicators for critical care profiles (see Created Variables Common table) and duplicates some related stored data for convenience . It is populated and used by the statistician for reporting and data extracts. Primarily these are the APACHE score and its components, e.g. Glasgow Coma Scale {| class="wikitable sortable" |- !| field !| type !| de...")
- 17:31, 2021 December 29 Ttenbergen talk contribs created page Created Variables CC maker 2021 query (Created page with "<onlyinclude>The Created_Variables_CC_maker_2021 query in CFE generates some calculated values used for Critical Care only and stores them in the Created_Variables_CC_2021 table. </onlyinclude> The query is triggered when the button "calc created variables" on the front screen of CFE is pressed. == Log == see Created Variables CC 2021 table#Log == Legacy == The query replaces Created_Variables_CC_maker query. == Related articles == {{Related...")
- 17:16, 2021 December 29 Ttenbergen talk contribs created page Created Variables Common maker 2021 query (Created page with "<onlyinclude>The Created_Variables_Common_maker_2021 query in CFE generates some calculated values and stores them in the Created_Variables_Common_2021 table. </onlyinclude> {{Todo | who = Tina | question = * The query needs to eventually be triggered when the button "calc created variables" on the front screen of CFE is pressed. }} == Log == see Created_Variables_Common_maker_2021 query#Log == Legacy == The query replaces Created_Variab...")
- 17:13, 2021 December 29 Ttenbergen talk contribs created page Created Variables Common 2021 table (Created page with "The Created_Variables_Common_2021 table in CFE contains the values created by Created_Variables_Common_maker_2021 query. They are stored rather than generated on the fly because the query is slow for the volume of data involved (many minutes on Tina's PC) and because SAS can not read some data from queries. It is used by the statistician for reporting and data extracts. == Data Structure == {| class="wikitable sortable" |- !| field !| type !| description !|...")
- 11:08, 2021 December 29 Ttenbergen talk contribs deleted page MediaWiki:Smw import skos (content was: "http://www.w3.org/2004/02/skos/core#|[http://www.w3.org/TR/skos-reference/skos.rdf Simple Knowledge Organization System (SKOS)] altLabel|Type:Monolingual text broader|Type:Annotation URI broaderTransitive|Type:Annotation URI broadMatch|Type:Annotation URI changeNote|Type:Text closeMatch|Type:Annotation URI Collection|Class Concept|Class ConceptScheme|Class d...", and the only contributor was "Ttenbergen" (talk))
- 11:07, 2021 December 29 Ttenbergen talk contribs deleted page MediaWiki:Smw import owl (content was: "http://www.w3.org/2002/07/owl#|[http://www.w3.org/2002/07/owl Web Ontology Language (OWL)] AllDifferent|Category allValuesFrom|Type:Page AnnotationProperty|Category backwardCompatibleWith|Type:Page cardinality|Type:Number Class|Category comment|Type:Page complementOf|Type:Page DataRange|Category DatatypeProperty|Category DeprecatedClass|Category Deprecated...", and the only contributor was "Ttenbergen" (talk))
- 11:07, 2021 December 29 Ttenbergen talk contribs deleted page Property:Owl:differentFrom (content was: "* Imported from::owl:differentFrom * Has property description::The property that determines that two given individuals are different.@en Category:Imported vocabulary {{DISPLAYTITLE:owl:differentFrom}}", and the only contributor was "127.0.0.1" (talk))
- 11:07, 2021 December 29 Ttenbergen talk contribs deleted page Property:Foaf:name (content was: "* Imported from::foaf:name * Has property description::A name for some thing or agent.@en Category:Imported vocabulary{{DISPLAYTITLE:foaf:name}}", and the only contributor was "127.0.0.1" (talk))
- 11:07, 2021 December 29 Ttenbergen talk contribs deleted page Property:Foaf:knows (content was: "* Imported from::foaf:knows * Has property description::A person known by this person (indicating some level of reciprocated interaction between the parties).@en Category:Imported vocabulary {{DISPLAYTITLE:foaf:knows}}", and the only contributor was "127.0.0.1" (talk))
- 11:07, 2021 December 29 Ttenbergen talk contribs deleted page Property:Foaf:homepage (content was: "* Imported from::foaf:homepage * Has property description::URL of the homepage of something, which is a general web resource.@en Category:Imported vocabulary {{DISPLAYTITLE:foaf:homepage}}", and the only contributor was "127.0.0.1" (talk))
- 11:07, 2021 December 29 Ttenbergen talk contribs deleted page MediaWiki:Smw import foaf (content was: "http://xmlns.com/foaf/0.1/|[http://www.foaf-project.org/ Friend Of A Friend] name|Type:Text homepage|Type:URL mbox|Type:Email mbox_sha1sum|Type:Text depiction|Type:URL phone|Type:Text Person|Category Organization|Category knows|Type:Page member|Type:Page Category:Imported vocabulary", and the only contributor was "Maintenance script" (talk))
- 10:08, 2021 December 23 Ttenbergen talk contribs deleted page MediaWiki:Smw import foaf (content was: "http://xmlns.com/foaf/spec/|[http://www.foaf-project.org/ Friend Of A Friend] name|Type:Text homepage|Type:URL mbox|Type:Email mbox_sha1sum|Type:Text depiction|Type:URL phone|Type:Text Person|Category Organization|Category knows|Type:Page member|Type:Page Category:Imported vocabulary", and the only contributor was "Ttenbergen" (talk))
- 16:24, 2021 December 22 Ttenbergen talk contribs deleted page Wiki onto laptops (Not gonna happen and no longer an issue with modern wifi)
- 16:23, 2021 December 22 Ttenbergen talk contribs deleted page Exporting the wiki (ancient info that isn't relevant any more)
- 11:18, 2021 December 22 Ttenbergen talk contribs deleted page Tracheostomy days (Deleted at Julie's requests since it's not a regular indicator, and not linked from anywhere.)
- 11:18, 2021 December 22 Ttenbergen talk contribs deleted page Hemodialysis days (Deleted at Julie's requests since it's not a regular indicator, and not linked from anywhere.)
- 15:17, 2021 December 16 Ttenbergen talk contribs created page Sex Rate (Created page with "{{Reporting Indicators |description=See page |Program=Critical Care and Medicine |indicator_start_date=1988-07-11 |indicator_name={{PAGENAME}} |program=Critical Care and Medicine }}")
- 11:37, 2021 December 16 Ttenbergen talk contribs changed visibility of 2 revisions on page Bed census.mdb: content unhidden, edit summary unhidden and username unhidden
- 20:39, 2021 December 15 Ttenbergen talk contribs changed visibility of 86 revisions on page Bed census.mdb: content hidden, edit summary hidden and username hidden
- 18:25, 2021 December 15 Ttenbergen talk contribs deleted page CT Summary discharges FiscalYear query (evil twon of CT_Summary_Discharges_FiscalYear query)
- 18:24, 2021 December 15 Ttenbergen talk contribs created page CT Summary discharges FiscalYear query (Created page with "{{PAGENAME}} is a query in CFE. ===Purpose=== * workload analysis * cross-check for reporting ===Description=== Counts the discharges (profiles with discharge dates) for each site/program per fiscal year. === See also === * CT_Summary_discharges query - same but by year == Related articles == {{Related Articles}} Category:Data Processing Category:Database Manager Category:Centralized data front end.accdb Category:CT Query")
- 15:54, 2021 December 15 Ttenbergen talk contribs deleted page Property:TISS28RowNumber (no longer used)
- 15:23, 2021 December 15 Ttenbergen talk contribs deleted page Property:Collection Collector (no longer used)
- 13:02, 2021 December 15 Ttenbergen talk contribs deleted page What is a service admission (This page was started to define service admission around Cognos. We decided not to do that and instead to rely on program specific details documented in Definition of a Medicine Laptop Admission and Definition of a Critical Care Laptop Admission)
- 17:52, 2021 December 14 Ttenbergen talk contribs created page Medicine Primary Diagnosis Rate (Created page with "{{Reporting Indicators | description = Rate of ICD10 Primary Admit Diagnosis | indicator_name = {{PAGENAME}} | created_raw = Created | program = Medici...")
- 17:47, 2021 December 14 Ttenbergen talk contribs created page ICU Primary Diagnosis ICD10 Chapter Rate (Created page with "{{Reporting Indicators | description = Rate of ICD10 Chapters of Primary Admit Diagnosis | indicator_name = {{PAGENAME}} | created_raw = Created | program = Critical Care...")
- 17:47, 2021 December 14 Ttenbergen talk contribs created page ICU Primary Diagnosis APACHE Category Rate (Created page with "{{Reporting Indicators | description = Rate of APACHE Categories of Primary Admit Diagnosis | indicator_name = {{PAGENAME}} | created_raw = Created | program = Critical Ca...")
- 17:28, 2021 December 8 Ttenbergen talk contribs created page Created APACHEChronic comparison query (Created page with "Query ''Created_APACHEChronic_comparison'' is a temporary query in Centralized data front end.accdb that compares what has been coded in the ... to validate the now collec...")
- 17:23, 2021 December 8 Ttenbergen talk contribs created page Change for Apache Chronic to ICD10 from separate variable (Created page with "We used to collect Chronic Health APACHE as its own variable. When we moved to ICD10 collection we realized we would be able to tag which diagnoses make up APACHE Co...")
- 16:48, 2021 December 8 Ttenbergen talk contribs deleted page CRRT Monthly Report (evil twin of CRRT Report)
- 16:55, 2021 December 1 Ttenbergen talk contribs replaced the Cargo table Indicators with a new version
- 16:41, 2021 December 1 Ttenbergen talk contribs recreated the Cargo table Indicators
- 12:24, 2021 December 1 Ttenbergen talk contribs moved page External User Portal for the Manitoba Critical Care and Medicine Databases to Data User Portal for the Manitoba Critical Care and Medicine Databases without leaving a redirect (Text replacement - "External User Portal for the Manitoba Critical Care and Medicine Databases" to "Data User Portal for the Manitoba Critical Care and Medicine Databases")
- 17:22, 2021 November 24 Ttenbergen talk contribs recreated the Cargo table Drugs_Included
- 16:55, 2021 November 24 Ttenbergen talk contribs moved page Template:Pharmacy to Template:Drugs included without leaving a redirect
- 16:41, 2021 November 24 Ttenbergen talk contribs replaced the Cargo table Drugs_Included with a new version
- 16:25, 2021 November 24 Ttenbergen talk contribs created the Cargo table Drugs_Included
- 16:25, 2021 November 24 Ttenbergen talk contribs created page Template:Pharmacy (Created page with "<noinclude> This template should be used wherever we are including drugs in documentation, for example Pharmacy collection, Addiction, Category:Ov...")
- 12:36, 2021 November 24 Ttenbergen talk contribs deleted the Cargo table Data_Element
- 12:16, 2021 November 24 Ttenbergen talk contribs created the Cargo table Data_Element
- 10:57, 2021 November 24 Ttenbergen talk contribs created page Error "Invalid SQL statment..." when sending (Created page with "{{bug}} When sending, the process gets as far as "Centralized L_TmpV2 update/delete" and then throws an error Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE'...")
- 15:26, 2021 November 18 Ttenbergen talk contribs deleted page Query check tmp chrono boarding transfer (This was implemented as query s_tmp_check_combined_Boarding_Loc_and_TransferReadyDtTm and query s_tmp_check_combined_BL_and_TRDtTm_nonsequential)
- 15:14, 2021 November 18 Ttenbergen talk contribs moved page Length of Stay (Critical Care Report) to LOS per Service without leaving a redirect
- 15:13, 2021 November 18 Ttenbergen talk contribs deleted page LOS per Service (evil twin)
- 15:12, 2021 November 18 Ttenbergen talk contribs moved page Length of Stay (ICU Report) to Length of Stay (Critical Care Report) without leaving a redirect
- 15:09, 2021 November 18 Ttenbergen talk contribs moved page Avoidable Days in ICU to Avoidable Days (Critical Care) without leaving a redirect (Text replacement - "Avoidable Days in ICU" to "Avoidable Days (Critical Care)")
- 14:51, 2021 November 18 Ttenbergen talk contribs moved page LOS per Critical Care Unit to LOS per Location without leaving a redirect
- 14:46, 2021 November 18 Ttenbergen talk contribs deleted page Multiple encounter linking checks (This is all dealt with elsewhere now.)
- 14:32, 2021 November 18 Ttenbergen talk contribs moved page ICU Beds Occupied by Transferable Patients to Beds occupied by transferrable patients (Critical Care) without leaving a redirect
- 14:30, 2021 November 18 Ttenbergen talk contribs moved page Beds Occupied by Transferable Patients to ICU Beds Occupied by Transferable Patients without leaving a redirect
- 14:30, 2021 November 18 Ttenbergen talk contribs created page Beds Occupied by Transferable Patients (Created page with "{{Reporting Indicators | description = Avoidable Days in ICU is proportion of ICU total patient days being spent occupying an ICU bed when the patient no longer requires the i...")
- 11:03, 2021 November 18 Ttenbergen talk contribs created page OIT (Redirected page to Outcomes Improvement Team) Tag: New redirect
- 11:02, 2021 November 18 Ttenbergen talk contribs moved page WRHA Outcomes Improvement Team to Outcomes Improvement Team without leaving a redirect (Text replacement - "WRHA Outcomes Improvement Team" to "Outcomes Improvement Team")
- 15:53, 2021 November 17 Ttenbergen talk contribs deleted page Created Variables common table (evil twin of Created Variables Common table)
- 15:51, 2021 November 17 Ttenbergen talk contribs deleted page Created Variables common maker query (evil twin of Created Variables Common maker query)
- 15:40, 2021 November 17 Ttenbergen talk contribs deleted page Form:CCMDB Element (evil twin of ...Data Element...)
- 15:40, 2021 November 17 Ttenbergen talk contribs deleted page Category:CCMDB Element (evil twin of ...Data Element...)
- 15:40, 2021 November 17 Ttenbergen talk contribs deleted page Template:CCMDB Element (evil twin of ...Data Element...)
- 10:32, 2021 November 16 Ttenbergen talk contribs deleted page File:Network speed issues.pdf (outdated)
- 10:26, 2021 November 16 Ttenbergen talk contribs deleted page Changing Network Provider Order when Regional Server is not working (outdated info)
- 14:31, 2021 November 15 Ttenbergen talk contribs created page User:Ttenbergen/Relationship Diagram (Created page with "Documentation: https://github.com/SemanticMediaWiki/Mermaid/blob/master/docs/USAGE.md {{#mermaid:sequenceDiagram participant Alice participant Bob Alice->John: Hello John,...")
- 14:36, 2021 November 10 Ttenbergen talk contribs moved page Query check CCI TISS Intubation vs Intubated discontinuous to Query check CCI TISS discontinuous ETT without leaving a redirect
- 14:36, 2021 November 10 Ttenbergen talk contribs created page Query check CCI TISS Intubation vs Intubated discontinuous (Created page with "{{Data Integrity Check |DIC_summary=___ Any marked TISS Item in {{TISS w Nr | Planned extubation (TISS Item)}} or in {{TISS w Nr | Unplanned extubation (TISS Item)}} must have...")
- 22:11, 2021 November 9 Ttenbergen talk contribs deleted page Phone numbers (content was: "#redirect:Contact", and the only contributor was "Ttenbergen" (talk))
- 22:10, 2021 November 9 Ttenbergen talk contribs deleted page Contact list (content was: "#redirect:Contact")
- 22:09, 2021 November 9 Ttenbergen talk contribs created page Contact (Created page with "Contacts for the Critical Care and Medicine Database: * Medical contact: :: Dr. Allan Garland {{Discuss | Or should we use the Dept Int Med link: https://wiki.umintmed...")
- 21:51, 2021 November 9 Ttenbergen talk contribs created page Category:About (Created page with "Pages with background info about our program.")
- 21:42, 2021 November 9 Ttenbergen talk contribs created page History and Background of the Critical Care and Medicine Database (Created page with "The ICU database was created in 1988 by Dr. Dan Roberts, when he was the head of the Section of Critical Care Medicine. Creating a database from scratch is a substanti...")
- 12:51, 2021 November 3 Ttenbergen talk contribs moved page File:Remote-access-service-request-form 2020 April 2 WRHA Data collectors .pdf to File:Remote-access-service-request-form 2020 April 2 WRHA Data collectors.pdf without leaving a redirect
- 12:49, 2021 November 3 Ttenbergen talk contribs moved page File:Remote-access-service-request-form 2020 April 2 WRHA Data collectorts .pdf to File:Remote-access-service-request-form 2020 April 2 WRHA Data collectors .pdf
- 12:26, 2021 November 2 Ttenbergen talk contribs created page Query z s dispo lastUsed (Created page with "{{{PAGENAME}}} is one of the queries used to maintain the s_dispo table. It has a companion Query z s dispo inactivatable. This query will show when an entry in s_...")
- 12:26, 2021 November 2 Ttenbergen talk contribs created page Query z s dispo inactivatable (Created page with "{{{PAGENAME}}} is one of the queries used to maintain the s_dispo table. It has a companion Query z s dispo lastUsed. This query will show when an entry in s_dispo...")
- 15:31, 2021 October 28 Ttenbergen talk contribs created page Entity–attribute–value model of the L Tmp V2 table (Redirected page to L TmpV2 table#Entity–attribute–value model) Tag: New redirect
- 12:22, 2021 October 28 Ttenbergen talk contribs created page Created BoardingLoc query (Created page with "The query created_BoardingLoc in CFE and CCMDB.accdb contains the Boarding Locs for each profile. == Log == 2021-10-28 - created query == Related articles ==...")
- 16:49, 2021 October 27 Ttenbergen talk contribs moved page GRA Med to GH-Med
- 16:49, 2021 October 27 Ttenbergen talk contribs moved page GRA N3 to GH-N3
- 16:49, 2021 October 27 Ttenbergen talk contribs moved page GRA N5 to GH-N5
- 16:49, 2021 October 27 Ttenbergen talk contribs moved page GRA OVER to GH-OVER
- 16:49, 2021 October 27 Ttenbergen talk contribs moved page GRA S3 to GH-S3
- 16:49, 2021 October 27 Ttenbergen talk contribs moved page GRA W3 to GH-W3
- 16:48, 2021 October 27 Ttenbergen talk contribs moved page GRA MICU to GH-MICU
- 16:48, 2021 October 27 Ttenbergen talk contribs moved page GRA EMIP to GH-EMIP
- 16:47, 2021 October 27 Ttenbergen talk contribs moved page GRA CC to GH-CC
- 16:46, 2021 October 27 Ttenbergen talk contribs moved page GRA CAU to GH-CAU
- 16:45, 2021 October 27 Ttenbergen talk contribs moved page GRA 5S C to GH-5S C
- 16:45, 2021 October 27 Ttenbergen talk contribs moved page GRA 2S to GH-2S
- 15:20, 2021 October 27 Ttenbergen talk contribs moved page Query check CCI ICD10 Dialysis has Dx to Query check CCI ICD10 Dialysis no Dx without leaving a redirect
- 11:36, 2021 October 27 Ttenbergen talk contribs created page External User Portal for the Manitoba Critical Care and Medicine Databases (Created page with "{{DA| As requested}}")
- 11:15, 2021 October 27 Ttenbergen talk contribs created page Location (Redirected page to Boarding Loc) Tag: New redirect
- 09:55, 2021 October 25 Ttenbergen talk contribs created page Template:ICD10 Guideline Brain Injury (Created page with "<noinclude> Template to make sure extra information is consistent for the various Brain Injury diagnoses. Category:ICD10 wiki infrastructure ---- </noinclude> To code a...")
- 09:30, 2021 October 25 Ttenbergen talk contribs created page Template:ICD10 Guideline Myocarditis (Created page with "<noinclude> Template to make sure extra information is consistent for the various Myocarditis diagnoses. Category:ICD10 wiki infrastructure ---- </noinclude>Myocarditis...")
- 11:32, 2021 October 21 Ttenbergen talk contribs created page Category:Legacy Tmp check (Created page with "Category:Legacy Content Category:Data Integrity Checks")
- 10:50, 2021 October 21 Ttenbergen talk contribs deleted page Outcomes Improvement Team Quarterly ICU Report (content was: " {{TT | This is the same as Critical Care Program Quality Indicator Report, and the official name of the report is "Quality Indicator Report"; Julie is labelling it "QI Report" so we should call it "Critical Care Program Quality Indicator Report" . I need to update the references to these things. Ttenbergen 15:48, 2021 October 20 (CDT)}}", and the only contributor was "Ttenbergen" (talk))
- 10:42, 2021 October 21 Ttenbergen talk contribs moved page Directors Quarterly Report (Critical Care) to Critical Care Program Quality Indicator Report without leaving a redirect (Text replacement - "Directors Quarterly Report (Critical Care)" to "Critical Care Program Quality Indicator Report")
- 09:26, 2021 October 21 Ttenbergen talk contribs moved page ICU Mortality to Unit Mortality without leaving a redirect
- 15:29, 2021 October 20 Ttenbergen talk contribs created page Template:DxPxDateTime Instructions (Created page with "<noinclude> This template makes sure the instructions for when to use the time component of the date as well is consistent between Dx Date and Px Date. Category:CC...")
- 14:50, 2021 October 20 Ttenbergen talk contribs created page Category:Dialysis (Created page with "Pages related to dialysis")
- 14:24, 2021 October 20 Ttenbergen talk contribs created page Template:CCIWithCode (Created page with "<noinclude> This template resolved an CCI page name to "px page name (px code)" To use: ::<nowiki>{{</nowiki> {{PAGENAME}} |page name}} [[Category:CCI wiki infrastructure]...")
- 14:22, 2021 October 20 Ttenbergen talk contribs deleted page Template:Link by ICD10 code (content was: "{{#ask: Category:ICD10 Diagnosis [[Has ICD10Code::{{{1}}}]] }} <noinclude> ---- Usage: First, '''think, why am I linking by code and is that really the right thing to do?''' Should I not be linking by full name? Linking by code will break the "what links here" functionality, we should avoid it. Then, if you really need to link this way: <pre>{{Link by ICD...", and the only contributor was "Ttenbergen" (talk))
- 11:48, 2021 October 19 Ttenbergen talk contribs created page Template:Logically deleted profiles (Created page with "When the "Delete Sent Patients" button is used, part of the record is actually retained '''for 90 days'''. These retained records are for use by Cognos Report Integrator...")
- 17:10, 2021 October 7 Ttenbergen talk contribs moved page Check fundamentals for ICD10 to ICD10 Dx Checks without leaving a redirect (Text replacement - "Check fundamentals for ICD10" to "ICD10 Dx Checks")
- 15:30, 2021 October 7 Ttenbergen talk contribs created page Category:Legacy Registry check (Created page with "Category:Registry checks")
- 14:52, 2021 October 7 Ttenbergen talk contribs moved page Query NDC CLI vs DX but no TISS17 CentralLine to Query check ICD10 CLI vs CCI CentralLine without leaving a redirect (Text replacement - "Query NDC CLI vs DX but no TISS17 CentralLine" to "query check_ICD10_CLI_vs_CCI_CentralLine")
- 16:29, 2021 October 6 Ttenbergen talk contribs deleted page Critical Care Regional OpPlan (content was: "{{Report | Program = Critical Care | StartDtTm = | EndDtTm = | Frequency = | ContactPerson= | Recipients = | MailingList = | DataDependencies = | SASFiles = }} {{DJ | Added this because CAM positive (TISS Item) refers to it. What is this report? }} == Related articles == {{Related Articles}}", and the only contributor was "Ttenbergen" (talk))
- 13:50, 2021 October 5 Ttenbergen talk contribs deleted page Template:SQL (can't make it work so delete)
- 11:32, 2021 October 5 Ttenbergen talk contribs created page Template:/pre (Created page with "</pre>")
- 11:32, 2021 October 5 Ttenbergen talk contribs created page Template:Pre (Created page with "<pre>")
- 11:19, 2021 October 5 Ttenbergen talk contribs created page Template:SQL (Created page with "<noinclude> This template makes it quick to list SQL query code in a collapsable, non-interpreted format. To use: <pre>{{SQL | <the SQL code> }}</pre> ---- </noinclude>{{C...")
- 10:05, 2021 October 5 Ttenbergen talk contribs created page Template:CCI Guideline Capsule Endoscopy (Created page with "<noinclude> This template puts the guidelines for capsule endoscopies into a central place so they don't get listed inconsistently. To use: <pre>{{CCI Guideline Capsule End...")
- 15:49, 2021 October 4 Ttenbergen talk contribs created page User:Ttenbergen/pastebin (Created page with "== SMW ================================================= {{#ask: [[CommitteeMember::={{PAGENAME}}]] Category:something [[Property::something]] DICStatus::!retired V...")
- 16:55, 2021 September 29 Ttenbergen talk contribs recreated the Cargo table ICD10_Dx
- 11:42, 2021 September 29 Ttenbergen talk contribs created page Created FirstNonER BoardingLoc query (Created page with "The query L_First_Boarding_Loc_Non_ER in CFE contains the first Boarding Loc dttm for each profile. It is similar but not the same as L First Boarding Loc Non ER que...")
- 11:39, 2021 September 29 Ttenbergen talk contribs created page L First Boarding Loc Non ER query (Created page with "The query L_First_Boarding_Loc_Non_ER in CCMDB.accdb contains the first Boarding Loc and dttm for each profile. It is similar but not the same as created_FirstNonER_...")
- 10:42, 2021 September 29 Ttenbergen talk contribs moved page Cognos Hospital Discharge query to Cognos2 Hospital Discharge query without leaving a redirect
- 10:40, 2021 September 29 Ttenbergen talk contribs created page Cognos Hospital Discharge query (Created page with "{{PAGENAME}} lists records that have a corresponding Hospital Discharge DtTm and Dispo. {{Discuss | This is a work in progress. Feel free to have a look at the query and te...")
- 13:36, 2021 September 23 Ttenbergen talk contribs moved page Query check CCI TISS Dxs vs Dialysis to Query check CCI ICD10 Dialysis has Dx without leaving a redirect
- 09:34, 2021 September 23 Ttenbergen talk contribs moved page Query Check CCI CXR vs LOS to Query check CCI CXR vs LOS without leaving a redirect
- 09:33, 2021 September 23 Ttenbergen talk contribs moved page Check CCI CXR vs LOS to Query Check CCI CXR vs LOS without leaving a redirect
- 14:42, 2021 September 22 Ttenbergen talk contribs moved page Cardiac arrythmia, NOS to Cardiac arrhythmia, NOS without leaving a redirect (typo)
- 16:38, 2021 September 16 Ttenbergen talk contribs deleted page Query TISS Errors ETT consistent (evil twin of Query check CCI TISS Intubation vs Intubated)
- 15:04, 2021 September 16 Ttenbergen talk contribs deleted page Query L First Boarding loc (see Created FirstLocation query)
- 14:41, 2021 September 16 Ttenbergen talk contribs created page Query L First Boarding loc (Created page with "Utility query in CCMDB.accdb that lists the first boarding loc for each profile. == Related articles == {{Related Articles}}")
- 11:09, 2021 September 16 Ttenbergen talk contribs moved page Query Check CCI vs LOS count days to Query check CCI vs LOS count days without leaving a redirect
- 11:08, 2021 September 16 Ttenbergen talk contribs moved page Check CCI vs LOS count days to Query Check CCI vs LOS count days without leaving a redirect
- 11:05, 2021 September 16 Ttenbergen talk contribs moved page Check CCI vs LOS count each day to Check CCI vs LOS count days without leaving a redirect
- 11:05, 2021 September 16 Ttenbergen talk contribs created page Check CCI vs LOS count each day (Created page with "{{Data Integrity Check |DIC_summary=Confirm that CCI Collection Mode CCI collect count days items don't have a count > LOS. |DIC_related_concepts=LOS; Dispo DtTm;...")
- 13:31, 2021 September 8 Ttenbergen talk contribs moved page Query ''check ER Delay not too big'' to Query check ER Delay not too big without leaving a redirect (Text replacement - "Query ''check ER Delay not too big''" to "Query check_ER_Delay_not_too_big")
- 11:33, 2021 September 8 Ttenbergen talk contribs moved page Category:TISS28 checks to Category:TISS28 check without leaving a redirect (Text replacement - "TISS28 checks" to "TISS28 check")