Function CognosImport: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m Text replacement - "Cognos_dispo_translator table" to "s_Cognos_Locations table"
mNo edit summary
 
(15 intermediate revisions by the same user not shown)
Line 1: Line 1:
'''{{PAGENAME}}''' is the sub that accomplishes the [[Cognos EPR Report]] importing as part of [[Cognos data import]] .
'''{{PAGENAME}}''' 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
== Approximate algorithm==
** if email is not found in that timeframe, it will send an email to dc cc, dc med and quit
Check the sub itself for the actual current process.
* cleans out [[Cognos_import table]] and [[Cognos_processed table]]
 
* imports "page1_1!" and "page2_2!" from [[Cognos EPR Report]] into [[Cognos_import table]]
* tries for an hour to save file "CCMdb Sample.xlsx" from an email from [[Chastity]]
* runs [[Cognos_import_processor query]] to turn the data into the format we need and store it in [[Cognos_processed table]]
** if email is not found in that timeframe, it will send an email to dc cc and quit
* again cleans out temporary table [[Cognos_import table]]
* 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
* 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]]  
** 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]]  
** [[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]]  
** 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]]
 
== Log ==
2020-07-30 - added [[Cognos_SubServices_additions_needed query]] and code to generate email if it has content.


== Related articles ==  
== Related articles ==  

Latest revision as of 11:39, 2024 January 7

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: