Dong Shin 10.16.2013

  • deployed new FA, everything seems well
  • went over Obligation and Outlay import calculations with Lenny and found that the only Outlay should be added with the previous month’s value (not cumulative).
  • fixed update_obligation_outlays.py script to fix incorrect calculation detailed above – do not add previous month’s value when type is not Outlay
  • disabled runPythonScript in FA until fix for slow running script is found….
  • updated EA cognos queries to correctly sum up obligations/outlays – obligation_outlay_queries.sql
  • created a table – contracts_cognos_all, to keep all historical data, also created a trigger to add contracts_cognos data to the table the new files get ingested  – DBUpdateEnhancements.sql