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.
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.
- Cognos EPR Report is the data source
- Cognos data import is the process to get the data into CCMDB.accdb
- Cognos Admitter is the tool collectors would use to add ward stay records or Boarding Loc entries to CCMDB.accdb from Cognos
- Cognos Patient viewer tab FormQuery query shows Cognos data for patients currently in CCMDB.accdb
- Cognos Discharger is the tool collectors use to track who is already on CCMDB.accdb and has been discharged or moved
Fields
|
Where should this live? |
This next part isn't really part of the import but the explanation needs to live somewhere, so parking here for now.
- Cognos_integrator query then tries to match up the data from Cognos to records currently or previously on the laptop; it uses Cognos_dispo_translator table and Cognos_SubServices table for the mapping
- field equivalences (sort of see Cognos_import_processor query and Cognos_integrator query for details)
- IPAdmitDtm --> Accept DtTm (but only if pt is from ER)
- AsgnUnitStartDtm_current --> Arrive DtTm or Boarding Loc date and time
- AsgnUnitEndDtm_current --> Dispo DtTm or Boarding Loc date and time
- AsgnUnit_Prior (but it's more complicated, when pt comes from ER or other site there is info in field "EmergencyDepartment" or "ReferringLocation"; I try to summarize this in Cognos_import_processor query.FromLoc to facilitate process for collectors but not yet good enough for full automation) --> Previous Location
- AsgnUnit_current --> Service/Location or Boarding Loc
- AsgnUnit_Next / IPDischargeDisposition / IPDischargeLocation depending on story; I try to summarize this in Cognos_import_processor query.ToLoc to facilitate process for collectors but not yet good enough for full automation --> Dispo
How it is used further
- then Cognos_integrator query draws from Cognos_processed table and feeds the following: