Share this page

# RPT_DIM_RM_POSITIONS

This is a materialized view and stores the position information for a given staffing profile.

## Foreign Keys

This table does not have any foreign keys.

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
POSITION_ID | NOT NULL | NUMBER | Unique identifier to represent this position and is derived from PPM RSC_POSTIONS table.
STAFFING_PROFILE_ID | NULLABLE | NUMBER | This is a foreign to the parent table RPT_DIM_RM_STAFF_PROFILES. Although there is no explicit foreign key constraint on this column.
RESOURCE_POOL_ID | NULLABLE | VARCHAR2(40) | The resource pool ID from which the resources are requested to fill this position.
POSITION_NAME | NULLABLE | VARCHAR2(255) | Name of this position.
ROLE_NAME | NOT NULL | VARCHAR2(260) | The role selected for this position. Note the resource assigned to this position may have a different role than the role specified on this position.
USER_DATA1-20 | NULLABLE | VARCHAR2(255) | User data segment
VISIBLE_USER_DATA1-20 | NULLABLE | VARCHAR2(255) | User data segment

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
RPT_DIM_RM_POSITIONS_N4 | NONUNIQUE | 1 | POSITION_ID
RPT_DIM_RM_POSITIONS_N5 | NONUNIQUE | 1 | POSITION_NAME

## 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: