Cognos Report Integrator

From CCMDB Wiki
Revision as of 11:42, 2022 April 21 by Ttenbergen (talk | contribs) (removed links to accept and arrive dttm)
Jump to navigation Jump to search

This page is about how Cognos EPR Report will be integrated into CCMDB. For anything not linked directly from this page, also see Cognos Report Integrator.

Overview

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

Related articles

Related articles: