Dong Shin 10.14.11

  • working at home
  • PPM
    • made font size bigger (12)
    • fixed endpoint errors not getting to MySQLIf (timing)
    • find overdue budget centers
      • select *, ‘overdue’ as status from obligations_outlays
        where (year + year_count) = 2013 and isnull(month_1)
        and funding_id in
        (select uid from budget_centers where project_id = 99)
        group by funding_id
    • find overdue years for the budget center
      • select *, ‘overdue’ as status from obligations_outlays
        where (year + year_count) = 2013 and isnull(month_1)
        and funding_id = 181
        group by year