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 to work with the following:

• Resource Management to oversee a resource time

  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

• Set up resources and assign a track mode of "Time". Resources require entering hours worked into their timesheet in CA Clarity PPM for the time period specified.
• To use the OBS Unit parameter to filter the report, add at least one OBS to the system. In addition, assign an OBS unit 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. Then, select the relative date from the drop-down list.

Resource OBS

Indicates the OBS unit to filter the report. Click the Browse icon and select the OBS from the list.

Project Manager

Indicates the managers whose projects require reporting.

Resource Name

Indicates the names of the resources to include on the report.

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. Then, select the relative date from the drop-down list.

Report Fields

Hours

Displays in hours that a resource works.

Database Tables and Columns:

prj_blb_slices.slice

Manager

Displays the name of the manager whose projects are being reported.

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 to generate a report.

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.

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.

Database Tables and Columns:

prtask.prname

Time Period

Displays the reporting time period with missed time for the resource. It indicates the start and end dates of the time period.

Database Tables and Columns:

prtimeperiod.prstart

prtimeperiod.prfinish - 1