Data Collector Portal: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older editNewer edit →
Line 2: Line 2:
{{:News and Notices}}
{{:News and Notices}}
<!-- don't put content here directly, if we are going to keep that page let's transclude it. Or let's get rid of it... but let's not put some here and some there -->
<!-- don't put content here directly, if we are going to keep that page let's transclude it. Or let's get rid of it... but let's not put some here and some there -->
== Recent edits to pages with questions ==
{{Discuss |
* Figured the last 7 days of pages with questions that have been edited would be manageable, but hey that's still ''tons''! Let's see further how we can make that more manageable. }}
{{#cargo_query:
tables=Discussions, _pageData
|join on=Discussions._pageName=_pageData._pageName
|fields=Discussions._pageName=wiki page, question, _modificationDate=Last modified, CONCAT(" \{\{#show:", _pageData._pageName, "{{!}}?Last editor is \}\}")=LastEditor
|where=_modificationDate>(CURDATE()-7) AND (who="all" or who="")
|order by=LastEditor
|limit=1000
|rows per page=200
|default=no results were found
|format=table
}}


== Day to day items ==
== Day to day items ==

Revision as of 22:17, 30 April 2020

News and Notices

Recent edits to pages with questions

  • Figured the last 7 days of pages with questions that have been edited would be manageable, but hey that's still tons! Let's see further how we can make that more manageable.
  • SMW


  • Cargo


  • Categories
wiki page question Last modified LastEditor
ACP Status Collection Task
  • I had understood that DR wanted to know if the doctors on the current service are processing this. That might be a misunderstanding, though. DR if a patient is admitted to our service from another service or ward (icu to medicine, ER to medicine/ICU, surgical ward to ICU/medicine) and has an ACP already established by the previous service, can we use this as the first documented ACP? or do you want to know when the new service establishes an ACP status?
    • Ah... I don't think I got clarification on that one. I have added it to my list for my next meeting with Dr. Roberts (Thu Jul 3). Also added to Task in case that happens sooner. Ttenbergen 22:57, 29 June 2025 (CDT)
 2025-08-22 2:42:18 AM Lisa Kaita
Boarding Loc
        • leave what is in Cognos, the main office doesn't use this part for anything for home locations, but it can be used to crosscheck accuracy.
          • what is this about? Ttenbergen 17:42, 19 August 2025 (CDT)
 2025-11-27 4:09:31 AM Ttenbergen
Change Explainer Pages
  • For now that listing is quite incomplete, we have left quite a trail of these and will need to add them.
 2025-09-26 7:34:07 PM Ttenbergen
Check pre acute consistent JALT
  • Julie found data discrepancies and asked if we could review doing cross checks at least on records with the same Visit Admit DtTm for the following fields:
  • We reviewed a broader cross check proposal (link below) in some detail in a version available in the history of this page], so if we consider adding this we should confirm that none of those apply to any checks. Or we can ignore and just implement as soft-checks. Thoughts? Ttenbergen 12:28, 17 December 2025 (CST)
 2025-12-17 6:30:28 PM Ttenbergen
ClientGUID field
  • Lisa, any idea why this might be happening from a collection perspective? Is the problem in what we receive the right info from Cognos, or is there an issue in the collection process that makes this happen? Ttenbergen 09:52, 2024 December 5 (CST)
  • Julie, do we need to flag anywhere further that this data is suspect? Ttenbergen 09:52, 2024 December 5 (CST)
 2025-10-31 8:55:14 PM Ttenbergen
Data Meaning Layer
  • This had been percolating in my head for a while and I finally had a chance to look into it. Looking forward to thoughts. Ttenbergen 18:11, 18 July 2025 (CDT)
 2025-09-26 7:15:04 PM Ttenbergen
Definition of a Critical Care Program Admission
  • We need to extract a summary of the definition details from the page history.
  • We should set up a Data Meaning Layer to provide a clear Record definition in CFE to treat historical, pre PatientFollow Project, records in a way that is consistent with our current definition.
 2025-08-07 4:22:00 PM Lisa Kaita
