Cognos2 Hospital Discharge query

From CCMDB Wiki
Jump to navigation Jump to search

Cognos2 Hospital Discharge query lists records that have a corresponding Hospital Discharge DtTm and Dispo.

Interro-01.gif
  • This is a work in progress. Feel free to have a look at the query and test it. Let me know if things are missing or if you have suggestions. Ttenbergen 10:40, 2021 September 29 (CDT)
    • Hey Tina, the query is super helpful for us, just a couple of comments, it would be helpful if we could somehow get to the profile from this page so we could just enter it, you know the binoculars thing, also if it would somehow drop off once we do enter it? This may be big asks or not even feasible to program, but thought I would ask, thank you for creating the query!! Lisa Kaita 10:06, 2021 October 15 (CDT)
      • Yes, I can add a button once I turn it into a form. There might be more than one profile for the patient on the laptop. Both will be listed, so the collector will need to keep an eye on that. But I wonder: is the next step actually to open the profile, or is it to request the chart? What would a collector do in there at that point? Because maybe what we need instead is something optimized to request the next round of charts? Then the collector would open from PatientList as they go through charts. Just trying to make sure we tie this into the actual process rather than add functionality just because we can. Ttenbergen 15:51, 2021 October 19 (CDT)
        • We go into the profile to change the record to MR*, to replace where the patient was e.g. A3S (A3stepdown lets us know as a quick glance that the patient is still in hospital, once discharged we change it to MR*) it puts it to the bottom of our MR list. When we are ready to request the chart we remove the *, generate the MR list, and then request it from medical records.
          • That is interesting. Is the MR* technique actually across sites? This is not documented anywhere, eg. Record field and MR List. If this is common procedure, then would it be better functionality to just change all records that now have a hosp discharge to have record = MR*? It doesn't sound like something that benefits from human intervention... Ttenbergen 09:50, 2021 October 20 (CDT)
  • SMW


  • Cargo


  • Categories
Discuss@task.png
  • This query raises the possibility of also capturing Hospital disposition and dttm, a value Allan has wanted for a long time. But it also raises the problem that we are only finalizing records late now, and do we want to risk similar delay going fwd?
  • SMW


  • Cargo


  • Categories

Examples of why this might be needed

HSC is backlogged and will often only request a chart from Medical Records once the patient is actually discharged from hospital. There is no nice mechanism in EPR to keep track of this, so we are testing if this can be done with Cognos data.

Limitations

We may not get this for all patients - Due to Cognos Report Time Limits, if a pt stays off one of our units for more than that limit, there would no longer be records for them in the dump by the time they get discharged. So we would not get this for all patients.

Interro-01.gif

We might be able to convince the Cognos people to stretch the query to include this, but that's somewhat unlikely. However, the number of records for which this would not come in time for us to collect it might be small enough for Pagasa to grab after the fact? How small would it need to be for that to be feasible?

  • SMW


  • Cargo


  • Categories

Having collectors collect this would delay record completion - At sites where collectors are not behind, we would likely not want to incur delays in completing records just to include this. We might overcome this by diverting this info from Cognos directly to CFE, rather than through collectors.

Interro-01.gif

That would raise the question of who and how...

    • At sites where they are up to date or have a dedicated collector for that laptop only would likely not use this, as EPR lists can be used
  • SMW


  • Cargo


  • Categories

Log

2021-09-29 created query

Related articles

Related articles: