Database Manager

From CCMDB Wiki
Jump to navigation Jump to search

Acting Manager is p:Lisa Kaita.

Questions for Manager

edit page question ModDate
edit page question ModDate
edit Homeless
  • Province - That definition doesn't make it clear to me whether the entry should be "NK Not Known / Not available" or "MB" - can we clarify that? Ttenbergen 00:17, 12 July 2025 (CDT)
* who should we clarify with, I would think if they have a MB PHIN or are self pay then you would choose MB, if they don't then I would choose Not known Lisa Kaita 21:25, 6 September 2025 (CDT)
  • more of a "tighten definition" than "check with"; from talking with SW this population frequently doesn't have their paperwork or registrations figured out, or their MB Health status has expired even if they would theoretically be covered, etc. This all came up when Julie checked for outliers and compared the province and postal code to determine status for homelessness.
2025-09-08 3:27:05 PM
edit Query check tmp AHC
  • if there is referral sent there must be a referral received entry and a consult dealt with entryLisa Kaita 11:31, 7 August 2025 (CDT)
    • pt could die in between? consult could go missing? In a way those would be really the ones we would want to know about, no? I suppose we could make it a soft check... Ttenbergen 16:26, 19 August 2025 (CDT)
  • 2025-08-19 9:26:25 PM
    edit Service/Location field
  • is this section still current? Ttenbergen 11:13, 6 March 2025 (CST)
  • It up for discussion tomorrow at JALT Meeting - Rolling Agenda and Minutes 2025 Lisa Kaita 21:04, 10 March 2025 (CDT)
  • Allan spoke with Bojan, to be discussed at next JALT Lisa Kaita 14:48, 16 April 2025 (CDT)
  • still being dicussed at JALT Lisa Kaita 21:45, 9 September 2025 (CDT)
  • 2025-09-10 2:45:14 AM
    edit SBGH L2
  • We need to clean up this page and likely some linking to it. I don't know the truth on the ground so can't just do it. Something do do in one of the wiki wrangling efforts LK and TT may want to schedule one of these days. Ttenbergen 12:35, 20 March 2025 (CDT)
  • 2025-03-21 3:27:04 AM
    edit LAU collection readmission data
  • what if they spend time in an ED in between as part of re-admission, possibly pushing past the 7 day range? Due to the very long ER delays for LAU I think we would want to include those. Ttenbergen 00:06, 12 March 2025 (CDT
    • These would be included because I am using the ADT/EPR readmits and the admit time reflects first time of presentation and an ensuing admission Lisa Kaita 12:13, 10 April 2025 (CDT))
      • to be perfectly clear: if someone is discharged from LAU on Jan 1, and then presents to an ED at GRA, where they decide the person should go to LAU, but the patient is not transferred and made an inpatient again at an LAU for another 3 days (pushing their new admission past the 10 day window), would you tag them as a re-admission? Ttenbergen 12:42, 10 April 2025 (CDT)
  • Yes, I believe it would because in EPR for patient visits, the patient you describe would show them as an inpatient, beginning Jan 7, even though by our definition they are not an inpt til the LAU folks accept them. I would not be able to decipher the actual first service time without having the chart or running an EPR report. Lisa Kaita 12:49, 10 April 2025 (CDT)
  • 2025-07-30 4:34:49 PM
    edit John or Jane Doe patient
    • Entries for these would affect Overstay2 Overview and initial entry practice isn't currently clear in Minimal Data Set; is there anything we need to review with that in mind? Ttenbergen 13:47, 20 June 2025 (CDT)
      • Most of our JD patients are identified at some point during their admission, I can't think of any that haven't been, are there many in the database? Lisa Kaita 21:29, 6 September 2025 (CDT)
        • We use some of this data while incomplete, and it also has been a candidate for overstay parameters. Think of it coming from the "is this patient from Manitoba" vs "is this patient a JD". Even if they eventually become identified, that doesn't help with initial data. We are trying to define how this data should be handled in that scenario as well. Ttenbergen 10:13, 8 September 2025 (CDT)
    • Julie had added some chart info for JD patients to the Postal code page, but its about chart so belongs here or in the chart page. So: do we want to consolidate the JD info here and link to field pages, or in field pages and link to this and use this just as an index? Or do we want templates for each so we can list the whole bit consistently on both? Ttenbergen 09:47, 11 August 2025 (CDT)
    • SMW


    • Cargo


    • Categories
    2025-09-08 3:13:24 PM
    edit Query Check VADT too close to first boarding loc

    We discussed this in our after-Task meeting 2023-07-23 and I just stumbled across it. I do not remember what this was about, nor what a reasonable delay would be. Could one of you fill in the details for the query if we still want it? No hurry. In fact I'd prefer if you not hurried ;-). Ttenbergen 21:38, 13 August 2025 (CDT)

    • SMW


    • Cargo


    • Categories
    2025-08-19 10:10:00 PM
    edit DtTm for First Boarding Loc and First Service do we need to be specific here that this should always mean setting a boarding loc to a later dttm in case a pt was there earlier? I would not want someone to omit an initial boarding loc and set the second location's time to earlier
    • wouldn't our cross checks capture this? As long as collectors follow the above instruction the first boarding loc has to have the same DTTM Lisa Kaita 11:16, 7 August 2025 (CDT)
    2025-08-07 4:16:12 PM
    edit Boarding Loc It says:
  • Change one to be off by one minute, put a note in Notes field to check boarding location to confirm the correct date and time for the boarding locations of concern.
    • how does that fit in with reviewing reality in the chart?
    • I don't know what you mean by this? It means you double check the correct first service and first and second boarding loc dttm Lisa Kaita 21:14, 6 September 2025 (CDT)
      • Well, it seems like this triggers an error check, so you pull the times a minute apart to overcome the error check and put a note to remind you to check later. So either the check should run later (on complete or send) or we shouldn't have it at all. But a check that just gets you to "tweak" the data to make it go away isn't a good idea.
  • 2025-09-08 3:08:30 PM
    edit Error "The database cannot be opened because ..." Lisa, what did you do just before the error popped up? Ttenbergen 22:11, 10 September 2025 (CDT) 2025-09-11 3:11:18 AM
    edit Dispo field That more detailed info included things like HSC Lennox Bell; we discussed whether or not we need to document the details of this. If so, the following is likely a starting point:
  • Home
  • Home with support
  • Institution NOS
  • TRSF Group/Supportive housing
  • TRSF to Correctional Facility
  • any Hospices
  • GH-Transitional care
  • HSC - Transitional care
  • Misericordia - Transitional care
  • STB - Transitional care
  • VIC - Transitional care
  • HSC Lennox Bell
  • Manitoba Adolescent Treatment Center - unknown/other
    • what is this about again? we already collect these with the exception of the transitional care units, which don't exist, at GH, HSC, SBGH and VIC, but there is a TCU at Miseri and DLC Lisa Kaita 21:18, 6 September 2025 (CDT)
      • we discussed whether we should shift to EPR's "TRSF to Residential Care" and decided not to because our data is more granular. But we should be able to compare to their TRSF, so should understand which of our data would compare to theirs, and how. I think the above is a list of what we have in dispo, so which of those correspond do what listing in EPR? Ttenbergen 10:31, 8 September 2025 (CDT)
  • 2025-09-08 3:31:26 PM
    edit Previous Location field what is the Pre-admit Inpatient Institution entry for this case? --JMojica 13:37, 29 July 2025 (CDT)
  • That is what we need to decide we should probably keep it consistent with EMIP concept, however, for SICU we generally disregard the surgical service (when in ER) unless they were truly an inpt on a ward Lisa Kaita 13:59, 30 July 2025 (CDT)
  • 2025-07-31 3:56:57 AM

    Related articles

    Related articles: