RM Stalker – Allocation over 120% – SQL

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.

Want access to our solutions?

Register for a free theBasiX™  account and upgrade to theWorX to gain access to all of the content available on RegoXchange™.

Download Details

RegoXchange Content ID: EX0882

Submission Date:

Submitter:

Content Type: Clarity Studio

Related Modules: Allocations

Company: Rego Consulting

Version Support

Versions Supported: 15.x, 16.x

Special Instructions

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.