RegoXchange
  • Course Description:   Have you considered using Rally Software® in conjunction with Clarity PPM? Have you seen or heard about the OOTB connector? This class will go through the OOTB connector in detail and show how Rego has built addons to enhance the connectivity between these two tools.
  • 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).
  • The Global Action Items portlet will help users and clarity admins to keep track of action items in the CA PPM system. This is useful to keep track of Timesheet Approval through Action Item or any other Action Item related workflows. The portlet displays Name, Type Assignee, Created by, Due Date, Health and Status of the Action Items as default columns. The portlet provides  Project, Project Manager, Project OBS, Assignee, Status and Due Dates of the Action Items as default filters.
  • The Timesheet Audit portlet displays timesheet information in order to perform an audit.  The only required data needed to search the portlet is start and finish date. Additionally, you may narrow the results by filtering by resource, resource ID, OBS Unit, resource manager, timesheet status, project, and task. The portlet provides reporting on the following:
    • Resource
    • Resource ID
    • Email Icon of Resource (So the reviewer can quickly email the Resource)
    • Resource is Active
    • Resource Open for Time
    • Time Period (Start and Finish Dates)
    • Timesheet Status
    • Is Adjustment (If the timesheet is adjusted)
    • Timesheet Modified Date
    • Timesheet Posted Date
    • Timesheet Submitted By
    • Timesheet Approved By
    • Project
    • Task
    • Proposed ETC Hours
    • Pending Actual Hours
    • Total Actual Hours
  • 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 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.
  • 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.
  • The Time by Stage and Timescale – Grid portlet displays hours for all tasks on projects by their stage for a user-defined time period. The user may narrow the results by time scale, resource OBS unit, and dates. The portlet not only provides the total hours per stage, but also the percentage of time spent on each task type. This portlet pulls data from the timeslices.  Using this portlet, management can determine if excess time is being spent on a certain task stage within a project.
  • The Time By Type - Pie Chart portlet is a graphical representation of time by type of investment for all resources the logged in user has security rights to view. This portlet pulls from the daily timeslices, and can be used for determining what types of projects receive the majority of hours.  The filter option allows for entry of a specific start date and finish date.
  • The Auto-Approve Old Timesheets workflow process can be run through the "Execute a Process" job and may be used to quickly close out timesheets for a specified timeframe for period closure.  The workflow will execute a query that will automatically approve ALL (no matter the status of the timesheet) timesheets that have a time period start date before the Approve Date specified within the process itself.
  • The Time by Task portlet displays time logged to tasks for all investments the logged in user has security rights to view - pulling data from the timeslices. It is capable of displaying the data by weekly, monthly, quarterly or annually segments. The portlet may also be filtered by investment and resource OBS.
  • The Time By Resource and Investment - PM portlet shows time spent on projects where the logged in user is the project manager.  This portlet is used to get a snapshot of investments and the time that has been put against them at the individual resource level for the projects that user has access to. This portlet is used for determining what resources have put time against specific investments and can be used to see where resources are spending their time or to help rationalize ETCs for remaining work for planning purposes. The portlet may be filtered by time-scale, date, resource or investment to narrow the search results.
  • The Time By Resource and Investment - PM portlet shows time spent on projects where the logged in user is the project manager.  This portlet is used to get a snapshot of investments and the time that has been put against them at the individual resource level for the projects that user has access to. This portlet is used for determining what resources have put time against specific investments and can be used to see where resources are spending their time or to help rationalize ETCs for remaining work for planning purposes. The portlet may be filtered by time-scale, date, resource or investment to narrow the search results.
  • This portlet displays the actual hours resources entered against investments. The per-period actual hours can be showed in days, weeks, months, quarters, or years. The data can be filtered by Resource, Resource Manager, OBS Unit, Investment and time period
  • This portlet displays the actual hours resources entered against investments. The per-period actual hours can be showed in days, weeks, months, quarters, or years. The data can be filtered by Resource, Resource Manager, OBS Unit, Investment and time period
  • The Time by Investment portlet displays time logged to investments for all investments the logged in user has security rights to view using data from timeslices. It is capable of displaying the data by annual, quarterly, monthly, weekly, and daily segments with totals per date also being presented. The portlet may can be filtered by investment, resource OBS, and time segments.  This portlet can be used as a management and governance tool to review aggregate hours posted to investments by time period.
  • The Time by Investment portlet displays time logged to investments for all investments the logged in user has security rights to view using data from timeslices. It is capable of displaying the data by annual, quarterly, monthly, weekly, and daily segments with totals per date also being presented. The portlet may can be filtered by investment, resource OBS, and time segments.  This portlet can be used as a management and governance tool to review aggregate hours posted to investments by time period.
  • The Time by Assignment portlet displays time logged to assignments for all investments the logged in user has security rights to view - pulling data from the timeslices. It is capable of displaying the data by weekly, monthly or quarterly segments. The portlet may also be filtered by investment and resource OBS.
  • The Missing Time by OBS portlet displays all missing or late timesheets for resources staffed within a specific OBS.   Resources will be included if they are open for time entry, have the track mode of ‘Clarity’ and have a timesheet that is not posted. The portlet accommodates for hire and termination dates.  Also, the portlet only shows resources that the active user has the security rights to view. Administrators and the Project Management Office may use this portlet to determine the timesheet status of all resources within a specific OBS in open time periods. This portlet allows a user to quickly search by OBS and view all timesheets under that area. After selecting the OBS, the user can also filter on time period start date, Resource Manager and/or Project Manager. The portlet will display a ‘Stop Light’ indicator based on timesheet status, the status, period start, Resource Name, Resource Manager and any actual hours entered for the timesheet.
  • The Adjusted Timesheet Stalker process is designed to be run via a scheduled job. The end user will need to set up the job and can choose the frequency at which this job should be run. The process will search the system for timesheets with a status of ‘Adjusted’. An email is sent to the resource manager for any resources identified as having adjusted timesheets. The email will provide: • Name of resource • Time period The resource manager is advised that once the timesheet is resubmitted, they will need to approve it. A link to the timesheet itself is provided in the body of the email.
  • The Adjusted Timesheet Stalker process is designed to be run via a scheduled job. The end user will need to set up the job and can choose the frequency at which this job should be run. The process will search the system for timesheets with a status of ‘Adjusted’. An email is sent to the resource manager for any resources identified as having adjusted timesheets. The email will provide: • Name of resource • Time period The resource manager is advised that once the timesheet is resubmitted, they will need to approve it. A link to the timesheet itself is provided in the body of the email.  
  • This portlet displays Actual Time by Project over a span of time.  It supports Annual, Quarterly, Monthly, and Weekly time periods.  The time span displayed is controlled by a filter field for the Start Date (of the time span) and by a filter field for the Number of Time Periods to be displayed. There are also filters for Project name, Project Manager, and Project Type.
  • This portlet displays Actual Time by Project over a span of time.  It supports Annual, Quarterly, Monthly, and Weekly time periods.  The time span displayed is controlled by a filter field for the Start Date (of the time span) and by a filter field for the Number of Time Periods to be displayed. There are also filters for Project name, Project Manager, and Project Type.
  • Portlet to show the stage of any Action Item triggered by Timesheet submission.  Portlet allows for a period start date input, filters by Resource, Approver, Action Item Status and Timesheet Status.  A link to the action item is provided for direct action by review if needed. This portlet is only for the clients who have established a process that triggers on Timesheet Status change to Submitted and to send Action Items to the person responsible for timesheet approval/validation i.e. PM for project tracking and/or RM for overall approval of the timesheet. The portlet won’t display any data if there are no timesheet Action Items.  Examples of such processes would be CA’s OOTB Project Manager Approval or the Timesheet Approval - PM and RM process found on 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.
Go to Top