Dong Shin 02.28.2014

  • deployed new FA and query updates, everything seemed well until…. found that the fiscal year in obligations/outlay gets messed up when the data spans over one year. will need to separate the obligations / outlays
  • created four new views…
    • __view_monthly_obligations_by_contract, __view_monthly_outlays_by_contract, __view_monthly_obligations_by_req_id, __view_monthly_outlays_by_req_id
  • updating post-processing queries – done
  • found some lingering (ghost) summary data in budget_center_contracts table in my database, need to check it on-site to make sure it doesn’t get confused with others.