Dong Shin 03.15.2013

  • cleaned up menus in the main panel and ProjectMgmtPanel
  • saving database modifications to ProjectManager/src/main/resources/database/DBUpdateEnhancements.sql
  • created a copy of ProjPortfolioMgr webapp – ProjectManager – to use test database, project_portfolio_enh
  • created budget_center_contracts – store unique contracts from contracts_cognos table
    • additional column, budget_center_id, to map budget_centers to contracts
    • query to add 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

  • add columns to projects table
    • ALTER TABLE `projects` ADD `center_name` VARCHAR( 50 ) NULL ,
      ADD `center_number` VARCHAR( 50 ) NULL ,
      ADD `appropriation` VARCHAR( 30 ) NULL ,
      ADD `type` VARCHAR( 50 ) NULL ,
      ADD `capability` VARCHAR( 50 ) NULL ,
      ADD `expenditure_center` VARCHAR( 50 ) NULL ,
      ADD `investment_portfolio` VARCHAR( 50 ) NULL ,
      ADD `program_element` VARCHAR( 50 ) NULL ,
      ADD `facts_pe` VARCHAR( 50 ) NULL