Dong Shin 10.17.2018

  • deployed new FA, queries, script to correct EA calculations, everything is well
  • talked Lenny about keeping historical COGNOS data to keep track of changes occurring, as well as reviewing and flagging duplicate rows
    • run a series of queries to show potential conflicting data
    • each query displays the data to be resolved
    • rows are marked to *IGNORE* to be included in reports and data imports
  • removed TRUNCATE contracts_cognos from ProjectMgmtPanel to keep all COGNOS data
  • working on COGNOS data processor
  • reset_obligations_outlays.sql to reset obligations and outlays data
  • database updates – DBUpdateEnhancements.sql
    • additional column in contracts_cognos
      • ALTER TABLE `contracts_cognos` ADD `hide_flag` TINYINT NOT NULL DEFAULT ‘0’;
    • remove trigger copy_contracts_cognos
      • DROP TRIGGER IF EXISTS `copy_contracts_cognos`
    • create queries table to process COGNOS data
      • CREATE TABLE IF NOT EXISTS `process_cognos_data_queries` (
        `uid` int(11) NOT NULL,
        `name` varchar(255) NOT NULL,
        `query` text NOT NULL,
        `description` text NOT NULL,
        PRIMARY KEY (`uid`)
        ) ENGINE=InnoDB DEFAULT CHARSET=latin1;