Dong Shin 01.25.2013

  • Master Spreadsheet meeting – worked out most of the details
  • working on queries for Col. Duke’s presentation
    • created projects for each of Capabilities and Appropriations
    • built a query to retrieve PM Actuals grouped by capability
      • SELECT CONCAT(capability, ‘_’, TRIM(TRAILING ‘(FY10)’ FROM appropriation), ‘_PM_Actuals’) as Name,
        SUM(IF(o.year_count = 1, month_1, 0) )AS OCT_2012_FY13,
        SUM(IF(o.year_count = 1, month_1, 0) )AS NOV_2012_FY13,
        SUM(IF(o.year_count = 1, month_1, 0) )AS DEC_2012_FY13,
        SUM(IF(o.year_count = 1, month_1, 0) )AS JAN_2013_FY13,
        SUM(IF(o.year_count = 1, month_1, 0) )AS FEB_2013_FY13,
        SUM(IF(o.year_count = 1, month_1, 0) )AS MAR_2013_FY13,
        SUM(IF(o.year_count = 1, month_1, 0) )AS APR_2013_FY13,
        SUM(IF(o.year_count = 1, month_1, 0) )AS MAY_2013_FY13,
        SUM(IF(o.year_count = 1, month_1, 0) )AS JUN_2013_FY13,
        SUM(IF(o.year_count = 1, month_1, 0) )AS JUL_2013_FY13,
        SUM(IF(o.year_count = 1, month_1, 0) )AS AUG_2013_FY13,
        SUM(IF(o.year_count = 1, month_1, 0) )AS SEP_2013_FY13,
        SUM(IF(o.year_count = 2, month_1, 0) )AS OCT_2013_FY13,
        SUM(IF(o.year_count = 2, month_1, 0) )AS NOV_2013_FY13,
        SUM(IF(o.year_count = 2, month_1, 0) )AS DEC_2013_FY13,
        SUM(IF(o.year_count = 2, month_1, 0) )AS JAN_2014_FY13,
        SUM(IF(o.year_count = 2, month_1, 0) )AS FEB_2014_FY13,
        SUM(IF(o.year_count = 2, month_1, 0) )AS MAR_2014_FY13,
        SUM(IF(o.year_count = 2, month_1, 0) )AS APR_2014_FY13,
        SUM(IF(o.year_count = 2, month_1, 0) )AS MAY_2014_FY13,
        SUM(IF(o.year_count = 2, month_1, 0) )AS JUN_2014_FY13,
        SUM(IF(o.year_count = 2, month_1, 0) )AS JUL_2014_FY13,
        SUM(IF(o.year_count = 2, month_1, 0) )AS AUG_2014_FY13,
        SUM(IF(o.year_count = 2, month_1, 0) )AS SEP_2014_FY13
        FROM obligations_outlays o, budget_centers c, budget_amounts a
        WHERE
        o.year = 2013
        AND (o.year_count = 1 OR o.year_count = 2)
        AND o.type = ‘PM Actuals (Invoiced) Outlay $:’
        AND c.uid = o.funding_id
        AND c.uid = a.budget_center_id
        AND a.year = 1
        AND (capability = ‘TRCO’
        or capability = ‘ACC’
        or capability = ‘GCC’
        or capability = ‘MCC’
        or capability = ‘CCRSE’)
        GROUP BY Name