Definition of a Medicine Program Admission
  • We need to extract a summary of the definition details from the page history.
  • We should set up a Record definition query in CFE to provide a clear way in CFE to treat historical, pre PatientFollow Project, records in a way that is consistent with our current definition.
 2025-12-09 12:55:39 AM Ttenbergen
Definition of a Medicine Program Admission JALT
  • heard that some beds at STB may have been "given" to Nephro, so we may be collecting them? Made me do a quick query to get rough numbers, sent off to JALT. . Is there anything we want to update in our definition based on this?Ttenbergen 18:55, 8 December 2025 (CST)
 2025-12-09 12:55:39 AM Ttenbergen
Discharged to community Just a placeholder for now because the idea of how we define dispo to community (or for that matter, re-admit Previous Location) in data came up re. things like Readmission to MedWard and others. We have the obvious "Home" but if someone is discharged to something like Dialysis, would that also count? How do we define? Ideally by a column in s_dispo table such as s_dispo.loc_type, but that one uses "non-patient" which it also uses for Deceased patients (should we just split that out?). There is probably even more to this. Likely Julie has more than one approach in reporting. This came up because we were looking to define this for LAU collection readmission data.
  • This is actually just as much regarding to admitted from community, so maybe this should just be renamed to "outpatient sites in s_dispo table"?
 2025-11-26 5:14:45 PM Ttenbergen
Dispo field If this is actually done then why don't we just make the nursing stations available? We already have s_dispo table entries for them. 35 entries since 2016, 6 in the last 12 months. Are there other things for which this entry is used? Checked for reasons for this decision but they don't appear documented Ttenbergen 19:42, 13 March 2025 (CDT) 2025-12-19 4:07:48 AM Ttenbergen
Dispo field JALT Task
  • HSC Virtual Ward
  • .... but do the virtual wards fall under transfer to Group/Supportive housing? Lisa Kaita 14:03, 14 November 2025 (CST)
    • is there more than on VW now? Ttenbergen 22:07, 18 December 2025 (CST)
 2025-12-19 4:07:48 AM Ttenbergen
Dispo field JALT Task
  • Home O2 return
  • Those that have home O2 prior to admission, and go home with O2, do we use Home with support services everytime? Or is it only during the first time they get set up with home O2 service?
Allyson Alcudia 14:40, 12 December 2025 (CST)		 2025-12-19 4:07:48 AM Ttenbergen
Dispo field JALT Task
  • Private Nursing Service
  • does this include patients who are discharged home with private nursing service? (steph)
    • With "this" do you mean "TRSF Group/Supportive housing"? I would not have thought so. If you mean "Home with Support Services", good question. How would HIS use it (aside from getting it wrong at times)? We should probably stick with their definition for consistency. Convince me otherwise. Julie also might have thoughts on how we would use this entry, will flag for her. Ttenbergen 01:02, 24 October 2025 (CDT)
  • I think this would be belong under home with support services...Lisa Kaita 14:03, 14 November 2025 (CST)
 2025-12-19 4:07:48 AM Ttenbergen
ER Delay
  • I have re-updated Created_Variables_Common_maker_2021 query, for some reason the change I had made was not reflected in the master version. Ready to test. Ttenbergen 13:25, 2022 June 28 (CDT)
    • emailed Tina some inconsistencies found in ER Delays Aug 15,2022. --JMojica 13:21, 2022 August 29 (CDT)
      • are these still an issue? Ttenbergen 11:15, 2024 May 1 (CDT)
        • I will re-check again. Can't remember if have been resolved. --JMojica 14:40, 2024 October 2 (CDT)
 2025-12-08 10:03:52 PM Ttenbergen
Error "Invalid SQL statment..." when sending
  • I have a hunch that this error may be related to a send failing for one collector and a second collector then also sending, leading to problems with the lock file.
So, when the error happens, please have a look at Regional Server\​/output\\ad.wrha.mb.ca\WRHA\REGION\SHARED\ICU_DATA_COLLECTION\/output and see if there is a second centralized_data file there with an extension .lccdb. See Lccmdb and ldb files for details. Please log here about what you find. Ttenbergen 10:41, 2024 November 30 (CST)		 2025-11-07 3:17:49 PM Allyson Alcudia
EuroSCORE II
  • Do we need to add "Dr. Michael Troncone" to this? Or is it better to not maintain that list here and instead ask collectors to refer to the dropdown?
 2025-08-19 9:54:43 PM Ttenbergen
