Main public logs

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

22:50, 29 January 2025 Ttenbergen talk contribs created page Centralized data front end.accdb Change Log 2025 (Created page with "{{DISPLAYTITLE:Centralized_data_front_end.accdb Change Log 2025}} __NOTOC__  ''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 Check...")
19:48, 23 January 2025 Ttenbergen talk contribs created page Project Overstay2 (Created page with "{{Project | Project = {{PAGENAME}} | ProjectActive = planned | ProjectProgram = Med | ProjectRequestor = Dan Roberts | ProjectCollectionStartDate = '''within the next few weeks''' | ProjectCollectionStopDate = continuous }} ''' Not live yet! ''' == Data Collection == For any medicine record, enter the Minimal dataset + {{Discuss| * which additional values? At least ** the diagnoses constituting Charlson... }} === Data Entry Instructions === ''will a...")
16:41, 9 January 2025 Ttenbergen talk contribs created page Task Team Meeting - Rolling Agenda and Minutes 2025 (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=...")
14:26, 8 January 2025 Ttenbergen talk contribs created page CCMDB.accdb Change Log 2025 (Created page with "__NOTOC__  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...")
22:32, 22 December 2024 Ttenbergen talk contribs created page Using RSS to inform occasional users of our data of definition changes (Created page with "This page contains instructions on how to generate an [https://en.wikipedia.org/wiki/RSS RSS link] for pages on this wiki, and how to set these up in Outlook. This allows an occasional user of our data to be notified of any changes on wiki pages pertaining to their use, without having to monitor recent changes. We should encourage people who rely on our data to set up feeds so they know when our definitions change. == Generating an RSS link == To generate an RSS link f...")
21:03, 21 December 2024 Ttenbergen talk contribs deleted page MediaWiki:Preferences-summary (content was: "testing mw pref summ", and the only contributor was "Ttenbergen" (talk))
21:02, 21 December 2024 Ttenbergen talk contribs created page MediaWiki:Preferences-summary (Created page with "testing mw pref summ")
17:37, 11 December 2024 Ttenbergen talk contribs created page PowerBI Data Model for CCMDB (Created page with "I am setting up a data model for CCMDB in PowerBI for some of the data I am doing for Dr. Robert's project. Needed to document some stuff and thought this was a better place for that than my email or similar. Rough notes for now. == state of setup == * I have things mostly set up to work with current data, ie I have not necessarily dealt with old style dates or dxs etc * currently only working with content from CCMDB, CFE, Centralized, ie not labs or any legacy data =...")
15:25, 29 November 2024 Ttenbergen talk contribs moved page Query s tmp RAH consistent to Query s tmp AHC consistent without leaving a redirect
15:15, 29 November 2024 Ttenbergen talk contribs created page Project MR (Created page with "{{Project | Project = {{PAGENAME}} | ProjectActive = planned  | ProjectProgram = Med | ProjectRequestor = Dan Roberts | ProjectCollectionStartDate = within the next few weeks | ProjectCollectionStopDate = continuous }} == Data Collection == For any medicine record, capture when the patient is medically stable and ready to leave an acute medicine bed. === Data Entry Instructio...")
14:02, 28 November 2024 Ttenbergen talk contribs moved page Project RAH to Project AHC without leaving a redirect
11:59, 28 November 2024 Ttenbergen talk contribs created page Query s tmp RAH consistent (Created page with "{{Data Integrity Check |DIC_summary=Checks for Project RAH |DIC_related_concepts=Project RAH |DIC_firmness=hard check |DIC_timing=complete |DIC_status= |DIC_LProblem=No |DIC_app=CCMDB.accdb }} === checks === * Medicine records admitted after the start and before the end of project have all four lines * The lines have to be yes or no * If there is a date it has to be after project start, after or at admission, before the project end and before discharge. == Related...")
11:59, 28 November 2024 Ttenbergen talk contribs created page Project RAH (Created page with "{{Project | Project = {{PAGENAME}} | ProjectActive = planned  | ProjectProgram = Med | ProjectRequestor = Dan Roberts | ProjectCollectionStartDate = within the next week or so | ProjectCollectionStopDate = somewhere between 100 records and 3 months }} == Data Collection == For any new medicine record added to the laptop after the project start date, capture whether there were an...")
19:42, 13 November 2024 Ttenbergen talk contribs deleted page Category:Charlson Comorbid Diagnosis (old) (cleanup, those dxs are not set up with this categorization)
20:34, 3 November 2024 Ttenbergen talk contribs deleted page File:Remote-access-service-request-form 2020 April 2 WRHA Data collectorts .pdf (unlinked redirec)
14:40, 31 October 2024 Ttenbergen talk contribs created page More - Refresh on wiki (Created page with "The mediawiki software we use in this wiki contains some structured data stored via extensions Semantic Mediawiki and [https://www.mediawiki.org/wiki/Extension:Cargo]. Many of the lists on the wiki are not stored explicitly, but generated via query through one of those extensions. When you edit a page, sometimes other pages containing its data don't update immediately. There is a '''More tab''' with a '''Refresh''' option at the top of the page that allows you to...")
08:45, 22 October 2024 Ttenbergen talk contribs created page Template:ICD10 Guideline Tracheostomy (Created page with "<noinclude> Template to make sure extra information is consistent for the various Tracheostomy diagnoses. Category:ICD10 wiki infrastructure ---- </noinclude> '''Includes''' * laryngectomy tube")
15:05, 17 October 2024 Ttenbergen talk contribs created page Centralized data front end.accdb Change Log 2024 (Created page with "{{DISPLAYTITLE:Centralized_data_front-end.accdb Change Log 2024}} __NOTOC__  ''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 Check...")
08:10, 10 October 2024 Ttenbergen talk contribs created page Error "query must have at least one destination field" after restoring deleted patient (Created page with "{{bug}} A collector got error "query must have at least one destination field" when trying to complete the record. The admission to WRS3 had been a restored record after initially deleting it. When we tried to troubleshoot this the record had already been sent and the error wasn't easy to replicate. So I just want to document this in case it happens again. If you get an error like this, stop trying to fix the data and let Tina know so we can find out what goes wrong an...")
08:44, 8 October 2024 Ttenbergen talk contribs created page Reverting back to an older version of CCMDB.accdb (Created page with "Access databases can become corrupt. This page tells how to identify this and recover from it in our setting. Generally we don't troubleshoot these, we revert to an earlier working version, re-apply the changes as per Change log, and roll out the changes == Identifying a corrupted version == The following things might tell you that you have corrupted version. * error messages that sound IT related, and that are addressed not on this wiki spe...")
12:06, 11 September 2024 Ttenbergen talk contribs created page Adding a drug to pharmacy collection (Created page with "{{Discuss | * This needs cleanup, just putting it here instead of email }} == Adding a specific medication to an already collected class of drugs == === update the wiki === When you edit the specific drug page (such as Azoles), there is a listing for <nowiki>{{Azole antifungals}}</nowiki>. The curly brackets tell you it's calling a template, and it is like that because we want to refer to things like "azoles" with the same list wherever we put this list (in this cas...")
19:02, 29 April 2024 Ttenbergen talk contribs created page Drawio:Test2 (Created page with "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAMkAAAChCAYAAABtYZsyAAAAAXNSR0IArs4c6QAABwx0RVh0bXhmaWxlACUzQ214ZmlsZSUyMGhvc3QlM0QlMjJlbWJlZC5kaWFncmFtcy5uZXQlMjIlMjBtb2RpZmllZCUzRCUyMjIwMjQtMDQtMzBUMDElM0EwMCUzQTUyLjk1NlolMjIlMjBhZ2VudCUzRCUyMk1vemlsbGElMkY1LjAlMjAoV2luZG93cyUyME5UJTIwMTAuMCUzQiUyMFdpbjY0JTNCJTIweDY0KSUyMEFwcGxlV2ViS2l0JTJGNTM3LjM2JTIwKEtIVE1MJTJDJTIwbGlrZSUyMEdlY2tvKSUyMENocm9tZSUyRjEyNC4wLjAuMCUyMFNhZmFyaSUyRjUzNy4zNiUyMEVkZyUyRjEyNC4wLjAuMCUyMiUyMGV0Y...")
11:46, 25 April 2024 Ttenbergen talk contribs created page Template:ICD10 Hypothermia (broke out for consistency)
15:47, 24 April 2024 Ttenbergen talk contribs moved page Query check CCI imaging count vs LOS to Query check CCI each count vs LOS without leaving a redirect
14:58, 24 April 2024 Ttenbergen talk contribs created page Template:CCIPick ByCode (Created page with "<noinclude> This template resolves a CCI Picklist code to "CCI page name (dx code)" To use: ::<nowiki>{{</nowiki> {{PAGENAME}} |the code}}</pre> Category:CCI wiki infrastructure ---- </noinclude>{{#ask: [[Has CCI Picklist Code::{{{1}}}]]}} ({{{1}}})")
14:00, 24 April 2024 Ttenbergen talk contribs moved page Query check CCI CXR vs LOS to Query check CCI imaging count vs LOS without leaving a redirect (Text replacement - "Query check CCI CXR vs LOS" to "Query check_CCI_imaging_count_vs_LOS")
12:15, 24 April 2024 Ttenbergen talk contribs deleted page Myocardial infarction, acute (AMI), transmural (Q-wave) (content was: "#REDIRECT Myocardial infarction (STEMI), acute (AMI), transmural (Q-wave)", and the only contributor was "Lkaita" (talk))
20:59, 23 April 2024 Ttenbergen talk contribs deleted page Drawio:Test tool (content was: "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAI8AAACiCAYAAAB4UZ57AAAHYXRFWHRteGZpbGUAJTNDbXhmaWxlJTIwaG9zdCUzRCUyMmVtYmVkLmRpYWdyYW1zLm5ldCUyMiUyMG1vZGlmaWVkJTNEJTIyMjAyNC0wNC0yNFQwMiUzQTQ1JTNBNDMuMTUzWiUyMiUyMGFnZW50JTNEJTIyTW96aWxsYSUyRjUuMCUyMChXaW5kb3dzJTIwTlQlMjAxMC4wJTNCJTIwV2luNjQlM0IlMjB4NjQlM0IlMjBydiUzQTEyNC4wKSUyMEdlY2tvJTJGMjAxMDAxMDElMjBGaXJlZm94JTJGMTI0...", and the only contributor was "Ttenbergen" (talk))
20:45, 23 April 2024 Ttenbergen talk contribs created page Drawio:Test tool (Created page with "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAI8AAACiCAYAAAB4UZ57AAAHYXRFWHRteGZpbGUAJTNDbXhmaWxlJTIwaG9zdCUzRCUyMmVtYmVkLmRpYWdyYW1zLm5ldCUyMiUyMG1vZGlmaWVkJTNEJTIyMjAyNC0wNC0yNFQwMiUzQTQ1JTNBNDMuMTUzWiUyMiUyMGFnZW50JTNEJTIyTW96aWxsYSUyRjUuMCUyMChXaW5kb3dzJTIwTlQlMjAxMC4wJTNCJTIwV2luNjQlM0IlMjB4NjQlM0IlMjBydiUzQTEyNC4wKSUyMEdlY2tvJTJGMjAxMDAxMDElMjBGaXJlZm94JTJGMTI0LjAlMjIlMjB2ZXJzaW9uJTNEJTIyMjQuMi44JTIyJTIwZXRhZyUzRCUyMkdXZHMxZHM5SkFiR1ZLT00zenJHJTIyJTIwdHlwZSUzRCUyM...")
10:26, 8 April 2024 Ttenbergen talk contribs created page OIT Report (Redirected page to Critical Care Program Quality Indicator Report) Tag: New redirect
20:29, 29 March 2024 Ttenbergen talk contribs deleted page Urine Output field (field is gone and nothing links to it.)
10:09, 21 March 2024 Ttenbergen talk contribs created page Category:ANCA-associated Vasculitis (AAV) (Created page with "Category:ICD10 Diagnosis Category:Vasculitis")
11:37, 24 January 2024 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...")
11:23, 15 January 2024 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...")
21:01, 2 January 2024 Ttenbergen talk contribs recreated the Cargo table ICD10_Dx
20:35, 2 January 2024 Ttenbergen talk contribs recreated the Cargo table ICD10_Category
20:33, 2 January 2024 Ttenbergen talk contribs recreated the Cargo table Discussions
20:32, 2 January 2024 Ttenbergen talk contribs recreated the Cargo table CollectionLocation
19:44, 2 January 2024 Ttenbergen talk contribs recreated the Cargo table ToDo
19:44, 2 January 2024 Ttenbergen talk contribs recreated the Cargo table TISS_Items
19:44, 2 January 2024 Ttenbergen talk contribs recreated the Cargo table Reports
19:44, 2 January 2024 Ttenbergen talk contribs recreated the Cargo table Publications
19:44, 2 January 2024 Ttenbergen talk contribs recreated the Cargo table Indicators
19:44, 2 January 2024 Ttenbergen talk contribs recreated the Cargo table ICD10_Dx
19:44, 2 January 2024 Ttenbergen talk contribs recreated the Cargo table ICD10_Category
19:44, 2 January 2024 Ttenbergen talk contribs recreated the Cargo table Drugs_Included
19:44, 2 January 2024 Ttenbergen talk contribs recreated the Cargo table Discussions
19:44, 2 January 2024 Ttenbergen talk contribs recreated the Cargo table Data_Element
19:44, 2 January 2024 Ttenbergen talk contribs recreated the Cargo table DataIntegrityChecks
19:44, 2 January 2024 Ttenbergen talk contribs recreated the Cargo table CollectionLocation
19:39, 2 January 2024 Ttenbergen talk contribs recreated the Cargo table _ganttData
19:39, 2 January 2024 Ttenbergen talk contribs recreated the Cargo table _bpmnData
19:39, 2 January 2024 Ttenbergen talk contribs recreated the Cargo table _fileData
19:38, 2 January 2024 Ttenbergen talk contribs created the Cargo table foreign_keys
19:38, 2 January 2024 Ttenbergen talk contribs deleted the Cargo table foreign_keys
11:55, 1 January 2024 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.")
11:14, 1 January 2024 Ttenbergen talk contribs created page CCMDB.accdb Change Log 2024 (Created page with "__NOTOC__  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...")
10:47, 1 January 2024 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=...")
10:29, 1 January 2024 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...")
09:54, 13 December 2023 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...")
10:26, 25 November 2023 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
10:25, 25 November 2023 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))
10:25, 25 November 2023 Ttenbergen talk contribs moved page Query check TISS Errors CAM positive vs Dx to Query check CCI TISS Errors CAM positive vs Dx
10:24, 25 November 2023 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
10:20, 25 November 2023 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)
10:54, 3 November 2023 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")
10:54, 3 November 2023 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")
12:21, 1 November 2023 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)
12:20, 1 November 2023 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)
15:07, 27 September 2023 Ttenbergen talk contribs deleted page CFE log (unlinked redirect)
14:55, 27 September 2023 Ttenbergen talk contribs deleted page ECHMO (unlinked redirect)
10:19, 2 August 2023 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...")
10:34, 27 July 2023 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)
11:03, 12 July 2023 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...")
09:55, 12 July 2023 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...")
10:39, 6 July 2023 Ttenbergen talk contribs moved page Project Legacy HSC CCU Location to Project Legacy HSC CCU Loc without leaving a redirect (too long for field)
10:28, 6 July 2023 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)
10:14, 6 July 2023 Ttenbergen talk contribs created page Project Legacy Filter H B (Created page with "{{Project|}}")
10:14, 6 July 2023 Ttenbergen talk contribs created page Project Legacy Co-managed (Created page with "{{Project|}}")
08:53, 6 July 2023 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...")
14:28, 28 June 2023 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...")
09:47, 27 June 2023 Ttenbergen talk contribs deleted page Atrial Ablation (made sure the term was included on the relevant CCI code Destruction)
09:45, 27 June 2023 Ttenbergen talk contribs deleted page MAZE procedure (made sure the term was included on the relevant CCI code Destruction)
14:24, 8 June 2023 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®)")
15:35, 31 May 2023 Ttenbergen talk contribs created page Category:SL tables (Created page with "{{DISPLAYTITLE:sL tables}} Category:Data structure")
15:34, 31 May 2023 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...")
15:34, 31 May 2023 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...")
13:43, 24 May 2023 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...")
09:57, 18 May 2023 Ttenbergen talk contribs deleted page File:Link tester.svg (was a test upload)
09:37, 18 May 2023 Ttenbergen talk contribs uploaded a new version of File:Link tester.svg
09:31, 18 May 2023 Ttenbergen talk contribs uploaded a new version of File:Link tester.svg
09:19, 18 May 2023 Ttenbergen talk contribs uploaded a new version of File:Link tester.svg
09:19, 18 May 2023 Ttenbergen talk contribs created page User:Ttenbergen/svg testing (Created page with "* https://ccmdb.kuality.ca/index.php?title=Quality_Assurance * Quality_Assurance 300px")
09:18, 18 May 2023 Ttenbergen talk contribs created page File:Link tester.svg
09:18, 18 May 2023 Ttenbergen talk contribs uploaded File:Link tester.svg
16:27, 17 May 2023 Ttenbergen talk contribs deleted page Importing data into MS Access (Not linked to anything, and there is no reason to document this.)
16:26, 17 May 2023 Ttenbergen talk contribs deleted page Validating Data Importing (nope it won't)
15:12, 17 May 2023 Ttenbergen talk contribs deleted page S Priorities (evil twin of S Priorities table)
15:08, 17 May 2023 Ttenbergen talk contribs moved page S Tmp to S tmp table over a redirect without leaving a redirect
15:08, 17 May 2023 Ttenbergen talk contribs deleted redirect S tmp table by overwriting (Deleted to make way for move from "S Tmp")
11:34, 16 May 2023 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...")
12:22, 9 May 2023 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")
12:19, 9 May 2023 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")
12:16, 9 May 2023 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")
12:10, 9 May 2023 Ttenbergen talk contribs moved page S RecordStatus to S RecordStatus table without leaving a redirect (consistency for table pages)
11:36, 9 May 2023 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")
12:45, 4 May 2023 Ttenbergen talk contribs deleted page Drug-induced immunosuppression (no longer in dataset)
11:02, 4 May 2023 Ttenbergen talk contribs deleted page FinalCheck field (no longer in dataset)
11:01, 4 May 2023 Ttenbergen talk contribs deleted page ApLab Complete (no longer in dataset)
11:00, 4 May 2023 Ttenbergen talk contribs deleted page Room nr (no longer in dataset)
10:50, 4 May 2023 Ttenbergen talk contribs deleted page EPR Admit DtTm field (no longer in dataset)
10:50, 4 May 2023 Ttenbergen talk contribs deleted page EPR Admit DtTm (no longer in dataset)
10:48, 4 May 2023 Ttenbergen talk contribs deleted page Pharm Flow Complete (no longer in dataset)
09:34, 27 April 2023 Ttenbergen talk contribs moved page Query S CCI Categories sort missing to Query s CCI Categories sort missing without leaving a redirect
09:29, 27 April 2023 Ttenbergen talk contribs moved page S CCI Categories sort missing to Query S CCI Categories sort missing without leaving a redirect
09:29, 27 April 2023 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}...")
09:28, 27 April 2023 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}...")
16:47, 19 April 2023 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}}")
16:08, 19 April 2023 Ttenbergen talk contribs deleted page Category:Created Variables Common table (see Category:Created Variables Common table)
15:58, 19 April 2023 Ttenbergen talk contribs deleted page Created Variables Common maker query (see Created Variables Common maker 2021 query)
15:56, 19 April 2023 Ttenbergen talk contribs deleted page Created Variables Common table (see Created Variables Common 2021 table)
14:54, 19 April 2023 Ttenbergen talk contribs deleted page Created Variables CC table (see Created Variables CC 2021 table)
14:47, 19 April 2023 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")
14:47, 19 April 2023 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")
14:46, 19 April 2023 Ttenbergen talk contribs deleted page Category:Created Variables CC table (see Category:Created Variables CC 2021 table)
14:42, 19 April 2023 Ttenbergen talk contribs deleted page Created Variables CC maker query (replaced by Created Variables Common maker 2021 query)
14:12, 19 April 2023 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")
08:49, 19 April 2023 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")
13:44, 12 April 2023 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...")
13:37, 12 April 2023 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"")
13:36, 12 April 2023 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 |...")
13:35, 12 April 2023 Ttenbergen talk contribs moved page Mermaid:Test to Mermaid:Test w template without leaving a redirect
13:33, 12 April 2023 Ttenbergen talk contribs created page Template:ER Mermaid (Created page with "s_dispo[s_dispo table] -->|"dispo_ID to #8734; Dispo"| L_Log")
13:18, 12 April 2023 Ttenbergen talk contribs recreated the Cargo table foreign_keys
11:26, 12 April 2023 Ttenbergen talk contribs created page Drawio:Test (Created page with "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAANMAAAEFCAYAAAB5F9JfAAAJvnRFWHRteGZpbGUAJTNDbXhmaWxlJTIwaG9zdCUzRCUyMmVtYmVkLmRpYWdyYW1zLm5ldCUyMiUyMG1vZGlmaWVkJTNEJTIyMjAyMy0wNC0xMlQxNyUzQTI2JTNBMzEuMDQ4WiUyMiUyMGFnZW50JTNEJTIyTW96aWxsYSUyRjUuMCUyMChXaW5kb3dzJTIwTlQlMjAxMC4wJTNCJTIwV2luNjQlM0IlMjB4NjQlM0IlMjBydiUzQTEwOS4wKSUyMEdlY2tvJTJGMjAxMDAxMDElMjBGaXJlZm94JTJGMTExLjAlMjIlMjB2ZXJzaW9uJTNEJTIyMjEuMS43JTIyJTIwZXRhZyUzRCUyMnpEcFAwd3VwbHMxWENpQ0J0RmU5JTIyJTIwdHlwZSUzRCUyM...")
11:25, 12 April 2023 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")
11:20, 12 April 2023 Ttenbergen talk contribs recreated the Cargo table foreign_keys
11:17, 12 April 2023 Ttenbergen talk contribs created the Cargo table foreign_keys
11:11, 12 April 2023 Ttenbergen talk contribs created page Category:Data structure wiki infrastructure (Created page with "Pages that encode the data structure of our database.")
11:10, 12 April 2023 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...")
10:56, 12 April 2023 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...")
15:34, 11 April 2023 Ttenbergen talk contribs deleted page VIKI (extension is defunct, see Mediawiki extension Network)
20:22, 5 April 2023 Ttenbergen talk contribs deleted page Backup Checker.vbs (deleted file after confirming with Pagasa that it has not been used in a long time)
20:16, 5 April 2023 Ttenbergen talk contribs moved page Transfusion of FFP to Transfusion of plasma products without leaving a redirect (not FFP any more)
20:01, 5 April 2023 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. }}")
19:29, 5 April 2023 Ttenbergen talk contribs deleted page File:MED Master Data Collection LOG.pdf (Form that is no longer used and not relevant do continuing data.)
14:28, 16 March 2023 Ttenbergen talk contribs created page Template:ICD10 Secondary infections of aspiration (duplication of this content on Pneumonia, ventilator-associated (VAP) and Aspiration pneumonitis)
09:05, 8 March 2023 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. {{#...")
09:52, 1 March 2023 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)")
10:27, 22 February 2023 Ttenbergen talk contribs deleted page File:Screen settings.png (not used, old)
10:25, 22 February 2023 Ttenbergen talk contribs deleted page File:Construc.gif (not used)
10:25, 22 February 2023 Ttenbergen talk contribs deleted page File:March 5.13 TISS28 FINAL changes Yellow.pdf (not used)
10:23, 22 February 2023 Ttenbergen talk contribs deleted page File:Edit vacation.png (not used)
10:23, 22 February 2023 Ttenbergen talk contribs deleted page File:Thumbsup.gif (not used)
10:21, 22 February 2023 Ttenbergen talk contribs deleted page File:CCMDB door.pdf (unused)
16:41, 15 February 2023 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")
16:38, 15 February 2023 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")
11:28, 8 February 2023 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...")
11:24, 8 February 2023 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)
09:59, 2 February 2023 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")
09:53, 2 February 2023 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")
09:51, 2 February 2023 Ttenbergen talk contribs deleted page Charlson Comorbid Score query (see query Charlson_Score_pre_and_ICD10)
15:30, 1 February 2023 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...")
15:23, 1 February 2023 Ttenbergen talk contribs moved page S charlson dxs to S charlson dxs table without leaving a redirect (consistency for table pages)
14:35, 1 February 2023 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")
13:53, 1 February 2023 Ttenbergen talk contribs deleted page Query s ICD10 Charlson score (query doesn't exist, see query s_ICD10_Charlson_Comorbids for likely angelic twin)
15:16, 26 January 2023 Ttenbergen talk contribs deleted page Database utilization status report (evil twin of Data Request Status ICU/Med)
09:56, 26 January 2023 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...")
13:24, 25 January 2023 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)
13:14, 25 January 2023 Ttenbergen talk contribs deleted page Template:First Service and Boarding Loc same (moved to DtTm for Frist Boarding Loc and First Service)
12:15, 25 January 2023 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...")
10:53, 25 January 2023 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! ~~~~")
09:45, 11 January 2023 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...")
10:35, 4 January 2023 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=...")
10:31, 4 January 2023 Ttenbergen talk contribs created page Centralized data front end.accdb Change Log 2023 (Created page with "__NOTOC__  ''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...")
10:24, 4 January 2023 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...")
10:15, 4 January 2023 Ttenbergen talk contribs created page CCMDB.accdb Change Log 2023 (Created page with "__NOTOC__  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...")
12:34, 29 December 2022 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")
12:07, 29 December 2022 Ttenbergen talk contribs deleted page Care levels in the community (nothing left here, all on Pre acute living situation field now.)
10:33, 29 December 2022 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")
12:13, 8 December 2022 Ttenbergen talk contribs moved page AMA DtTm to BedHeldEnd DtTm without leaving a redirect
12:04, 8 December 2022 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...")
11:02, 8 December 2022 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...")
13:29, 29 November 2022 Ttenbergen talk contribs moved page CCMDB.accdb flickers or flashes at times to CCMDB.accdb flickers or flashes without leaving a redirect
13:27, 29 November 2022 Ttenbergen talk contribs moved page User:Cross Check Engine to Cross Check Engine without leaving a redirect
13:27, 29 November 2022 Ttenbergen talk contribs moved page User:Ttenbergen/Cross Check Engine to User:Cross Check Engine without leaving a redirect
13:26, 29 November 2022 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.")
16:26, 24 November 2022 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.")
16:26, 24 November 2022 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...")
11:49, 24 November 2022 Ttenbergen talk contribs deleted page Battery disposal (wasn't being updated, so deleting the page.)
14:54, 16 November 2022 Ttenbergen talk contribs created page JALT Meeting - Rolling Agenda and Minutes (Redirected page to JALT Meeting - Rolling Agenda and Minutes 2022) Tag: New redirect
14:46, 16 November 2022 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...")
16:55, 3 November 2022 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>")
16:44, 3 November 2022 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)
16:43, 3 November 2022 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...")
16:40, 3 November 2022 Ttenbergen talk contribs created page Category:2023 Data Collection Team Meetings (Created page with "Category:Data Collection Team Meetings")
16:39, 3 November 2022 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")
15:27, 27 October 2022 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")
14:05, 26 October 2022 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...")
14:05, 26 October 2022 Ttenbergen talk contribs deleted page SL EPR Exclusions table (table is no more, and no references to it remain)
09:17, 19 October 2022 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...")
12:45, 13 October 2022 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...")
11:07, 5 October 2022 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")
16:26, 29 September 2022 Ttenbergen talk contribs deleted page Setting up CCMDB.accdb and CCMDB data.mdb on a new computer (consolidated in Laptop Setup)
16:16, 29 September 2022 Ttenbergen talk contribs deleted page CCMDB laptop setup instructions (merged with Laptop Setup)
13:34, 28 September 2022 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...")
09:53, 28 September 2022 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 {...")
08:58, 28 September 2022 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")
14:25, 20 September 2022 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)
13:11, 20 September 2022 Ttenbergen talk contribs created page Tina Tenbergen (Created page with "see Priv:Tina Tenbergen")
14:20, 7 September 2022 Ttenbergen talk contribs moved page Guidelines around coding sex and gender to Guidelines for coding sex and gender without leaving a redirect
11:03, 7 September 2022 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...")
08:41, 7 September 2022 Ttenbergen talk contribs created page Level of care (Redirected page to Level of care hierarchy) Tag: New redirect
08:22, 7 September 2022 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")
14:36, 25 August 2022 Ttenbergen talk contribs moved page ClientVisitGUID to ClientVisitGUID field without leaving a redirect (Text replacement - "ClientVisitGUID" to "ClientVisitGUID field")
14:42, 15 August 2022 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...")
15:22, 10 August 2022 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")
14:31, 10 August 2022 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...")
15:34, 9 August 2022 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)
10:04, 5 August 2022 Ttenbergen talk contribs created page L Log+ query (Created page with "A helper query that combines L_Log table with the Admit DtTm concept.")
15:27, 3 August 2022 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")
08:45, 3 August 2022 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...")
10:21, 28 July 2022 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...")
10:38, 13 July 2022 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")
08:29, 13 July 2022 Ttenbergen talk contribs moved page Check BL TR combiner null to Query Check BL TR combiner null without leaving a redirect (consistency)
08:17, 13 July 2022 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...")
15:13, 30 June 2022 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)
14:37, 30 June 2022 Ttenbergen talk contribs deleted page Process for bad data in Cognos (deleted page after link cleanup; this process never took off)
14:29, 30 June 2022 Ttenbergen talk contribs deleted page Project CognosDataEmail (project was aborted; asked Pagasa to eliminate the small number of records that were entered.)
13:48, 30 June 2022 Ttenbergen talk contribs deleted page Cognos2 Hospital Discharge query (backlog done, no longer needed.)
11:02, 30 June 2022 Ttenbergen talk contribs created page Template:ICD10 Rectal Varices (made template to keep this consistent on change)
10:08, 30 June 2022 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.")
09:40, 30 June 2022 Ttenbergen talk contribs created page Ap Chronic (Redirected page to Chronic Health APACHE) Tag: New redirect
13:29, 28 June 2022 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")
10:37, 28 June 2022 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")
09:48, 23 June 2022 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)
09:43, 23 June 2022 Ttenbergen talk contribs undeleted page Template:ICD10 Guideline ESRD vs Acute renal failure (23 revisions)
09:24, 23 June 2022 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 ===")
14:55, 22 June 2022 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.)
14:41, 22 June 2022 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")
15:15, 16 June 2022 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")
15:14, 16 June 2022 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")
15:13, 16 June 2022 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")
15:09, 16 June 2022 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")
15:08, 16 June 2022 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 .)
09:28, 16 June 2022 Ttenbergen talk contribs created page Category:Cognos import3 table (Created page with "Articles related to the Cognos_import3 table. Category:Data structure")
15:54, 15 June 2022 Ttenbergen talk contribs created page TISS Item Specific Interventions (outside the ICU) (creating cci category page for completeness to avoid redlinks)
15:54, 15 June 2022 Ttenbergen talk contribs created page TISS Item At 2300 Hours (creating cci category page for completeness to avoid redlinks)
15:51, 15 June 2022 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.)
09:41, 15 June 2022 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...")
14:51, 14 June 2022 Ttenbergen talk contribs deleted page CTE (one-of concept description, now just treated on the page that includes it)
14:48, 14 June 2022 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)
14:42, 14 June 2022 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)
14:34, 14 June 2022 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")
14:29, 14 June 2022 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.")
13:59, 14 June 2022 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.)
09:57, 9 June 2022 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")
08:10, 9 June 2022 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.)
08:07, 9 June 2022 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.)
08:04, 9 June 2022 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.)
08:26, 2 June 2022 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")
08:23, 2 June 2022 Ttenbergen talk contribs deleted page HOBs (unneeded redirect)
07:17, 2 June 2022 Ttenbergen talk contribs created page Transfer Delay CC (Redirected page to Transfer Delay (Critical Care)) Tag: New redirect
19:54, 1 June 2022 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? ~~~~ }}")
09:28, 31 May 2022 Ttenbergen talk contribs deleted page Laptop prep.vbs (file no longer exists and hasn't been used in 7years, so deleting)
08:11, 26 May 2022 Ttenbergen talk contribs deleted page Minimalbreak (test page no longer needed)
15:20, 19 May 2022 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...")
08:30, 19 May 2022 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...")
15:59, 18 May 2022 Ttenbergen talk contribs created page "MR Organizer" button (Redirected page to MR Organizer form) Tag: New redirect
10:01, 18 May 2022 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. }}")
08:34, 11 May 2022 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")
10:09, 9 May 2022 Ttenbergen talk contribs moved page Created TrasferDelay to Created TransferDelay without leaving a redirect
10:09, 9 May 2022 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")
14:09, 4 May 2022 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...")
13:49, 4 May 2022 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...")
13:11, 3 May 2022 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
12:33, 3 May 2022 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...")
14:11, 27 April 2022 Ttenbergen talk contribs deleted page Created APACHEChronic comparison query (query no longer needed)
13:52, 27 April 2022 Ttenbergen talk contribs deleted page Query Covid rept (ended up disfunctional/not needed)
13:50, 27 April 2022 Ttenbergen talk contribs deleted page Form Covid rept (ended up disfunctional/not needed)
13:45, 27 April 2022 Ttenbergen talk contribs deleted page User:Ttenbergen/questions remaining from Cognos changes (no need for separate list)
13:45, 27 April 2022 Ttenbergen talk contribs deleted page User:Ttenbergen/questions remaining from COVID changes (none left)
10:47, 27 April 2022 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)
15:59, 26 April 2022 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)
13:20, 26 April 2022 Ttenbergen talk contribs created page Combiner tab resorts after entering (Created page with "{{Bug}}")
13:00, 20 April 2022 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...")
08:46, 20 April 2022 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")
09:51, 19 April 2022 Ttenbergen talk contribs deleted page "MR copy-paste" button (removing this button)
15:08, 14 April 2022 Ttenbergen talk contribs deleted page L First Boarding Loc Non ER query (wasn't really doing what we need it to)
15:00, 14 April 2022 Ttenbergen talk contribs deleted page Query s tmp Boarding Loc ER plus LT 30 (replaced by query s_tmp_Boarding_Loc_ER_delay_reasonable)
14:59, 14 April 2022 Ttenbergen talk contribs deleted page Query check ER Delay not too big (replaced with query s_tmp_Boarding_Loc_ER_delay_reasonable)
14:49, 14 April 2022 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 }}...")
10:20, 13 April 2022 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...")
09:21, 13 April 2022 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.")
09:14, 13 April 2022 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")
09:12, 13 April 2022 Ttenbergen talk contribs deleted page Category:Quality and Process Engineering Group (Empty Category)
16:28, 7 April 2022 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.")
12:45, 7 April 2022 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 -...")
09:58, 6 April 2022 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...")
14:34, 31 March 2022 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...")
14:05, 31 March 2022 Ttenbergen talk contribs deleted page Data Integrity Checks/review list (all questions have now been reviewed)
08:42, 31 March 2022 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...")
20:35, 24 March 2022 Ttenbergen talk contribs moved page PL missing L Tables content to Reconnect check missing L Tables content query without leaving a redirect
19:42, 24 March 2022 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)
15:50, 24 March 2022 Ttenbergen talk contribs moved page Check for Completes query to Reconnect check Completes query without leaving a redirect
15:40, 24 March 2022 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")
15:39, 24 March 2022 Ttenbergen talk contribs deleted page Cleaning up a failed send (Process is now almost trivial so was just rolled in with Re-sending data)
15:16, 24 March 2022 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...")
14:07, 24 March 2022 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
14:06, 24 March 2022 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...")
12:47, 24 March 2022 Ttenbergen talk contribs deleted page SubAcute (service type concept was discontinued)
12:37, 24 March 2022 Ttenbergen talk contribs deleted page Service type (No longer used so removing documentation)
12:33, 24 March 2022 Ttenbergen talk contribs deleted page S dispo.service type (Field eliminated since we no longer use NTU etc)
08:20, 24 March 2022 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...")
16:02, 23 March 2022 Ttenbergen talk contribs moved page Capsule Endoscopy Picklist to Capsule Endoscopy without leaving a redirect (bad copy-paste)
15:01, 23 March 2022 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...")
12:26, 23 March 2022 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...")
10:53, 17 March 2022 Ttenbergen talk contribs uploaded a new version of File:Legacy.svg
10:52, 17 March 2022 Ttenbergen talk contribs uploaded a new version of File:Legacy.svg
10:50, 17 March 2022 Ttenbergen talk contribs created page File:Legacy.svg
10:50, 17 March 2022 Ttenbergen talk contribs uploaded File:Legacy.svg
10:11, 17 March 2022 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")
10:11, 17 March 2022 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")
10:10, 17 March 2022 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")
10:10, 17 March 2022 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")
10:10, 17 March 2022 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")
10:10, 17 March 2022 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")
10:10, 17 March 2022 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")
10:10, 17 March 2022 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")
10:10, 17 March 2022 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")
15:25, 16 March 2022 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...")
15:00, 16 March 2022 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))
14:47, 16 March 2022 Ttenbergen talk contribs moved page Palliative to Palliative (concept) without leaving a redirect
14:34, 16 March 2022 Ttenbergen talk contribs created page Invasive mechanical ventilation at 2300 hrs (concept) (Created page with "{{Indicator}}")
21:49, 17 February 2022 Ttenbergen talk contribs deleted page Requested TISS changes for the next version (Not using the TISS mdb any more, so no more changes.)
20:07, 17 February 2022 Ttenbergen talk contribs deleted page Directors Quarterly Report (Medicine) (see Directors Quarterly and Annual Report (Medicine))
17:37, 17 February 2022 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.)
16:58, 17 February 2022 Ttenbergen talk contribs deleted page Transfer time rule (no longer done, and has no bearing on future interpretation of data, so deleting.)
16:20, 17 February 2022 Ttenbergen talk contribs deleted page Query check ICD10 some cant be PCAA (evil twin of Controlling Dx Type for ICD10 codes)
15:58, 17 February 2022 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)
15:58, 17 February 2022 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")
15:57, 17 February 2022 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.")
15:46, 17 February 2022 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")
15:41, 17 February 2022 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...")
15:36, 17 February 2022 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")
15:34, 17 February 2022 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")
15:31, 17 February 2022 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")
15:06, 17 February 2022 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...")
14:28, 17 February 2022 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)
17:44, 14 February 2022 Ttenbergen talk contribs deleted page Logs (didn't solve the problem)
13:46, 14 February 2022 Ttenbergen talk contribs created page Logs (Redirected page to Log) Tag: New redirect
17:31, 10 February 2022 Ttenbergen talk contribs deleted page S dispo chooser (was never fully implemented and is not needed.)
16:21, 10 February 2022 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")
15:27, 10 February 2022 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...")
15:18, 10 February 2022 Ttenbergen talk contribs deleted page Query check CCI vs LOS count days (unlinked redirect)
15:18, 10 February 2022 Ttenbergen talk contribs moved page Query check CCI vs LOS count days to Query check CCI vs LOS count days component
13:55, 10 February 2022 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}}")
13:35, 10 February 2022 Ttenbergen talk contribs created page Category:Location Information (Created page with "Pages related to or containing Location metadata storage.")
10:27, 10 February 2022 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 ||...")
21:06, 9 February 2022 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>")
21:06, 9 February 2022 Ttenbergen talk contribs deleted page Manager's list (moved content to Database Manager)
21:00, 9 February 2022 Ttenbergen talk contribs created page File:LK.png
21:00, 9 February 2022 Ttenbergen talk contribs uploaded File:LK.png
15:11, 9 February 2022 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")
15:55, 8 February 2022 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...")
14:43, 8 February 2022 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 infrastructure Category:Drug and substance template ---- </noinclude>=== Common antiseizure drugs === * barbiturates * dilantin/hydantoin * keppra * gabapentin")
14:41, 8 February 2022 Ttenbergen talk contribs deleted page Antiseizure drug NOS,, adverse effect (unlinked redirect)
14:31, 8 February 2022 Ttenbergen talk contribs deleted page Barbituates (unlinked redirect)
14:39, 2 February 2022 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")
14:15, 2 February 2022 Ttenbergen talk contribs moved page Anti-arrythmic, overdose/toxicity to Anti-arrhythmic, overdose/toxicity without leaving a redirect (Text replacement - "arrythmic" to "arrhythmic")
14:15, 2 February 2022 Ttenbergen talk contribs moved page Anti-arrythmic, adverse effect to Anti-arrhythmic, adverse effect without leaving a redirect (Text replacement - "arrythmic" to "arrhythmic")
16:39, 27 January 2022 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)
16:39, 27 January 2022 Ttenbergen talk contribs deleted page GRA Boarding Locations (No longer needed after Change of remaining location names from "our" names to EPR/Cognos names)
16:39, 27 January 2022 Ttenbergen talk contribs deleted page STB Boarding Locations (No longer needed after Change of remaining location names from "our" names to EPR/Cognos names)
09:31, 27 January 2022 Ttenbergen talk contribs deleted page Directors Annual Report (Medicine) (Replaces by directors quarterly and annual report)
09:30, 27 January 2022 Ttenbergen talk contribs deleted page Directors Annual Report (Critcal Care) (replaced by Directors Quarterly and Annual Report)
17:29, 26 January 2022 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")
13:44, 17 January 2022 Ttenbergen talk contribs deleted page Upgrading from Office/Access 2010 to 2019 (update complete for everyone, project and info no longer relevant)
11:03, 13 January 2022 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
16:39, 12 January 2022 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)
16:16, 12 January 2022 Ttenbergen talk contribs deleted page Director's Chart Report (evil twin of Critical Care Program Quality Indicator Report)
09:15, 12 January 2022 Ttenbergen talk contribs deleted page ZCM Agent Roll-out (no further relevance)
17:57, 6 January 2022 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...")
14:03, 6 January 2022 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)
16:59, 5 January 2022 Ttenbergen talk contribs deleted page Critical Care Inter-facility Transfer Report (no longer done)
16:21, 5 January 2022 Ttenbergen talk contribs moved page ICU Primary Diagnosis APACHE Category Rate to ICU Diagnosis APACHE Category Rate without leaving a redirect (not just primary)
15:19, 5 January 2022 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>  {{#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...")
15:12, 5 January 2022 Ttenbergen talk contribs created page Centralized data front end.accdb Change Log 2022 (Created page with "__NOTOC__  ''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...")
15:08, 5 January 2022 Ttenbergen talk contribs created page CCMDB.accdb Change Log 2022 (Created page with "__NOTOC__  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...")
12:11, 5 January 2022 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")
11:51, 5 January 2022 Ttenbergen talk contribs moved page S AP AdmitType to S AP AdmitType table without leaving a redirect
09:35, 5 January 2022 Ttenbergen talk contribs deleted page Public Entrance Likely Initial Page (Main page was changed so this is no longer needed)
09:09, 5 January 2022 Ttenbergen talk contribs created page Team Meeting 2022-04-26 (Just starting the page as anchor for link)
10:42, 4 January 2022 Ttenbergen talk contribs moved page Category:2022 Data Collection Team Meeting to Category:2022 Data Collection Team Meetings without leaving a redirect
10:42, 4 January 2022 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")
15:38, 30 December 2021 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.")
15:36, 30 December 2021 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...")
15:31, 30 December 2021 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")
15:13, 30 December 2021 Ttenbergen talk contribs created page Category:COVID (Created page with "Category:ICD10 Diagnosis Category:Misc Category:Infectious disease‎")
15:11, 30 December 2021 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}}")
16:55, 29 December 2021 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...")
16:32, 29 December 2021 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...")
16:31, 29 December 2021 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...")
16:16, 29 December 2021 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...")
16:13, 29 December 2021 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 !|...")
10:08, 29 December 2021 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))
10:07, 29 December 2021 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))
10:07, 29 December 2021 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))
10:07, 29 December 2021 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))
10:07, 29 December 2021 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))
10:07, 29 December 2021 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))
10:07, 29 December 2021 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))
09:08, 23 December 2021 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))
15:24, 22 December 2021 Ttenbergen talk contribs deleted page Wiki onto laptops (Not gonna happen and no longer an issue with modern wifi)
15:23, 22 December 2021 Ttenbergen talk contribs deleted page Exporting the wiki (ancient info that isn't relevant any more)
10:18, 22 December 2021 Ttenbergen talk contribs deleted page Tracheostomy days (Deleted at Julie's requests since it's not a regular indicator, and not linked from anywhere.)
10:18, 22 December 2021 Ttenbergen talk contribs deleted page Hemodialysis days (Deleted at Julie's requests since it's not a regular indicator, and not linked from anywhere.)
14:17, 16 December 2021 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 }}")
10:37, 16 December 2021 Ttenbergen talk contribs changed visibility of 2 revisions on page Bed census.mdb: content unhidden, edit summary unhidden and username unhidden
19:39, 15 December 2021 Ttenbergen talk contribs changed visibility of 86 revisions on page Bed census.mdb: content hidden, edit summary hidden and username hidden
17:25, 15 December 2021 Ttenbergen talk contribs deleted page CT Summary discharges FiscalYear query (evil twon of CT_Summary_Discharges_FiscalYear query)
17:24, 15 December 2021 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")
14:54, 15 December 2021 Ttenbergen talk contribs deleted page Property:TISS28RowNumber (no longer used)
14:23, 15 December 2021 Ttenbergen talk contribs deleted page Property:Collection Collector (no longer used)
12:02, 15 December 2021 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)
16:52, 14 December 2021 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...")
16:47, 14 December 2021 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...")
16:47, 14 December 2021 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...")
16:28, 8 December 2021 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...")
16:23, 8 December 2021 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...")
15:48, 8 December 2021 Ttenbergen talk contribs deleted page CRRT Monthly Report (evil twin of CRRT Report)
15:55, 1 December 2021 Ttenbergen talk contribs replaced the Cargo table Indicators with a new version
15:41, 1 December 2021 Ttenbergen talk contribs recreated the Cargo table Indicators
11:24, 1 December 2021 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")
16:22, 24 November 2021 Ttenbergen talk contribs recreated the Cargo table Drugs_Included
15:55, 24 November 2021 Ttenbergen talk contribs moved page Template:Pharmacy to Template:Drugs included without leaving a redirect
15:41, 24 November 2021 Ttenbergen talk contribs replaced the Cargo table Drugs_Included with a new version
15:25, 24 November 2021 Ttenbergen talk contribs created the Cargo table Drugs_Included
15:25, 24 November 2021 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...")
11:36, 24 November 2021 Ttenbergen talk contribs deleted the Cargo table Data_Element
11:16, 24 November 2021 Ttenbergen talk contribs created the Cargo table Data_Element
09:57, 24 November 2021 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'...")
14:26, 18 November 2021 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)
14:14, 18 November 2021 Ttenbergen talk contribs moved page Length of Stay (Critical Care Report) to LOS per Service without leaving a redirect
14:13, 18 November 2021 Ttenbergen talk contribs deleted page LOS per Service (evil twin)
14:12, 18 November 2021 Ttenbergen talk contribs moved page Length of Stay (ICU Report) to Length of Stay (Critical Care Report) without leaving a redirect
14:09, 18 November 2021 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)")
13:51, 18 November 2021 Ttenbergen talk contribs moved page LOS per Critical Care Unit to LOS per Location without leaving a redirect
13:46, 18 November 2021 Ttenbergen talk contribs deleted page Multiple encounter linking checks (This is all dealt with elsewhere now.)
13:32, 18 November 2021 Ttenbergen talk contribs moved page ICU Beds Occupied by Transferable Patients to Beds occupied by transferrable patients (Critical Care) without leaving a redirect
13:30, 18 November 2021 Ttenbergen talk contribs moved page Beds Occupied by Transferable Patients to ICU Beds Occupied by Transferable Patients without leaving a redirect
13:30, 18 November 2021 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...")
10:03, 18 November 2021 Ttenbergen talk contribs created page OIT (Redirected page to Outcomes Improvement Team) Tag: New redirect
10:02, 18 November 2021 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")
14:53, 17 November 2021 Ttenbergen talk contribs deleted page Created Variables common table (evil twin of Created Variables Common table)
14:51, 17 November 2021 Ttenbergen talk contribs deleted page Created Variables common maker query (evil twin of Created Variables Common maker query)
14:40, 17 November 2021 Ttenbergen talk contribs deleted page Form:CCMDB Element (evil twin of ...Data Element...)
14:40, 17 November 2021 Ttenbergen talk contribs deleted page Category:CCMDB Element (evil twin of ...Data Element...)
14:40, 17 November 2021 Ttenbergen talk contribs deleted page Template:CCMDB Element (evil twin of ...Data Element...)
09:32, 16 November 2021 Ttenbergen talk contribs deleted page File:Network speed issues.pdf (outdated)
09:26, 16 November 2021 Ttenbergen talk contribs deleted page Changing Network Provider Order when Regional Server is not working (outdated info)
13:31, 15 November 2021 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,...")
13:36, 10 November 2021 Ttenbergen talk contribs moved page Query check CCI TISS Intubation vs Intubated discontinuous to Query check CCI TISS discontinuous ETT without leaving a redirect
13:36, 10 November 2021 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...")
21:11, 9 November 2021 Ttenbergen talk contribs deleted page Phone numbers (content was: "#redirect:Contact", and the only contributor was "Ttenbergen" (talk))
21:10, 9 November 2021 Ttenbergen talk contribs deleted page Contact list (content was: "#redirect:Contact")
21:09, 9 November 2021 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...")
20:51, 9 November 2021 Ttenbergen talk contribs created page Category:About (Created page with "Pages with background info about our program.")
20:42, 9 November 2021 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...")
11:51, 3 November 2021 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
11:49, 3 November 2021 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
11:26, 2 November 2021 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_...")
11:26, 2 November 2021 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...")
14:31, 28 October 2021 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
11:22, 28 October 2021 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 ==...")
15:49, 27 October 2021 Ttenbergen talk contribs moved page GRA Med to GH-Med
15:49, 27 October 2021 Ttenbergen talk contribs moved page GRA N3 to GH-N3
15:49, 27 October 2021 Ttenbergen talk contribs moved page GRA N5 to GH-N5
15:49, 27 October 2021 Ttenbergen talk contribs moved page GRA OVER to GH-OVER
15:49, 27 October 2021 Ttenbergen talk contribs moved page GRA S3 to GH-S3
15:49, 27 October 2021 Ttenbergen talk contribs moved page GRA W3 to GH-W3
15:48, 27 October 2021 Ttenbergen talk contribs moved page GRA MICU to GH-MICU
15:48, 27 October 2021 Ttenbergen talk contribs moved page GRA EMIP to GH-EMIP
15:47, 27 October 2021 Ttenbergen talk contribs moved page GRA CC to GH-CC
15:46, 27 October 2021 Ttenbergen talk contribs moved page GRA CAU to GH-CAU
15:45, 27 October 2021 Ttenbergen talk contribs moved page GRA 5S C to GH-5S C
15:45, 27 October 2021 Ttenbergen talk contribs moved page GRA 2S to GH-2S
14:20, 27 October 2021 Ttenbergen talk contribs moved page Query check CCI ICD10 Dialysis has Dx to Query check CCI ICD10 Dialysis no Dx without leaving a redirect
10:36, 27 October 2021 Ttenbergen talk contribs created page External User Portal for the Manitoba Critical Care and Medicine Databases (Created page with "{{DA| As requested}}")
10:15, 27 October 2021 Ttenbergen talk contribs created page Location (Redirected page to Boarding Loc) Tag: New redirect
08:55, 25 October 2021 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...")
08:30, 25 October 2021 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...")
10:32, 21 October 2021 Ttenbergen talk contribs created page Category:Legacy Tmp check (Created page with "Category:Legacy Content Category:Data Integrity Checks")
09:50, 21 October 2021 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))
09:42, 21 October 2021 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")
08:26, 21 October 2021 Ttenbergen talk contribs moved page ICU Mortality to Unit Mortality without leaving a redirect
14:29, 20 October 2021 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...")
13:50, 20 October 2021 Ttenbergen talk contribs created page Category:Dialysis (Created page with "Pages related to dialysis")
13:24, 20 October 2021 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]...")
13:22, 20 October 2021 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))
10:48, 19 October 2021 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...")
16:10, 7 October 2021 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")
14:30, 7 October 2021 Ttenbergen talk contribs created page Category:Legacy Registry check (Created page with "Category:Registry checks")
13:52, 7 October 2021 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")
15:29, 6 October 2021 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))
12:50, 5 October 2021 Ttenbergen talk contribs deleted page Template:SQL (can't make it work so delete)
10:32, 5 October 2021 Ttenbergen talk contribs created page Template:/pre (Created page with "</pre>")
10:32, 5 October 2021 Ttenbergen talk contribs created page Template:Pre (Created page with "<pre>")
10:19, 5 October 2021 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...")
09:05, 5 October 2021 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...")
14:49, 4 October 2021 Ttenbergen talk contribs created page User:Ttenbergen/pastebin (Created page with "== SMW ================================================= {{#ask: [[CommitteeMember::={{PAGENAME}}]] Category:something [[Property::something]] DICStatus::!retired V...")
15:55, 29 September 2021 Ttenbergen talk contribs recreated the Cargo table ICD10_Dx
10:42, 29 September 2021 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...")
10:39, 29 September 2021 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_...")
09:42, 29 September 2021 Ttenbergen talk contribs moved page Cognos Hospital Discharge query to Cognos2 Hospital Discharge query without leaving a redirect
09:40, 29 September 2021 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...")
12:36, 23 September 2021 Ttenbergen talk contribs moved page Query check CCI TISS Dxs vs Dialysis to Query check CCI ICD10 Dialysis has Dx without leaving a redirect
08:34, 23 September 2021 Ttenbergen talk contribs moved page Query Check CCI CXR vs LOS to Query check CCI CXR vs LOS without leaving a redirect
08:33, 23 September 2021 Ttenbergen talk contribs moved page Check CCI CXR vs LOS to Query Check CCI CXR vs LOS without leaving a redirect
13:42, 22 September 2021 Ttenbergen talk contribs moved page Cardiac arrythmia, NOS to Cardiac arrhythmia, NOS without leaving a redirect (typo)
15:38, 16 September 2021 Ttenbergen talk contribs deleted page Query TISS Errors ETT consistent (evil twin of Query check CCI TISS Intubation vs Intubated)
14:04, 16 September 2021 Ttenbergen talk contribs deleted page Query L First Boarding loc (see Created FirstLocation query)
13:41, 16 September 2021 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}}")
10:09, 16 September 2021 Ttenbergen talk contribs moved page Query Check CCI vs LOS count days to Query check CCI vs LOS count days without leaving a redirect
10:08, 16 September 2021 Ttenbergen talk contribs moved page Check CCI vs LOS count days to Query Check CCI vs LOS count days without leaving a redirect
10:05, 16 September 2021 Ttenbergen talk contribs moved page Check CCI vs LOS count each day to Check CCI vs LOS count days without leaving a redirect
10:05, 16 September 2021 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;...")
12:31, 8 September 2021 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")
10:33, 8 September 2021 Ttenbergen talk contribs moved page Category:TISS28 checks to Category:TISS28 check without leaving a redirect (Text replacement - "TISS28 checks" to "TISS28 check")
10:33, 8 September 2021 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")
10:12, 8 September 2021 Ttenbergen talk contribs deleted page WRHA Critical Care Quality Indicator Chart Report (see Directors Quarterly Report (Critical Care))
15:24, 2 September 2021 Ttenbergen talk contribs deleted page Query check CCI TISS per service (evil twin of Query check CCI TISS matching BoardingLoc time)
13:02, 2 September 2021 Ttenbergen talk contribs moved page User talk:TOstryzniuk to Manager's list without leaving a redirect
12:59, 2 September 2021 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.)
09:58, 2 September 2021 Ttenbergen talk contribs created page Category:Legacy CCI Px check (Created page with "Category:CCI Px check")
09:55, 2 September 2021 Ttenbergen talk contribs created page Category:Legacy TISS28 checks (Created page with "Category:TISS28 checks")
09:49, 2 September 2021 Ttenbergen talk contribs deleted page Tiss28 Form Scanning (unlinked redirect)
09:43, 2 September 2021 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")
08:56, 2 September 2021 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)
15:38, 1 September 2021 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...")
15:37, 1 September 2021 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...")
15:23, 1 September 2021 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)")
15:21, 1 September 2021 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))
15:18, 1 September 2021 Ttenbergen talk contribs undeleted page Supp O2 No ETT No Trach (TISS Item) (2 revisions)
15:17, 1 September 2021 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))
15:13, 1 September 2021 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.)
15:11, 1 September 2021 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)")
10:17, 26 August 2021 Ttenbergen talk contribs moved page P Count of sent query to CT Count of sent query without leaving a redirect
10:12, 26 August 2021 Ttenbergen talk contribs deleted page P queries (no more pivots in 2019, see CT queries)
10:11, 26 August 2021 Ttenbergen talk contribs deleted page P Outstanding Dispo query (see CT Outstandings Dispo query)
10:09, 26 August 2021 Ttenbergen talk contribs moved page P Summary Discharges FiscalYear query to CT Summary Discharges FiscalYear query without leaving a redirect
09:54, 26 August 2021 Ttenbergen talk contribs moved page P Summary Discharges query to CT Summary Discharges query without leaving a redirect (no more pivots)
09:49, 26 August 2021 Ttenbergen talk contribs moved page P Summary discharges FiscalYear query to P Summary Discharges FiscalYear query without leaving a redirect
09:26, 26 August 2021 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
09:24, 26 August 2021 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...")
13:15, 25 August 2021 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:...")
11:00, 25 August 2021 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")
10:39, 25 August 2021 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")
10:02, 25 August 2021 Ttenbergen talk contribs deleted page Category:P Query (see Category:CT Query)
10:02, 25 August 2021 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")
10:00, 25 August 2021 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...")
09:58, 25 August 2021 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...")
09:49, 25 August 2021 Ttenbergen talk contribs deleted page Manager (see Database Manager)
09:45, 25 August 2021 Ttenbergen talk contribs created page Database Manager (Created page with "Position previously held by p:Trish Ostryzniuk... == Related articles == {{Related Articles}} *")
16:04, 24 August 2021 Ttenbergen talk contribs moved page GRA PACU to GH-Recovery Room without leaving a redirect
09:13, 5 August 2021 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...")
15:58, 4 August 2021 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))
15:58, 4 August 2021 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))
15:58, 4 August 2021 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)
15:25, 4 August 2021 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)
14:55, 4 August 2021 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...")
14:55, 4 August 2021 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...")
14:54, 4 August 2021 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...")
09:56, 4 August 2021 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)
09:55, 4 August 2021 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...")
09:54, 4 August 2021 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...")
09:54, 4 August 2021 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...")
08:46, 4 August 2021 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...")
15:48, 29 July 2021 Ttenbergen talk contribs moved page Query check tmp service chrono boardind trasfer to Query check tmp service chrono boarding trasfer without leaving a redirect
15:48, 29 July 2021 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...")
15:04, 29 July 2021 Ttenbergen talk contribs created page Discharge Date (Redirected page to Dispo DtTm) Tag: New redirect
09:23, 28 July 2021 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}}...")
16:06, 27 July 2021 Ttenbergen talk contribs created page CFE Inline Integrity Checks (moved here from Change Priorities)
13:48, 27 July 2021 Ttenbergen talk contribs created page "Generate Person IDs" button (Redirected page to Generate Person IDs) Tag: New redirect
09:07, 27 July 2021 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...")
09:05, 27 July 2021 Ttenbergen talk contribs created page Category:P Query (Created page with "P queries are a set of data processing queries. Category:Data Processing")
12:59, 22 July 2021 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...")
12:15, 22 July 2021 Ttenbergen talk contribs moved page EPR LMS training to LMS training without leaving a redirect (Text replacement - "EPR LMS training" to "LMS training")
11:12, 22 July 2021 Ttenbergen talk contribs deleted page Publication Listing Test (testing orphan)
18:03, 21 July 2021 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))
18:02, 21 July 2021 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
14:43, 21 July 2021 Ttenbergen talk contribs deleted page Category:Potential Change (no longer using this wiki infrastructire)
14:37, 21 July 2021 Ttenbergen talk contribs deleted page File:Change pot.svg (no longer used)
14:37, 21 July 2021 Ttenbergen talk contribs deleted page Template:Potential Change (no longer used)
12:38, 21 July 2021 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.)
14:07, 19 July 2021 Ttenbergen talk contribs created page User:Rlabossiere (Redirected page to p:Rosanne Labossiere-Gee) Tag: New redirect
13:55, 19 July 2021 Ttenbergen talk contribs changed group membership for Rlabossiere from (none) to CCMDB_legit
13:55, 19 July 2021 User account Rlabossiere talk contribs was created by Ttenbergen talk contribs and password was sent by email
15:26, 15 July 2021 Ttenbergen talk contribs moved page NCD dx implying death across encounters to Query NCD dx implying death across encounters without leaving a redirect (consistency)
14:41, 15 July 2021 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")
13:57, 15 July 2021 Ttenbergen talk contribs created page LSusp button (Redirected page to Correcting suspect links) Tag: New redirect
13:12, 15 July 2021 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.)
09:02, 15 July 2021 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...")
14:39, 14 July 2021 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...")
13:10, 14 July 2021 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...")
12:56, 14 July 2021 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...")
08:09, 14 July 2021 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...")
08:09, 14 July 2021 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...")
16:32, 13 July 2021 Ttenbergen talk contribs moved page 72hr Readmission Rate to ICU to Readmission Rate to ICU without leaving a redirect (as per Julie's request)
16:28, 13 July 2021 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...")
16:10, 13 July 2021 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...")
15:42, 13 July 2021 Ttenbergen talk contribs moved page Director's chart report to Director's Chart Report without leaving a redirect (It's a proper noun)
15:10, 13 July 2021 Ttenbergen talk contribs deleted page Directors Quarterly Report - Activity Summary (nothing links here and we already have a page for quarterly reports)
15:05, 13 July 2021 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...")
15:04, 13 July 2021 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...")
14:55, 13 July 2021 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...")
14:55, 13 July 2021 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...")
14:44, 13 July 2021 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...")
14:44, 13 July 2021 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...")
13:24, 13 July 2021 Ttenbergen talk contribs created page MediaWiki:Mytalk (don't want anything listed there)
13:18, 13 July 2021 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: ")
12:36, 13 July 2021 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>...")
15:38, 8 July 2021 Ttenbergen talk contribs deleted page Eyes button (no more eyes button)
15:10, 8 July 2021 Ttenbergen talk contribs deleted page Category:EPR Reports Integrator (No more EPR Reports Integrator)
15:09, 8 July 2021 Ttenbergen talk contribs deleted page EPR Reports Integrator (No more EPR Reports Integrator)
14:49, 8 July 2021 Ttenbergen talk contribs deleted page SL EPR Logs table (No more EPR Reports Integrator)
14:37, 8 July 2021 Ttenbergen talk contribs deleted page 'add/open' button (No more EPR Reports Integrator)
14:34, 8 July 2021 Ttenbergen talk contribs deleted page EPR Logs form (No more EPR Reports Integrator)
14:31, 8 July 2021 Ttenbergen talk contribs deleted page Exporting EPR Reports for EPR Reports Integrator (No more EPR Reports Integrator)
14:31, 8 July 2021 Ttenbergen talk contribs deleted page Import EPR Reports button (No more EPR Reports Integrator)
14:30, 8 July 2021 Ttenbergen talk contribs deleted page View EPR Reports button (No more EPR Reports Integrator)
14:04, 8 July 2021 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...")
13:48, 8 July 2021 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_...")
08:36, 8 July 2021 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...")
15:45, 7 July 2021 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")
15:38, 7 July 2021 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 === *...")
09:14, 7 July 2021 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...")
10:46, 29 June 2021 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...")
10:31, 29 June 2021 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...")
15:36, 28 June 2021 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...")
15:25, 24 June 2021 Ttenbergen talk contribs moved page HSC and STB ICUs CRRT Days by Patient to CRRT Monthly Report without leaving a redirect
08:37, 24 June 2021 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...")
08:14, 24 June 2021 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...")
15:38, 15 June 2021 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 |...")
15:38, 15 June 2021 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 |...")
14:34, 15 June 2021 Ttenbergen talk contribs created page ClientVisitGUID (Redirected page to Hospitalization ID) Tag: New redirect
15:17, 10 June 2021 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...")
11:18, 10 June 2021 Ttenbergen talk contribs recreated the Cargo table ICD10_Category
10:02, 10 June 2021 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...")
08:47, 10 June 2021 Ttenbergen talk contribs deleted page Broken/ (content was: "test", and the only contributor was "Ttenbergen" (talk))
13:26, 9 June 2021 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 ==...")
13:08, 9 June 2021 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...")
15:26, 3 June 2021 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...")
14:39, 3 June 2021 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...")
14:01, 3 June 2021 Ttenbergen talk contribs deleted page Reset Button (button deleted, and no reason this should be kept as legacy info)
12:56, 3 June 2021 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")
12:41, 2 June 2021 Ttenbergen talk contribs deleted page LOS Record (evil twin of LOS Per Record)
14:54, 20 May 2021 Ttenbergen talk contribs created page Cognos Import Button (convenience redirect) Tag: New redirect
14:43, 20 May 2021 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...")
08:21, 18 May 2021 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...")
19:42, 13 May 2021 Ttenbergen talk contribs created the Cargo table ICD10_Dx
19:42, 13 May 2021 Ttenbergen talk contribs created the Cargo table ICD10_Category
14:58, 12 May 2021 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...")
09:44, 7 May 2021 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)
15:36, 6 May 2021 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...")
15:15, 5 May 2021 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>")
15:14, 5 May 2021 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...")
12:38, 5 May 2021 Ttenbergen talk contribs moved page Lost/missing charts to Lost/missing chart without leaving a redirect (should be singular for better linking)
21:24, 29 April 2021 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")
21:10, 29 April 2021 Ttenbergen talk contribs moved page Re-admission to Readmission without leaving a redirect (Text replacement - "Re-admission" to "Readmission")
20:58, 29 April 2021 Ttenbergen talk contribs deleted page Category:DC TX (deleting empty category)
09:45, 29 April 2021 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...")
09:29, 29 April 2021 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
09:14, 29 April 2021 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=...")
08:42, 29 April 2021 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...")
16:07, 28 April 2021 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...")
16:07, 28 April 2021 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...")
15:46, 28 April 2021 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...")
15:44, 28 April 2021 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...")
15:42, 28 April 2021 Ttenbergen talk contribs recreated the Cargo table Reports
15:05, 28 April 2021 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...")
14:48, 28 April 2021 Ttenbergen talk contribs recreated the Cargo table Reports
14:37, 28 April 2021 Ttenbergen talk contribs created the Cargo table Reports
14:37, 28 April 2021 Ttenbergen talk contribs created the Cargo table Indicators
14:19, 28 April 2021 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...")
14:14, 28 April 2021 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 |...")
14:12, 28 April 2021 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 |...")
13:51, 28 April 2021 Ttenbergen talk contribs created page Category:Reports (Created page with "Pages related to Reports. Category:Statistical Analysis Category:Reporting")
13:49, 28 April 2021 Ttenbergen talk contribs created page Reports (Created page with "This will contain an automatic listing of reports. == Related articles == {{Related Articles}} *")
13:48, 28 April 2021 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...")
15:42, 21 April 2021 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 }} =...")
15:31, 21 April 2021 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")
15:30, 21 April 2021 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")
15:16, 21 April 2021 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")
15:16, 21 April 2021 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")
15:16, 21 April 2021 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")
15:05, 21 April 2021 Ttenbergen talk contribs moved page S GCS to S GCS table without leaving a redirect (consistency of data table pages)
14:25, 21 April 2021 Ttenbergen talk contribs moved page Tracheostomy, presence to Tracheostomy creation over a redirect without leaving a redirect
14:25, 21 April 2021 Ttenbergen talk contribs deleted redirect Tracheostomy creation by overwriting (Deleted to make way for move from "Tracheostomy, presence")
14:16, 21 April 2021 Ttenbergen talk contribs moved page Tracheostomy creation (TISS Item) to Trach Tube Present (TISS Item) without leaving a redirect
13:51, 21 April 2021 Ttenbergen talk contribs moved page Category:Created variables CC table to Category:Created Variables CC table without leaving a redirect
13:37, 21 April 2021 Ttenbergen talk contribs moved page Category:Created variables common table to Category:Created Variables Common table without leaving a redirect
13:28, 21 April 2021 Ttenbergen talk contribs moved page Created variables common table to Created Variables Common table without leaving a redirect
13:28, 21 April 2021 Ttenbergen talk contribs moved page Created variables common maker query to Created Variables Common maker query without leaving a redirect
13:26, 21 April 2021 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...")
13:26, 21 April 2021 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...")
13:17, 21 April 2021 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")
13:17, 21 April 2021 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")
13:17, 21 April 2021 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")
13:17, 21 April 2021 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")
13:14, 21 April 2021 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.)
13:06, 21 April 2021 Ttenbergen talk contribs deleted page Category:Created variables CC table (see Category:Created Variables)
13:04, 21 April 2021 Ttenbergen talk contribs created page Category:Created Variables (Created page with "Pages related to the concept of "Created Variables" in CFE. Category:Data Use")
13:01, 21 April 2021 Ttenbergen talk contribs moved page Created variables common to Created variables common table without leaving a redirect (reverting to name incl "table")
13:01, 21 April 2021 Ttenbergen talk contribs deleted page Created variables common table (reverting to full name)
13:57, 15 April 2021 Ttenbergen talk contribs deleted page Accept DtTm Equiv (not used any more)
13:49, 15 April 2021 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)
10:55, 14 April 2021 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...")
15:13, 8 April 2021 Ttenbergen talk contribs moved page Trach Tube Present (TISS Item) to Tracheostomy creation (TISS Item) without leaving a redirect (had been moved in error)
15:13, 8 April 2021 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)
15:13, 8 April 2021 Ttenbergen talk contribs deleted redirect CVC placement, any location by overwriting (Deleted to make way for move from "CVC presence, any location")
16:09, 7 April 2021 Ttenbergen talk contribs moved page Tracheostomy creation to Tracheostomy, presence (definition and name tweaked)
16:06, 7 April 2021 Ttenbergen talk contribs moved page CVC placement, any location to CVC presence, any location
15:12, 7 April 2021 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)
12:34, 7 April 2021 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)
12:32, 7 April 2021 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...")
15:02, 1 April 2021 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...")
13:16, 1 April 2021 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...")
12:45, 1 April 2021 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...")
10:23, 1 April 2021 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...")
08:39, 1 April 2021 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)
11:14, 31 March 2021 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)
11:07, 31 March 2021 Ttenbergen talk contribs moved page Query NDC TISS vs pharmacy to Query check CCI TISS vs Pharmacy without leaving a redirect (consistency)
10:54, 31 March 2021 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)
10:12, 31 March 2021 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...)
14:01, 24 March 2021 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...")
13:43, 24 March 2021 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...")
10:10, 23 March 2021 Ttenbergen talk contribs deleted the Cargo table Newsflash
09:40, 23 March 2021 Ttenbergen talk contribs created page Unknown patient (Redirected page to John or Jane Doe patient) Tag: New redirect
09:01, 19 March 2021 Ttenbergen talk contribs deleted page "Test" code tag (can't find any reference of whatever I was doing here, so deleting.)
15:19, 18 March 2021 Ttenbergen talk contribs recreated the Cargo table Discussions
14:24, 18 March 2021 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.)
14:24, 18 March 2021 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.)
13:32, 18 March 2021 Ttenbergen talk contribs created page Delete button (Created page with "Could mean one of the following: * ♻️ button * "Delete Sent Patients" button")
12:37, 18 March 2021 Ttenbergen talk contribs created page Surgery (made automatic listing page just for completeness, absence caused redlinks)
12:31, 18 March 2021 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...")
12:17, 18 March 2021 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")
17:59, 4 March 2021 Ttenbergen talk contribs moved page Sub CognosImport to Function CognosImport without leaving a redirect (Text replacement - "Sub CognosImport" to "Function CognosImport")
14:58, 4 March 2021 Ttenbergen talk contribs deleted page Employee Assistance Program (was never filled in and there must be better sources)
14:45, 4 March 2021 Ttenbergen talk contribs deleted page Category:Paperwork (category was almost empty and not meaningful, so emptied it and deleting)
14:44, 4 March 2021 Ttenbergen talk contribs created page Category:Legacy Forms (Created page with "Category:Forms")
14:37, 4 March 2021 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.)
10:52, 4 March 2021 Ttenbergen talk contribs deleted page Spam Quarantine Notification from IronPort (No more IronPot)
11:24, 12 February 2021 Ttenbergen talk contribs created page Chastity (Redirected page to Decision Support Services#Contact) Tag: New redirect
15:50, 11 February 2021 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...")
13:40, 11 February 2021 Ttenbergen talk contribs created page ♻️ button (Created page with "The {{PAGENAME}} deletes a patient.")
13:01, 4 February 2021 Ttenbergen talk contribs created page CFE Log (Redirected page to Centralized data front end.accdb Change Log 2021) Tag: New redirect
14:50, 3 February 2021 Ttenbergen talk contribs deleted page Service Boarding Transfer Chrono (evil twin of query check_transfer_ready_tmp_LT_first_Boarding_Loc)
14:18, 3 February 2021 Ttenbergen talk contribs moved page Check has transfer ready entry to Query check has transfer ready date or checkbox without leaving a redirect
18:38, 28 January 2021 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))
18:38, 28 January 2021 Ttenbergen talk contribs moved page Query check check transfer DtTm during admission to Query check transfer DtTm during admission
18:30, 28 January 2021 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
18:29, 28 January 2021 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)
17:09, 28 January 2021 Ttenbergen talk contribs moved page Query heck CCI TISS Vented without mechanism to Query check CCI TISS Vented without mechanism without leaving a redirect
17:02, 28 January 2021 Ttenbergen talk contribs moved page Check CCI TISS Vented without mechanism to Query heck CCI TISS Vented without mechanism without leaving a redirect
16:42, 28 January 2021 Ttenbergen talk contribs moved page Query TISS Errors Vent vs mechanism to Check CCI TISS Vented without mechanism without leaving a redirect
16:04, 28 January 2021 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")
15:28, 28 January 2021 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")
13:54, 28 January 2021 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")
18:43, 27 January 2021 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...")
18:25, 27 January 2021 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...")
18:15, 27 January 2021 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...")
16:49, 27 January 2021 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...")
16:37, 27 January 2021 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 ")
16:29, 27 January 2021 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...")
13:59, 27 January 2021 Ttenbergen talk contribs deleted page Some button (testing only)
13:53, 27 January 2021 Ttenbergen talk contribs created page Some button (Created page with "test")
13:49, 27 January 2021 Ttenbergen talk contribs created page 👀 button (Created page with "test")
11:33, 26 January 2021 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...")
15:09, 21 January 2021 Ttenbergen talk contribs deleted page Query NDC CLI AcqDX but NoCLI DateinTMPV2 (no more tmp cli)
15:08, 21 January 2021 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...")
14:22, 21 January 2021 Ttenbergen talk contribs created page Eyes button (Redirected page to Process for bad data in Cognos) Tag: New redirect
14:21, 21 January 2021 Ttenbergen talk contribs created page Clock button (Redirected page to Cognos2 No Service or Loc in some time query) Tag: New redirect
14:21, 21 January 2021 Ttenbergen talk contribs created page ⏱ Button (Redirected page to Cognos2 No Service or Loc in some time query) Tag: New redirect
14:05, 21 January 2021 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)
12:28, 21 January 2021 Ttenbergen talk contribs deleted page User:Jthiessen (removed unused broken redirect)
12:23, 21 January 2021 Ttenbergen talk contribs deleted page ICU Database Task Group (removed unused redirect from old name)
12:21, 21 January 2021 Ttenbergen talk contribs deleted page Pending macro (unlinked broken redirect)
12:18, 21 January 2021 Ttenbergen talk contribs deleted page User:JWinestock (unlinked broken redirect)
12:18, 21 January 2021 Ttenbergen talk contribs deleted page User:Fquezon (unlinked broken redirect)
12:18, 21 January 2021 Ttenbergen talk contribs deleted page User talk:Fquezon (unlinked broken redirect)
12:17, 21 January 2021 Ttenbergen talk contribs deleted page Peptic Ulcer (there are multiple codes now and they include the words so no need for this.)
12:12, 21 January 2021 Ttenbergen talk contribs undeleted page Query TISS Errors missing days (14 revisions) (we still have forms coming in...)
12:07, 21 January 2021 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]])
11:28, 21 January 2021 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...")
11:11, 21 January 2021 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)
23:06, 20 January 2021 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...")
22:49, 20 January 2021 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...")
21:19, 20 January 2021 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...")
12:39, 19 January 2021 Ttenbergen talk contribs deleted page Cognos integrator query (defunct)
12:32, 19 January 2021 Ttenbergen talk contribs deleted page Cognos import table (defunct)
12:29, 19 January 2021 Ttenbergen talk contribs deleted page Cognos processed table (defunct)
12:27, 19 January 2021 Ttenbergen talk contribs deleted page Cognos import processor query (defunct)
10:19, 19 January 2021 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>=")
20:58, 15 January 2021 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...")
20:16, 15 January 2021 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...")
19:54, 15 January 2021 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...")
19:42, 15 January 2021 Ttenbergen talk contribs moved page Query Service or Location Duplicate to Query check tmp service or location duplicate without leaving a redirect (consistency)
19:35, 15 January 2021 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...")
12:08, 14 January 2021 Ttenbergen talk contribs deleted page Cognos Discharger (No more Cognos Discharger)
12:07, 14 January 2021 Ttenbergen talk contribs deleted page Cognos Discharger FormQuery query (removed as part of deleting Cognos Discharger)
12:00, 14 January 2021 Ttenbergen talk contribs deleted page Cognos Admitter (Cognos Admitter is no more.)
12:00, 14 January 2021 Ttenbergen talk contribs deleted page "EMIP" button (removed as part of removing Cognos Admitter)
11:53, 14 January 2021 Ttenbergen talk contribs deleted page Cognos Admitter FormQuery query (removed as part of deleting Cognos_Admitter)
11:29, 14 January 2021 Ttenbergen talk contribs deleted page Cognos Admit filter table (removed as partr of cleaning out Cognos Admitter)
11:25, 14 January 2021 Ttenbergen talk contribs deleted page "Mine! Mine!" button (gone after removal of Cognos Admitter)
11:20, 14 January 2021 Ttenbergen talk contribs deleted page Patient Viewer Tab Cognos ADT (replaced by Patient Viewer Tab Cognos ADT)
10:51, 14 January 2021 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.)
10:37, 14 January 2021 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...")
10:22, 14 January 2021 Ttenbergen talk contribs deleted page Cognos Patient viewer tab FormQuery query (This query was removed with the original Cognos ADT tab)
14:21, 12 January 2021 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...")
21:28, 6 January 2021 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...")
16:48, 6 January 2021 Ttenbergen talk contribs moved page Close - WITH or NO Updates button to Close - WITH or NO Updates buttons without leaving a redirect
16:42, 6 January 2021 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")
15:18, 6 January 2021 Ttenbergen talk contribs created page Patient Viewer Tab ADL (for completeness, we should have a page for this tab)
10:40, 5 January 2021 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")
10:40, 5 January 2021 Ttenbergen talk contribs created page CUS (Redirected page to Cognos2 Unit Starter) Tag: New redirect
20:38, 2 January 2021 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...")
20:17, 1 January 2021 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...")
20:08, 1 January 2021 Ttenbergen talk contribs created page Centralized data front end.accdb Change Log 2021 (Created page with "__NOTOC__  ''see the :Category: Development Documentatio...")
20:03, 1 January 2021 Ttenbergen talk contribs created page CCMDB.accdb Change Log 2021 (Created page with "__NOTOC__  See Log (disambiguation) for other uses of...")
19:58, 1 January 2021 Ttenbergen talk contribs created page CE (Redirected page to Cognos2 Ender) Tag: New redirect
16:21, 31 December 2020 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)
16:21, 31 December 2020 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)
15:03, 31 December 2020 Ttenbergen talk contribs moved page Cognos2 import Cognos2 Services query to Cognos3 import Cognos2 Services query without leaving a redirect (new query replaced old)
15:03, 31 December 2020 Ttenbergen talk contribs moved page Cognos2 import Cognos2 Units query to Cognos3 import Cognos2 Units query without leaving a redirect (new query replaced old)
14:09, 23 December 2020 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...")
11:03, 23 December 2020 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,...")
10:35, 23 December 2020 Ttenbergen talk contribs deleted page Date and Time formats (evil twin of Date and Time Format; unlinked)
13:25, 17 December 2020 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")
10:54, 16 December 2020 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...")
10:38, 16 December 2020 Ttenbergen talk contribs moved page TISS28 Collection Guide to TISS28 Legacy Guide for Paper Form Collection without leaving a redirect
10:32, 16 December 2020 Ttenbergen talk contribs moved page Limited TISS28 Collection to Limiting of TISS28 Collection without leaving a redirect
10:31, 16 December 2020 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...")
22:07, 15 December 2020 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...")
21:52, 15 December 2020 Ttenbergen talk contribs moved page Test code tag to "Test" code tag without leaving a redirect
21:18, 15 December 2020 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...")
19:27, 15 December 2020 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")
15:17, 15 December 2020 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...")
15:13, 15 December 2020 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...")
10:04, 15 December 2020 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")
12:50, 14 December 2020 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...")
18:01, 10 December 2020 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...")
16:47, 8 December 2020 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 (...")
09:57, 8 December 2020 Ttenbergen talk contribs moved page Reporting Indicators Documentation Health to Reporting Indicators Documentation Status without leaving a redirect
09:48, 8 December 2020 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...")
23:37, 7 December 2020 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 }}")
19:23, 3 December 2020 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...")
10:20, 3 December 2020 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.)
16:43, 2 December 2020 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)
16:38, 2 December 2020 Ttenbergen talk contribs deleted page Checking TISS Data from CCMDB.accdb (evil twin of Flagging for TISS)
15:14, 2 December 2020 Ttenbergen talk contribs recreated the Cargo table TISS_Items
14:55, 2 December 2020 Ttenbergen talk contribs recreated the Cargo table TISS_Items
14:48, 2 December 2020 Ttenbergen talk contribs recreated the Cargo table TISS_Items
14:47, 2 December 2020 Ttenbergen talk contribs recreated the Cargo table TISS_Items
14:45, 2 December 2020 Ttenbergen talk contribs recreated the Cargo table TISS_Items
14:43, 2 December 2020 Ttenbergen talk contribs created the Cargo table TISS_Items
12:09, 2 December 2020 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")
11:58, 2 December 2020 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...")
09:54, 2 December 2020 Ttenbergen talk contribs created page CCI collect each day (Redirected page to Template:CCI collect each day) Tag: New redirect
09:40, 2 December 2020 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. =...")
22:26, 26 November 2020 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...")
14:29, 26 November 2020 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...")
11:39, 26 November 2020 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...")
11:38, 26 November 2020 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)
21:18, 25 November 2020 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...")
21:18, 25 November 2020 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...")
21:17, 25 November 2020 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...")
20:59, 25 November 2020 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")
20:59, 25 November 2020 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")
20:59, 25 November 2020 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")
20:03, 25 November 2020 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 *...")
16:37, 25 November 2020 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...")
16:28, 25 November 2020 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...")
16:12, 25 November 2020 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...")
13:05, 25 November 2020 Ttenbergen talk contribs created page CSS (Redirected page to Cognos2 Service Starter) Tag: New redirect
18:48, 24 November 2020 Ttenbergen talk contribs created page Visit Admit DtTm (Redirected page to Visit Admit DtTm field) Tag: New redirect
11:11, 24 November 2020 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‎")
11:07, 23 November 2020 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...")
11:31, 20 November 2020 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}}")
00:42, 20 November 2020 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...")
14:43, 19 November 2020 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")
21:48, 13 November 2020 Ttenbergen talk contribs deleted page Ed's Medicine PDA Reader run time error 5 (bug in a long defunct program)
20:31, 13 November 2020 Ttenbergen talk contribs deleted page Category:CCVSM (no more ccvsm)
13:07, 10 November 2020 Ttenbergen talk contribs moved page Cognos Ender to Cognos2 Ender without leaving a redirect (consistency)
23:43, 5 November 2020 Ttenbergen talk contribs created page Cognos2 matcher query (Created page with "Populates Cognos Service Starter. == Related articles == {{Related Articles}} Category:Cognos2")
23:43, 5 November 2020 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")
23:43, 5 November 2020 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")
20:48, 5 November 2020 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...")
19:51, 5 November 2020 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...")
13:17, 5 November 2020 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...")
12:30, 5 November 2020 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...")
12:28, 5 November 2020 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...")
12:21, 5 November 2020 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...")
12:19, 5 November 2020 Ttenbergen talk contribs created page Category:Cognos2 (Created page with "Pages related to the Cognos2.")
12:18, 5 November 2020 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...")
12:18, 5 November 2020 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...")
11:46, 4 November 2020 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...")
10:01, 4 November 2020 Ttenbergen talk contribs moved page S Cognos Locations table to S Cognos Units table without leaving a redirect
10:00, 4 November 2020 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))
09:59, 4 November 2020 Ttenbergen talk contribs moved page S Cognos Locations additions needed query to S Cognos Units additions needed query
09:53, 4 November 2020 Ttenbergen talk contribs moved page Cognos SubServices additions needed query to S Cognos Services additions needed query without leaving a redirect
09:47, 4 November 2020 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")
09:33, 4 November 2020 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")
09:31, 4 November 2020 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")
09:24, 4 November 2020 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")
20:04, 1 November 2020 Ttenbergen talk contribs deleted page Swing bed (see Swap locations)
19:58, 1 November 2020 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}}")
19:47, 1 November 2020 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...")
11:38, 28 October 2020 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.)
14:17, 23 October 2020 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.)
15:16, 22 October 2020 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...")
16:05, 21 October 2020 Ttenbergen talk contribs created page Maltreatment (Created page with "{{ICD10 dx |ICD10 Code=T74 |StartDate=2020/10/21 }}")
10:54, 21 October 2020 Ttenbergen talk contribs moved page S PatientFollow distribution query to S PatientFollow distribution thisLaptop query without leaving a redirect (was built under wrong name)
10:53, 21 October 2020 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...")
10:44, 21 October 2020 Ttenbergen talk contribs created page "Show PatientFollow allocation" button (Created page with "Placeholder")
22:50, 20 October 2020 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...")
14:42, 20 October 2020 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...")
22:48, 18 October 2020 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.)
21:30, 18 October 2020 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.)
21:27, 18 October 2020 Ttenbergen talk contribs moved page Parked in ER to Parked in ER tmp entry without leaving a redirect
08:19, 16 October 2020 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...")
06:50, 16 October 2020 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")
00:19, 16 October 2020 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 = }}...")
00:19, 16 October 2020 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 = }}...")
00:18, 16 October 2020 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 = }}...")
23:51, 15 October 2020 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")
22:43, 15 October 2020 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...")
22:41, 15 October 2020 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...")
21:59, 15 October 2020 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...")
17:49, 15 October 2020 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...")
17:39, 15 October 2020 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...")
16:35, 15 October 2020 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...")
16:30, 15 October 2020 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,...")
16:14, 15 October 2020 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...")
16:14, 15 October 2020 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...")
16:00, 15 October 2020 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'...")
17:11, 13 October 2020 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 = |...")
16:43, 13 October 2020 Ttenbergen talk contribs created page Cognos data not showing up in ADT tab (new bug description and troubleshooting page.)
16:39, 13 October 2020 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.)
16:39, 13 October 2020 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.)
09:34, 9 October 2020 Ttenbergen talk contribs deleted page 2020 COVID Second Wave (was never used, replaced by 2020-10 EMIP changes)
20:44, 8 October 2020 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...")
20:28, 8 October 2020 Ttenbergen talk contribs created page HSC D4 pre COVID (Redirected page to HSC D4) Tag: New redirect
20:19, 8 October 2020 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")
18:45, 8 October 2020 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...")
08:51, 2 October 2020 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...")
08:49, 2 October 2020 Ttenbergen talk contribs created page Shingles (Redirected page to Template:ICD10 Guideline Shingles) Tag: New redirect
08:26, 2 October 2020 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...")
12:48, 23 September 2020 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...")
08:25, 23 September 2020 Ttenbergen talk contribs created page Marijuana (Redirected page to Category:Cannabis related) Tag: New redirect
11:41, 22 September 2020 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...")
08:16, 22 September 2020 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...")
08:59, 18 September 2020 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...")
12:58, 28 August 2020 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...")
13:45, 27 August 2020 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...")
13:38, 27 August 2020 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.)
08:38, 25 August 2020 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...")
09:54, 24 August 2020 Ttenbergen talk contribs created page File:STB Medical Records Request.pdf
09:54, 24 August 2020 Ttenbergen talk contribs uploaded File:STB Medical Records Request.pdf
08:28, 21 August 2020 Ttenbergen talk contribs created page Data collector xxdc account for EPR (Created page with " == Related articles == {{Related Articles}} Category: New Hire Category: IT Support")
12:59, 13 August 2020 Ttenbergen talk contribs deleted page HSC MS3 (this location never took off)
08:59, 7 August 2020 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...")
19:22, 4 August 2020 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 ...")
21:00, 30 July 2020 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")
21:00, 30 July 2020 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")
20:59, 30 July 2020 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")
20:59, 30 July 2020 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")
20:59, 30 July 2020 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")
20:59, 30 July 2020 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")
15:18, 30 July 2020 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...")
08:40, 30 July 2020 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...")
20:47, 29 July 2020 Ttenbergen talk contribs moved page Sampleinfoboxuser to SampleInfoboxUser without leaving a redirect
20:47, 29 July 2020 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.")
20:45, 29 July 2020 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...")
20:41, 29 July 2020 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...")
15:15, 29 July 2020 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 }}")
09:44, 29 July 2020 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...")
09:35, 29 July 2020 Ttenbergen talk contribs created page File:Related.png (button on Cognos Admitter that opens Previous entry form Category:Cognos Report Integrator)
09:35, 29 July 2020 Ttenbergen talk contribs uploaded File:Related.png (button on Cognos Admitter that opens Previous entry form Category:Cognos Report Integrator)
16:29, 28 July 2020 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)")
12:32, 28 July 2020 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...")
12:32, 28 July 2020 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 == {...")
12:32, 28 July 2020 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...")
12:27, 28 July 2020 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...")
10:47, 28 July 2020 Ttenbergen talk contribs deleted page Query Cognos import processor (evil twin of Cognos import processor query)
10:33, 28 July 2020 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...")
22:12, 24 July 2020 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...")
22:11, 24 July 2020 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...")
20:38, 24 July 2020 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...")

Main public logs

Navigation menu

Search