Previous Topic: Resource Assignments Report

Next Topic: Timesheet Detail Report


Resource by Role Description Report

Description

This report displays the following information:

Run the report to work with resources.

See the Resource Management User Guide for more information.

Prerequisites
Parameters
Period Type

Indicates if the weekly or monthly period type requires reporting.

Resource Manager

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

Resource OBS

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

Role

Indicates the roles for which the report is generated. Click the Browse icon and select roles.

Starting Period

Defines the start date of 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 such as Start of Next Month, select the Relative Date option. Then, select the relative date from the drop-down list.

Report Fields
Alloc

Displays the percentage of the capacity hours allocated.

Database Tables and Columns:

prj_blb_slices.slice for request_name = dailyresourcealloccurve.

Avail

Displays the available capacity remaining.

Calculation: (Capacity Hours - Allocation Hours).

Database Tables and Columns:

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

Cap

Displays the capacity available in hours.

Database Tables and Columns:

prj_blb_slices.slice for request_name = dailyresourceavailcurve.

Investment

Displays the name of the investment to generate the report.

Database Tables and Columns:

prteam.prprojectid

Role

Displays the project role a resource performs.

Database Tables and Columns:

prteam.prroleid

OBS

Displays the organizational breakdown structure for the projects on the report.

Database Tables and Columns:

nbi_dim_obs.obs_unit_id

Resource Name

Displays the resource being reported.

Database Tables and Columns:

nbi_resource_facts.full_name