Cognos data import: Difference between revisions

Line 14:

== Background ==

* [[Cognos EPR Report]]

* [[LoadCognos.bat]] calls

* [[LoadCognos.vbs]] which calls

Line 23:

Line 21:

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)

* 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 --> [[Previous Location]] (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]], but not yet good enough for automation.

~~{{DT | needs more detail. }}~~

** AsgnUnit_current --> [[Service/Location]] or [[Boarding Loc]]

** AsgnUnit_Next / IPDischargeDisposition / IPDischargeLocation --> [[Dispo]]

* it feeds ~~forward as follows~~:

* 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]]

@@ Line 14: / Line 14: @@
 == Background ==
-* [[Cognos EPR Report]]
 * [[LoadCognos.bat]] calls
 * [[LoadCognos.vbs]] which calls
@@ Line 23: / Line 21: @@
 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)
+* 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 --> [[Previous Location]] (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]], but not yet good enough for automation.
-{{DT | needs more detail. }}
+** AsgnUnit_current --> [[Service/Location]] or [[Boarding Loc]]
+** AsgnUnit_Next / IPDischargeDisposition / IPDischargeLocation --> [[Dispo]]
-* it feeds forward as follows:
+* 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]]