RPG Dataset PS Cloud Analytics Output Fields

The RPG dataset includes fields from the Region, Practice, and Group objects in PSA. The fields are:

RPG Fields

Field Type

Field

Description

  Dimension Group ID System-generated identifier of the group.
ID System-generated identifier of the region, practice or group.
ID Chain System-generated list of identifiers of all of the regions, practices, or groups listed in descending hierarchical order.
ID XX The name of the region, practice, or group. XX represents a number between 00 and 12, and determines the region, practice, or group's level in their respective hierarchies. 00 is the highest level of region, practice, or group.
Name Chain System-generated list of names of all of the regions, practices, or groups listed in descending hierarchical order.
Name Chain Ascending System-generated list of names of all of the regions, practices, or groups listed in ascending hierarchical order.
Name XX The RPG level of the region, practice or group, where XX is a number between 00 and 12. Level 00 represents the highest RPG level of the region, practice or group.
Practice ID System-generated identifier of the practice.
Region ID System-generated identifier of the region.
Type Indicates the object from which the field is derived. The function of this field varies depending on whether it is derived from region, practice, or group.
Measure Hierarchy Depth Level down in the hierarchy of the region, practice or group.