Dong Shin 05.24.2011

  • not getting any useful info out of all financial data script
  • few question to convert to script
    1. What projects are under #% under budget?
    2. What managers/Financial people have project > 10%?
    3. 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