Dong Shin 08.16.2012

  • working at home
  • query to get projects that has same value in previous months
    • SELECT p.project_number, p.title, p.proj_mgr_login,
      c.uid, c.center_number, c.center_name, c.appropriation,
      a.year, a.amount,
      o.*
      FROM projects p,
      budget_centers c,budget_amounts a,obligations_outlays o
      WHERE p.uid = c.project_id
      AND a.budget_center_id = c.uid
      AND o.project_id = p.uid AND c.uid = o.funding_id AND o.year_count = a.year
      AND ((o.month_1 = o.month_2 AND NOT ISNULL(o.month_1))
      OR (o.month_2 = o.month_3 AND NOT ISNULL(o.month_2))
      OR (o.month_3 = o.month_4 AND NOT ISNULL(o.month_3))
      OR (o.month_4 = o.month_5 AND NOT ISNULL(o.month_4))
      OR (o.month_5 = o.month_6 AND NOT ISNULL(o.month_5))
      OR (o.month_6 = o.month_7 AND NOT ISNULL(o.month_6))
      OR (o.month_7 = o.month_8 AND NOT ISNULL(o.month_7))
      OR (o.month_8 = o.month_9 AND NOT ISNULL(o.month_8))
      OR (o.month_9 = o.month_10 AND NOT ISNULL(o.month_9))
      OR (o.month_10 = o.month_11 AND NOT ISNULL(o.month_10))
      OR (o.month_11 = o.month_12 AND NOT ISNULL(o.month_11)))
  • no 10:30 meeting
  • created script to generate project data that has same value as previous months – src/main/java/resources/scripts/EqualMonths.py
    • working on passover years
  • need to clean up associated managers in projects, move all the managers to separate table and remove the fields in the projects table