| Column Label | Description |
| Resource Name | Name of the resource |
| Resource ID | ID of the resource |
| Type | Object or Portlet |
| Portlet Code | ID of the portlet |
| Portlet Name | Name of the portlet |
| Object | Associated Object |
| Object View | ID of the modified view on the object |
| Object Code | Internal code used by the query |
| pkid | Internal code used by the query |
| portlet_dbid | Database id of the portlet |
| res_dbid | Database id of the resource |
-
The Customized Object/Portlet Views portlet displays all user edited object/portlet views and the resource(s) that have edited them. This can assist in identifying users who need to be notified prior to publishing view changes. The table below describes the available columns on the object. -
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 Invalid Transactions portlet displays all of the transactions that did/will not post in Clarity. The benefit of this portlet is that you can use the filter to select a specific project, resource, or error to display all transactions associated to your selection. There are several reasons a transaction may fail to post such as inactive resource, no location or inactive location selected on the Financial sub-page, project on hold, etc. To resolve the error, the user must go into the project or resource and make the noted change. Once all corrections are complete, the Post Transactions to Financials job must be run to evaluate the corrected WIP transactions to be sure the data is now complete and accurate. If additional incorrect data is found, the transaction will fail to post again and the new error/reason will display. -
The Invalid Transactions portlet displays all of the transactions that did/will not post in Clarity. The benefit of this portlet is that you can use the filter to select a specific project, resource, or error to display all transactions associated to your selection. There are several reasons a transaction may fail to post such as inactive resource, no location or inactive location selected on the Financial sub-page, project on hold, etc. To resolve the error, the user must go into the project or resource and make the noted change. Once all corrections are complete, the Post Transactions to Financials job must be run to evaluate the corrected WIP transactions to be sure the data is now complete and accurate. If additional incorrect data is found, the transaction will fail to post again and the new error/reason will display. -
The Missing Time by RM portlet displays all missing or late timesheets for resources for which the logged in user has resources (logged in user is the RM). Resources will be listed if they are open for time entry, have a track mode of Clarity, and have timesheet that is not posted (accommodates for hire and termination dates). Resource managers may use this portlet to determine the timesheet status of all resources in open time periods. The portlet will display an indicator based on timesheet status, the status, period start, resource name, and actual hours for the timesheet. -
The Missing Time by PM portlet displays all missing or late timesheets for resources staffed on a project where the logged in user is the project manager. Resources will be listed if they are open for time entry, have a track mode of Clarity, and have timesheet that is not posted (accommodates for hire and termination dates). Project managers may use this portlet to determine the timesheet status of resources staffed on their projects. You may narrow the results by filtering by resource manager, period start, resource name, or status. The portlet will display an indicator based on timesheet status, the status, period start, resource name, and actual hours for the timesheet. -
The Give PM Collaboration Manager Rights workflow process can be run through the "Execute a Process" job. The workflow will execute a query that gives a Project Manager the Collaboration Manager rights to their projects. Often times, PMs are not set as Collaboration Managers when the project is created. This script can be run to automatically give a PM the Collaboration Manager rights to their projects, without having to go through the projects one by one. -
The Dashboard: Change Requests portlet gives an overview of all change requests on the project. The portlet will pull the "id" from the page it is placed on, so this portlet is usually placed on the project dashboard tab. The portlet sorts the issues first by priority and then by target date. It displays the name, owner, status, target date, approved by, and the priority. -
A review of how Northern Trust integrates financial systems with Clarity PPM bilaterally, providing the Finance organization crucial information, and NT Project Managers with a birds-eye view of project financials. Utilizing the Rego Data Extractor and the Rego Data Processor, these information exchanges help Portfolio and Project Managers eliminate their manual and redundant efforts, solidify their overall data accuracy, and dramatically improve the content provided to their Execs for decision-making.

