Cognos data import: Difference between revisions

Line 20:

* [[Cognos_dispo_translator_additions_needed query]]

* the process imports into [[~~Cognos import~~ table]] and then uses [[~~Cognos import processor~~ query]] to populate [[~~Cognos processed~~ table]] with data that has been transformed for our use (e.g. Cognos does dates down to the second, we only do them to the minute... )

* the process imports into [[Cognos_import table]] and then uses [[Cognos_import_processor query]] to populate [[Cognos_processed table]] with data that has been transformed for our use (e.g. Cognos does dates down to the second, we only do them to the minute... )

* [[Cognos_dispo_translator_additions_needed query]] runs automatically; if it finds new entries, an email is started to a collector to find out what should be added to [[Cognos_dispo_translator table]] to map the new entries to entries of [[s_dispo table]]

{{DT | I need to make a similar thing for [[Cognos SubServices table]]. }}

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 feeds forward as follows:

* [[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)

** IPAdmitDtm --> [[Accept DtTm]] (but only if pt is from ER)

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

* it feeds forward as follows:

** [[Cognos_Admitter_FormQuery query]] feeds [[Cognos Admitter]]

** [[Cognos_Patient_viewer_tab_FormQuery query]] feeds [[Patient viewer tab Cognos ADT]]

@@ Line 20: / Line 20: @@
 * [[Cognos_dispo_translator_additions_needed query]]
-* the process imports into [[Cognos import table]] and then uses [[Cognos import processor query]] to populate [[Cognos processed table]] with data that has been transformed for our use (e.g. Cognos does dates down to the second, we only do them to the minute... )
+* the process imports into [[Cognos_import table]] and then uses [[Cognos_import_processor query]] to populate [[Cognos_processed table]] with data that has been transformed for our use (e.g. Cognos does dates down to the second, we only do them to the minute... )
+* [[Cognos_dispo_translator_additions_needed query]] runs automatically; if it finds new entries, an email is started to a collector to find out what should be added to [[Cognos_dispo_translator table]] to map the new entries to entries of [[s_dispo table]]
+{{DT | I need to make a similar thing for [[Cognos SubServices table]]. }}
 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 feeds forward as follows:
+* [[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)
+** IPAdmitDtm --> [[Accept DtTm]] (but only if pt is from ER)
+** 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. }}
+* it feeds forward as follows:
 ** [[Cognos_Admitter_FormQuery query]] feeds [[Cognos Admitter]]
 ** [[Cognos_Patient_viewer_tab_FormQuery query]] feeds [[Patient viewer tab Cognos ADT]]