Function CognosImport: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 8: | Line 8: | ||
* cleans out the tmp tables where raw Cognos data is stored | * cleans out the tmp tables where raw Cognos data is stored | ||
* imports the correct tab (3) from [[Cognos EPR Report]] into raw data table [[Cognos_import3 table]] | * imports the correct tab (3) from [[Cognos EPR Report]] into raw data table [[Cognos_import3 table]] | ||
* runs [[Cognos2_import_Cognos2_OneTime query]] | * runs [[Cognos2_import_Cognos2_OneTime query]] | ||
* runs [[Cognos3_import_Cognos2_Units query]] | * runs [[Cognos3_import_Cognos2_Units query]] | ||
* runs [[Cognos3_import_Cognos2_Services query]] | * runs [[Cognos3_import_Cognos2_Services query]] | ||
* again cleans out temporary raw data tables | * again cleans out temporary raw data tables | ||
* 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 | ** 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]] | ** 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 11:09, 2023 May 17
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.
- 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
- cleans out the tmp tables where raw Cognos data is stored
- 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 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