Crystal Reports Stock Report Descriptions › Missing Time Report

Missing Time Report

Description

This report lists all resources who have submitted less time than the available hours on their calendar during a specified time period. Also, reports the resources not provided timesheet hours.

Run the report to work with resource management.

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

Prerequisites

• Resources assigned a calendar.
• To use the OBS Unit parameter to filter, add at least one OBS to the system. In addition, assign an OBS unit to the programs or projects.

Parameters

Group By

Indicates the grouping and presenting of information on the report. Select an option from the drop-down.

OBS Unit

Indicates the OBS unit by which the report is filtered.

Resource Manager

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

Resource Type

Indicates the category of resource to generate the report. You can select multiple categories.

Status

Indicates the status of resource timesheets to include on the report. You can select multiple statuses.

Time Period

Defines the time period date range to filter the report. To define a Specific Date, click the Select Date icon, or a Time Period relative to the current date from the drop-down.

If you enter a date as a parameter, the application scans all the time periods to find and assign the time period accordingly.

Charts

Two pie charts indicate the following:

• The number of resources that completed time entry, had partial entry, or had no time entry.
• The actual hours entered compared against the missing hours.

Report Fields

Actual

Displays the number of hours the resource charged during the reporting time period.

Database Tables and Columns:

prtimeentry.practsum

Available

Displays the number of chargeable hours available for the resource during the reporting time period.

Database Tables and Columns:

nbi_resource_facts.available_hours

Email

Displays the email address of the resource.

Database Tables and Columns:

srm_resources.email

Missing

Displays the number of missing (uncharged) hours for the resource.

Calculation: Available - Actual

Database Tables and Columns:

A calculated field. For more information, see the report SQL statement.

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

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