Function CognosImport: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Line 14: Line 14:
* again cleans out temporary table [[Cognos_import table]]
* again cleans out temporary table [[Cognos_import table]]
* 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
** checks [[s_Cognos_Units_additions_needed query]]; if it finds new entries, an email is sent to a Lisa Kaita to find out what should be added to [[s_Cognos_Units 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]]  
** checks [[s_Cognos_Units_additions_needed query]]; if it finds new entries, an email is sent to a Lisa Kaita to find out what should be added to [[s_Cognos_Units 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 [[S Cognos Units table]]  
** checks [[s_Cognos_Services_additions_needed query]]; 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 [[s_Cognos_Services table]]
** checks [[s_Cognos_Services_additions_needed query]]; 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 [[s_Cognos_Services table]]



Revision as of 12:26, 2021 January 14

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

Approximate algorithm

Check the sub itself for the actual current process.

Related articles

Related articles: