Cognos Report Integrator

This page is about how Cognos EPR Report will be integrated into CCMDB. This will likely be the replacement for EPR Reports Integrator. Feel free to comment now, but be aware it's a work in progress right now.

How will this work

Broadly, we will get electronic output early every morning that is similar to a combination of all the EPR reports we get. Tina will build something to get this data into CCMDB. In there, two functionalities will be added:

• a way to see new patients who have arrived, and to facilitate entering them
• a way to see movements of patients already on the laptop, and a way to facilitate entering them into Boarding Loc.

To start, both parts will work interactively with collectors picking and choosing, but the goal would be to get this process so both are updated automatically.

Getting data into CCMDB.accdb

See Cognos data import

Getting new pts into CCMDB.accdb from Cognos report

See Cognos Admitter

Processing pts who are discharged

There will be another form that will show all pt who have left the ward:

• have a "ToDtm" combined with a change in service
• have a "IPDischargeDtm"

The listing will show our Dispo_DtTm or Dispo for them to help keep track which have been processed

There will be a button to transfer the following Cognos data into our record:

• "ToDtm" into Dispo DtTm ( straightfwd )
• Dispo field can be populated if AMA, Deceased or Home; possibly other hospital but likely not because it doesn't say whether ICU or ward; we can list what we get.

Updating Boarding Loc from Cognos report

There will be a different window that will list the movements of pts from the Cognos report and facilitate entering them into CCMDB.accdb. We will need to decide if we want to keep the current "just enter home or other" process, or if it might be easier to go to a "enter as it says on report rather than figure it out" process. Open to suggestions.

Decisions for later

• Do we want other province PHIN field?