GRA Medicine Collection Guide
  • I thought that GRA was not a teaching hospital. So what does it mean for them to have a CTU? Ttenbergen 23:17, 29 November 2025 (CST)
 2025-11-30 5:17:39 AM Ttenbergen
Guideline for coding organ donation after death For a patient who intend to be an organ donor and died in the unit or ward but the organ donor did not happen for some reason (e.g. family changed their mind, or some other circumstance occurred, and they did not end up going to the OR), do we still need to code Organ donor (organ/tissue donation by the donor) in admit or acquired? maybe not and the Dispo entry is just - Died to morgue ? Or if we want to keep the organ donor code, we need a code telling it did not happen, is that possible? --JMojica 16:58, 18 November 2025 (CST)

Another scenario - For a patient who has an acquired diagnosis of Organ donor (organ/tissue donation by the donor) and brain death and the harvesting done during the same ICU admission and did not go to OR, then the dispo is Died to morgue , is this correct? --JMojica 16:58, 18 November 2025 (CST)

  • Question is under the MAID heading in here but does not necessarily seem to be related to MAID... or is it? Ttenbergen 23:20, 18 November 2025 (CST)
  • I have a feeling this question comes with context - what were you looking for? Ttenbergen 23:20, 18 November 2025 (CST)
    • the two items listed here are general questions about organ donor and how to know if the donor happened or not. i just inserted the discussions after the MAID but not meant to be related to MAID. Sorry, I notice how the two comments came out , one with a box and another under it. I tried to change but unsuccessful so I leave them as is. The main goal is to add them to the instruction if making sense. --JMojica 09:05, 19 November 2025 (CST)
 2025-11-19 3:05:33 PM JMojica
ICD10 Guideline for drugs and substances Task
  • just realized that Illicit drug use wasn't mentioned here; we might want better info how it fits into the remaining instructions on this page.
 2025-09-08 10:47:18 PM Ttenbergen
Intended1stSrvc Things we need to resolve:
  • We need to review anything that links to ICUotherService, and anything that page lists to. The "anything that links there" can be accessed by expanding the "related articles (expand)" at the bottom of ICUotherService. Ttenbergen 10:59, 25 September 2025 (CDT)
  • This Intended1stSrvc assumes a whole stay on the borrowed service. How about the case where there is only partial stay being taken care by borrowed service and then the patient now becomes a legit patient of that service. Example, Intended1stSrvc is STB ICSM taken care by ACCU service (May 24,2023 13:17) boarding at ACCU bed , then by May 26,2023 15:40 became an ACCU patient taken care by ACCU in same ACCU bed until discharge to ward June 5,2023 16:22. This is currently just one record. For me to breakdown the days, there is a need to enter the start dttm and/or end dttm aside from the intended unit. OR Should this case be two records, thus there is no need to enter dttm?--JMojica 17:31, 18 December 2025 (CST)
 2025-12-19 4:13:49 AM Ttenbergen
Intended1stSrvc This project is not live yet, do not follow the instructions to stop the old collection yet. I hope to have this set up to start collecting with the new instructions Dec1. For now, continue to use the instructions in ICUotherService. Ttenbergen 14:27, 26 September 2025 (CDT) 2025-12-19 4:13:49 AM Ttenbergen
Intended1stSrvc as per JALT Meeting - Rolling Agenda and Minutes 2025#JALT 2025-12-18, needs to be integrated:
  • We agreed that the options for the dropdown listings should all be the same for Boarding Loc, Service/Location, and the new field Intended1stSrvc, and that these will be the same as those currently used for Boarding Loc, i.e: HSC-MICU, HSC-SICU, HSC-IICU, STB-MICU, STB-CICU, STB-ACCU and GH-CC
  • We recognize that these will then be different from the "official" ADT services listings provided to us in Cognos2
 2025-12-19 4:13:49 AM Ttenbergen
Intended1stSrvc
  • I don't think any checks are possible for this, or can someone think of one?
 2025-12-19 4:13:49 AM Ttenbergen
JALT Meeting - Rolling Agenda and Minutes 2025
  • this is not only about what data they want, but also about how we would find out which patients we should collect
  • it might need to include a conversation about why the data is wrong in 10% of cases
Ttenbergen 22:17, 18 December 2025 (CST)		 2025-12-19 4:17:49 AM Ttenbergen
JALT Meeting - Rolling Agenda and Minutes 2025 just came across Proposed future changes to Location and Transfer Ready and related fields about a previous consideration to changing related fields. Ttenbergen 13:28, 27 June 2025 (CDT) 2025-12-19 4:17:49 AM Ttenbergen
Link suspect not same visitAdmitDtTm query 2025-07-23 4:13:26 AM Ttenbergen
MediaWiki:Common.js ", post: " 2025-06-28 4:30:21 AM
Overstay2 data processing and reporting in CFE
  • Nothing yet, fill in as it becomes available.
 2025-02-23 10:13:18 PM Ttenbergen
Overstay2 Overview
  • When I talked with Andrea Thiessen she said there was no SOP for the clerk yet, and that the form is not yet part of the admission package because they are finalizing some forms approval for it. Until we hear it's set up it might be good to flag when you run low on forms or forms are not in the admission package.
 2025-07-24 9:18:10 PM Ttenbergen
Patients residing in Manitoba with ambiguous MH Health coverage JALT
  • The page name isn't quite right, this concept is still evolving in documentation.
  • Some of these may be better off broken out as their own pages or templates and only indexed from here.
 2025-08-14 5:06:29 PM Ttenbergen
Postal Code field
  • CCMDB have pre_acute_living_situation field homeless with Postal Code, should the Postal code be ignored and replaced by N/A. Should the R_Province entry be affected by Postal Code N/A? --JMojica 10:54, 24 June 2025 (CDT)
    • We are currently reviewing some of the definitions of homelessness. It is possible that details will change as outcome from that. The concept has been broadened to include some ambiguous states and terminology changed to houselessness. Next meeting later this week about that.
    • I don't expect that it would change instructions of how to code Postal Code; so, it makes sense to me to update vetted data for postal code to "N/A" if the Pre acute living situation is "homeless".
    • Also, we have discussed whether it would be better to do this as an actual change in data, or as an logical change by function or encoded data in the Data Meaning Layer. Julie, you already do some other things in that layer to re-write data, if I interpret your SAS code correctly. Ttenbergen 17:11, 18 July 2025 (CDT)
 2025-08-11 2:48:50 PM Ttenbergen
Postal Code field I understand the sentiment in the following, but this should either be rules or not mentioned at all, or it will cause confusion, since it would be relevant specifically in the edge cases when it would fall apart. So it might be better to address the specific edge cases and make a rule and cross check where relevant.

Where this bears on data use, we should make sure we define once what we will check for and how we adjudicate or interpret inconsistencies, like we did for homeless patients. Ttenbergen 16:10, 11 July 2025 (CDT)


Relationship between Province, PHIN and Postal code

When collecting Postal Code, PHIN number and Province, think about the relationship of this information when you are collecting it.

  • if patient has a MB PHIN number, then Province code should be MB and the postal code should be for MB (MB postal codes start with an "R").
  • if Province code is not MB then the postal code should not be a MB postal code. Enter "not applicable" or the out of province postal code if available, and also, there should not be a PHIN number.
 2025-08-11 2:48:50 PM Ttenbergen
Postal Code field 2025-08-11 2:48:50 PM Ttenbergen
Previous Location field
  • for consistency, should this also use the Template:PrePrevDispo listing? Actually, what does this even mean for previous location? And what do you do if the patient comes from med?
 2025-07-31 3:56:57 AM Ttenbergen
Project MR DRQ
  • Do we want that to be the first time during a medicine program admission, or only the first time during a hospitalization? Ttenbergen 08:45, 26 February 2025 (CST)
  • Also, we define Transfer Ready DtTm tmp entry to be able to do this per level of care to enable reporting separately for HOBS. I think there are problems with that concept since I doubt users of the data keep the detailed definition in mind, but we still need to decide if we want to be able to report this the same way. If so, we need the the same connector integer in the instructions. Ttenbergen 08:51, 26 February 2025 (CST)
    • added to agenda to discuss with DR 2025-08-28 Ttenbergen 17:04, 21 August 2025 (CDT)
 2025-08-21 10:04:55 PM Ttenbergen
Project MR DRQ
  • How do we want to define where to get this? Unless we get physicians to put this information into a specific spot we are right back to all the definition difficulties in Transfer Ready DtTm tmp entry, only it will be worse because collectors will need to keep conflicting but similar instructions in mind. Ttenbergen 08:49, 26 February 2025 (CST)
    • emailed DR about this Ttenbergen 11:36, 28 February 2025 (CST)
 2025-08-21 10:04:55 PM Ttenbergen
Re-analysis and generation of Overstay2 model Still needs: 2025-08-12 8:43:59 PM JMojica
Record definition query in CFE
  • We should set up a Record definition query in CFE to provide a clear way in CFE to treat historical, pre PatientFollow Project, records in a way that is consistent with our current definition. This is a good idea but not trivial, so we should decide how badly we need this, but definitely document the concept.
    • JM email from 2025-03-18: "Perhaps, creating a query to link those records from old definition to become similar to patient follow is needed in ACCESS to generate at least the LOS, first admit date and last discharge date, first previous location and last dispo location. In this way, SAS will not generate it and I just get it from ACCESS query. Is this hard to do? "
      • The query is probably the easiest part, but this would take some analysis to figure out what all is actually affected by this, ie which other queries would need to be updated. Having said that, we should still probably do it. I don't know who would be in a position to prioritize this, I don't have bandwidth for this as a side project right now. Don't think it's a task question because I don't know if anyone there would have anything to add to this. Ttenbergen 14:17, 18 March 2025 (CDT)
 2025-03-18 7:35:56 PM Ttenbergen
Sending Patients JALT
  • Can we again revisit the pros and cons of sending only when working on site against sending from home? There is always a need of updated data and I do not want to be emailing everyone to send when data are needed. This can be solved by sending in all days the collector works regardless onsite or from home during the assigned time slots. In addition, I think this practice of submitting data frequently will also mean lesser new data on the laptop if unfortunate incident happens on the laptop and there is a need to re-enter data again. Do we still experience problem in sending when we set up the sending time schedule by site? --JMojica 16:37, 2 December 2025 (CST)
There might be ways to make sending faster or more reliable. This would take a fair bit of analysis and testing.
One reason I have not pursued this is the prospect of re-platforming. A cloud based system would eliminate sending; it might cause new process tangles but that's a different topic. So it would be good to have an idea of the time horizon for this to decide if the work to mitigate the errors and reduce sending restrictions is worth it.
It might be possible to find a compromise that re-balances risk and benefit. Ttenbergen 01:19, 3 December 2025 (CST)
  • I heard nothing from the collectors about errors in sending since we started this new schedule. If they work from home, can we allow them to send? They can send early or after 04:30 PM. PTorres 14:27, 3 December 2025 (CST)
    • Open to it. If things work fine now, changing process may break them again. Ttenbergen 11:50, 17 December 2025 (CST)
 2025-12-17 5:50:08 PM Ttenbergen
St.Amant
  • Is that actually true, that we use the code for patients in one of their residential programs? Would we even know the patient is, considering many are now set up as home-stays or group homes? Or do we only collect this for people who actually live there, if there is still such a thing? Ttenbergen 15:40, 29 October 2025 (CDT)
  • I ran a query to check and
 2025-11-26 9:46:22 PM Lisa Kaita
STB Medical Records requests
  • the list on STB Critical Care Collection Guide has become inconsistent with this one, let's consolidate it in one place. It contained the following: ... email your list to Reggie Albis & Joanna Talastas; cc supervisor Tianna Mohammed who will redirect the list as required
 2025-12-19 3:45:13 AM Ttenbergen
Transfer for bed management 2025-11-28 3:00:46 PM Lisa Kaita
Visit Admit DtTm differences within same admission 2025-02-23 9:12:56 PM Ttenbergen

Day to day items

Collection and Diagnosis coding

Diagnoses
Procedures

Communication

Misc

Information for new collectors

Info about our program

Back office

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Data_Collector_Portal&oldid=143828"