Dong Shin 11.26.2013

  • deployed new FA/RA
    • outlay not adding up from the previous year
    • add Total Funded to Project Mgmt Panel
  • working on FA
    • query to update second year of Outlays
    • UPDATE obligations_outlays o1,
      (SELECT month_12 FROM obligations_outlays oo2 WHERE type = ‘Outlay $ (Reported in FACTS)’ AND year_count = 1
      AND o1.funding_id = o2.funding_id AND o1.project_id = o2.project_id
      ) AS o2
      SET o1.month_1 = o2.month_12 + o1.month_1,
      o1.month_2 = o2.month_12 + o1.month_2,
      o1.month_3 = o2.month_12 + o1.month_3,
      o1.month_4 = o2.month_12 + o1.month_4,
      o1.month_5 = o2.month_12 + o1.month_5,
      o1.month_6 = o2.month_12 + o1.month_6,
      o1.month_7 = o2.month_12 + o1.month_7,
      o1.month_8 = o2.month_12 + o1.month_8,
      o1.month_9 = o2.month_12 + o1.month_9,
      o1.month_10 = o2.month_12 + o1.month_10,
      o1.month_11 = o2.month_12 + o1.month_11,
      o1.month_12 = o2.month_12 + o1.month_12
      WHERE type = ‘Outlay $ (Reported in FACTS)’
      AND (year + year_count) <= (IF(MONTH(CURDATE()) > 9, YEAR(CURDATE()) + 2, YEAR(CURDATE()) + 1))
      AND year_count = 2

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.