Dong Shin 08.30.11

  • adding monthly PM Actuals to Financial Status
    • PM Actual Outlay tooltip added to FinancialStatusDataForm
    • query – long and +gly, grabs whole year’s data
    • SELECT * FROM (SELECT r.funding_amount as statusAmount, r.*, c.uid as contractUid, c.contract_number as contractNumber, c.name as contractorName, c.location as contractorLocation, c.amount as contractAmount, d.uid as directCiteUid, d.obligation_amount as dObligationAmount, d.outlay_amount as dOutlayAmount, NULL as rObligationAmount, NULL as rOutlayAmount, b.center_number, a.amount, r.uid as fundingRequestId, a.uid as budgetAmountsId, o.month_1, o.month_2, o.month_3, o.month_4, o.month_5, o.month_6, o.month_7, o.month_8, o.month_9, o.month_10, o.month_11, o.month_12 FROM funding_requests r LEFT JOIN direct_cites d ON r.uid = d.funding_request_id LEFT JOIN contracts c ON d.contract_id = c.uid LEFT JOIN budget_centers b on r.project_id = b.project_id LEFT JOIN budget_amounts a on b.uid = a.budget_center_id, obligations_outlays o WHERE b.project_id = 100 AND a.uid = 1395 AND NOT ISNULL(d.funding_request_id)  AND r.fiscal_year = 2011 AND o.year = 2011 AND o.project_id = 100 AND o.funding_id = 213 AND o.type LIKE ‘PM Actuals Outlay%’ AND o.year_count = 1 UNION SELECT r.funding_amount as statusAmount, r.*, NULL as contractUid, NULL as contractNumber, NULL as contractorName, NULL as contractorLocation, NULL as contractAmount, NULL as directCiteUid, NULL as dObligationAmount, NULL as dOutlayAmount, r.reimbursable_amount as rObligationAmount, r.outlay_amount as rOutlayAmount, b.center_number, a.amount, r.uid as fundingRequestId, a.uid as budgetAmountsId, o.month_1, o.month_2, o.month_3, o.month_4, o.month_5, o.month_6, o.month_7, o.month_8, o.month_9, o.month_10, o.month_11, o.month_12 FROM funding_requests r LEFT JOIN budget_centers b on r.project_id = b.project_id LEFT JOIN budget_amounts a on b.uid = a.budget_center_id, obligations_outlays o WHERE b.project_id = 100 AND a.uid = 1395 AND r.fiscal_year = 2011 AND r.uid NOT IN (SELECT funding_request_id FROM direct_cites) AND o.year = 2011 AND o.project_id = 100 AND o.funding_id = 213 AND o.type LIKE ‘PM Actuals Outlay%’ AND o.year_count = 1) AS T1 ORDER BY uid, contractUid, statusAmount DESC