Timesheet Approval – PM and RM – SQL

The Timesheet Approval – RM and PM process is an auto-start process that begins once the resource submits his or her timesheet. This process provides a checks-and-balances style to ensure that all resources entering time have entered the 40 hours.

Once the timesheet is submitted, the process will lock the user’s timesheet to prevent editing. The process will then select the next action based on three different factors:

  1. The timesheet has less than 40 hours.
  2. The timesheet has 40 or more hours.
  3. The resource’s availability is less than 8hrs/day.

If the user has submitted a timesheet with less than 40 hours, then the process will email the user informing him/her of issue, unlocks the timesheet, and changes the status to “Returned”. If the user has an availability of less than 8hrs/day or the timesheet has 40 or more hours, then an action item will be sent to the resource manager informing him/her of the timesheet. If the resource manager (RM) AND project manager (PM) approves the action item, then the process will approve the timesheet and unlock the timesheet. However, if the RM or PM selects “Return” on the action item, then the process will return the timesheet, mail the user that informing him/her that the timesheet has been returned, and unlock the timesheet.

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: EX0122

Submission Date:

Submitter:

Content Type: Clarity Studio

Related Modules: Project Management

Company: Rego Consulting

Version Support

Versions Supported: 15.x, 16.x

Special Instructions

Special Instructions: In the email submitter step, a parameter must be set in the script to email. The parameter must be the email address the emails will be sent from.

Users that initiate this process must have Process Start permissions. Typically, those rights are granted to a security group which contains all active users.