Dong Shin 05.27.2011

  • additional fields needed to Funding Request – also in Bug List
    • Title/Task Name
    • Program Element in Budget Center/Funding list
    • Contracts Info: Contract Numbers, Contractor Names, Contractor Place of Performance
    • Additional Info (required so MIPR will not be rejected)
  • PPM Changes
    • fixed Create Project panel showing AddBudgetCenterWindow on double click on empty DG (itemDoubleClick)
    • funding_request table modification so that Appropriation changes reflect…
      1. ALTER TABLE `funding_requests` ADD INDEX ( `appropriation` )
      2. ALTER TABLE `funding_requests` CHANGE `appropriation` `appropriation` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
      3. ALTER TABLE `funding_requests` ADD FOREIGN KEY ( `appropriation` ) REFERENCES `project_portfolio`.`appropriations` (`type`) ON DELETE NO ACTION ON UPDATE CASCADE ;
    • update Appropriations
      1. UPDATE `project_portfolio`.`appropriations` SET `type` = ‘O&M (FY10)’ WHERE `appropriations`.`type` = ‘FY10 O&M’;
      2. UPDATE `project_portfolio`.`appropriations` SET `type` = ‘Procurement (FY10)’ WHERE `appropriations`.`type` = ‘FY10 Procurement’;
      3. UPDATE `project_portfolio`.`appropriations` SET `type` = ‘RDT&E (FY10)’ WHERE `appropriations`.`type` = ‘FY10 RDT&E’;
    • added new fields to Funding Request panel
      • Title/Task Name
      • Program Element
      • Contract Info datagrid
      • Additional Info
    • created _funding_requests_contracts table to support contracts info
      1. CREATE TABLE `_funding_requests_contracts` (`funding_request_id` INT NOT NULL ,`contract_id` INT NOT NULL , INDEX ( `funding_request_id` , `contract_id` )) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci;
      2. ALTER TABLE `_funding_requests_contracts` ADD INDEX ( `contract_id` );
      3. ALTER TABLE `_funding_requests_contracts` ADD FOREIGN KEY ( `funding_request_id` ) REFERENCES `project_portfolio`.`funding_requests` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE ;
      4. ALTER TABLE `_funding_requests_contracts` ADD FOREIGN KEY ( `contract_id` ) REFERENCES `project_portfolio`.`contracts` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE ;