Crystal Reports › Resource Forecasted Utilization Detail Report

Resource Forecasted Utilization Detail Report

Description

This report is similar to the Resource Forecasted Utilization report, except that it adds a detailed schedule for a resource. In addition, it includes a list of the various investments and project tasks to which a resource is assigned and allocated. The report displays a detailed forecasted utilization for specific resources based on the requested start and end date parameters.

For each period ending (start date and end date), the provided totals for available, allocated, and assigned hours.

Prerequisites

• All investments (approved or unapproved) must be in active status.
• Actual timesheet data must exist in the system.
• Allocate and assign resources to specific active investments.
• Define charge codes for all active projects.
• Define financial properties for active projects.

See the Project Management User Guide for more information.

Parameters

OBS Unit

Indicates the OBS unit to filter the report.

Report Name

Indicates the names of the report.

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.

Start Date

Indicates the start date for the report.

End Date

Indicates the end date for the report.

Report Fields

Project ID

Displays the unique ID of the project for the associated resource.

Database Tables and Columns:

nbi_project_res_task_facts.project_id

Investment Name

Displays the investment name for the associated resource.

Database Tables and Columns:

nbi_project_current_facts.project_name

Task Name

Displays the task name for the associated resource.

Database Tables and Columns:

nbi_project_res_task_facts.task_description

Charge Code

Displays the charge code for the investment for the associated resource.

Database Tables and Columns:

nbi_project_res_task_facts.charge_code

Bill Rate

Displays the billing rate for the investment for the associated resource.

Database Tables and Columns:

nbi_project_res_task_facts.billable_rate

Allocated Hours

Displays the number of allocated hours for the associated resource.

Database Tables and Columns:

nbi_project_res_task_facts.allocated_qty

Assigned Hours

Displays the number of assigned hours for the associated resource.

Database Tables and Columns:

nbi_project_res_task_facts.etc_qty

nbi_project_res_task_facts.actual_qty

Resource Name

Displays the full name of the resource.

Database Tables and Columns:

nbi_resource_facrs.last_name

nbi_resource_facts.first_name

Period Ending

Displays the period ending date based on whether the timesheet period is set as monthly or weekly.

More information:

Access to Crystal Reports