Crystal Reports Stock Report Descriptions › Timesheet Detail Report

Timesheet Detail Report

This report provides a listing of the hours a resource worked for a specified period based on the timesheet. Use this report to view all hours worked during certain time periods at certain regions or locations.

Run this report if you work with the following:

• Resource Management to oversee a resource’s time

  Note: See the Resource Management User Guide for more information.

• Project management

  Note: See the Project Management User Guide for more information.

• Financial management

  Note: See the Financial Management User Guide for more information.

• Service management

  Note: See the IT Service Management User Guide for more information.

• Demand management

  Note: See the Demand Management User Guide for more information.

• Portfolio management

  Note: See the Portfolio Management User Guide for more information.

Prerequisites

• Resources must be set up and assigned a track mode of "Time". Resources must have entered hours worked into their timesheet in CA Clarity PPM for the time period that is selected.
• To use the OBS Unit parameter to filter the report, at least one OBS must be added to the system and an OBS unit must be assigned to the programs or projects.

Parameters

From Period

Defines the beginning of the effective date range for the report. To select a specific end date, select the Specific Date option and type a date in the text field in the mm/dd/yyyy format or click the Date Picker to select a day from the calendar that displays. To select a relative date, select the Relative Date option and select the relative date that applies from the drop-down list for the field.

Resource OBS

Indicates the OBS unit that the report will be filtered by. Click the Browse icon and select the OBS from the list that appears.

Project Manager

Indicates the manager or managers whose projects are to appear on the report.

Resource Name

Indicates the names of the resource that the report will provide data for. Click the Browse icon and select names from the list that appears.

To Period

Defines the end of the effective date range for the report. To select a specific day, select the Specific Date option and type a date in the text field in the mm/dd/yyyy format or click the Date Picker to select a day from the calendar that displays. To select a relative date, select the Relative Date option and select the relative date that applies from the drop-down list for the field.

Report Fields

Hours

Displays in hours the time worked by a resource.

Database Tables and Columns:

prj_blb_slices.slice

Manager

Displays the name of the manager whose resources are being reported on.

Database Tables and Columns:

srm_resources.manager_id

Note Category

Displays a category for the note (for example, Project or Personal),

Database Tables and Columns:

prnote.prcategory

Note Description

Displays the contents of the note.

Database Tables and Columns:

prnote.prvalue

Project Name

Displays the name of the project being reported on.

Database Tables and Columns:

inv_investments.name

Resource ID

Displays the unique identifier for the resource.

Database Tables and Columns:

srm_resources.id

Resource Name

Displays the resource being reported on.

Database Tables and Columns:

nbi_resource_facts.full_name

Status

Displays the status of the timesheet for the reporting time period.

Database Tables and Columns:

prtimesheet.prstatus

Task Name

Displays a project task being reported on.

Database Tables and Columns:

prtask.prname

Time Period

Displays the reporting time period that has missing time for the resource. It indicates the start and end dates of the time period.

Database Tables and Columns:

prtimeperiod.prstart

prtimeperiod.prfinish - 1