Dong Shin 06.20.2013

  • VizTool meeting – in Requirement’s Bugs, Stuffs page
    • incorrect Total in Project Mgmt panel
    • EA mappings to contracts disappearing on Data Upload
    • move Type field from Project Info to Req in Project Editor
    • rework Add New ComboBox
      • set it to blank on new
    • update Sub Budget Center Names in the database
    • auto-fill from COGNOS data upload
      • Reported FACTS Obligated
      • Outlay $ (Reported in FACTS)
  • continue working on FA
    • working down the list from today’s meeting
    • working on fixing EA mapping to contracts
    • moved Type field to Req
      • query to update budget_center tables from projects table
      • UPDATE budget_centers c1 INNER JOIN ( SELECT p.type as p_type, c.uid as budget_center_id FROM projects p, budget_centers c WHERE p.uid = c.project_id) T ON c1.uid = t.budget_center_id SET type = T.p_type