Function CognosImport: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m Text replacement - "Cognos_dispo_translator_additions_needed query" to "s_Cognos_Locations_additions_needed query"
m Text replacement - "Cognos_SubServices_additions_needed" to "s_Cognos_Services_additions_needed"
Line 9: Line 9:
* starts the email that will tell collectors that the new data is now available
* starts the email that will tell collectors that the new data is now available
** [[s_Cognos_Locations_additions_needed query]] runs automatically; if it finds new entries, an email is sent to a Lisa Kaita to find out what should be added to [[s_Cognos_Locations table]] to map the new entries to entries of [[s_dispo table]]; the email will be sent each time this is run until the answer is added to [[Cognos Admit filter table]]  
** [[s_Cognos_Locations_additions_needed query]] runs automatically; if it finds new entries, an email is sent to a Lisa Kaita to find out what should be added to [[s_Cognos_Locations table]] to map the new entries to entries of [[s_dispo table]]; the email will be sent each time this is run until the answer is added to [[Cognos Admit filter table]]  
** [[Cognos_SubServices_additions_needed query]]  runs automatically; if it finds new entries, an email is sent to a Tina to find out what should be added to [[s_Cognos_Services table]]; the email will be sent each time this is run until the answer is added to [[Cognos_SubServices table]]  
** [[s_Cognos_Services_additions_needed query]]  runs automatically; if it finds new entries, an email is sent to a Tina to find out what should be added to [[s_Cognos_Services table]]; the email will be sent each time this is run until the answer is added to [[Cognos_SubServices table]]  


== Log ==
== Log ==
2020-07-30 - added [[Cognos_SubServices_additions_needed query]] and code to generate email if it has content.  
2020-07-30 - added [[s_Cognos_Services_additions_needed query]] and code to generate email if it has content.  


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

Revision as of 09:53, 2020 November 4

Function CognosImport is the sub that accomplishes the Cognos EPR Report importing as part of Cognos data import .

Log

2020-07-30 - added s_Cognos_Services_additions_needed query and code to generate email if it has content.

Related articles

Related articles: