Dong Shin 07.21.11

  • refined the projects_overdue query
    • SELECT 2011 AS currentYear, 10 as currentMonth,  p.uid as ‘project_id’, p.begin_year, p.project_number, b.uid as ‘budget_center_id’, b.center_number, b.appropriation, a.year as ‘budget_year’  FROM project_portfolio.projects p, project_portfolio.budget_centers b, project_portfolio.budget_amounts a,  project_portfolio.obligations_outlays o, project_portfolio.obligations_outlays_goals g  WHERE p.uid = b.project_id AND b.uid = a.budget_center_id AND b.uid = o.funding_id  AND b.appropriation = g.appropriation AND g.year = year_count AND a.year = g.year AND (p.begin_year + a.year – 1) = 2011 AND ISNULL(o.month_10) ORDER BY b.uid, a.year, o.year