- not getting any useful info out of all financial data script
- few question to convert to script
- What projects are under #% under budget?
- What managers/Financial people have project > 10%?
- What projects are overdue?
- query to retrieve current year data – year 2012 is for 2011 (year = 2011 + year_count (1…))
SELECT p.project_number, c.center_number, a.*, o.* from projects p, budget_centers c, budget_amounts a, obligations_outlays oWHERE p.uid = c.project_id AND c.uid = a.budget_center_id AND p.uid = o.project_idAND year_count = a.year AND (o.year + o.year_count) = 2012