-
Bar Chart displays average percent variance for all active projects by OBS unit. Percent variance = Planned Cost - Budgeted Cost / Budgeted Cost * 100. Projects with no Budgeted Cost are ignored for the calculation. Then all project variance percentages are algebraically added (some may be negative), and divided by total projects with a variance. This yields the Average Percent Variance. This calculation is performed for active projects in each OBS unit. OBS units include all units at all levels where projects are attached. Portlet filterable by OBS, Financial Status, and Financially Approved. Vertical axis = OBS Unit Name. Horizontal axis = Variance Percent. Data value = Average Percent Variance. Mouseover value = OBS Name + Average Variance Percent. -
The Milestone Task Dependency portlet shows the milestone task dependency count and has a drilldown to the details. The portlet looks at the dependency impact on milestones, and is not limited to just dependencies that are on different projects. The lag days calculation is based off of the maximum dependency impact and the drilldown portlet (Milestone Task Dependency Details :::: rego_milestone_dependency_det)shows the details for each. -
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). -
Grid Portlet displays project and task data--including name, dates, status, effort, %Complete, and schedule. Portlet initially displays project data. But there is a + sign toggle, which, when clicked, reveals task data, and the toggle becomes a – sign. User can choose to Automatically Expand all levels from Options Icon>Configure>List Column Section>Options. Portlet supports up to 10 levels of WBS. Portlet filterable by project name and ID, OBS structure, manager name, active/inactive, and open for time entry. -
This portlet depicts the Resource Utilization by comparing actual hours booked as a percentage of total resource availability grouped and totaled by OBS Unit in a hierarchical fashion. Resource availability is determined by the working days and daily availability on the individual Resource Calendar and is depicted on a Monthly basis. This portlet uses Monthly Times and the Time Slice job may need to run before the end user will see results in the portlet. The portlet filters for Project Activity, Resource Open for Time, Resource Activity, and Employment time have been added to OBS Type and the Start and Finish dates. The OBS summary totals show on a single line, but can be clicked (+) to roll out the details behind each OBS total. -
The portlet - Attributes on Portlets - details all attributes on every portlet in the system, whether the person viewing the list has rights to the returned portlets. The table below describes the available columns in the portlet. Column Label Description Portlet Name Name of the portlet Portlet Code ID of the portlet Field Name Name of the attribute Field Code ID of the attribute Virtual Is the attribute virtual or not id Internal code used by the query -
The portlet - Attributes on Portlets - details all attributes on every portlet in the system, whether the person viewing the list has rights to the returned portlets. The table below describes the available columns in the portlet. Column Label Description Portlet Name Name of the portlet Portlet Code ID of the portlet Field Name Name of the attribute Field Code ID of the attribute Virtual Is the attribute virtual or not id Internal code used by the query -
The Investment Resource Rate portlet allows a user to search for effective (or missing) rates for resources across all investment types. It pulls rate information from the matrix extraction tables and includes currency conversion if the environment supports multiple currencies. The portlet can be used both to search for the rate of any given resource and to determine which resources might be missing rates when an error is generated when attempting to populate a cost plan (REVMGR-20728:Rates and Costs are both missing for one or more roles/resources). -
The Timesheets by Resource portlet gives the ability to highlight the time periods where resources are working overtime or working less than 25 hours a week. The filter requires timesheet Start Date and End Date to be provided. Additionally, the information can be filtered by Resource, Resource ID, OBS Unit, Employment Type, Resource Manager, Open for Time, and Active status. This portlet displays Resource, Resource ID, Active (yes/no), Employment Type, Primary Role, Resource Manager, and Timesheet Hours Flag. The flags are set with the logic- Yellow = timesheets not posted / zero hour timesheets
- Green = where number of hours posted is > 25 and less than 45
- Red = where number of hours posted is < 25 or > 45

