Dong Shin 03.20.2013

  • need to modify presentation scripts/queries to show 6 months of data instead of full 24 months
    • looked at the queries and scripts, need to get working scripts/queries from site.
  • screen resolution of the monitor in the ISR PMO conference is 1280×1024
  • continue working on ProjectManager
    • working on filtering contracts data
    • created procedure to import contracts_cognos to budget_center_contracts –  import_cognos_contracts
      • CREATE DEFINER=`root`@`localhost` PROCEDURE `import_cognos_contracts`()
        NO SQL
        BEGIN
        TRUNCATE budget_center_contracts;
        INSERT INTO budget_center_contracts(budget_center,appropriation_year,requisition_id,po_reference,acr,
        committed_date,committed_amount,obligation_date,obligated_amount,expensed_date,expensed_amount,
        po_start_date,po_end_date,contract_type,po_type_code,contract_no,vendor_id)
        SELECT budget_center, appropriation_year, requisition_id, po_reference, acr, committed_date, committed_amount, obligation_date, obligated_amount, expensed_date, expensed_amount, po_start_date, po_end_date, contract_type, po_type_code, contract_no, vendor_id
        FROM contracts_cognos
        GROUP BY requisition_id, po_reference;
        END