Dong Shin 01.26.2011

  • PPM Changes
    • all necessary project data passed onto Financial Status Panel
    • added Program Element and FACTS PE to Create Project Panel
    • disabled changed check on Financial Data – wasn’t really needed because data save is automatic
    • new tables to support Financial Status
      • program_elements
        • CREATE TABLE `project_portfolio`.`program_elements` (
          `name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,PRIMARY KEY ( `name` )) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci;

      • facts_pe
        • CREATE TABLE `project_portfolio`.`facts_pe` (
          `name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,PRIMARY KEY ( `name` )) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci;

    • added program_elements and facts_pe fields to budget_centers and set relationships
      • ALTER TABLE `budget_centers` ADD `program_element` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
        ADD `facts_pe` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL
      • ALTER TABLE `budget_centers` ADD INDEX ( `program_element` )
      • ALTER TABLE `budget_centers` ADD INDEX ( `facts_pe` )
      • ALTER TABLE `budget_centers` ADD FOREIGN KEY ( `program_element` ) REFERENCES `project_portfolio`.`program_elements` (
        `name`) ON DELETE SET NULL ON UPDATE CASCADE ;

      • ALTER TABLE `budget_centers` ADD FOREIGN KEY ( `facts_pe` ) REFERENCES `project_portfolio`.`facts_pe` (
        `name`) ON DELETE SET NULL 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.