Dong Shin 02.14.2013

  • FGM Mail down? can’t get to the web mail either….
  • added Budget Center DropdownList to the status view, added event handler to change data
  • added a flag to keep track of Funded Budget (Commit in the Funding Request table) in the database – done!
    • ALTER TABLE `funding_requests` ADD `commit_flag` TINYINT NOT NULL DEFAULT '0' AFTER `commit`
    • UPDATE funding_requests SET commit_flag = 1 WHERE COMMIT > 0
    • DBUpdateSQLs02142013.sql
    • query to update commit_flag
      • UPDATE funding_requests SET commit_flag = 1 WHERE funding_requests.uid IN
        (SELECT funding_request_id FROM _funding_requests_budget_centers
        WHERE budget_center_id = 18)
  • changed PPM to keep track of the funded budget flag in the funding requests
  • disabled projects in PA that has $0 budgeted amount in funding requests
  • trouble shooting 4.7 install issues…. no luck, java crashes in memory dump found in the installation directory. uninstalling and re-install 4.6