Project Schedule and Milestone Tracking

Start of the Workflow/Process.

Create a new entry in the Project Data Model to kick off the project lifecycle.

Assign a task to the Project Manager to define deliverables and constraints.

Generate individual entries in the Milestone Data Model based on the project roadmap.

Create tasks for specific team members to take ownership of individual milestones.

Fetch all milestone entries associated with the current Project ID.

Calculate the difference between the Project Start Date and the Project End Date.

Retrieve the completion status of all child milestones.

Aggregate completed milestones vs. total milestones to determine project progress percentage.

Aggregate the 'Cost' property from all milestone entries to track total spend.

Create a recurring task for the Stakeholder to review milestone achievements.

Update the 'Health' field (Green, Amber, Red) in the Project Data Model based on progress.

Calculate the difference between the 'Planned End Date' and the 'Forecasted End Date'.

Send an email to the Project Manager if the Schedule Variance calculation exceeds a specific threshold.

Create a task to develop a recovery plan if a milestone is flagged as 'Delayed'.

Create a visual report summarizing completed milestones, upcoming deadlines, and budget status.

Email the generated Project Progress Report to all project stakeholders.

Update the status of a milestone entry to 'Completed' once all related tasks are finished.

Update the Project Data Model entry to 'Closed' upon achievement of the final milestone.

Send an SMS to the Project Owner if a high-priority milestone enters a 'Critical' state.

End of the Workflow/Process.