Project Status and Costs – SQL

The portlet shows the Overall Status and Budget Status and Amounts. It displays one row per project. The portlet shows the following main fields: Overall Status, Budget Status, Capital Budget, Operating Budget, Total Budget, Capital Planed, Operating Planned, Total Planned, Capital Actuals, Operating Actuals, Total Actuals, Budget Variance ($), Budget Variance (%)

Displaying the budget variance allows the PM to understand of the project is over / under spent, and thus the costs planning needs to be re-visited.