Dong Shin 10.23.2012

  • created a script to save Planned Value alerts to Alerts table – AlertPlannedValuesSaveToTable.py
  • working on script to generate alerts for unchanged Financial Mitigation Plans
  • query to get unchanged FMPs from previous months
    • SELECT *
      FROM `financial_mitigation_plans` fmp1, financial_mitigation_plans fmp2
      WHERE fmp1.obligation_outlay_uid = fmp2.obligation_outlay_uid
      AND fmp1.financial_mitigation_plan = fmp2.financial_mitigation_plan
      AND fmp1.explanation1 = fmp2.explanation1
      AND fmp1.explanation2 = fmp2.explanation2
      AND fmp1.explanation3 = fmp2.explanation3
      AND fmp1.explanation4 = fmp2.explanation4
      AND fmp1.explanation5 = fmp2.explanation5
      AND fmp1.month + 1 = fmp2.month