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 ;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.