Late Milestones – SQL

The Late Milestones portlet displays all action items related to active projects that the logged in user has view rights to.  The milestones displayed are those that are not closed but are past their finish date or past their baseline finish date.  The portlet provides a Project Manager the ability to view and track action items across multiple projects without going into each project individually.

This portlet provides a single consolidated view of late milestones based on the current project baseline, and the age of the milestone. The portlet will display the Project ID, Project Name, Project Manager, Milestone Name, Due Date, Baseline Date, Days Late (calculated from baseline dates), and Days Old (calculated from today’s date).