RM Stalker - Allocation over 120% - Postgres

theWorX

Based on the pre-determined schedule frequency, this job will send an email to Resource Managers that have a Resource meeting the criteria of: Average allocations are greater than 120% where Resource(s) and Project(s) are active over the next 90 days. This serves as a reminder to Resource Managers to monitor and manage allocations. The contents of the email include a message indicating the Resource Manager has at least one Resource meeting this criteria and a table indicating the Resource and that resource’s average, next 90 days allocations.

Download Details
Submission Date Jan 7, 2020 4:01 pm
Submitter Rego
Content Type Other
Database Architecture Postgres
Work Type
Work Categories
Supported Versions v15.7+
Special Instructions This workflow should be run as a Job via Execute a Process. This job would typically be scheduled versus running ad-hoc. The frequency (e.g. Once per week on Mondays) should be determined by current business process and approved by management. The xml to xog this in an environment is provided. If no local resources exist that are comfortable with importing and exporting via xog, then Rego install is required.
Company Rego Consulting