Cognos Report Integrator: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (→‎Fields: This is an OK place for that info to live)
m (cleanup done)
 
(7 intermediate revisions by the same user not shown)
Line 1: Line 1:
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]].
This page is about how [[Cognos EPR Report]] is integrated into CCMDB.


== Overview ==
== Overview ==
* [[Cognos EPR Report]] is the data source
* [[Cognos EPR Report]] is the data source
* [[Cognos data import]] is the process to get the data into [[CCMDB.accdb]]
* [[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
* [[Cognos2]] is the set of tools data collectors use in [[CCMDB.accdb]] to interact with and enter the data from Cognos into profiles
* [[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 ==
== Data ==
This next part isn't really part of the import but the explanation needs to live somewhere, so parking here for now.
* field equivalences (see  ''Cognos import processor query'' and ''Cognos_integrator query'' for details)
* [[Cognos_integrator query]] then tries to match up the data from Cognos to records currently or previously on the laptop; it uses [[s_Cognos_Locations table]] and [[Cognos_SubServices table]] for the mapping
** IPAdmitDtm --> [[Visit Admit DtTm field]], "Accept DtTm" (but only if pt is from ER)
* field equivalences (sort of see  [[Cognos_import_processor query]] and [[Cognos_integrator query]] for details)
** AsgnUnitStartDtm_current --> "Arrive DtTm" or [[Boarding Loc]] date and time
** 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
** 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]]   
** AsgnUnit_current --> [[Service/Location]] or [[Boarding Loc]]
** 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]]
** 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:
** [[Cognos_Admitter_FormQuery query]] feeds [[Cognos Admitter]]
** [[Cognos_Patient_viewer_tab_FormQuery query]] feeds [[Patient Viewer Tab Cognos ADT]]
** [[Cognos_Discharger_FormQuery query]] feeds [[Cognos Discharger]]


== Related articles ==  
== Related articles ==  

Latest revision as of 14:13, 2022 June 14

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

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:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Cognos_Report_Integrator&oldid=156473"