Dong Shin 01.24.2014

  • checked the Funded Budget, found that the calculated values not stored correctly. The field needs gone.
  • ran the query for the reports, quick enough.
  • ran through the queries that Lenny runs to get the data from Cognos. I tried to look for the relation tables, but no luck. Somehow it mashes the tables up behind… Then we ran the query with minimal number of columns that we think we definitely need, all the duplicates disappeared! There are more than 7 tables to get all the data and I think the duplicates are generated because of the relations….
  • Minimal Columns!
    • Budget Center, Sub-Budget Center, Executing Budget Center, Appropriation Year, Requisition ID, PO Reference, ACR, Obligation Date, Obligated Amount, Expensed Date, Expensed Amount, Voucher ID
  • working on the new COGNOS data structure changes
    • new contracts_cognos tabel structure
      • CREATE TABLE IF NOT EXISTS `contracts_cognos` (
        `uid` int(11) NOT NULL AUTO_INCREMENT,
        `budget_center` varchar(10) NOT NULL,
        `sub_budget_center` varchar(128) DEFAULT NULL,
        `executing_budget_center` varchar(128) DEFAULT NULL,
        `appropriation_year` int(11) NOT NULL,
        `requisition_id` varchar(10) NOT NULL,
        `po_reference` varchar(40) DEFAULT NULL,
        `acr` varchar(3) DEFAULT NULL,
        `obligation_date` date DEFAULT NULL,
        `obligated_amount` decimal(10,2) DEFAULT NULL,
        `expensed_date` date DEFAULT NULL,
        `expensed_amount` decimal(10,2) DEFAULT NULL,
        `voucher_id` varchar(255) DEFAULT NULL,
        `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
        `hide_flag` tinyint(4) NOT NULL DEFAULT ‘0’,
        PRIMARY KEY (`uid`)
        ) ENGINE=InnoDB;