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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.