Capacity Dataset PS Cloud Analytics Output Fields

The Capacity dataset includes fields from the Utilization Detail object in PSA as well as other associated objects. The fields are:

Key: H - Hidden field

Capacity Fields

Field Type

Field

 

Description
Measures Total Capacity Hours  

If the Total Capacity type equals Remaining or Scheduled, this field can be one of the following fields derived from the Utilization Detail or Utilization Summary objects:

  • Scheduled Credited Hours
  • Scheduled Billable Hours
  • Scheduled Billable Hours
  • Scheduled Excluded Hours
  • Scheduled Held Hours
  • Scheduled Non-Billable Hours

This field can also be calculated as:

Total Capacity Hours = Scheduled Calendar Hours - (Scheduled Billable Hours + Scheduled Credited Hours + Scheduled Excluded Hours + Scheduled Held Hours + Scheduled Non-Billable Hours)

Else, this field equals 0.
Total Requested Hours   This field is the value of the Unheld Hours in the Utilization Summary object if the capacity type is Requested. Else, this field value is 0.
Utilization Record Type   This field enables you filter by records derived from either the Utilization Summary object or the Utilization Detail object.
  Total Weighted Requested Hours   This field is the value of the Unheld Hours Opp Pct field in the Utilization Summary object if the capacity type is Requested. Else, this field value is 0.
  Total Weighted Capacity Hours  

This field is identical to the Total Capacity Hours measure except it uses weighted fields from Utilization records where applicable, and recalculates Remaining accordingly.

The field uses values derived from the Held Hours Opp Pct Weighted field in the Utilization Summary object if the capacity subtype is Scheduled Held. If the value of this field is null, then the value of the unweighted Scheduled Held field is used instead. When this measure is calculated, the value of all other non-weighted fields are added from the Total Capacity Hours measure:
Scheduled Non-Billable, Scheduled Credited, Scheduled Billable.

The value of the subtype Remaining in the Total Capacity Hours measure is then recalculated to reflect the value of the weighted Scheduled Held field. For example:

Capacity Type

Capacity Subtype

Sum of Total Capacity Hours

Sum of Total Weighted Capacity Hours

Sum of Total Requested Hours

Sum of Total Weighted Requested Hours
Total   4,619,465 4,619,465.00 46,208.99 33,000.00
Remaining Remaining 1,987,908.79 1,990,188.79 0 0
Subtotal 1,987,908.79 1,990,188.80 0 0
Requested Unheld Hours 0 0 46,208.99 33,000.00
Subtotal 0   46,208.99 33,000.00
Scheduled Scheduled Billable 2,585,326.83 2,585,326.83 0 0
Scheduled Credited 40 40 0 0
  Scheduled Non-Billable 38,409.37 38,409.37 0 0
  Scheduled Held 7,780 5,500.00 0 0
  Subtotal 2,631,556.20 2,629,276.20 0 0
  Subtotal       33,000.00
Dates Utilization End Date   This is the value of the Utilization Detail object Scheduled End Date field.
Dimensions Time Period Type   This is the time period for the Utilization detail object. By default the values of this field are: Week, Month, Quarter, and Year.

Capacity Type

   This is the type of capacity. It varies in function of the data, it can be either the Scheduled Hours, the Requested Hours, or the Remaining Capacity.
Capacity Subtype  

This is the subtype of capacity. It varies in function of the capacity type.

Scheduled Hours subtypes:

  • Scheduled Credited Hours
  • Scheduled Billable Hours
  • Scheduled Excluded Hours
  • Scheduled Held Hours
  • Scheduled Non-Billable Hours

Remaining Capacity subtypes:

  • Remaining Capacity

Requested Hours subtypes:

  • Held Hours
  • Unheld Hours
Resource ID   The identification number of the resource.
Resource Name   The name of the resource.
Resource Role   The role assigned to the resource.
Resource Skills   This multi-value field is used to store skills, certifications, and their categories data associated with the resource.
Salesforce Resource User ID   The identification number of the Salesforce User contact.
Salesforce Resource User Name   The name of the Salesforce User contact.
Salesforce Resource User Photo URL   The URL of the Salesforce User contact photo.
Group ID   The identification number of the group related to the contact.
Group Name   The concatenation between the RPG levels of the group related to the contact.
Group Level XX   The RPG level of the group related to the contact, where XX is a number between 00 and 12. Level 00 represents the highest RPG level of the group related to the contact.
Practice ID   The identification number of the practice related to the contact.
Practice Name   The concatenation between the RPG levels of the practice related to the contact.
Practice Level XX   The RPG level of the practice related to the contact, where XX is a number between 00 and 12. Level 00 represents the highest RPG level of the practice related to the contact.
Region ID   The identification number of the region related to the contact.
Region Name   The concatenation between the RPG levels of the region related to the contact.
Region Level XX   The RPG level of the region related to the contact, where XX is a number between 00 and 12. Level 00 represents the highest RPG level of the region related to the contact.
Region/Practice/Group Hierarchy Depth   Depending on the calculation this value can be the RPG hierarchy level of the region, practice, or group related to the calculation.
RHierarchyDepth H Depending on the calculation this value can be the RPG hierarchy level of the region related to the calculation.
PHierarchyDepth H Depending on the calculation this value can be the RPG hierarchy level of the practice related to the calculation.
GHierarchyDepth H Depending on the calculation this value can be the RPG hierarchy level of the group related to the calculation.
Region/Practice/Group Type  

Depending on the calculation this value can be the RPG type of the records related to the calculation. The possible types are:

  • Region
  • Practice
  • Group