Cognos Report Integrator

This page is about how Cognos EPR Report will be integrated into CCMDB.

_wiki housekeeping Cognos This refers to the original report, I think. Some of the queries below no longer exist. See Cognos data import for the surrounding steps, but I need to update what happens in our program. Ttenbergen 11:48, 2022 April 21 (CDT)

added: 2022-04-21 action: 2022-04-21

• Cargo

• Categories

Overview

• Cognos EPR Report is the data source
• Cognos data import is the process to get the data into CCMDB.accdb
• Cognos2 is the set of tools data collectors use in CCMDB.accdb to interact with and enter the data from Cognos into profiles

Data

• field equivalences (see Cognos import processor query and Cognos_integrator query for details)
  • IPAdmitDtm --> Visit Admit DtTm field, "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