Dong Shin 10.30.2013

  • changed Numeric to Currency in queryBuilderConfig.xml, Numeric is now number, now $ values
  • working on Outlays query…
    • decided to update the outlays data similar to obligations, may not have to use python script at all.
    • created views to replace the views created yesterday!
      • __view_monthly_obligations_outlays_by_contract, to be used for both outlay and obligations
      • __view_monthly_obligations_outlays_by_req_id, to be used to update obligations_outlays table
    • two update queries
      • UPDATE obligations_outlays oo
        LEFT JOIN __view_monthly_obligations_outlays_by_req_id AS vv
        ON vv.bc_uid = oo.funding_id
        SET oo.month_1 = vv.month_1_obligated, oo.month_2 = vv.month_2_obligated, oo.month_3 = vv.month_3_obligated, oo.month_4 = vv.month_4_obligated,
        oo.month_5 = vv.month_5_obligated, oo.month_6 = vv.month_6_obligated, oo.month_7 = vv.month_7_obligated, oo.month_8 = vv.month_8_obligated,
        oo.month_9 = vv.month_9_obligated, oo.month_10 = vv.month_10_obligated, oo.month_11 = vv.month_11_obligated, oo.month_12 = vv.month_12_obligated
        WHERE type = ‘Reported FACTS Obligated $:’
        AND year=2013 AND year_count=1
      • UPDATE obligations_outlays oo
        LEFT JOIN __view_monthly_obligations_outlays_by_req_id AS vv
        ON vv.bc_uid = oo.funding_id
        SET oo.month_1 = vv.month_1_outlay, oo.month_2 = vv.month_2_outlay, oo.month_3 = vv.month_3_outlay, oo.month_4 = vv.month_4_outlay,
        oo.month_5 = vv.month_5_outlay, oo.month_6 = vv.month_6_outlay, oo.month_7 = vv.month_7_outlay, oo.month_8 = vv.month_8_outlay,
        oo.month_9 = vv.month_9_outlay, oo.month_10 = vv.month_10_outlay, oo.month_11 = vv.month_11_outlay, oo.month_12 = vv.month_12_outlay
        WHERE type = ‘Outlay $ (Reported in FACTS)’
        AND year=2013 AND year_count=1