Skip to main content
Planview Customer Success Center

RES12 - Resource Pending Timesheets

Overview

Resource portfolio based exception report that lists all resources with timesheets that are overdue, rejected or requiring approval.

           

RES12.jpg

RES12 Resource Pending Timesheets example

           

           

RES12b.jpg

RES12 Resource Pending Timesheets example

           

           

Business Outcomes

  • Drive effective work planning and resource management processes by monitoring and driving towards timely timesheet submission and approval.
  • Measure effectiveness of the feedback and reforecasting process that is driven by timesheet actuals.

           

           

Supporting Capabilities

  • Time Reporting

           

           

Administration: User Parameter Configuration

Parameters Description Configuration Options Default/Example Settings
Start/Finish Interval start/end date The default range selection will always be the periods between cutoff and today.

The list of periods can be modified directly in the user parameter section of the report to include additional periods prior to cutoff or periods in the future.
Defaults cannot be modified
Timesheet Status Status(es) to consider This is a multi select parameter. Values are:
  • Missing
  • Entered
  • Disapproved
  • Signed
  • Approved
  • Progressed
There is an entry for each value:
  • Timesheet_status=M
  • Timesheet_status=E
  • Timesheet_status=D
  • Timesheet_status=S
  • Timesheet_status=A
  • Timesheet_status=P

           

           

Administration: Hidden Parameter Configuration

Parameters Description Configuration Options Default/Example Settings
Table Columns 6 columns can be displayed before the detailed tables in this report. Only one required column (if only one column - it should be resource_description) obs_level_2_res
obs_level_3_res
resource_description
cbs1_res
obs30_res
Default Start/End Dates Parameter that controls the default start and end dates of the time periods returned. Option for modifying the default dates applied to the Start/End time periods are controlled with the following syntaxes:
  • ts_range_past=n
Where n is the number of weeks earlier than cutoff to include.
  • ts_range_future=n
Where n is the number of additional weeks beyond today to include.
Default values are:
  • ts_range_past=0
  • ts_range_future=0
Report Title Configurable report title that appears at the top of the report. If a longer report title is required, then create additional report_title=xxx entries and these will be concatenated together based on the order in which they are listed in the configuration structure.  report_title=Pending Timesheets - By Resource

           

           

Additional Information

  • The report shows the number of timesheets with anomalies for each resource in the portfolio.
  • User defines a specified interval of time reporting periods for analysis.
  • Two columns are available for displaying resource attributes.
  • NOTE – this report does not recognized effectivity dates on resource attributes. Any attributes configured for display will show the CURRENT value of the attribute, not the value in place for the tie reporting period.

           

           

Technical/Database Information

Report (RDL) Location …/Reports/RPM/Resources_RPM/RPM-RES12/RPM-RES12_v2.rdl
Database This report uses the transactional database and updates will be real-time.