RegoXchange
  • This training document is a Rego Consulting Quick Reference Guide to assist with Time Entry Administration Settings for Timesheets.  This doc references version 16.0.3 views. Document provides detail on Timesheet Options for the Modern UX and how to enable end user column configuration. Detail is also provided on how end users may configure their timesheet view.
  • The Rego Estimation Module Provides a more accurate estimate earlier in the idea/project lifecycle.
    • Is applied consistently so it can be improved.
    • Retains the data in Clarity to enable analysis.
    • Provides ongoing feedback by comparing estimates to current EAC.
    • Provides historical record of estimating for projects overall as well as change requests.
  • This portlet pulls back the Availability and Allocation totals by Role between a user-specified Start and Finish Date, then the user can drilldown to look at the information for Applications.  The Time Period filter allows for comparing these values across different timeframes (monthly, weekly, quarterly, annual) as desired.  Other filters allow for looking at Active or Inactive Roles (or both) and including Active or Inactive Projects (or both) in the totals.
  • Capacity Graph report provides the Resource Managers & PMO a single place to view Monthly Availability, Allocations, Actuals and Assignments for one or more active resources. Information is displayed in the form of a line chart. Legend displays the color associated with each metric. Mouse over the line chart displays hours associated with that corresponding metric. This report provides Managers a simple means to analyze: Allocations vs. Availability, Allocations vs. Actuals, Allocations vs. ETC and ETC vs. Availability and helps in determining the areas of improvement. User can further narrow their search by OBS Type & Path, Month Start Date, Resource Name, Resource Manager, Primary Role & Employment Type.
  • This process workflow with gel script forces billable hours on timesheet down to 40 hours, and sets overtime hours to non-billable.  Timesheets with 40 or fewer hours are not touched.  Process kicks off upon submission of timesheet.  Steps are:
    • Determine if timesheet has > 40 hours.  If so, proceed.
    • Create a SPLIT row for each timesheet row, with Input Type Code = Non-Bill.
    • Divide 40 by total timesheet ours.  Store this value.
    • Multiply each timesheet cell by the stored value, and enter the result into that cell.
    • Take the difference (original cell value – new cell value), and enter in same cell on Split row.
    • The end result will be 40 hours total on Billable rows, and overtime hours on Non-Billable rows.
  • Process sends an email to RM, for resources assigned, that indicates the allocation percentage for each resource for the next 6 weeks.  Email has links to each resource so that allocation modifications can be made as required.
  • The Enhanced Time Tracking Stalker – RM workflow process automatically sends a single email to Resource Managers which contains a list of any of their resources that have not submitted their timesheet for a prior open time period.  The email informs the RM if their resources are submitting their timesheets on time.  The email includes a table that provides this information for each resource: Resource Name, Time Period, Timesheet Status and Total Hours saved on the timesheet with links to the timesheet in the Modern User Experience of Clarity. These notifications will help to ensure that time is being posted and approved in a timely manner.
  • The Grant Resources Timesheet Edit Rights process will grant each resource timesheet edit instance rights to his or her own timesheets.  This process will not remove any existing timesheet edit instance rights.
  • The Grant Resources Timesheet Edit Rights process will grant each resource timesheet edit instance rights to his or her own timesheets.  This process will not remove any existing timesheet edit instance rights.
  • The Timesheet Approval - Auto process is an auto-start process that begins once the resource submits his or her timesheet. This process bypasses a Resource Manager approval and allows the user to post his or her timesheet. 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 the issue, unlock the timesheet, and change 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 user as a last step before the timesheet is approved. Once the timesheet is approved, then the script will set the status of the timesheet to “Approved” and unlock the timesheet.
  • The Time Tracking Stalker - RM workflow process automatically sends an email to Resource Managers for each one of their resources that have not submitted their timesheet for a prior open time period, thus informing the RM if their resources are submitting their timesheets on time. Project Managers will also benefit since the notifications will help to ensure that time is being posted against their projects in a timely manner, helping to provide them with an accurate view of time expended on the projects.
  • The Timesheet Notes portlet displays all timesheet notes split out by resource, investment and task.  This is very useful in situations where you want to review multiple notes as you do not have to open each note separately. The table below describes the available filter fields in the portlet.
    Column Label Description
    Timesheet Period Start Range of time periods to display filtered by start date
    Timesheet Period Finish Range of time periods to display filtered by finish date
    Resource Resource(s) to display
    Type Note on a timesheet or time entry (task specific)
  • The Timesheet Notes portlet displays all timesheet notes split out by resource, investment and task.  This is very useful in situations where you want to review multiple notes as you do not have to open each note separately. The table below describes the available filter fields in the portlet.
    Column Label Description
    Timesheet Period Start Range of time periods to display filtered by start date
    Timesheet Period Finish Range of time periods to display filtered by finish date
    Resource Resource(s) to display
    Type Note on a timesheet or time entry (task specific)
  • Resource Availability – 4 Weeks is a grid portlet that displays all resources with their total allocated hours by week, and an average availability percent (4 Wk Avail %) for next four weeks.  If % Available is negative, this indicates an over-allocation.  Zero% Average Availability indicates fully allocated (no remaining availability). Filterable by Role, Resource, Resource Type, Full-Time/Part-Time, Availability Range.  Contractor Type is a custom attribute (Lookup - String) created on the Resource object. It is attached to the lookup, Contractor Type (Lookup ID: REGO_CONTRACTOR_TYPE) that has static values Part Time (PT) and Full Time(FT).
  • A Process run via Execute a Process job; sends an email to active resources, containing a facsimile of their Resource Allocation Detail page.  It shows the next six weeks of allocations by investment, with a column total.  The email also contains a click here link to this page in CA PPM, to enable editing of the data, as appropriate.
  • The Pending Actuals portlet displays pending actuals for resources by task. This portlet allows the user to filter on Project, Project Manager, Is Active and Is Open for Time Entry. This portlet provides Resource Managers and Project Managers a simple way to analyse which actuals have been submitted but not posted on specific tasks, as well as the aggregate pending hour total. Note: the information displayed is dependent on what the user has security rights to view.
  • The purpose is to show actual hours, planned effort and remaining effort at the resource level, with the addition of OBS levels to support filtering and manipulation of the exported data.
  • The purpose is to show actual hours, planned effort and remaining effort at the resource level, with the addition of OBS levels to support filtering and manipulation of the exported data.
  • Project managers may use this portlet to show the planned effort and the remaining effort on projects.  Includes actual hours as well as estimate at completion. You may narrow the results by filtering by project name, project manager, project OBS, or active flag. The portlet will display each project by ID, name, project manager, planned effort (total allocation hours), actual hours, remaining effort (ETC), and estimate at complete (actual + ETC).
  • The My Resource Vacation portlet allows a resource to view the current logged in users' annual vacation allowance, as set by the resource manager, against the resource vacation calendar hours and actual posted timesheet hours. The portlet is useful for determining the amount of hours a resource has requested off and has remaining. The portlet also ensures the resource has accounted for all annual vacation allowance hours in the calendar and has posted time for all past calendar request hours.
  • The My Resource Vacation portlet allows a resource to view the current logged in users' annual vacation allowance, as set by the resource manager, against the resource vacation calendar hours and actual posted timesheet hours. The portlet is useful for determining the amount of hours a resource has requested off and has remaining. The portlet also ensures the resource has accounted for all annual vacation allowance hours in the calendar and has posted time for all past calendar request hours.
  • The Hours and Cost by Vendor – Grid portlet displays vendor hour or costs by month grouped by vendor.  Using this portlet, management is provided with a quick overview of vendor costs or hours by month for a set of time without running a report or navigating to each resource individually. This portlet uses the monthly actual timeslices.  The user may filter by vendor, vendor ID, date, and hours/cost in addition to the start/finish and hours/cost. Once populated, the grid will display all vendors that currently have hours/cost for the selected time frame.
  • The Hours and Cost by Vendor – Grid portlet displays vendor hour or costs by month grouped by vendor.  Using this portlet, management is provided with a quick overview of vendor costs or hours by month for a set of time without running a report or navigating to each resource individually. This portlet uses the monthly actual timeslices.  The user may filter by vendor, vendor ID, date, and hours/cost in addition to the start/finish and hours/cost. Once populated, the grid will display all vendors that currently have hours/cost for the selected time frame.
  • The Hours and Cost by Vendor - Graph portlet displays vendor hour or costs by month.  Using this portlet, management is provided with a graphical representation of vendor costs or hours by month for a set of time without running a report or navigating to each resource individually. This portlet uses the monthly actual timeslices.  Additionally, the user must select a date range and whether to display hours or costs. Once populated, the graph will display all vendors that currently have hours and cost for the selected date range.
Go to Top