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 and resources that provided no timesheet hours at all.

Run this report if you work with resource management.

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

Prerequisites

• Resources must be assigned a calendar.
• 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

Group By

Indicates how the information is to be grouped and presented on the report. Select an option from the drop-down to show how you want the information grouped.

OBS Unit

Indicates the OBS unit by which the report is filtered.

Resource Manager

Identifies the Resource manager or managers whose data displays in the report. Click the Browse icon to select names.

Resource Type

Indicates the category of resource that is desired on the report. You can select multiple categories.

Status

Indicates the status of resource timesheets that are to be included on the report. You can select multiple statuses.

Time Period

Defines the time period date range with which to filter this report. You can define a Specific Date by clicking 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 of the time periods to find the time period where that date fits in and assigns that time period.

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 hours that the resource had available to charge 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 hours that are missing (not charged) by the resource.

Calculation: Available - Actual

Database Tables and Columns:

This is a calculated field. For more information, see the report's 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 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

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