Cognos Report Integrator: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (no more EPR Integrator)
m (removed links to accept and arrive dttm)
Line 8: Line 8:
== Data ==
== Data ==
* field equivalences (see  ''Cognos import processor query'' and ''Cognos_integrator query'' for details)
* 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)
** IPAdmitDtm --> [[Visit Admit DtTm field]], "Accept DtTm" (but only if pt is from ER)
** AsgnUnitStartDtm_current --> [[Arrive DtTm]] or [[Boarding Loc]] date and time
** AsgnUnitStartDtm_current --> "Arrive DtTm" or [[Boarding Loc]] date and time
** AsgnUnitEndDtm_current --> [[Dispo 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_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]]   

Revision as of 11:42, 2022 April 21

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: