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: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")
- 11:33, 2021 September 8 Ttenbergen talk contribs moved page Category:Legacy TISS28 checks to Category:Legacy TISS28 check without leaving a redirect (Text replacement - "Legacy TISS28 checks" to "Legacy TISS28 check")
- 11:12, 2021 September 8 Ttenbergen talk contribs deleted page WRHA Critical Care Quality Indicator Chart Report (see Directors Quarterly Report (Critical Care))
- 16:24, 2021 September 2 Ttenbergen talk contribs deleted page Query check CCI TISS per service (evil twin of Query check CCI TISS matching BoardingLoc time)
- 14:02, 2021 September 2 Ttenbergen talk contribs moved page User talk:TOstryzniuk to Manager's list without leaving a redirect
- 13:59, 2021 September 2 Ttenbergen talk contribs deleted page Temporary page to list dxs documented as requiring treatment to be coded (this might have been relevant 2 years ago but would just be strange to add now.)
- 10:58, 2021 September 2 Ttenbergen talk contribs created page Category:Legacy CCI Px check (Created page with "Category:CCI Px check")
- 10:55, 2021 September 2 Ttenbergen talk contribs created page Category:Legacy TISS28 checks (Created page with "Category:TISS28 checks")
- 10:49, 2021 September 2 Ttenbergen talk contribs deleted page Tiss28 Form Scanning (unlinked redirect)
- 10:43, 2021 September 2 Ttenbergen talk contribs created page Category:TISS28 timing checks (Created page with "Checks related to DtTms on TISS28 entries; subset of Category:TISS28 checks with related functionality so made subcategory. Category:TISS28 checks")
- 09:56, 2021 September 2 Ttenbergen talk contribs moved page Query NDC Dxs vs TISS Dialysis to Query check CCI TISS Dxs vs Dialysis without leaving a redirect (no longer a CFE NDC query)
- 16:38, 2021 September 1 Ttenbergen talk contribs created page Query check CCI TISS time means must be two (Created page with "{{Data Integrity Check | DIC_summary = If the Px Date component of a CCI Picklist has a time, then there must be a corresponding Boarding Loc entry | DIC_related_c...")
- 16:37, 2021 September 1 Ttenbergen talk contribs created page Query check CCI TISS matching BoardingLoc time (Created page with "{{Data Integrity Check | DIC_summary = If the Px Date component of a CCI Picklist has a time, then there must be a corresponding Boarding Loc entry | DIC_related_c...")
- 16:23, 2021 September 1 Ttenbergen talk contribs moved page Spontaneous breathing via ETT or Trach (TISS Item) to Spontaneous breathing via ETT without PEEP/CPAP, with or without supplemental O2 (TISS Item) without leaving a redirect (Text replacement - "Spontaneous breathing via ETT or Trach (TISS Item)" to "Spontaneous breathing via ETT without PEEP/CPAP, with or without supplemental O2 (TISS Item)")
- 16:21, 2021 September 1 Ttenbergen talk contribs deleted page Supp O2 No ETT No Trach (TISS Item) (content was: "{{TISS Item | TISS28 Row Number = 20 | TISS28 Description = Supp O2 though any device, delivered via nose, mouth, ETT or trach | TISS28 Points = 2 | TISS28 Item Number = 17 | TISS28 Comment = Row 18-21: If more than one is marked, get one with the highest points. | TISS28 Category = Respiratory Support }} == Legacy info == * Starting 2021-07-01 we changed this item f...", and the only contributor was "Ttenbergen" (talk))
- 16:18, 2021 September 1 Ttenbergen talk contribs undeleted page Supp O2 No ETT No Trach (TISS Item) (2 revisions)
- 16:17, 2021 September 1 Ttenbergen talk contribs deleted page Supp O2 No ETT No Trach (TISS Item) (see Supp O2 though any device, delivered via nose, mouth, ETT or trach (TISS Item))
- 16:13, 2021 September 1 Ttenbergen talk contribs created page Supp O2 No ETT No Trach (TISS Item) (Moved legacy info into its own section prior to renaming the page. Removed the 2 points info since that's stored in the infobox.)
- 16:11, 2021 September 1 Ttenbergen talk contribs moved page Supp O2 No ETT No Trach (TISS Item) to Supp O2 though any device, delivered via nose, mouth, ETT or trach (TISS Item) without leaving a redirect (Text replacement - "Supp O2 No ETT No Trach (TISS Item)" to "Supp O2 though any device, delivered via nose, mouth, ETT or trach (TISS Item)")
- 11:17, 2021 August 26 Ttenbergen talk contribs moved page P Count of sent query to CT Count of sent query without leaving a redirect
- 11:12, 2021 August 26 Ttenbergen talk contribs deleted page P queries (no more pivots in 2019, see CT queries)
- 11:11, 2021 August 26 Ttenbergen talk contribs deleted page P Outstanding Dispo query (see CT Outstandings Dispo query)
- 11:09, 2021 August 26 Ttenbergen talk contribs moved page P Summary Discharges FiscalYear query to CT Summary Discharges FiscalYear query without leaving a redirect
- 10:54, 2021 August 26 Ttenbergen talk contribs moved page P Summary Discharges query to CT Summary Discharges query without leaving a redirect (no more pivots)
- 10:49, 2021 August 26 Ttenbergen talk contribs moved page P Summary discharges FiscalYear query to P Summary Discharges FiscalYear query without leaving a redirect
- 10:26, 2021 August 26 Ttenbergen talk contribs moved page S tmp check combined BL and TRDtTm nonsequential to Query s tmp check combined BL and TRDtTm nonsequential without leaving a redirect
- 10:24, 2021 August 26 Ttenbergen talk contribs created page S tmp check combined BL and TRDtTm nonsequential (Created page with "{{Data Integrity Check |DIC_summary=Validates that the combiner integers for Transfer Ready DtTm tmp entry and Boarding Loc are consecutive with the date/time_vals |D...")
- 14:15, 2021 August 25 Ttenbergen talk contribs created page Query check TISS each day (Created page with "{{Data Integrity Check |DIC_summary=There needs to be at least one TISS entry in CCI Picklist for each day for each ICU profile. |DIC_related_concepts=TISS28; {{#ask:...")
- 12:00, 2021 August 25 Ttenbergen talk contribs moved page Query P Outstandings to CT Outstandings query without leaving a redirect (Text replacement - "Query P Outstandings" to "CT_Outstandings query")
- 11:39, 2021 August 25 Ttenbergen talk contribs moved page Query P Outstandings Dispo to CT Outstandings Dispo query without leaving a redirect (Text replacement - "Query P Outstandings Dispo" to "CT Outstandings Dispo query")
- 11:02, 2021 August 25 Ttenbergen talk contribs deleted page Category:P Query (see Category:CT Query)
- 11:02, 2021 August 25 Ttenbergen talk contribs moved page P Count of Admissions query to CT Count of Admissions query without leaving a redirect (Text replacement - "P Count of Admissions query" to "CT Count of Admissions query")
- 11:00, 2021 August 25 Ttenbergen talk contribs created page CT queries (Created page with "The "{{PAGENAME}}" are used by the Main office to keep track of backlogs and progress on data collection. {{#ask: Category:CT Query |format=UL |link=all |limit=1...")
- 10:58, 2021 August 25 Ttenbergen talk contribs created page Category:CT Query (Created page with "CT queries are a set of crosstab queries used by the Database Manager, Data Processor and Statistician for quick review of data collection status. Category...")
- 10:49, 2021 August 25 Ttenbergen talk contribs deleted page Manager (see Database Manager)
- 10:45, 2021 August 25 Ttenbergen talk contribs created page Database Manager (Created page with "Position previously held by p:Trish Ostryzniuk... == Related articles == {{Related Articles}} *")
- 17:04, 2021 August 24 Ttenbergen talk contribs moved page GRA PACU to GH-Recovery Room without leaving a redirect
- 10:13, 2021 August 5 Ttenbergen talk contribs created page Stevens-Johnson Syndrome (Bullous erythema multiforme) (Created page with "{{ICD10 dx | ICD10 Code=L51.1 }} {{ICD10 category|Skin}}{{ICD10 category|Heme/immunology}} == Additional Info == {{TT | currently being added ~~~~ }} == Alternate ICD10s to...")
- 16:58, 2021 August 4 Ttenbergen talk contribs deleted page Query check tmp 2 Service tmp same time (content was: "{{Data Integrity Check |DIC_summary=There can't be two Service tmp entry entries with the same date and time |DIC_related_concepts=Service tmp entry |DIC_firmness=hard check |DIC_coding=Query ''check_tmp_service_2_Service_tmp_same_time'' |DIC_implementation_date= |DIC_status=ready to implement |DIC_app=CCMDB.accdb |DIC_backlogged=No }} . {{Todo | who = Tina | todo...", and the only contributor was "Ttenbergen" (talk))
- 16:58, 2021 August 4 Ttenbergen talk contribs deleted page Query check tmp 2 Boarding Locs same time (content was: "{{Data Integrity Check |DIC_summary= There can't be two Boarding_Loc entries with the same date and time |DIC_related_concepts=Boarding_Loc |DIC_firmness=hard check |DIC_coding=Query ''check_tmp_service_2_Boarding_Locs_same_time'' |DIC_implementation_date= |DIC_status=ready to implement |DIC_app=CCMDB.accdb |DIC_backlogged=No }} . {{Todo | who = Tina | todo_added...", and the only contributor was "Ttenbergen" (talk))
- 16:58, 2021 August 4 Ttenbergen talk contribs moved page Query check tmp 2 Transfer Ready same time to Query check tmp 2 BL TR S same tm without leaving a redirect (made three queries into one)
- 16:25, 2021 August 4 Ttenbergen talk contribs moved page Query check Transfer Ready not before Boarding Loc to Query check tmp Transfer Ready not before Boarding Loc without leaving a redirect (consistency)
- 15:55, 2021 August 4 Ttenbergen talk contribs created page Query check eliminated ICD10 (Created page with "{{Data Integrity Check | DIC_summary = disallows any currently entered diagnosis that has been ''' eliminated''' | DIC_related_con...")
- 15:55, 2021 August 4 Ttenbergen talk contribs created page Query check eliminated CCI Pick (Created page with "{{Data Integrity Check | DIC_summary = disallows any currently entered diagnosis that has been ''' eliminated''' | DIC_related_con...")
- 15:54, 2021 August 4 Ttenbergen talk contribs created page Query check eliminated CCI Comp (Created page with "{{Data Integrity Check | DIC_summary = disallows any currently entered diagnosis that has been ''' eliminated''' | DIC_related_con...")
- 10:56, 2021 August 4 Ttenbergen talk contribs moved page Query check tmp service chrono boarding trasfer to Query check tmp chrono boarding transfer without leaving a redirect (typo and then some)
- 10:55, 2021 August 4 Ttenbergen talk contribs created page Query check tmp 2 Service tmp same time (Created page with "{{Data Integrity Check |DIC_summary=There can't be two Service tmp entry entries with the same date and time |DIC_related_concepts=Service tmp entry |DIC_firmness=hard che...")
- 10:54, 2021 August 4 Ttenbergen talk contribs created page Query check tmp 2 Transfer Ready same time (Created page with "{{Data Integrity Check |DIC_summary= There can't be two Transfer Ready DtTm entries with the same date and time |DIC_related_concepts=Transfer Ready DtTm |DIC_firmness=har...")
- 10:54, 2021 August 4 Ttenbergen talk contribs created page Query check tmp 2 Boarding Locs same time (Created page with "{{Data Integrity Check |DIC_summary= There can't be two Boarding_Loc entries with the same date and time |DIC_related_concepts=Boarding_Loc |DIC_firmness=hard check |DIC_c...")
- 09:46, 2021 August 4 Ttenbergen talk contribs created page Query linking pairs out of sequence/linking pairs out of sequence deleter (Created page with "Queries linking_pairs_out_of_sequence and linking_pairs_out_of_sequence_deleter are queries in CFE that are used by Populate linking pairs for making linking_pairs t...")
- 16:48, 2021 July 29 Ttenbergen talk contribs moved page Query check tmp service chrono boardind trasfer to Query check tmp service chrono boarding trasfer without leaving a redirect
- 16:48, 2021 July 29 Ttenbergen talk contribs created page Query check tmp service chrono boardind trasfer (Created page with "{{Todo | who = Tina | todo_added = 2021-07-27 | todo_action = 2021-08-10 | question = * do we have instructions where the linking integer is supposed to have meaning? discus...")
- 16:04, 2021 July 29 Ttenbergen talk contribs created page Discharge Date (Redirected page to Dispo DtTm) Tag: New redirect
- 10:23, 2021 July 28 Ttenbergen talk contribs created page Query linking pairs preList (Created page with "Query linking_pairs_preList is a query in CFE that is used by Populate linking pairs for making linking_pairs table. == Related articles == {{Related Articles}}...")
- 17:06, 2021 July 27 Ttenbergen talk contribs created page CFE Inline Integrity Checks (moved here from Change Priorities)
- 14:48, 2021 July 27 Ttenbergen talk contribs created page "Generate Person IDs" button (Redirected page to Generate Person IDs) Tag: New redirect
- 10:07, 2021 July 27 Ttenbergen talk contribs created page P queries (Created page with "The "P queries" are used by the Main office to keep track of backlogs and progress on data collection. {{#ask: Category:P Query |format=UL |link=all |limit=1000...")
- 10:05, 2021 July 27 Ttenbergen talk contribs created page Category:P Query (Created page with "P queries are a set of data processing queries. Category:Data Processing")
- 13:59, 2021 July 22 Ttenbergen talk contribs created page Change to replace Accept DtTm with first Service tmp entry, and Arrive DtTm with first Boarding Loc (Created page with "We used to collect only Admit DtTm; at some point this was split into Accept DtTm and Arrive DtTm. With the collection of Boarding Loc and Service tmp entry...")
- 13:15, 2021 July 22 Ttenbergen talk contribs moved page EPR LMS training to LMS training without leaving a redirect (Text replacement - "EPR LMS training" to "LMS training")
- 12:12, 2021 July 22 Ttenbergen talk contribs deleted page Publication Listing Test (testing orphan)
- 19:03, 2021 July 21 Ttenbergen talk contribs deleted page Error "You entered an expresion that has no value" at end of sending (content was: "#REDIRECT Error "You entered an expression that has no value" at end of sending", and the only contributor was "Ttenbergen" (talk))
- 19:02, 2021 July 21 Ttenbergen talk contribs moved page Error "You entered an expresion that has no value" at end of sending to Error "You entered an expression that has no value" at end of sending
- 15:43, 2021 July 21 Ttenbergen talk contribs deleted page Category:Potential Change (no longer using this wiki infrastructire)
- 15:37, 2021 July 21 Ttenbergen talk contribs deleted page File:Change pot.svg (no longer used)
- 15:37, 2021 July 21 Ttenbergen talk contribs deleted page Template:Potential Change (no longer used)
- 13:38, 2021 July 21 Ttenbergen talk contribs moved page Gamma knife to Template:CCI Guideline Gamma Knife without leaving a redirect (consistent naming, and turning this into a template.)
- 15:07, 2021 July 19 Ttenbergen talk contribs created page User:Rlabossiere (Redirected page to p:Rosanne Labossiere-Gee) Tag: New redirect
- 14:55, 2021 July 19 Ttenbergen talk contribs changed group membership for Rlabossiere from (none) to CCMDB_legit
- 14:55, 2021 July 19 User account Rlabossiere talk contribs was created by Ttenbergen talk contribs and password was sent by email
- 16:26, 2021 July 15 Ttenbergen talk contribs moved page NCD dx implying death across encounters to Query NCD dx implying death across encounters without leaving a redirect (consistency)
- 15:41, 2021 July 15 Ttenbergen talk contribs moved page Check dx implying death across encounters to NCD dx implying death across encounters without leaving a redirect (Text replacement - "Check dx implying death across encounters" to "NCD_dx_implying_death_across_encounters")
- 14:57, 2021 July 15 Ttenbergen talk contribs created page LSusp button (Redirected page to Correcting suspect links) Tag: New redirect
- 14:12, 2021 July 15 Ttenbergen talk contribs moved page Check TISS Intubation consistent to Query check CCI InExtubation consistent without leaving a redirect (no longer done in TISS, if we want to do it at all it has to be in CCI and should be in CCMDB.)
- 10:02, 2021 July 15 Ttenbergen talk contribs created page ADL Score (Created page with "{{Reporting Indicators | description = Indicator of help needed with Activities of Daily Living (ADLs) | indicator_name = ADL Score | created_raw = Created | program = Medic...")
- 15:39, 2021 July 14 Ttenbergen talk contribs created page Collection location documentation (Created page with "We document collection locations using the Template:Collection Location. They can all be viewed on Site and Location table. However, much of that is from before Pati...")
- 14:10, 2021 July 14 Ttenbergen talk contribs created page Form:Reporting Indicators (Created page with "<noinclude> This is the "Reporting Indicators" form. To create a page with this form, enter the page name below; if a page with that name already exists, you will be sent to a...")
- 13:56, 2021 July 14 Ttenbergen talk contribs created page Form:Report (Created page with "<noinclude> This is the "Report" form. To create a page with this form, enter the page name below; if a page with that name already exists, you will be sent to a form to edit...")
- 09:09, 2021 July 14 Ttenbergen talk contribs created page Hemodialysis days (Created page with "{{Reporting Indicators | description = (one sentence description of indicator) | indicator_name = {{PAGENAME}} | created_raw = (Created / Raw) | program = (Critical Care / M...")
- 09:09, 2021 July 14 Ttenbergen talk contribs created page Tracheostomy days (Created page with "{{Reporting Indicators | description = (one sentence description of indicator) | indicator_name = {{PAGENAME}} | created_raw = (Created / Raw) | program = (Critical Care / M...")
- 17:32, 2021 July 13 Ttenbergen talk contribs moved page 72hr Readmission Rate to ICU to Readmission Rate to ICU without leaving a redirect (as per Julie's request)
- 17:28, 2021 July 13 Ttenbergen talk contribs created page Beds occupied by transferrable patients (Medicine) (Created page with "{{Reporting Indicators | description = Medicine beds occupied by transferrable patients | indicator_name = {{PAGENAME}} | created_raw = Created | program = Medicine | indica...")
- 17:10, 2021 July 13 Ttenbergen talk contribs created page CRRT Report (Created page with "{{Report | Program = Critical Care | StartDtTm = | EndDtTm = | Frequency = | ContactPerson= <names, organization if outside of Shared Health> | Recipients = <names> | Mailing...")
- 16:42, 2021 July 13 Ttenbergen talk contribs moved page Director's chart report to Director's Chart Report without leaving a redirect (It's a proper noun)
- 16:10, 2021 July 13 Ttenbergen talk contribs deleted page Directors Quarterly Report - Activity Summary (nothing links here and we already have a page for quarterly reports)
- 16:05, 2021 July 13 Ttenbergen talk contribs created page Directors Quarterly Report (Medicine) (Created page with "{{Report | Program = Medicine | StartDtTm = | EndDtTm = | Frequency = quarterly | ContactPerson= <names, organization if outside of Shared Health> | Recipients = Distributio...")
- 16:04, 2021 July 13 Ttenbergen talk contribs created page Directors Quarterly Report (Critical Care) (Created page with "{{Report | Program = Medicine | StartDtTm = | EndDtTm = | Frequency = quarterly | ContactPerson= <names, organization if outside of Shared Health> | Recipients = Distributio...")
- 15:55, 2021 July 13 Ttenbergen talk contribs created page Transfer Delay (Medicine) (Created page with "{{Data_element | field_name = Transfer Delay | element_description = '''Transfer Delay''' is the difference between Dispo_DtTm and Transfer_Ready_DtTm in decimal days...")
- 15:55, 2021 July 13 Ttenbergen talk contribs created page Transfer Delay (Critical Care) (Created page with "{{Data_element | field_name = Transfer Delay | element_description = '''Transfer Delay''' is the difference between Dispo_DtTm and Transfer_Ready_DtTm in decimal days...")
- 15:44, 2021 July 13 Ttenbergen talk contribs created page Directors Annual Report (Medicine) (Created page with "{{Report | Program = Critical Care and Medicine | StartDtTm = | EndDtTm = | Frequency = quarterly | ContactPerson= <names, organization if outside of Shared Health> | Recipien...")
- 15:44, 2021 July 13 Ttenbergen talk contribs created page Directors Annual Report (Critcal Care) (Created page with "{{Report | Program = Critical Care and Medicine | StartDtTm = | EndDtTm = | Frequency = quarterly | ContactPerson= <names, organization if outside of Shared Health> | Recipien...")
- 14:24, 2021 July 13 Ttenbergen talk contribs created page MediaWiki:Mytalk (don't want anything listed there)
- 14:18, 2021 July 13 Ttenbergen talk contribs created page MediaWiki:Vector.css (Created page with "All CSS here will be loaded for users of the Vector skin: #ca-talk { display:none!important; } hide discussion tab: ")
- 13:36, 2021 July 13 Ttenbergen talk contribs created page Outcomes Improvement Team Quarterly ICU Report (Created page with "{{Report | Program = Critical Care | StartDtTm = | EndDtTm = | Frequency = quarterly | ContactPerson= <names, organization if outside of Shared Health> | Recipients = <names>...")
- 16:38, 2021 July 8 Ttenbergen talk contribs deleted page Eyes button (no more eyes button)
- 16:10, 2021 July 8 Ttenbergen talk contribs deleted page Category:EPR Reports Integrator (No more EPR Reports Integrator)
- 16:09, 2021 July 8 Ttenbergen talk contribs deleted page EPR Reports Integrator (No more EPR Reports Integrator)
- 15:49, 2021 July 8 Ttenbergen talk contribs deleted page SL EPR Logs table (No more EPR Reports Integrator)
- 15:37, 2021 July 8 Ttenbergen talk contribs deleted page 'add/open' button (No more EPR Reports Integrator)
- 15:34, 2021 July 8 Ttenbergen talk contribs deleted page EPR Logs form (No more EPR Reports Integrator)
- 15:31, 2021 July 8 Ttenbergen talk contribs deleted page Exporting EPR Reports for EPR Reports Integrator (No more EPR Reports Integrator)
- 15:31, 2021 July 8 Ttenbergen talk contribs deleted page Import EPR Reports button (No more EPR Reports Integrator)
- 15:30, 2021 July 8 Ttenbergen talk contribs deleted page View EPR Reports button (No more EPR Reports Integrator)
- 15:04, 2021 July 8 Ttenbergen talk contribs created page LAU (Created page with "LAU, or Lower Acuity Units, are wards operated at Vic and Oak by family medicine for lower acuity patients. We don't collect on these units. <!-- this is an index page so that...")
- 14:48, 2021 July 8 Ttenbergen talk contribs created page Template:ICD10 Guideline Stroke resolved exception (Created page with "<noinclude> This template encodes an exception that likely needs to be mentioned in a bunch of places. Category:ICD10 Coding Guidelines ---- </noinclude> === Comorbid_...")
- 09:36, 2021 July 8 Ttenbergen talk contribs created page Change from Awaiting/delayed dx codes to Transfer Ready DtTm (Created page with "Until 2021-07-01 we coded a patient's reason for delay as ICD10 Category:Awaiting/delayed transfer code. After that, we are coding it as a value/item under Transfer Rea...")
- 16:45, 2021 July 7 Ttenbergen talk contribs created page Category:Main Office PC (Created page with "Pages about main office PCs, and info that might be required to re-image them. Category:IT Instructions")
- 16:38, 2021 July 7 Ttenbergen talk contribs created page Statistician's PC (Created page with "This page contains information that might be required by anyone who needs to do a re-build on the Statistician's computer. == Special Software installed == === SAS === *...")
- 10:14, 2021 July 7 Ttenbergen talk contribs created page Pulling fresh data when push/pull is not being done (Created page with "When the Data Processor is away, Push/Pull doesn't happen. To still get the newest data, do the following: == Instructions == # manual...")
- 11:46, 2021 June 29 Ttenbergen talk contribs created page MediaWiki:Passwordreset-success-details-generic (Created page with "If the information submitted is valid, a password reset email will be sent. If you haven't received an email, we recommend that you visit the mw:Special:MyLanguage/Help:Rese...")
- 11:31, 2021 June 29 Ttenbergen talk contribs created page Upgrading from Office/Access 2010 to 2019 (Created page with "We can pull the update from Microsoft Office version 2010 to 2019 ourselves. == Instructions == # Consider if this is a good time for the update; it takes about half an h...")
- 16:36, 2021 June 28 Ttenbergen talk contribs created page "set COVID and isolation" button (Created page with "The {{PAGENAME}} on the Patient Viewer Tab Dispo in CCMDB.accdb will enter the ICD10 and CCI Picklist entries for a COVID patient as per COVID-19_(SARS-COV-2)#Isolat...")
- 16:25, 2021 June 24 Ttenbergen talk contribs moved page HSC and STB ICUs CRRT Days by Patient to CRRT Monthly Report without leaving a redirect
- 09:37, 2021 June 24 Ttenbergen talk contribs created page Query check Transfer Ready not before Boarding Loc (Created page with "{{Data Integrity Check |DIC_summary=Validates that the DtTm for a Transfer_Ready_DtTm_tmp entry is not before its matching Boarding Loc entry |DIC_related_concepts=Boa...")
- 09:14, 2021 June 24 Ttenbergen talk contribs created page Changing the Access 2019 ribbon colour (Created page with "Office 2019/Access 2019 uses a red ribbon by default. You can change this. == Instructions == # Open Access # Click '''File''', '''Account''' # Change '''Office Theme''' fro...")
- 16:38, 2021 June 15 Ttenbergen talk contribs created page WRHA Critical Care Quality Indicator Chart Report (Created page with "{{Report | Program = Critical Care | StartDtTm = | EndDtTm = | Frequency = | ContactPerson= | Recipients = | MailingList = | DataDependencies = | SASFiles = }} {{DJ |...")
- 16:38, 2021 June 15 Ttenbergen talk contribs created page Critical Care Regional OpPlan (Created page with "{{Report | Program = Critical Care | StartDtTm = | EndDtTm = | Frequency = | ContactPerson= | Recipients = | MailingList = | DataDependencies = | SASFiles = }} {{DJ |...")
- 15:34, 2021 June 15 Ttenbergen talk contribs created page ClientVisitGUID (Redirected page to Hospitalization ID) Tag: New redirect
- 16:17, 2021 June 10 Ttenbergen talk contribs created page Palliative (Created page with "{{Reporting Indicators | description = Palliative... | indicator_name = Palliative ... | created_raw = Created | program = Critical Care | indicator_start_date = | indicato...")
- 12:18, 2021 June 10 Ttenbergen talk contribs recreated the Cargo table ICD10_Category
- 11:02, 2021 June 10 Ttenbergen talk contribs created page Hospitalization ID (Created page with "{{Data element |field_name=Person_ID |CCMDB_label=N/A |in_table=L Log table, L Person table |data_type=number |datafield_length=long integer |program_collecting=Med and CC |cr...")
- 09:47, 2021 June 10 Ttenbergen talk contribs deleted page Broken/ (content was: "test", and the only contributor was "Ttenbergen" (talk))
- 14:26, 2021 June 9 Ttenbergen talk contribs created page Query Form Cognos2 Service Starter latest previous entry finder (Created page with "{{TT | No idea how this is used, it can likely go, but not ready to test right now. ~~~~}} == Log == * 2021-06-09 not sure when query was made, just documenting it today ==...")
- 14:08, 2021 June 9 Ttenbergen talk contribs created page Query Cognos2 sub Services VADT finder (Created page with "Used by patient copier button in service area of Patient Viewer Tab Cognos ADT2 to acquire the correct Visit Admit DtTm for the new profile. == Log == * 2021-06-09 qu...")
- 16:26, 2021 June 3 Ttenbergen talk contribs created page LOS per Service (Created page with "{{Reporting Indicators | description = ... | indicator_name = {{PAGENAME}} | created_raw = Created | program = Critical Care | indicator_start_date = 2020-10-15 <!-- patient...")
- 15:39, 2021 June 3 Ttenbergen talk contribs created page LOS per Critical Care Unit (Created page with "{{Reporting Indicators | description = ... | indicator_name = {{PAGENAME}} | created_raw = Created | program = Critical Care | indicator_start_date = 1988-07-11 }} {{DJ | J...")
- 15:01, 2021 June 3 Ttenbergen talk contribs deleted page Reset Button (button deleted, and no reason this should be kept as legacy info)
- 13:56, 2021 June 3 Ttenbergen talk contribs moved page Check Inf Pathogens must have Infection requiring pathogen or Potential Infection to Query Check Inf Pathogens must have Infection requiring pathogen or Potential Infection without leaving a redirect (Text replacement - "Check Inf Pathogens must have Infection requiring pathogen or Potential Infection" to "query Check_Inf_Pathogens_must_have_Infection_requiring_pathogen_or_Potential_Infection")
- 13:41, 2021 June 2 Ttenbergen talk contribs deleted page LOS Record (evil twin of LOS Per Record)
- 15:54, 2021 May 20 Ttenbergen talk contribs created page Cognos Import Button (convenience redirect) Tag: New redirect
- 15:43, 2021 May 20 Ttenbergen talk contribs created page Beta testing (Created page with "We generally roll out changes to CCMDB.accdb to all laptops, and have everyone test them, because we don't have designated testers, or a full test...")
- 09:21, 2021 May 18 Ttenbergen talk contribs created page HSC ALC Medicine Service (Created page with "The HSC Services in Cognos include a set of "HSC ALC Medicine" services: * HSC ALC Medicine / Panel Appr PCH * HSC ALC Medicine / Panel in Process * HSC ALC Medicine / CIVP...")
- 20:42, 2021 May 13 Ttenbergen talk contribs created the Cargo table ICD10_Dx
- 20:42, 2021 May 13 Ttenbergen talk contribs created the Cargo table ICD10_Category
- 15:58, 2021 May 12 Ttenbergen talk contribs created page !CognosComparer.accdb (Created page with "{{PAGENAME}} is a tool to import a range of Cognos dumps for comparison. It gets huge and is slow, so we can't just keep a running tally in there, but this allows analysis of...")
- 10:44, 2021 May 7 Ttenbergen talk contribs moved page Starting an Entry to Making a new wiki page without leaving a redirect (I couldn't even find it under that name)
- 16:36, 2021 May 6 Ttenbergen talk contribs created page Change of remaining location names from "our" names to EPR/Cognos names (Created page with "We use different names for locations in s_dispo table (Previous Location, Pre-admit Inpatient Institution, Dispo) than in Cognos EPR Report, and sometimes...")
- 16:15, 2021 May 5 Ttenbergen talk contribs created page Template:DJ (Created page with "<noinclude>using this so much I wanted a quicker way to type it. </noinclude> <includeonly>{{Discuss | who=Julie | question = {{{1}}} }}</includeonly>")
- 16:14, 2021 May 5 Ttenbergen talk contribs created page Admit DtTm (Created page with "Admit DtTm is not as simple of a concept as it might seem, and it's definition and storage in our database has changed over time. This page gives some definitions and how we h...")
- 13:38, 2021 May 5 Ttenbergen talk contribs moved page Lost/missing charts to Lost/missing chart without leaving a redirect (should be singular for better linking)
- 22:24, 2021 April 29 Ttenbergen talk contribs moved page HSC/STB ICUs CRRT Days by Patient to HSC and STB ICUs CRRT Days by Patient without leaving a redirect (Text replacement - "HSC/STB ICUs CRRT Days by Patient" to "HSC and STB ICUs CRRT Days by Patient")
- 22:10, 2021 April 29 Ttenbergen talk contribs moved page Re-admission to Readmission without leaving a redirect (Text replacement - "Re-admission" to "Readmission")
- 21:58, 2021 April 29 Ttenbergen talk contribs deleted page Category:DC TX (deleting empty category)
- 10:45, 2021 April 29 Ttenbergen talk contribs created page Template:First Service and Boarding Loc same (Created page with "<noinclude> We decided during Task Team Meeting - Rolling Agenda and Minutes 2021#ICU Database Task Group Meeting – April 22, 2021 that the first Service tmp entry D...")
- 10:29, 2021 April 29 Ttenbergen talk contribs moved page Query s tmp Boarding Loc Service first same to Query check tmp Boarding Loc Service first same without leaving a redirect
- 10:14, 2021 April 29 Ttenbergen talk contribs created page Query s tmp Boarding Loc Service first same (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=...")
- 09:42, 2021 April 29 Ttenbergen talk contribs created page Directors Quarterly Report - Activity Summary (Created page with "{{Report | Program = Critical Care and Medicine | StartDtTm = | EndDtTm = | Frequency = quarterly | ContactPerson= <names, organization if outside of Shared Health> | Recipien...")
- 17:07, 2021 April 28 Ttenbergen talk contribs created page HSC ICUs Data by Patient (Created page with "{{Report | Program = Critical Care | StartDtTm = Aug 2018 | EndDtTm = | Frequency = monthly | ContactPerson= Barbara Osorio | Recipients = <names> | MailingList = <Outlook lis...")
- 17:07, 2021 April 28 Ttenbergen talk contribs created page STB ICUs CAM Rate, VAP Rate, CLIBSI Rate Summary (Created page with "{{Report | Program = Critical Care | StartDtTm = Nov 2013 | EndDtTm = | Frequency = monthly | ContactPerson= Brett Hiebert | Recipients = Brett Hiebert | MailingList = | Data...")
- 16:46, 2021 April 28 Ttenbergen talk contribs created page CRRT Days (Created page with "{{Reporting Indicators | description = Number of days pts have CRRT | indicator_name = {{PAGENAME}} | created_raw = Created | program = Critical Care | indicator_start_da...")
- 16:44, 2021 April 28 Ttenbergen talk contribs created page HSC/STB ICUs CRRT Days by Patient (Created page with "{{Report | Program = < one of Critical Care, Medicine, Critical Care and Medicine > | StartDtTm = Jan 2016 | EndDtTm = | Frequency = <eg monthly, quarterly, annually, as reque...")
- 16:42, 2021 April 28 Ttenbergen talk contribs recreated the Cargo table Reports
- 16:05, 2021 April 28 Ttenbergen talk contribs created page Reports Documentation Status (Created page with "This page automatically lists articles about Reports we use in reporting, and the issues that have been identified with those indicators. == List of Reports pages that c...")
- 15:48, 2021 April 28 Ttenbergen talk contribs recreated the Cargo table Reports
- 15:37, 2021 April 28 Ttenbergen talk contribs created the Cargo table Reports
- 15:37, 2021 April 28 Ttenbergen talk contribs created the Cargo table Indicators
- 15:19, 2021 April 28 Ttenbergen talk contribs created page Central Line Day (Created page with "{{Reporting Indicators | description = Number of days pts have Central Lines | indicator_name = Reporting Indicators | created_raw = Created | program = Critical Care | i...")
- 15:14, 2021 April 28 Ttenbergen talk contribs created page Indicators (Created page with "{{#cargo_query: tables=Indicators |fields=Reports._pageName=fieldAlias1, CONCAT("",foo, "")=name, |order by=Reports._pageName |limit=1000 |default=no results were found |...")
- 15:12, 2021 April 28 Ttenbergen talk contribs created page HSC MICU/SICU Central Line Days by patient (Created page with "{{Report | Program = < one of Critical Care, Medicine, Critical Care and Medicine > | StartDtTm = April 2015 | EndDtTm = | Frequency = monthly | ContactPerson= Sonja Musto |...")
- 14:51, 2021 April 28 Ttenbergen talk contribs created page Category:Reports (Created page with "Pages related to Reports. Category:Statistical Analysis Category:Reporting")
- 14:49, 2021 April 28 Ttenbergen talk contribs created page Reports (Created page with "This will contain an automatic listing of reports. == Related articles == {{Related Articles}} *")
- 14:48, 2021 April 28 Ttenbergen talk contribs created page Template:Report (Created page with "<noinclude> ==Template Use== This tempalte is to be used in articles about reports to make sure they are consistent and listed in Reports and Indicators and that the r...")
- 16:42, 2021 April 21 Ttenbergen talk contribs created page Created AdmitDtTm query (Created page with "The query created_FirstService in CFE contains the "admit date and time" of a profile according to the different definitions used over time. {{TT | Details to come }} =...")
- 16:31, 2021 April 21 Ttenbergen talk contribs created page Created FirstService query (Created page with "The query created_FirstService in CFE will... details to come == Related articles == {{Related Articles}} Category: Data structure")
- 16:30, 2021 April 21 Ttenbergen talk contribs created page Created FirstLocation query (Created page with "The query created_FirstLocation in CFE will... details to come == Related articles == {{Related Articles}} Category: Data structure")
- 16:16, 2021 April 21 Ttenbergen talk contribs created page S GCS eye query (Created page with "Filters s_GCS table for only items with ''gcs_type'' = "eye". == Related articles == {{Related Articles}} Category: Data structure")
- 16:16, 2021 April 21 Ttenbergen talk contribs created page S GCS motor query (Created page with "Filters s_GCS table for only items with ''gcs_type'' = "motor". == Related articles == {{Related Articles}} Category: Data structure")
- 16:16, 2021 April 21 Ttenbergen talk contribs created page S GCS verbal query (Created page with "Filters s_GCS table for only items with ''gcs_type'' = "verbal". == Related articles == {{Related Articles}} Category: Data structure")
- 16:05, 2021 April 21 Ttenbergen talk contribs moved page S GCS to S GCS table without leaving a redirect (consistency of data table pages)
- 15:25, 2021 April 21 Ttenbergen talk contribs moved page Tracheostomy, presence to Tracheostomy creation over a redirect without leaving a redirect
- 15:25, 2021 April 21 Ttenbergen talk contribs deleted redirect Tracheostomy creation by overwriting (Deleted to make way for move from "Tracheostomy, presence")
- 15:16, 2021 April 21 Ttenbergen talk contribs moved page Tracheostomy creation (TISS Item) to Trach Tube Present (TISS Item) without leaving a redirect
- 14:51, 2021 April 21 Ttenbergen talk contribs moved page Category:Created variables CC table to Category:Created Variables CC table without leaving a redirect
- 14:37, 2021 April 21 Ttenbergen talk contribs moved page Category:Created variables common table to Category:Created Variables Common table without leaving a redirect
- 14:28, 2021 April 21 Ttenbergen talk contribs moved page Created variables common table to Created Variables Common table without leaving a redirect
- 14:28, 2021 April 21 Ttenbergen talk contribs moved page Created variables common maker query to Created Variables Common maker query without leaving a redirect
- 14:26, 2021 April 21 Ttenbergen talk contribs created page Created variables common table (Created page with "The Created_variables_common table is a programmatically populated table in CFE containing the values created by Created variables common maker query|''created_variables...")
- 14:26, 2021 April 21 Ttenbergen talk contribs created page Created variables common maker query (Created page with "<onlyinclude>The created_variables common_maker query in CFE generates some calculated values used for Critical Care and Medicine...")
- 14:17, 2021 April 21 Ttenbergen talk contribs moved page Created variables CC maker query to Created Variables CC maker query without leaving a redirect (Text replacement - "Created variables" to "Created Variables")
- 14:17, 2021 April 21 Ttenbergen talk contribs moved page Created variables common maker query to Created Variables common maker query without leaving a redirect (Text replacement - "Created variables" to "Created Variables")
- 14:17, 2021 April 21 Ttenbergen talk contribs moved page Created variables common table to Created Variables common table without leaving a redirect (Text replacement - "Created variables" to "Created Variables")
- 14:17, 2021 April 21 Ttenbergen talk contribs moved page Created variables CC table to Created Variables CC table without leaving a redirect (Text replacement - "Created variables" to "Created Variables")
- 14:14, 2021 April 21 Ttenbergen talk contribs undeleted page Category:Created variables CC table (5 revisions) (guess it's an automatic "table" type category, so we should have it after all.)
- 14:06, 2021 April 21 Ttenbergen talk contribs deleted page Category:Created variables CC table (see Category:Created Variables)
- 14:04, 2021 April 21 Ttenbergen talk contribs created page Category:Created Variables (Created page with "Pages related to the concept of "Created Variables" in CFE. Category:Data Use")
- 14:01, 2021 April 21 Ttenbergen talk contribs moved page Created variables common to Created variables common table without leaving a redirect (reverting to name incl "table")
- 14:01, 2021 April 21 Ttenbergen talk contribs deleted page Created variables common table (reverting to full name)
- 14:57, 2021 April 15 Ttenbergen talk contribs deleted page Accept DtTm Equiv (not used any more)
- 14:49, 2021 April 15 Ttenbergen talk contribs moved page Query query s tmp check Boarding Loc and TransferReadyDtTm pairs to Query s tmp check Boarding Loc and TransferReadyDtTm pairs without leaving a redirect (duplication in name)
- 11:55, 2021 April 14 Ttenbergen talk contribs created page Microsoft Office version (Created page with "CCMDB.accdb uses MS Access 2010, which is part of MS Office 2010. Upgrading any part of MS Office breaks functionality, even if MS Access is left as 2010. Support for MS O...")
- 16:13, 2021 April 8 Ttenbergen talk contribs moved page Trach Tube Present (TISS Item) to Tracheostomy creation (TISS Item) without leaving a redirect (had been moved in error)
- 16:13, 2021 April 8 Ttenbergen talk contribs moved page CVC presence, any location to CVC placement, any location over a redirect without leaving a redirect (had been moved in error)
- 16:13, 2021 April 8 Ttenbergen talk contribs deleted redirect CVC placement, any location by overwriting (Deleted to make way for move from "CVC presence, any location")
- 17:09, 2021 April 7 Ttenbergen talk contribs moved page Tracheostomy creation to Tracheostomy, presence (definition and name tweaked)
- 17:06, 2021 April 7 Ttenbergen talk contribs moved page CVC placement, any location to CVC presence, any location
- 16:12, 2021 April 7 Ttenbergen talk contribs moved page Query NDC TISS Spontaneous vs ETT Trach to Query check CCI TISS spont breath no tube without leaving a redirect (old name was convention for CFE but this would now be in CCMDB where convention is different)
- 13:34, 2021 April 7 Ttenbergen talk contribs moved page Query s tmp check combined Boarding Loc and TransferReadyDtTm pairs to Query query s tmp check Boarding Loc and TransferReadyDtTm pairs without leaving a redirect (name too long for MS Access)
- 13:32, 2021 April 7 Ttenbergen talk contribs created page Query s tmp check combined Boarding Loc and TransferReadyDtTm pairs (Created page with "{{Data Integrity Check |DIC_summary=Validates that there are only matching pairs of Transfer Ready DtTm tmp entry and Boarding Loc as per Template:Combined instruct...")
- 16:02, 2021 April 1 Ttenbergen talk contribs created page Drug-induced immunosuppression (Created page with "{{ICD10 dx | ICD10 Code=U92.25 }} {{ICD10 category|Misc}}{{ICD10 category|Heme/Immunology}} == Additional Info == As decided Task_Team_Meeting_-_Rolling_Agenda_and_Minute...")
- 14:16, 2021 April 1 Ttenbergen talk contribs created page Category:Differences between Critical Care and Medicine (Created page with "Pages that discuss differences in how data is collected between Critical Care and Medicine. Just starting this 2020-04-01, no joke, so quite incomplete. This will be useful to...")
- 13:45, 2021 April 1 Ttenbergen talk contribs created page Template:Timing for ALERT vs APACHE (Created page with "<noinclude> To keep info consistent why Selection and timing of APACHE components and [[]] use different criteria. Category: ALERT Scale </noinclude>=== Timing of AL...")
- 11:23, 2021 April 1 Ttenbergen talk contribs created page Template:ICD10 Guideline Admit vs Acquired (Created page with "<noinclude> This template is used in Comorbid Diagnosis and Admit Diagnosis to give consistent instructions when to use either or neither. To use: <pre>{{ICD10 Guid...")
- 09:39, 2021 April 1 Ttenbergen talk contribs moved page Query check ICD10 Inf Potential Infection must have pathogen or alt combined code to Query check ICD10 Inf Potential Infection must have pathogen or alt without leaving a redirect (Access can't handle a query name that long)
- 12:14, 2021 March 31 Ttenbergen talk contribs moved page Query check CCI TISS vs Pharmacy to Query check CCI TISS Pharm Vasoactive without leaving a redirect (no meaning without)
- 12:07, 2021 March 31 Ttenbergen talk contribs moved page Query NDC TISS vs pharmacy to Query check CCI TISS vs Pharmacy without leaving a redirect (consistency)
- 11:54, 2021 March 31 Ttenbergen talk contribs moved page Check Inf Potential Infection must have pathogen or alt combined code to Query check ICD10 Inf Potential Infection must have pathogen or alt combined code without leaving a redirect (consistency)
- 11:12, 2021 March 31 Ttenbergen talk contribs deleted page Query check transfer ready tmp one per Boarding Loc (was an evil twin of query check_transfer_ready_tmp_for_each_Boarding_Loc to start with...)
- 15:01, 2021 March 24 Ttenbergen talk contribs created page Query s tmp check combined Boarding Loc and TransferReadyDtTm (Created page with "{{Data Integrity Check |DIC_summary=Validates that there are only matching pairs of Transfer Ready DtTm tmp entry and Boarding Loc as per Template:Combined instruct...")
- 14:43, 2021 March 24 Ttenbergen talk contribs created page Template:Combined instructions for Transfer Ready DtTm and Boarding Loc (Created page with "<noinclude>This template holds info that should be the same on Transfer Ready DtTm tmp entry and Boarding Loc. </noinclude>==Combining Transfer Ready DtTm tmp entry...")
- 11:10, 2021 March 23 Ttenbergen talk contribs deleted the Cargo table Newsflash
- 10:40, 2021 March 23 Ttenbergen talk contribs created page Unknown patient (Redirected page to John or Jane Doe patient) Tag: New redirect
- 10:01, 2021 March 19 Ttenbergen talk contribs deleted page "Test" code tag (can't find any reference of whatever I was doing here, so deleting.)
- 16:19, 2021 March 18 Ttenbergen talk contribs recreated the Cargo table Discussions
- 15:24, 2021 March 18 Ttenbergen talk contribs deleted page Template:Newsflash (we never actually implemented this and I doubt it would be adopted if I finished it, so cleaning it up.)
- 15:24, 2021 March 18 Ttenbergen talk contribs deleted page Newsflash (we never actually implemented this and I doubt it would be adopted if I finished it, so cleaning it up.)
- 14:32, 2021 March 18 Ttenbergen talk contribs created page Delete button (Created page with "Could mean one of the following: * ♻️ button * "Delete Sent Patients" button")
- 13:37, 2021 March 18 Ttenbergen talk contribs created page Surgery (made automatic listing page just for completeness, absence caused redlinks)
- 13:31, 2021 March 18 Ttenbergen talk contribs created page 0 D RawData table (Created page with "The '''0_D_RawData''' table in DSM_Labs_data.accdb is used during the import process to temporarily store the raw data. == Data Structure == It's temporary, just see the...")
- 13:17, 2021 March 18 Ttenbergen talk contribs created page Lost/missing charts (Created page with "{{Discuss | Working on std instructions on what to do about lost charts. More to come. }} == Related articles == {{Related Articles}} Category: Data Collection Guide")
- 18:59, 2021 March 4 Ttenbergen talk contribs moved page Sub CognosImport to Function CognosImport without leaving a redirect (Text replacement - "Sub CognosImport" to "Function CognosImport")
- 15:58, 2021 March 4 Ttenbergen talk contribs deleted page Employee Assistance Program (was never filled in and there must be better sources)
- 15:45, 2021 March 4 Ttenbergen talk contribs deleted page Category:Paperwork (category was almost empty and not meaningful, so emptied it and deleting)
- 15:44, 2021 March 4 Ttenbergen talk contribs created page Category:Legacy Forms (Created page with "Category:Forms")
- 15:37, 2021 March 4 Ttenbergen talk contribs deleted page TISS28 Implementation (This is about how a new process was implemented. The process is now retired. There is nothing in here that affects use of the data the process generated. So, deleting.)
- 11:52, 2021 March 4 Ttenbergen talk contribs deleted page Spam Quarantine Notification from IronPort (No more IronPot)
- 12:24, 2021 February 12 Ttenbergen talk contribs created page Chastity (Redirected page to Decision Support Services#Contact) Tag: New redirect
- 16:50, 2021 February 11 Ttenbergen talk contribs created page Proposed future changes to Location and Transfer Ready and related fields (Created page with "For legacy reasons, we collect general location info in Boarding Loc info in the L TmpV2 table. We decided at some task meeting to change the name of this to just "Uni...")
- 14:40, 2021 February 11 Ttenbergen talk contribs created page ♻️ button (Created page with "The {{PAGENAME}} deletes a patient.")
- 14:01, 2021 February 4 Ttenbergen talk contribs created page CFE Log (Redirected page to Centralized data front end.accdb Change Log 2021) Tag: New redirect
- 15:50, 2021 February 3 Ttenbergen talk contribs deleted page Service Boarding Transfer Chrono (evil twin of query check_transfer_ready_tmp_LT_first_Boarding_Loc)
- 15:18, 2021 February 3 Ttenbergen talk contribs moved page Check has transfer ready entry to Query check has transfer ready date or checkbox without leaving a redirect
- 19:38, 2021 January 28 Ttenbergen talk contribs deleted page Query check check transfer DtTm during admission (content was: "#REDIRECT Query check transfer DtTm during admission", and the only contributor was "Ttenbergen" (talk))
- 19:38, 2021 January 28 Ttenbergen talk contribs moved page Query check check transfer DtTm during admission to Query check transfer DtTm during admission
- 19:30, 2021 January 28 Ttenbergen talk contribs moved page Query check transfer ready tmp LT first Boarding Loc to Query check transfer ready tmp for each Boarding Loc without leaving a redirect
- 19:29, 2021 January 28 Ttenbergen talk contribs moved page Query check transfer ready tmp GT Dispo to Query check check transfer DtTm during admission without leaving a redirect (combined several)
- 18:09, 2021 January 28 Ttenbergen talk contribs moved page Query heck CCI TISS Vented without mechanism to Query check CCI TISS Vented without mechanism without leaving a redirect
- 18:02, 2021 January 28 Ttenbergen talk contribs moved page Check CCI TISS Vented without mechanism to Query heck CCI TISS Vented without mechanism without leaving a redirect
- 17:42, 2021 January 28 Ttenbergen talk contribs moved page Query TISS Errors Vent vs mechanism to Check CCI TISS Vented without mechanism without leaving a redirect
- 17:04, 2021 January 28 Ttenbergen talk contribs moved page Query NDC TISS Extubation only on TISS Intubated days to Query check CCI TISS Intubation vs Intubated without leaving a redirect (Text replacement - "Query NDC TISS Extubation only on TISS Intubated days" to "query check_CCI_TISS_Intubation_vs_Intubated")
- 16:28, 2021 January 28 Ttenbergen talk contribs moved page Check dx implying death must be dispo deceased to Query check ICD10 dx implying death must have appropriate dispo without leaving a redirect (Text replacement - "Check dx implying death must be dispo deceased" to "query check_ICD10_dx_implying_death_must_have_appropriate_dispo")
- 14:54, 2021 January 28 Ttenbergen talk contribs moved page Check has service entry to Query check has service entry without leaving a redirect (Text replacement - "Check has service entry" to "query check has service entry")
- 19:43, 2021 January 27 Ttenbergen talk contribs created page Query J in-process records (Created page with "Query '''J_in-process_records''' is a query in CFE that shows which records that have been completed by Data Collectors but have outstanding processing by the Data P...")
- 19:25, 2021 January 27 Ttenbergen talk contribs created page Query check transfer ready tmp one per Boarding Loc (Created page with "{{Data Integrity Check | DIC_summary = There should be exactly one Transfer Ready DtTm tmp entry for each Boarding Loc of a profile | DIC_related_concepts = Transfer R...")
- 19:15, 2021 January 27 Ttenbergen talk contribs created page Query check transfer ready tmp LT first Boarding Loc (Created page with "{{Data Integrity Check | DIC_summary = Transfer Ready DtTm tmp entry should never be before the first Boarding Loc of a profile | DIC_related_concepts = Transfer Ready...")
- 17:49, 2021 January 27 Ttenbergen talk contribs created page Query check transfer ready tmp GT Dispo (Created page with "{{Data Integrity Check | DIC_summary = Transfer Ready DtTm tmp entry should never be later than Dispo DtTm | DIC_related_concepts = Transfer Ready DtTm tmp entry; Disp...")
- 17:37, 2021 January 27 Ttenbergen talk contribs moved page P Outstandings query to Query P Outstandings without leaving a redirect (Text replacement - "P Outstandings query" to "query P_Outstandings ")
- 17:29, 2021 January 27 Ttenbergen talk contribs created page Query P Outstandings Dispo (Created page with "Query P_Outstandings_Dispo is a query in CFE. *'''Purpose''' : Summarizes the pending patients who are no longer in the unit or ward for each laptop by their Dispo DtT...")
- 14:59, 2021 January 27 Ttenbergen talk contribs deleted page Some button (testing only)
- 14:53, 2021 January 27 Ttenbergen talk contribs created page Some button (Created page with "test")
- 14:49, 2021 January 27 Ttenbergen talk contribs created page 👀 button (Created page with "test")
- 12:33, 2021 January 26 Ttenbergen talk contribs created page Project CognosDataEmail (Created page with "{{Project |ProjectActive=active |ProjectProgram=CC |ProjectRequestor=Internal |ProjectCollectionStartDate=2021-01-26 |Project={{PAGENAME}} }} Process for bad data in Cognos...")
- 16:09, 2021 January 21 Ttenbergen talk contribs deleted page Query NDC CLI AcqDX but NoCLI DateinTMPV2 (no more tmp cli)
- 16:08, 2021 January 21 Ttenbergen talk contribs deleted page Query NDC CLI No AcqDX but CLI DateinTMPV2 (content was: "{{Data Integrity Check |DIC_summary=Checks for Patients who have a CLI tmp entry but not the corresponding dx. |DIC_related_concepts=Iatrogenic, infection, central venous catheter-related bloodstream infection (CVC-BSI, CLI); QA Infection CLI |DIC_firmness=hard check |DIC_timing=complete |DIC_coding=query ''query NDC CLI AcqDX but NoCLI DateinTMPV2'' |DIC_implementation_date=2018/11/06 |DIC_status=needs review |DIC_LProblem=No |DIC_app=Centralized data front end.accdb }} {{TT...")
- 15:22, 2021 January 21 Ttenbergen talk contribs created page Eyes button (Redirected page to Process for bad data in Cognos) Tag: New redirect
- 15:21, 2021 January 21 Ttenbergen talk contribs created page Clock button (Redirected page to Cognos2 No Service or Loc in some time query) Tag: New redirect
- 15:21, 2021 January 21 Ttenbergen talk contribs created page ⏱ Button (Redirected page to Cognos2 No Service or Loc in some time query) Tag: New redirect
- 15:05, 2021 January 21 Ttenbergen talk contribs deleted page File:Patient Type Flowchart.gif (This has not been used in some time, and as per Admit Type for APACHE II it is out-of-date)
- 13:28, 2021 January 21 Ttenbergen talk contribs deleted page User:Jthiessen (removed unused broken redirect)
- 13:23, 2021 January 21 Ttenbergen talk contribs deleted page ICU Database Task Group (removed unused redirect from old name)
- 13:21, 2021 January 21 Ttenbergen talk contribs deleted page Pending macro (unlinked broken redirect)
- 13:18, 2021 January 21 Ttenbergen talk contribs deleted page User:JWinestock (unlinked broken redirect)
- 13:18, 2021 January 21 Ttenbergen talk contribs deleted page User:Fquezon (unlinked broken redirect)
- 13:18, 2021 January 21 Ttenbergen talk contribs deleted page User talk:Fquezon (unlinked broken redirect)
- 13:17, 2021 January 21 Ttenbergen talk contribs deleted page Peptic Ulcer (there are multiple codes now and they include the words so no need for this.)
- 13:12, 2021 January 21 Ttenbergen talk contribs undeleted page Query TISS Errors missing days (14 revisions) (we still have forms coming in...)
- 13:07, 2021 January 21 Ttenbergen talk contribs deleted page Query TISS Errors missing days (replaced by CCMDB.accdb checks query check_CCI_TISS_NrDays_GT_LOS and query check_CCI_TISS_NrDays_LT_LOS]])
- 12:28, 2021 January 21 Ttenbergen talk contribs created page Query check CCI TISS NrDays LT LOS (Created page with "{{Data Integrity Check | DIC_summary = There are more TISS Item Px_Dates than there are days between the first Service tmp entry and Dispo DtTm | DIC_related_conce...")
- 12:11, 2021 January 21 Ttenbergen talk contribs moved page Query check CCI TISS each day to Query check CCI TISS NrDays GT LOS without leaving a redirect (need to break the check in two, one can run early)
- 00:06, 2021 January 21 Ttenbergen talk contribs created page Query check CCI TISS each day (Created page with "{{Data Integrity Check | DIC_summary = There has to be a TISS entry in CCI Picklist with a Px_Date for each date between Accept DtTm and Dispo DtTm | DIC_relat...")
- 23:49, 2021 January 20 Ttenbergen talk contribs created page Query check CCI TISS per service (Created page with "{{Data Integrity Check | DIC_summary = There has to be at least one TISS entry for each Service tmp entry. | DIC_related_concepts = CCI Picklist; Service tmp entry | DIC_f...")
- 22:19, 2021 January 20 Ttenbergen talk contribs created page Query check CCI TISS if no then none (Created page with "{{Data Integrity Check | DIC_summary = If No TISS Item (TISS Item) in CCI Picklist there must be no other entry from TISS Item List in CCI Picklist, and vice v...")
- 13:39, 2021 January 19 Ttenbergen talk contribs deleted page Cognos integrator query (defunct)
- 13:32, 2021 January 19 Ttenbergen talk contribs deleted page Cognos import table (defunct)
- 13:29, 2021 January 19 Ttenbergen talk contribs deleted page Cognos processed table (defunct)
- 13:27, 2021 January 19 Ttenbergen talk contribs deleted page Cognos import processor query (defunct)
- 11:19, 2021 January 19 Ttenbergen talk contribs created page Template:= (Created page with "<noinclude> Template to allow using equal sign in another template. Use {{=}} in template. Without this you might get "not summarized" etc as content. </noinclude>=")
- 21:58, 2021 January 15 Ttenbergen talk contribs created page Query check tmp ER Boarding Loc should exist if from ER (Created page with "{{Data Integrity Check |DIC_summary=For patients with Previous Location ER at same site there should be a Boarding Loc ER. |DIC_related_concepts=Boarding Loc, Previou...")
- 21:16, 2021 January 15 Ttenbergen talk contribs created page Query check tmp Service and Boarding Loc during admission timeframe (Created page with "{{Data Integrity Check |DIC_summary=Service tmp entry values must be consistent with the Program |DIC_related_concepts=Service tmp entry; Program |DIC_firmness=hard ch...")
- 20:54, 2021 January 15 Ttenbergen talk contribs created page Query check tmp service and program consistency (Created page with "{{Data Integrity Check |DIC_summary=Service tmp entry values must be consistent with the Program |DIC_related_concepts=Service tmp entry; Program |DIC_firmness=hard ch...")
- 20:42, 2021 January 15 Ttenbergen talk contribs moved page Query Service or Location Duplicate to Query check tmp service or location duplicate without leaving a redirect (consistency)
- 20:35, 2021 January 15 Ttenbergen talk contribs created page Query Service or Location Duplicate (Created page with "{{Data Integrity Check |DIC_summary=Service tmp entryand Boarding_Loc entries must not have duplicate dates and services resp. locations and comments |DIC_related_conc...")
- 13:08, 2021 January 14 Ttenbergen talk contribs deleted page Cognos Discharger (No more Cognos Discharger)
- 13:07, 2021 January 14 Ttenbergen talk contribs deleted page Cognos Discharger FormQuery query (removed as part of deleting Cognos Discharger)
- 13:00, 2021 January 14 Ttenbergen talk contribs deleted page Cognos Admitter (Cognos Admitter is no more.)
- 13:00, 2021 January 14 Ttenbergen talk contribs deleted page "EMIP" button (removed as part of removing Cognos Admitter)
- 12:53, 2021 January 14 Ttenbergen talk contribs deleted page Cognos Admitter FormQuery query (removed as part of deleting Cognos_Admitter)
- 12:29, 2021 January 14 Ttenbergen talk contribs deleted page Cognos Admit filter table (removed as partr of cleaning out Cognos Admitter)
- 12:25, 2021 January 14 Ttenbergen talk contribs deleted page "Mine! Mine!" button (gone after removal of Cognos Admitter)
- 12:20, 2021 January 14 Ttenbergen talk contribs deleted page Patient Viewer Tab Cognos ADT (replaced by Patient Viewer Tab Cognos ADT)
- 11:51, 2021 January 14 Ttenbergen talk contribs deleted page Using Cognos Report Integrator to keep track of patients (no-longer-valid process that leaves no trail in data, so deleting page.)
- 11:37, 2021 January 14 Ttenbergen talk contribs created page Process for bad data in Cognos (Created page with "Occasionally collectors will find data that is wrong in Cognos Report Integrator. This page explains what to do about it. {{TT | * It was decided at Task_Team_Meeting...")
- 11:22, 2021 January 14 Ttenbergen talk contribs deleted page Cognos Patient viewer tab FormQuery query (This query was removed with the original Cognos ADT tab)
- 15:21, 2021 January 12 Ttenbergen talk contribs created page Post COVID-19 condition (Created page with "{{ICD10 dx | ICD10 Code=U07.4 }} {{ICD10 category|Misc}} {{DA | what other categories }} == Additional Info == == Alternate ICD10s to consider coding instead or in addition...")
- 22:28, 2021 January 6 Ttenbergen talk contribs created page Patient Viewer Tab Pharm Flow (Created page with "This article is about the '''Pharm Flow tab''' in Patient viewer, which is used for Pharmacy collection. == Related Articles == {{Related Articles}} Category:Pati...")
- 17:48, 2021 January 6 Ttenbergen talk contribs moved page Close - WITH or NO Updates button to Close - WITH or NO Updates buttons without leaving a redirect
- 17:42, 2021 January 6 Ttenbergen talk contribs created page Close - WITH or NO Updates button (Created page with "{{TT | Needs content }} == Related articles == {{Related Articles}} Category: Patient Viewer Category: CCMDB.accdb Category: CCMDB forms")
- 16:18, 2021 January 6 Ttenbergen talk contribs created page Patient Viewer Tab ADL (for completeness, we should have a page for this tab)
- 11:40, 2021 January 5 Ttenbergen talk contribs created page Cognos2 UnitStarter query (Created page with "{{TT | Needs more}} {{PAGENAME}} is the query that drives CUS. == Related articles == {{Related Articles}} Category:Cognos2")
- 11:40, 2021 January 5 Ttenbergen talk contribs created page CUS (Redirected page to Cognos2 Unit Starter) Tag: New redirect
- 21:38, 2021 January 2 Ttenbergen talk contribs created page Cognos2 No Service or Loc in some time query (Created page with "{{PAGENAME}} is used as part of Using Cognos2 to keep track of patients to list '''profiles where the newest Service tmp or Boarding Loc entry is more than 14 days...")
- 21:17, 2021 January 1 Ttenbergen talk contribs created page Task Team Meeting - Rolling Agenda and Minutes 2021 (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 | explanat...")
- 21:08, 2021 January 1 Ttenbergen talk contribs created page Centralized data front end.accdb Change Log 2021 (Created page with "__NOTOC__ <!-- This hides the table of contents so collectors can immediately see the most recent change without scrolling. --> ''see the :Category: Development Documentatio...")
- 21:03, 2021 January 1 Ttenbergen talk contribs created page CCMDB.accdb Change Log 2021 (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...")
- 20:58, 2021 January 1 Ttenbergen talk contribs created page CE (Redirected page to Cognos2 Ender) Tag: New redirect
- 17:21, 2020 December 31 Ttenbergen talk contribs created page File:Patient Copy button.png (screen shot of Patient copier button used on Patient Viewer Tab Cognos ADT2 and Patient List)
- 17:21, 2020 December 31 Ttenbergen talk contribs uploaded File:Patient Copy button.png (screen shot of Patient copier button used on Patient Viewer Tab Cognos ADT2 and Patient List)
- 16:03, 2020 December 31 Ttenbergen talk contribs moved page Cognos2 import Cognos2 Services query to Cognos3 import Cognos2 Services query without leaving a redirect (new query replaced old)
- 16:03, 2020 December 31 Ttenbergen talk contribs moved page Cognos2 import Cognos2 Units query to Cognos3 import Cognos2 Units query without leaving a redirect (new query replaced old)
- 15:09, 2020 December 23 Ttenbergen talk contribs created page Selection and timing of APACHE components (Created page with "This page explains how to select physiological or GCS values for entry into Apache fields in CCMDB.accdb. == Instructions == Choose the worst value that occu...")
- 12:03, 2020 December 23 Ttenbergen talk contribs created page The value you entered isn't valid for this field (Created page with "{{bug}} If a field is entered in a format that doesn't follow what MS Access expects, there is an error: <pre> The value you entered isn't valid for this field. For example,...")
- 11:35, 2020 December 23 Ttenbergen talk contribs deleted page Date and Time formats (evil twin of Date and Time Format; unlinked)
- 14:25, 2020 December 17 Ttenbergen talk contribs moved page PL SamePhin Diff LN FN DOB Sex to PL SamePhin Diff DOB Sex without leaving a redirect (Text replacement - "PL SamePhin Diff LN FN DOB Sex" to "PL_SamePhin_Diff_DOB_Sex")
- 11:54, 2020 December 16 Ttenbergen talk contribs created page TISS28 Collection Guide (Created page with "This pages explains how TISS28 is coded. See TISS Item List for the list of things that are collected. == Collection instructions == * Collect any it...")
- 11:38, 2020 December 16 Ttenbergen talk contribs moved page TISS28 Collection Guide to TISS28 Legacy Guide for Paper Form Collection without leaving a redirect
- 11:32, 2020 December 16 Ttenbergen talk contribs moved page Limited TISS28 Collection to Limiting of TISS28 Collection without leaving a redirect
- 11:31, 2020 December 16 Ttenbergen talk contribs created page Limited TISS28 Collection (Created page with "Overall work load for TISS28 collection was high, so it was decided to limit the number of items collectors collectors would do TISS quality checks. Quality assurance che...")
- 23:07, 2020 December 15 Ttenbergen talk contribs created page Cognos import3 table (Created page with "<onlyinclude>'''{{PAGENAME}}''' is an administrative-only, temporary table in CCMDB.mdb. It contains the data provided by the Cognos EPR Report during processing of th...")
- 22:52, 2020 December 15 Ttenbergen talk contribs moved page Test code tag to "Test" code tag without leaving a redirect
- 22:18, 2020 December 15 Ttenbergen talk contribs created page Test code tag (Created page with "We currently use different names for locations in s_dispo table (Previous Location, Pre-admit Inpatient Institution, Dispo) than in Cognos EPR Report, and...")
- 20:27, 2020 December 15 Ttenbergen talk contribs moved page Definition of an ICU admission to Definition of a Critical Care Laptop Admission without leaving a redirect (Text replacement - "Definition of an ICU admission" to "Definition of a Critical Care Laptop Admission")
- 16:17, 2020 December 15 Ttenbergen talk contribs created page SBGH Swing Beds (Created page with "A swing bed entry is used "as a placeholder to virtually locate a patient when their not physically on the unit such as in the Operating Room. " <!-- as per Chastity 2020-12-0...")
- 16:13, 2020 December 15 Ttenbergen talk contribs created page GH-SWAP Location (Created page with "Also see the EPR manual in the Citrix folder from where you open EPR. A wap location is used when a pt is swapped form one bed to another. These show up in Cognos EPR Re...")
- 11:04, 2020 December 15 Ttenbergen talk contribs moved page Definition of a Medicine Service admission to Definition of a Medicine Laptop Admission without leaving a redirect (Text replacement - "Definition of a Medicine Service admission" to "Definition of a Medicine Laptop Admission")
- 13:50, 2020 December 14 Ttenbergen talk contribs created page Prone positioning (Created page with "{{CCI PickList Procedure |CCI_Picklist_Code=7.SC.01.TP |CCI_Collection_Mode=CCI collect first |StartDate=2020-12-14 }} {{CCI category|Misc Px}} ==Additional Info== ==Alterna...")
- 19:01, 2020 December 10 Ttenbergen talk contribs created page DatePicker generated date looks different than usual until saved (Created page with "{{Bug}} When a field in Access contains a date value, then Access automatically shows a DatePicker tool (calendar) to help populate the date. We use tools like this in all our...")
- 17:47, 2020 December 8 Ttenbergen talk contribs created page Tables and queries not hidden in CCMDB.accdb (Created page with "{{Bug needing input}} When CCMDB.accdb opens, the panel on the left where one can see tables, queries etc should automatically collapse. For at least one data collector (...")
- 10:57, 2020 December 8 Ttenbergen talk contribs moved page Reporting Indicators Documentation Health to Reporting Indicators Documentation Status without leaving a redirect
- 10:48, 2020 December 8 Ttenbergen talk contribs created page Reporting Indicators Documentation Health (Created page with "This page automatically lists articles about indicators we use in reporting, and the issues that have been identified with those indicators. {{#ask: Category:Indicators...")
- 00:37, 2020 December 8 Ttenbergen talk contribs created page User:Ttenbergen/questions remaining from Cognos changes (Created page with "{{#ask: Category:EPR Reports Integrator AND Category:Questions |?DiscussQuestion |?DiscussWHO |default=none found }}")
- 20:23, 2020 December 3 Ttenbergen talk contribs created page Change of GRA location names from "our" names to EPR/Cognos names (Created page with "We currently use different names for locations in s_dispo table (Previous Location, Pre-admit Inpatient Institution, Dispo) than in Cognos EPR Report, and...")
- 11:20, 2020 December 3 Ttenbergen talk contribs moved page Sorting Cognos Admitter freezes program to Sorting in PatientList breaks when some Cognos Entries are done without leaving a redirect (that's really what's happening, so better page name.)
- 17:43, 2020 December 2 Ttenbergen talk contribs deleted page Flagging for TISS (no longer a separate thing from TISS quality checks since we could do most cross checks in CCMDB now)
- 17:38, 2020 December 2 Ttenbergen talk contribs deleted page Checking TISS Data from CCMDB.accdb (evil twin of Flagging for TISS)
- 16:14, 2020 December 2 Ttenbergen talk contribs recreated the Cargo table TISS_Items
- 15:55, 2020 December 2 Ttenbergen talk contribs recreated the Cargo table TISS_Items
- 15:48, 2020 December 2 Ttenbergen talk contribs recreated the Cargo table TISS_Items
- 15:47, 2020 December 2 Ttenbergen talk contribs recreated the Cargo table TISS_Items
- 15:45, 2020 December 2 Ttenbergen talk contribs recreated the Cargo table TISS_Items
- 15:43, 2020 December 2 Ttenbergen talk contribs created the Cargo table TISS_Items
- 13:09, 2020 December 2 Ttenbergen talk contribs created page Category:Cognos Issue (Created page with "Pages about, or including, issues related to the Cognos EPR Report. Category:Cognos Report Integrator")
- 12:58, 2020 December 2 Ttenbergen talk contribs created page Wrong service or unit entries in Cognos (Created page with "Sometimes Cognos EPR Report contains info on units or services that never happened. Some of these are Patient record or move shows in Cognos but not in EPR, but someti...")
- 10:54, 2020 December 2 Ttenbergen talk contribs created page CCI collect each day (Redirected page to Template:CCI collect each day) Tag: New redirect
- 10:40, 2020 December 2 Ttenbergen talk contribs created page Template:CCI collect each day (Created page with "<noinclude>This page gives instructions for CCI Collection for CCI Collection Mode - {{PAGENAME}} items. This is the mode used for TISS Item List CCI entries. =...")
- 23:26, 2020 November 26 Ttenbergen talk contribs created page Cognos Integrator forms not returning to the line you were on when you close Patient Viewer (Created page with "{{Bug}} Once a patient is entered from one of the Cognos forms, and Patient Viewer is closed, any currently open Cognos form is refreshed since the edit to the patient mi...")
- 15:29, 2020 November 26 Ttenbergen talk contribs created page Schedules of Attending Physicians (Created page with "In some circumstances it helps to know who is attending when and where to make sense of whether a patient meets our Definition of a Medicine Service admission / Definiti...")
- 12:39, 2020 November 26 Ttenbergen talk contribs created page Patient Viewer Tab CCI Comp (Created page with "This article is about the '''CCI_Comp tab''' in Patient viewer. The tab contains the L_CCI_Component subform for CCI Collection. == Related Articles == {{Relate...")
- 12:38, 2020 November 26 Ttenbergen talk contribs moved page Patient Viewer Tab CCI to Patient Viewer Tab CCI Pick without leaving a redirect (this was split into two tabs long ago)
- 22:18, 2020 November 25 Ttenbergen talk contribs created page Cognos2 Units table (Created page with "{{PAGENAME}} contains the units and their start and end dttm from the Cognos EPR Report. It is populated by Sub CognosImport. == Data Structure == {| class="wikitabl...")
- 22:18, 2020 November 25 Ttenbergen talk contribs created page Cognos2 Services table (Created page with "{{PAGENAME}} contains the services and their start and end dttm from the Cognos EPR Report. It is populated by Sub CognosImport. == Data Structure == {| class="wikit...")
- 22:17, 2020 November 25 Ttenbergen talk contribs created page Cognos2 OneTime table (Created page with "{{PAGENAME}} contains the parts of the Cognos EPR Report that are only needed once per patient visit. It is populated by Sub CognosImport. == Data Structure == {| cl...")
- 21:59, 2020 November 25 Ttenbergen talk contribs created page Cognos2 import Cognos2 Services query (Created page with "Query run by Sub CognosImport to populate Cognos2_Services table. == Related articles == {{Related Articles}} Category:Cognos Report Integrator")
- 21:59, 2020 November 25 Ttenbergen talk contribs created page Cognos2 import Cognos2 OneTime query (Created page with "Query run by Sub CognosImport to populate Cognos2_OneTime table. == Related articles == {{Related Articles}} Category:Cognos Report Integrator")
- 21:59, 2020 November 25 Ttenbergen talk contribs created page Cognos2 import Cognos2 Units query (Created page with "Query run by Sub CognosImport to populate Cognos2_Units table. == Related articles == {{Related Articles}} Category:Cognos Report Integrator")
- 21:03, 2020 November 25 Ttenbergen talk contribs created page Using Cognos2 to keep track of patients (Created page with "This page explains how the components of Cognos2 should be used together to keep track of patients. Cognos2 consists of the following components: * Cognos2 Ender *...")
- 17:37, 2020 November 25 Ttenbergen talk contribs created page Cognos Report Time Limits (Created page with "We use Cognos EPR Report data as part of Using Cognos Report Integrator to keep track of patients resp Using Cognos2 to keep track of patients. This page gives exp...")
- 17:28, 2020 November 25 Ttenbergen talk contribs created page Cognos downtime procedure (Created page with "We use Cognos EPR Report data as part of Using Cognos Report Integrator to keep track of patients resp Using Cognos2 to keep track of patients. This page gives exp...")
- 17:12, 2020 November 25 Ttenbergen talk contribs created page Cognos2 Unit Starter (Created page with "{{PAGENAME}} lists new unit entries that came in on the Cognos EPR Report and matches them to the likely local record they belong to. It's part of Cognos2 and can be o...")
- 14:05, 2020 November 25 Ttenbergen talk contribs created page CSS (Redirected page to Cognos2 Service Starter) Tag: New redirect
- 19:48, 2020 November 24 Ttenbergen talk contribs created page Visit Admit DtTm (Redirected page to Visit Admit DtTm field) Tag: New redirect
- 12:11, 2020 November 24 Ttenbergen talk contribs created page Mediawiki extension Network (Created page with "https://www.mediawiki.org/wiki/Extension:Network {{#network: COVID-19 (SARS-COV-2)}} == Related articles == {{Related Articles}} Category:Semantic Mediawiki")
- 12:07, 2020 November 23 Ttenbergen talk contribs created page Processes around changing a PatientFollow assignment (Created page with "Patients are assigned to collectors using the PatientFollow Project. This page explains what needs to happen when an assignment is changed. == Process for the collector...")
- 12:31, 2020 November 20 Ttenbergen talk contribs created page Carrier of infectious disease, unspecified (Created page with "{{ICD10 dx |ICD10 Code=Z22.9 |StartDate=2020-11-20 }} {{ICD10 category|Infection requiring pathogen}} {{ICD10 category|Infectious disease}}")
- 01:42, 2020 November 20 Ttenbergen talk contribs created page Change to collect TISS data in CCI Picklist (Created page with "We are changing the collection and storage of TISS data to enter it directly into the CCI Picklist form. == Collection instructions == {{Discuss | These will come shortl...")
- 15:43, 2020 November 19 Ttenbergen talk contribs moved page Cognos Service Starter to Cognos2 Service Starter without leaving a redirect (Text replacement - "Cognos Service Starter" to "Cognos2 Service Starter")
- 22:48, 2020 November 13 Ttenbergen talk contribs deleted page Ed's Medicine PDA Reader run time error 5 (bug in a long defunct program)
- 21:31, 2020 November 13 Ttenbergen talk contribs deleted page Category:CCVSM (no more ccvsm)
- 14:07, 2020 November 10 Ttenbergen talk contribs moved page Cognos Ender to Cognos2 Ender without leaving a redirect (consistency)
- 00:43, 2020 November 6 Ttenbergen talk contribs created page Cognos2 matcher query (Created page with "Populates Cognos Service Starter. == Related articles == {{Related Articles}} Category:Cognos2")
- 00:43, 2020 November 6 Ttenbergen talk contribs created page Cognos2 sub Units FormQuery query (Created page with "Populates Patient Viewer Tab Cognos ADT2. == Related articles == {{Related Articles}} Category:Cognos2")
- 00:43, 2020 November 6 Ttenbergen talk contribs created page Cognos2 sub Services FormQuery query (Created page with "Populates Patient Viewer Tab Cognos ADT2. == Related articles == {{Related Articles}} Category:Cognos2")
- 21:48, 2020 November 5 Ttenbergen talk contribs created page Template:PrePrevDispo listing (Created page with "<noinclude> consistency in explanation what should be entered between Pre-admit Inpatient Institution, Previous Location, Service/Location and Dispo. </noincl...")
- 20:51, 2020 November 5 Ttenbergen talk contribs created page L Problems D ID table (Created page with "A table Julie and Pagasa set up in CFE (or is it in Centralized data.mdb?) to store D_IDs where we ran into some problems, e.g. in Instructions for importing a batch...")
- 14:17, 2020 November 5 Ttenbergen talk contribs created page Cognos Ender (Created page with "{{PAGENAME}} lists the service or unit endings that came in on the Cognos EPR Report and facilitates getting old records updated or finished with the new info. It's part o...")
- 13:30, 2020 November 5 Ttenbergen talk contribs created page Patient Viewer Tab Cognos ADT2 (Created page with "{{PAGENAME}} is a new tab in Patient Viewer. It splits the service info and unit info in Cognos EPR Report into two chronological tables to make them easy to review an...")
- 13:28, 2020 November 5 Ttenbergen talk contribs created page Cognos Service Starter (Created page with "{{PAGENAME}} lists the patient services that came in on the Cognos EPR Report and facilitates getting new records started, or updating existing records with the new servic...")
- 13:21, 2020 November 5 Ttenbergen talk contribs created page Cognos2 (Created page with "Cognos2 is a new way to look at the Cognos data that should be more friendly than the old one. Being set up as of 2020-11-04, more info to come. == Related articles == {{R...")
- 13:19, 2020 November 5 Ttenbergen talk contribs created page Category:Cognos2 (Created page with "Pages related to the Cognos2.")
- 13:18, 2020 November 5 Ttenbergen talk contribs created page SL Cognos2 Service exclusions table (Created page with "<onlyinclude>'''{{PAGENAME}}''' is an administrative-only, temporary table in CCMDB_data.mdb. It contains units that should be hidden in Cognos Report Integrator. It...")
- 13:18, 2020 November 5 Ttenbergen talk contribs created page SL Cognos2 Unit exclusions table (Created page with "<onlyinclude>'''{{PAGENAME}}''' is an administrative-only, temporary table in CCMDB_data.mdb. It contains units that should be hidden in Cognos Report Integrator. It...")
- 12:46, 2020 November 4 Ttenbergen talk contribs created page What is a service admission (Created page with "This page is about how we can cross-check a service admission in Cognos against EPR. It turns out that the definition of this was done through orders in the past, and someti...")
- 11:01, 2020 November 4 Ttenbergen talk contribs moved page S Cognos Locations table to S Cognos Units table without leaving a redirect
- 11:00, 2020 November 4 Ttenbergen talk contribs deleted page S Cognos Locations additions needed query (content was: "#REDIRECT S Cognos Units additions needed query", and the only contributor was "Ttenbergen" (talk))
- 10:59, 2020 November 4 Ttenbergen talk contribs moved page S Cognos Locations additions needed query to S Cognos Units additions needed query
- 10:53, 2020 November 4 Ttenbergen talk contribs moved page Cognos SubServices additions needed query to S Cognos Services additions needed query without leaving a redirect
- 10:47, 2020 November 4 Ttenbergen talk contribs moved page Cognos dispo translator additions needed query to S Cognos Locations additions needed query without leaving a redirect (Text replacement - "Cognos dispo translator additions needed query" to "s_Cognos_Locations_additions_needed query")
- 10:33, 2020 November 4 Ttenbergen talk contribs moved page Cognos dispo translator table to S Cognos Locations table without leaving a redirect (Text replacement - "Cognos dispo translator table" to "s_Cognos_Locations table")
- 10:31, 2020 November 4 Ttenbergen talk contribs moved page "Make B Loc" button to "Make loc" button without leaving a redirect (Text replacement - ""Make B Loc" button" to ""Make loc" button")
- 10:24, 2020 November 4 Ttenbergen talk contribs moved page Cognos SubServices table to S Cognos Services table without leaving a redirect (Text replacement - "Cognos SubServices table" to "s_Cognos_Services table")
- 21:04, 2020 November 1 Ttenbergen talk contribs deleted page Swing bed (see Swap locations)
- 20:58, 2020 November 1 Ttenbergen talk contribs created page Swing bed (Created page with "This is really just a page to put a "related pages" link to keep track of where and how this is used. == Related articles == {{Related Articles}}")
- 20:47, 2020 November 1 Ttenbergen talk contribs created page STB CICU Admissions start at Arrive DtTm (Created page with " {{Discuss | * The following needs to live somewhere, but I can't figure out where it needs to go right now, so leaving it here for now. '''Does the following also go for ST...")
- 12:38, 2020 October 28 Ttenbergen talk contribs deleted page Identifying ICU admissions (replaced by the Cognos Report Integrator and other pages. Links to this page have been updated as relevant to context.)
- 15:17, 2020 October 23 Ttenbergen talk contribs moved page TISS Items SMW to TISS Item List without leaving a redirect (Who cares about the SMW part, that's just confusing in a page title.)
- 16:16, 2020 October 22 Ttenbergen talk contribs created page Template:Site Med page common content (Created page with "<noinclude>This template contains the content that is common to the wiki pages for the <site>_Med Service/Location entries. ---- </noinclude> === ...as a Boarding...")
- 17:05, 2020 October 21 Ttenbergen talk contribs created page Maltreatment (Created page with "{{ICD10 dx |ICD10 Code=T74 |StartDate=2020/10/21 }}")
- 11:54, 2020 October 21 Ttenbergen talk contribs moved page S PatientFollow distribution query to S PatientFollow distribution thisLaptop query without leaving a redirect (was built under wrong name)
- 11:53, 2020 October 21 Ttenbergen talk contribs created page S PatientFollow distribution query (Created page with "s_PatientFollow_distribution_thisLaptop query filters the s_PatientFollow_distribution table. It is opened by the "Show PatientFollow allocation" button. == Rela...")
- 11:44, 2020 October 21 Ttenbergen talk contribs created page "Show PatientFollow allocation" button (Created page with "Placeholder")
- 23:50, 2020 October 20 Ttenbergen talk contribs created page "Make Service" button (Created page with "The {{PAGENAME}} on the Patient Viewer Tab Cognos ADT in CCMDB.accdb will turn the current Service Start Dtm of and Service name into a Service tmp entry. The drop...")
- 15:42, 2020 October 20 Ttenbergen talk contribs created page Template:Location dropdown cleanup (Created page with "<noinclude>Template to ensure consistent messaging on this topic. ---- </noinclude>=== "Can we remove the items that are no longer Service/Locations, Previous Locatio...")
- 23:48, 2020 October 18 Ttenbergen talk contribs deleted page Template:Guideline CAU vs Boarding Loc vs EMIP (There are no longer any special collection instructions for CAUs since they are no longer part of ER.)
- 22:30, 2020 October 18 Ttenbergen talk contribs created page Parked in ER (moved new instructions to this page from Parked in ER tmp entry which was renamed so we can keep the instructions that had been used with that tmp entry there.)
- 22:27, 2020 October 18 Ttenbergen talk contribs moved page Parked in ER to Parked in ER tmp entry without leaving a redirect
- 09:19, 2020 October 16 Ttenbergen talk contribs created page Sorting Cognos Admitter freezes program (Created page with "{{Bug}} Observation from Pam: "...sorter buttons at top of columns freezing after cognos use ... I have to exit ccmdb and go back in to resolve, if I use cognos to admit more...")
- 07:50, 2020 October 16 Ttenbergen talk contribs moved page 2020-03 GRA COVID unit transition to 2020 GRA COVID unit transition without leaving a redirect (Text replacement - "2020-03 GRA COVID unit transition" to "2020 GRA COVID unit transition")
- 01:19, 2020 October 16 Ttenbergen talk contribs created page STB CC (Created page with "{{Collection Location | Collection StartDate = 2020-10-15 | Collection EndDate = | Collection Program = Critical Care | Collection Hospital = STB | Collection Bed Nrs = }}...")
- 01:19, 2020 October 16 Ttenbergen talk contribs created page HSC CC (Created page with "{{Collection Location | Collection StartDate = 2020-10-15 | Collection EndDate = | Collection Program = Critical Care | Collection Hospital = HSC | Collection Bed Nrs = }}...")
- 01:18, 2020 October 16 Ttenbergen talk contribs created page GRA CC (Created page with "{{Collection Location | Collection StartDate = 2020-10-15 | Collection EndDate = | Collection Program = Critical Care | Collection Hospital = GRA | Collection Bed Nrs = }}...")
- 00:51, 2020 October 16 Ttenbergen talk contribs moved page Change to GRA Med, HSC Med, STB Med Service Location to Change from Service Location to Service, Boarding Loc and Transfer Ready DtTm tmp entry without leaving a redirect (Text replacement - "Change to GRA Med, HSC Med, STB Med Service Location" to "Change from Service Location to Service, Boarding Loc and Transfer Ready DtTm tmp entry")
- 23:43, 2020 October 15 Ttenbergen talk contribs created page Check has transfer ready entry (Created page with "{{Data Integrity Check |DIC_summary=make sure there are sensibly dated entries |DIC_related_concepts=Service tmp entry; Transfer Ready DtTm tmp entry |DIC_coding=none yet |DIC...")
- 23:41, 2020 October 15 Ttenbergen talk contribs created page Check has service entry (Created page with "{{Data Integrity Check |DIC_summary=make sure each record has at least one Service tmp entry |DIC_related_concepts=Service tmp entry; |DIC_coding=none yet |DIC_status=need...")
- 22:59, 2020 October 15 Ttenbergen talk contribs created page Service Boarding Transfer Chrono (Created page with "{{Data Integrity Check}} Placeholder for the cross check(s) we will need to add to the new collection scheme introduced in Data Integrity Check. * Do we even want to cr...")
- 18:49, 2020 October 15 Ttenbergen talk contribs created page Transfer Ready DtTm tmp entry (Created page with "{{Project |ProjectActive=active |ProjectProgram=CC and Med |ProjectRequestor=internal |ProjectCollectionStartDate=2020-10-15 |Project=Transfer Ready DtTm tmp entry }} This i...")
- 18:39, 2020 October 15 Ttenbergen talk contribs created page Service tmp entry (Created page with "{{Project |ProjectActive=active |ProjectProgram=CC and Med |ProjectRequestor=internal |ProjectCollectionStartDate=2020-10-15 |Project=Boarding Loc }} This isn't so much a pro...")
- 17:35, 2020 October 15 Ttenbergen talk contribs created page S level of care table (Created page with "The '''s_level_of_care table''' in CCMDB.accdb contains identifiers of the laptops used to collect data. Equivalent to the data backup locations. This is '''not the name o...")
- 17:30, 2020 October 15 Ttenbergen talk contribs created page Change to GRA Med, HSC Med, STB Med Service Location (Created page with "This page contains info about the change of multiple Service/Location options per site for the medicine collectors to a single <site>_Med entry (GRA_Med, HSC_Med,...")
- 17:14, 2020 October 15 Ttenbergen talk contribs created page HSC Med (Created page with "{{Collection Location | Collection StartDate = 2020-10-01 | Collection EndDate = | Collection Program = Medicine | Collection Hospital = HSC | Collection Bed Nrs = }} Thi...")
- 17:14, 2020 October 15 Ttenbergen talk contribs created page STB Med (Created page with "{{Collection Location | Collection StartDate = 2020-10-01 | Collection EndDate = | Collection Program = Medicine | Collection Hospital = STB | Collection Bed Nrs = }} Thi...")
- 17:00, 2020 October 15 Ttenbergen talk contribs created page Level of care hierarchy (Created page with "We use the concept of a level of care hierarchy in the context of Transfer Delays. See Transfer Delay to understand how it is used. Level of care applies to a patient'...")
- 18:11, 2020 October 13 Ttenbergen talk contribs created page GRA Med (Created page with "{{Collection Location | Collection StartDate = January 1, 2005 | Collection EndDate = | Collection Program = Medicine | Collection Hospital = GRA | Collection Bed Nrs = |...")
- 17:43, 2020 October 13 Ttenbergen talk contribs created page Cognos data not showing up in ADT tab (new bug description and troubleshooting page.)
- 17:39, 2020 October 13 Ttenbergen talk contribs created page File:Access Editing.png (Icon showing up in MS Access when a record is being edited and has not been written yet.)
- 17:39, 2020 October 13 Ttenbergen talk contribs uploaded File:Access Editing.png (Icon showing up in MS Access when a record is being edited and has not been written yet.)
- 10:34, 2020 October 9 Ttenbergen talk contribs deleted page 2020 COVID Second Wave (was never used, replaced by 2020-10 EMIP changes)
- 21:44, 2020 October 8 Ttenbergen talk contribs created page 2020-10 EMIP changes (Created page with "Also consider * EMIP * GRA ER use as borrow location / GRA EMIP * STB Medicine workload splitting / STB EMIP * HSC EMIP PatientFollow Project...")
- 21:28, 2020 October 8 Ttenbergen talk contribs created page HSC D4 pre COVID (Redirected page to HSC D4) Tag: New redirect
- 21:19, 2020 October 8 Ttenbergen talk contribs moved page HSC D4 pre COVID to HSC D4 without leaving a redirect (Text replacement - "HSC D4 pre COVID" to "HSC D4")
- 19:45, 2020 October 8 Ttenbergen talk contribs created page 2020-10 COVID unit collection (Created page with "This page explains how we will collect data on patients located in COVID units or other temporary units starting 2020-10. == Instructions == === Which laptops will they be c...")
- 09:51, 2020 October 2 Ttenbergen talk contribs created page Template:ICD10 Guideline Shingles (Created page with "<noinclude> Consistent instructions for coding shingles. Category:ICD10 wiki infrastructure Category:Iatrogenic ---- </noinclude>=== Coding Shingles === For acti...")
- 09:49, 2020 October 2 Ttenbergen talk contribs created page Shingles (Redirected page to Template:ICD10 Guideline Shingles) Tag: New redirect
- 09:26, 2020 October 2 Ttenbergen talk contribs created page EPR Analytics (Created page with "There is a module called CPM (Clinical Performance Management) or EPR Analytics for the EPR our hospitals use. As of 2020-09 Shared Health has sort of a pilot project whe...")
- 13:48, 2020 September 23 Ttenbergen talk contribs created page Template:Guideline CAU vs Boarding Loc vs EMIP (Created page with "<noinclude> This template provides standardized info for how to collect patients in CAUs. ---- </noinclude>== Locations for patients in CAUs == It should be rare...")
- 09:25, 2020 September 23 Ttenbergen talk contribs created page Marijuana (Redirected page to Category:Cannabis related) Tag: New redirect
- 12:41, 2020 September 22 Ttenbergen talk contribs created page "EMIP" button (Created page with "The {{PAGENAME}} filters the Cognos Admitter to only show records that are EMIPs. ==testing== Testing this as of ~~~~~ '''There are some questions on the EMIP pa...")
- 09:16, 2020 September 22 Ttenbergen talk contribs created page CCMDB.accdb requires password when closing (Created page with "{{fixed bug}} Occasionally after changing something in the programming of CCMDB.accdb it starts requiring a password on closing. The only solution seems to be to revert to...")
- 09:59, 2020 September 18 Ttenbergen talk contribs created page Patient record or move shows in Cognos but not in EPR (Created page with "{{Bug}} A patient move from one unit to another showed up in Cognos but was invisible in EPR. When we checked with Chastity, she found out that this was a cancelled transactio...")
- 13:58, 2020 August 28 Ttenbergen talk contribs created page Swap Locations (Created page with "Some sites use swap locations as entries in EPR. Their use makes it hard to follow patients in Cognos Report Integrator, so we need to find out more about how these ar...")
- 14:45, 2020 August 27 Ttenbergen talk contribs created page Template:ICD10 Acquired neuromuscular weakness (Created page with "<noinclude> This template provides some content that should be consistent for all: {{ListICD10Category | categoryName = Acquired neuromuscular weakness}}. {{DA | tell me whic...")
- 14:38, 2020 August 27 Ttenbergen talk contribs deleted page Switching to a single serial pool per laptop (This was an evil twin of Facilitated Management of Serial numbers that we lost sight of during that implementation. They are all one pool now.)
- 09:38, 2020 August 25 Ttenbergen talk contribs created page Template:List of immunosuppressive drugs (Created page with "<noinclude>This template provides a list of immunosuppressive drugs to the various pages that reference these (see Special:WhatLinksHere/Template:List_of_immunosuppressive_d...")
- 10:54, 2020 August 24 Ttenbergen talk contribs created page File:STB Medical Records Request.pdf
- 10:54, 2020 August 24 Ttenbergen talk contribs uploaded File:STB Medical Records Request.pdf
- 09:28, 2020 August 21 Ttenbergen talk contribs created page Data collector xxdc account for EPR (Created page with " == Related articles == {{Related Articles}} Category: New Hire Category: IT Support")
- 13:59, 2020 August 13 Ttenbergen talk contribs deleted page HSC MS3 (this location never took off)
- 09:59, 2020 August 7 Ttenbergen talk contribs created page Using Cognos Report Integrator to keep track of patients (Created page with "{{Discuss | * I am trying to set out how using Cognos Discharger, Cognos Admitter and Patient Viewer Tab Cognos ADT should make it possible to keep track of patie...")
- 20:22, 2020 August 4 Ttenbergen talk contribs created page "Previous entry" button (Created page with "The {{PAGNAME}} on the Main Form (CCMDB.accdb) shows some of the data of patients that were logically deleted using the ...")
- 22:00, 2020 July 30 Ttenbergen talk contribs moved page Patient viewer tab APACHE to Patient Viewer Tab APACHE without leaving a redirect (Text replacement - "Patient viewer tab" to "Patient Viewer Tab")
- 22:00, 2020 July 30 Ttenbergen talk contribs moved page Patient viewer tab Cognos ADT to Patient Viewer Tab Cognos ADT without leaving a redirect (Text replacement - "Patient viewer tab" to "Patient Viewer Tab")
- 21:59, 2020 July 30 Ttenbergen talk contribs moved page Patient viewer tab ICD10 to Patient Viewer Tab ICD10 without leaving a redirect (Text replacement - "Patient viewer tab" to "Patient Viewer Tab")
- 21:59, 2020 July 30 Ttenbergen talk contribs moved page Patient viewer tab Tmp to Patient Viewer Tab Tmp without leaving a redirect (Text replacement - "Patient viewer tab" to "Patient Viewer Tab")
- 21:59, 2020 July 30 Ttenbergen talk contribs moved page Patient viewer tab CCI to Patient Viewer Tab CCI without leaving a redirect (Text replacement - "Patient viewer tab" to "Patient Viewer Tab")
- 21:59, 2020 July 30 Ttenbergen talk contribs moved page Patient viewer tab Dispo to Patient Viewer Tab Dispo without leaving a redirect (Text replacement - "Patient viewer tab" to "Patient Viewer Tab")
- 16:18, 2020 July 30 Ttenbergen talk contribs created page Cognos SubServices additions needed query (Created page with "Query ''Cognos_SubServices_additions_needed'' that shows any new services found by Sub CognosImport that are not in Cognos SubServices table yet. == Related articles...")
- 09:40, 2020 July 30 Ttenbergen talk contribs created page HSC HOBS (Created page with "{{Collection Location | Collection StartDate = 2020-08-07 | Collection EndDate = | Collection Program = Medicine | Collection Hospital = HSC | Collection Service Type = CTU...")
- 21:47, 2020 July 29 Ttenbergen talk contribs moved page Sampleinfoboxuser to SampleInfoboxUser without leaving a redirect
- 21:47, 2020 July 29 Ttenbergen talk contribs created page Category:External Sample (Created page with "This category contains some pages that have nothing to do with this wiki. They just needed to be hosted on a mediawiki.")
- 21:45, 2020 July 29 Ttenbergen talk contribs created page Sampleinfoboxuser (Created page with "{{SampleInfobox | firstValue = replace this with first value | secondValue = replace this with second value }} '''See Template:SampleInfobox for the simple infobox used in...")
- 21:41, 2020 July 29 Ttenbergen talk contribs created page Template:SampleInfobox (Created page with "<noinclude> <!-- Text starting with lt!-- and ending with --gt is a comment that will be not show. Text between the noinclude tags is the documentation for your templat...")
- 16:15, 2020 July 29 Ttenbergen talk contribs created page User:Ttenbergen/questions remaining from COVID changes (Created page with "{{#ask: Category:2020 COVID unit transition AND Category:Questions |default=none found |format = ul }}")
- 10:44, 2020 July 29 Ttenbergen talk contribs created page Previous entry form (Created page with "The previous entry form can be opened from Cognos Admitter and lists all patients with the same Chart as the record in Admitter. == Related articles == {{Related Art...")
- 10:35, 2020 July 29 Ttenbergen talk contribs created page File:Related.png (button on Cognos Admitter that opens Previous entry form Category:Cognos Report Integrator)
- 10:35, 2020 July 29 Ttenbergen talk contribs uploaded File:Related.png (button on Cognos Admitter that opens Previous entry form Category:Cognos Report Integrator)
- 17:29, 2020 July 28 Ttenbergen talk contribs moved page Decubitus (pressure) ulcer, Stage IV (involves bone) to Decubitus (pressure) ulcer, Stage IV (involves muscle, tendon, or bone) without leaving a redirect (Text replacement - "Decubitus (pressure) ulcer, Stage IV (involves bone)" to "Decubitus (pressure) ulcer, Stage IV (involves muscle, tendon, or bone)")
- 13:32, 2020 July 28 Ttenbergen talk contribs created page Cognos Admitter FormQuery query (Created page with "The '''Cognos_Admitter_FormQuery''' query in CCMDB.accdb streamlines input from Cognos_integrator query for use by Cognos_Admitter. == Related articles == {{Rela...")
- 13:32, 2020 July 28 Ttenbergen talk contribs created page Cognos Discharger FormQuery query (Created page with "The '''Cognos_Discharger_FormQuery''' query in CCMDB.accdb streamlines input from Cognos_integrator query for use by Cognos_Discharger . == Related articles == {...")
- 13:32, 2020 July 28 Ttenbergen talk contribs created page Cognos Patient viewer tab FormQuery query (Created page with "The '''Cognos_Patient_viewer_tab_FormQuery''' query in CCMDB.accdb streamlines input from Cognos_integrator query for use by Patient viewer tab Cognos ADT. == Rel...")
- 13:27, 2020 July 28 Ttenbergen talk contribs created page Cognos integrator query (Created page with "The '''{{PAGENAME}}''' in CCMDB.accdb takes input from Cognos_processed table and several local data tables and tries to match date from Cognos EPR Report to data...")
- 11:47, 2020 July 28 Ttenbergen talk contribs deleted page Query Cognos import processor (evil twin of Cognos import processor query)
- 11:33, 2020 July 28 Ttenbergen talk contribs created page Accept DtTm Equiv (Created page with "{{PAGENAME}} is a value that is generated from Cognos EPR Report fields "IPAdmitDtm" and "AsgnUnit_Prior" in Cognos_integrator table and then used by other tables. W...")
- 23:12, 2020 July 24 Ttenbergen talk contribs created page LoadCognos.bat (Created page with "The {{PAGENAME}} runs LoadCognos.vbs as part of Cognos data import. == File locations == Master: * currently on Tina's desktop while we are working out whether thi...")
- 23:11, 2020 July 24 Ttenbergen talk contribs created page LoadCognos.vbs (Created page with "The {{PAGENAME}} runs Sub CognosImport in CCMDB.accdb as part of Cognos data import. It is called by LoadCognos.bat. == File locations == Master: * currentl...")
- 21:38, 2020 July 24 Ttenbergen talk contribs created page Milk truck (Created page with "We have some processes that are only known to one person. If that person was hit by the proverbial {{Milk truck}} it would be hard for their successor to pick these up. We ha...")
- 21:24, 2020 July 24 Ttenbergen talk contribs created page Template:ICD10 Guideline Traumatic vs surgical amputation (Created page with "See Amputation for information on how to code the CCI procedure.")
- 21:18, 2020 July 24 Ttenbergen talk contribs moved page Table Cognos dispo translator to Cognos dispo translator table without leaving a redirect
- 21:17, 2020 July 24 Ttenbergen talk contribs deleted page Cognos dispo translator table (evil twin)
- 21:15, 2020 July 24 Ttenbergen talk contribs created page Query Cognos import processor (Created page with "The query Cognos_import_processor in CCMDB.accdb populates Cognos_processed table from Cognos EPR Report. Among other things, it adds mappings for Cognos unit loca...")
- 21:13, 2020 July 24 Ttenbergen talk contribs created page Cognos processed table (Created page with "The '''Cognos_processed''' table in CCMDB.accdb contains Cognos EPR Report that has been processed by query Cognos_import_processor. Among other things, it adds ma...")
- 21:07, 2020 July 24 Ttenbergen talk contribs created page Table Cognos dispo translator (Created page with "The '''Cognos_dispo_translator''' table in CCMDB.accdb contains the mapping of unit names in Cognos EPR Report against those in s_dispo table. Cognos_dispo_tran...")
- 20:59, 2020 July 24 Ttenbergen talk contribs created page Cognos dispo translator additions needed query (Created page with "Query that shows any new locations found by Sub CognosImport that are not in table Cognos_dispo_translator yet. == Related articles == {{Related Articles}} Catego...")
- 20:57, 2020 July 24 Ttenbergen talk contribs created page Sub CognosImport (Created page with "'''{{PAGENAME}}''' is the sub that accomplishes the Cognos EPR Report importing as part of Cognos data import . * cleans out table Cognos_import and table Cogno...")
- 19:23, 2020 July 24 Ttenbergen talk contribs deleted page Review of collection of initial data (ancient survey result that is no longer relevant)
- 19:20, 2020 July 24 Ttenbergen talk contribs deleted page Feedback Request - Patient List (nothing useful left here, cleaning it up.)
- 13:43, 2020 July 24 Ttenbergen talk contribs removed protection from Moves for Medicine (removed protection, any page should be questionable) (hist)
- 10:12, 2020 July 24 Ttenbergen talk contribs created page Update of D ID exclude service/location (Created page with "This page documents our move to a D_ID that no longer contains the Service/Location. == Background == When we first set up D_ID it consisted of the Pat_ID an...")
- 09:33, 2020 July 24 Ttenbergen talk contribs deleted page Patient ID field (Evil twin of [Pat ID]])
- 21:36, 2020 July 23 Ttenbergen talk contribs moved page S AP Chronic to S AP Chronic table without leaving a redirect (Text replacement - "S AP Chronic" to "S AP Chronic table")
- 15:00, 2020 July 23 Ttenbergen talk contribs created page "MR copy-paste" button (Redirected page to MR List) Tag: New redirect
- 15:00, 2020 July 23 Ttenbergen talk contribs created page "MR List by oldest discharge first" button (Redirected page to MR List) Tag: New redirect
- 15:56, 2020 July 17 Ttenbergen talk contribs created page "ActiveX component can't create object" error when sending (Created page with "{{bug}} At least one collector sporadically gets the following error when sending: <pre> Microsoft Access ActiveX component can't create object </pre> The second attempt to s...")
- 09:43, 2020 July 17 Ttenbergen talk contribs created page Roaming profiles (no more roaming profiles)
- 12:16, 2020 July 9 Ttenbergen talk contribs created page Template:ICD10 Guideline GI Angiodysplasia (Created page with "<noinclude> This template that the instructions for Angiodysplasia are consistent across the different Angiodysplasia codes. To use: <pre>{{ICD10 Guideline GI Angiodysplasi...")
- 11:07, 2020 July 9 Ttenbergen talk contribs created page HSC High Obs (Created page with "Currently the HSC High Obs unit is HSC B2. This changes frequently, so this page allows for consistent linking. The intention of HOBs is for patients that require more i...")
- 11:05, 2020 July 9 Ttenbergen talk contribs created page HOBS (Redirected page to HSC High Obs) Tag: New redirect
- 11:05, 2020 July 9 Ttenbergen talk contribs created page HOBs (Created page with "# redirect:HSC High Obs Convenience redirect for searching and linking")
- 15:44, 2020 July 3 Ttenbergen talk contribs created page Template:ICD10 Guideline Past medical history (Created page with "<noinclude> This template is used in ICD10 Diagnoses in the Category: Past medical history codes to make sure they are used consistently. To use: <pre>{{ICD10 Guide...")
- 20:17, 2020 June 30 Ttenbergen talk contribs moved page Other specified infectious agents as the cause of diseases classified to other chapters to Other specified infectious agents as the cause of diseases classified by other ICD10 code without leaving a redirect (Text replacement - "Other specified infectious agents as the cause of diseases classified to other chapters" to "Other specified infectious agents as the cause of diseases classified by other ICD10 code")
- 11:24, 2020 June 30 Ttenbergen talk contribs created page New Pt Serial helper form (Created page with "The {{PAGENAME}} starts a new record in CCMDB.accdb. It is opened either by the "Add Patient with Serial Helper" button or the "+" button on the Cognos Admitter....")
- 23:14, 2020 June 29 Ttenbergen talk contribs deleted page "View excludeds" button (content was: "#REDIRECT "View exclusions" button", and the only contributor was "Ttenbergen" (talk))
- 23:13, 2020 June 29 Ttenbergen talk contribs moved page "View excludeds" button to "View exclusions" button (Text replacement - ""View excludeds" button" to ""View exclusions" button")
- 14:22, 2020 June 29 Ttenbergen talk contribs changed group membership for Jvelasco from CCMDB_legit to CCMDB_legit and bureaucrat (to be able to use replaceText)
- 09:53, 2020 June 25 Ttenbergen talk contribs created page Effects of starvation (Created page with "{{ICD10 dx | ICD10 Code= }} == Additional Info == Need more info as per Task_Team_Meeting_-_Rolling_Agenda_and_Minutes_2020#ICU Database Task Group Meeting – June 11, 202...")
- 09:52, 2020 June 25 Ttenbergen talk contribs created page Other specified infectious agents as the cause of diseases classified to other chapters (Created page with "{{ICD10 dx | ICD10 Code= }} == Additional Info == Need more info as per Task_Team_Meeting_-_Rolling_Agenda_and_Minutes_2020#ICU Database Task Group Meeting – June 11, 202...")
- 09:44, 2020 June 25 Ttenbergen talk contribs moved page Fetal alcohol syndrome (applies to baby, not mom) to Fetal alcohol syndrome without leaving a redirect (Text replacement - "Fetal alcohol syndrome (applies to baby, not mom)" to "Fetal alcohol syndrome")