Crystal Reports › 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.

Use this report if you work with the following:

• Resource Management to oversee time for a resource.

  See the Resource Management User Guide for more information.

• Project management

  See the Project Management User Guide for more information.

• Financial management

  See the Financial Management User Guide for more information.

• Service management

  See the IT Service Management User Guide for more information.

• Demand management

  See the Demand Management User Guide for more information.

• Portfolio management

  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. In addition, an OBS unit must be assigned to the programs or projects.

Parameters

Report Name

Indicates the names of the report.

From Period

Defines the beginning of the effective date range for the report. To select a specific end date, select the Specific Date option. Then, type a date in the text field (mm/dd/yyyy format) or click the Date Picker to select a day from the calendar. 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.

To Period

Defines the end of the effective date range for the report. To select a specific day, select the Specific Date option. Then, type a date in the text field (mm/dd/yyyy format) or click the Date Picker to select a day from the calendar. 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 filters the report. Click the Browse icon and select OBS from the list that appears.

Resource Manager

Identifies the resource manager whose data displays in the report. Click the Browse icon to select names.

Resource Name

Indicates the names of the resource that the report provides data about. Click the Browse icon and select names from the list that appears.

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 projects are being reported on.

Database Tables and Columns:

nbi_project_current_facts.manager_last_name

nbi_project_current_facts.manager_first_name

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 project being reported on.

Database Tables and Columns:

nbi_project_current_facts. project_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. This field indicates the start and end dates of the time period.

Database Tables and Columns:

prtimeperiod.prstart

prtimeperiod.prfinish - 1