Share this page

# RPT_DIM_RM_TEAMS

This is a materialized view and stores the team related information.

## Foreign Keys

This table does not have any foreign keys.

## Column Descriptions

ColumnName | Null? | Data Type | Description
--- | --- | --- | ---
RANK | NULLABLE | NUMBER | Specifies the level of this resource pool in the hierarchy. The rank starts with number 1 being the root.
RESOURCE_POOL_ID | NULLABLE | NUMBER (19) | ID derived from the PPM RSC_RESOURCE_POOLS table.
TEAM_ID | NULLABLE | NUMBER (19) | ID of the team
TEAM_NAME | NULLABLE | VARCHAR2 (260 Char) | Name of the team
TEAM_TYPE | NULLABLE | VARCHAR2 (200 Char) | Type of the team
TEAM_ROLE | NULLABLE | VARCHAR2 (200 Char) | Specialty of the team
ORG_UNIT_ID | NULLABLE | NUMBER (19) | ID of the org unit this resource pool is tied to. In the original PPM table, this represents a foreign key to the KRSC_ORG_UNIT table.
REGION_ID | NULLABLE | NUMBER (19) | ID of the region this resource pool is tied to. In the original PPM table, this represents a foreign key to the KNTA_REGIONS table.
DIRECT_PARENT_TEAM_NAME | NULLABLE | VARCHAR2 (4000 Char) | ID of the immediate parent team
PARENT_TEAM_ID1 | NULLABLE | VARCHAR2 (4000 Char) | ID of the parent team in the hierarchy level 1 or rank 1
PARENT_TEAM_NAME1 | NULLABLE | VARCHAR2 (4000 Char) | Name of the parent team in the hierarchy level 1 or rank 1
PARENT_TEAM_ID2 | NULLABLE | VARCHAR2 (4000 Char) | ID of the parent team in the hierarchy level 2 or rank 2
PARENT_TEAM_NAME2 | NULLABLE | VARCHAR2 (4000 Char) | Name of the parent team in the hierarchy level 2 or rank 2
PARENT_TEAM_ID3 | NULLABLE | VARCHAR2 (4000 Char) | ID of the parent team in the hierarchy level 3 or rank 3
PARENT_TEAM_NAME3 | NULLABLE | VARCHAR2 (4000 Char) | Name of the parent team in the hierarchy level 3 or rank 3
PARENT_TEAM_ID4 | NULLABLE | VARCHAR2 (4000 Char) | ID of the parent team in the hierarchy level 4 or rank 4
PARENT_TEAM_NAME4 | NULLABLE | VARCHAR2 (4000 Char) | Name of the parent team in the hierarchy level 4 or rank 4
PARENT_TEAM_ID5 | NULLABLE | VARCHAR2 (4000 Char) | ID of the parent team in the hierarchy,level 5 or rank 5
PARENT_TEAM_NAME5 | NULLABLE | VARCHAR2 (4000 Char) | Name of the parent team in the hierarchy level 5 or rank 5
PARENT_TEAM_ID6 | NULLABLE | VARCHAR2 (4000 Char) | ID of the parent team in the hierarchy level 6 or rank 6
PARENT_TEAM_NAME6 | NULLABLE | VARCHAR2 (4000 Char) | Name of the parent team in the hierarchy level 6 or rank 6
PARENT_TEAM_ID7 | NULLABLE | VARCHAR2 (4000 Char) | ID of the parent team in the hierarchy level 7 or rank 7
PARENT_TEAM_NAME7 | NULLABLE | VARCHAR2 (4000 Char) | Name of the parent team in the hierarchy level 7 or rank7
PARENT_TEAM_ID8 | NULLABLE | VARCHAR2 (4000 Char) | ID of the parent team in the hierarchy level 8 or rank 8
PARENT_TEAM_NAME8 | NULLABLE | VARCHAR2 (4000 Char) | Name of the parent team in the hierarchy level 8 or rank 8
PARENT_TEAM_ID9 | NULLABLE | VARCHAR2 (4000 Char) | ID of the parent team in the hierarchy level 9 or rank9
PARENT_TEAM_NAME9 | NULLABLE | VARCHAR2 (4000 Char) | Name of the parent team in the hierarchy level 9 or rank 9
PARENT_TEAM_ID10 | NULLABLE | VARCHAR2 (4000 Char) | ID of the parent team in the hierarchy level 10 or rank 10
PARENT_TEAM_NAME10 | NULLABLE | VARCHAR2 (4000 Char) | Name of the parent team in the hierarchy level 10 or rank 10

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
RPT_DIM_RM_TEAMS_N40 | NONUNIQUE | 1 | TEAM_ID

## Sequences

This table uses no sequences.

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: