Function CognosImport: Difference between revisions

Line 8:

* again cleans out temporary table [[Cognos_import table]]

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

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

@@ Line 8: / Line 8: @@
 * again cleans out temporary table [[Cognos_import table]]
 * 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_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]]
 ** [[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]]