Dong Shin 04.01.2014

  • Oracle doubles the speed of MySQL query handling – found this while reading about MariaDB, upgrade soon?
  • need to run 6 queries to update Obligations/Outlays data when claim/un-claim happens…
    • update obligations (4), update outlays (5), update outlays for second year (6), update months in year 1 to 100% (101), update month 1 year 2 to 100% from month 12 year 1 (200), update months in year 2 to 100% (201)
  • worked off most of the Action Items from 3/25/2014
    • All fields with $ should accept negative values – CurrencyTextInput
    • get a list of budget values for FY13 and FY14 charts
    • create a query for Planned Obligated vs. FACTS
    • Outlay $ Reported row should not be editable
    • invoice dialog box should not show if the line item is not a MIPR or EAO
    • total budget in slides should be project total, not requistiion total
    • Req Data Analysis should show Req Allocated, Req Funded (Committed)