PM – Notification of Hard Booked Resources – Postgres

This notification process sends an email to the Manager of an investment (Project, Application, Idea, etc) when the resource assigned to the team has been hard booked.   The process should be scheduled to run on a daily basis as the logic in it looks to all resources where their Booking  Status has been changed from Soft to Hard on the day that the process is run.  It compares the audit trail date change field to the system date.

If the process is not scheduled to run daily no notification will occur on hardbookings from previous days.