Function CognosImport: Difference between revisions

(5 intermediate revisions by the same user not shown)

Line 4:

Check the sub itself for the actual current process.

* tries for an hour to save file "CCMdb Sample.xlsx" from an email from Chastity ~~Cleofas~~

* tries for an hour to save file "CCMdb Sample.xlsx" from an email from [[Chastity]]

** if email is not found in that timeframe, it will send an email to dc cc~~, dc med~~ and quit

** if email is not found in that timeframe, it will send an email to dc cc and quit

* cleans out the tmp tables where raw Cognos data is stored

* imports the correct tab (3) from [[Cognos EPR Report]] into raw data table

* imports the correct tab (3) from [[Cognos EPR Report]] into raw data table [[Cognos_import3 table]]

* runs [[Cognos2_import_Cognos2_OneTime query]]

* runs [[Cognos3_import_Cognos2_Units query]]

* runs [[Cognos3_import_Cognos2_Services query]]

* again cleans out temporary raw data tables

* 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 [[S Cognos Units table]]

** checks [[s_Cognos_Units_additions_needed query]]; if it finds new entries, an email is sent to a the [[Data Collection Manager]] and the [[Process Analyst]] 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]]

@@ Line 4: / Line 4: @@
 Check the sub itself for the actual current process.
-* tries for an hour to save file "CCMdb Sample.xlsx" from an email from Chastity Cleofas
+* tries for an hour to save file "CCMdb Sample.xlsx" from an email from [[Chastity]]
-** if email is not found in that timeframe, it will send an email to dc cc, dc med and quit
+** if email is not found in that timeframe, it will send an email to dc cc and quit
 * cleans out the tmp tables where raw Cognos data is stored
-* imports the correct tab (3) from [[Cognos EPR Report]] into raw data table
+* imports the correct tab (3) from [[Cognos EPR Report]] into raw data table [[Cognos_import3 table]]
 * runs [[Cognos2_import_Cognos2_OneTime query]]
 * runs [[Cognos3_import_Cognos2_Units query]]
 * runs [[Cognos3_import_Cognos2_Services query]]
 * again cleans out temporary raw data tables
 * 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 [[S Cognos Units table]]
+** checks [[s_Cognos_Units_additions_needed query]]; if it finds new entries, an email is sent to a the [[Data Collection Manager]] and the [[Process Analyst]] 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]]
@@ Line 20: / Line 20: @@
 [[Category:Cognos Report Integrator]]
+[[Category:CCMDB.accdb]]