Function CognosImport

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

• tries for an hour to save file CCMdb Sample.xlsx from email from Chastity Cleofas
  • if email is not found in that timeframe, it will send an email to dc cc, dc med and quit
• cleans out Cognos_import table and Cognos_processed table
• imports "page1_1!" and "page2_2!" from Cognos EPR Report into Cognos_import table
• runs Cognos_import_processor query to turn the data into the format we need and store it in Cognos_processed table
• again cleans out temporary table Cognos_import table
• starts the email that will tell collectors that the new data is now available
  • Cognos_dispo_translator_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

Log

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