Cognos Report Integrator: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) m (Text replacement - "[[Patient viewer tab" to "[[Patient Viewer Tab") |
||
| Line 23: | Line 23: | ||
* then [[Cognos_integrator query]] draws from [[Cognos_processed table]] and feeds the following: | * then [[Cognos_integrator query]] draws from [[Cognos_processed table]] and feeds the following: | ||
** [[Cognos_Admitter_FormQuery query]] feeds [[Cognos Admitter]] | ** [[Cognos_Admitter_FormQuery query]] feeds [[Cognos Admitter]] | ||
** [[Cognos_Patient_viewer_tab_FormQuery query]] feeds [[Patient | ** [[Cognos_Patient_viewer_tab_FormQuery query]] feeds [[Patient Viewer Tab Cognos ADT]] | ||
** [[Cognos_Discharger_FormQuery query]] feeds [[Cognos Discharger]] | ** [[Cognos_Discharger_FormQuery query]] feeds [[Cognos Discharger]] | ||
Revision as of 21:45, 2020 July 30
This page is about how Cognos EPR Report will be integrated into CCMDB. This will likely be the replacement for EPR Reports Integrator. For anything not linked directly from this page, also see Cognos Report Integrator.
Overview
- 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
Hierarchy of queries
- then Cognos_integrator query draws from Cognos_processed table and feeds the following: