Clarity: Which database tables and columns are used to generate the Resource by Role Description Report?

Document ID : KB000050830
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

Clarity's stock reports are documented in the Common Features and Personal Options User Guide for each version. This document as well as others can be downloaded from support.ca.com.

Solution:

The following columns and tables are used to generate the Resource by Role Description Report.

Report Fields

Allocation:
Displays the percentage of the capacity hours that have been allocated.
Database Tables and Columns:
prj_blb_slices.slice for request_name = dailyresourcealloccurve.

Availability:
Displays the available capacity remaining.
Calculation: (Capacity Hours - Allocation Hours).
Database Tables and Columns:
This is a calculated field. For more information, see the report's SQL statement.

Capacity:
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 being reported on.
Database Tables and Columns:
prteam.prprojectid

Role:
Displays the primary role being reported on.
Database Tables and Columns:
srm_resources.last_name where prprimaryroleid of the resource name equals srm_resources.id.

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 on.
Database Tables and Columns:
nbi_resource_facts.full_name