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.