RPT_DIM_RM_STAFF_PROFILES

This is a materialized view that contains information from PPM's RSC_STAFFING_PROFILES table.

Foreign Keys

This table does not have any foreign keys.

Column Descriptions

Column Name

Null?

Data Type

Description

STAFFING_PROFILE_ID

NULLABLE

NUMBER

Unique identifier that determines a staffing profile and derived from PPM RSC_STAFFING_PROFILES table.

STAFFING_PROFILE_NAME

NULLABLE

VARCHAR2(300)

Name of this staffing profile

REGION_ID

NULLABLE

NUMBER

Region attached to this staffing profile

DESCRIPTION

NULLABLE

VARCHAR2(650)

Description of this staffing profile

ORG_UNIT_CONTAINER_ID

NULLABLE

NUMBER

Org_unit ID if the parent type of this staffing profile is org unit

PFM_ENTITY_CONTAINER_ID

NULLABLE

NUMBER

The PFM entity ID if the parent type of this staffing profile is PFM entity

CONTAINER_TYPE

NULLABLE

VARCHAR2(150)

Staffing profile's parent type, like org unit or Proposal, Project or Asset

CONTAINER_NAME

NULLABLE

VARCHAR2(4000)

Name of the staffing profile's parent or container

WORKLOAD_CATEGORY

NULLABLE

VARCHAR2(4000)

Workload category of this staffing profile. This represents the meaning as in lookup table.

CREATED_ON

NULLABLE

DATE

Date when this staffing profile was created

CREATED_BY

NULLABLE

VARCHAR2(200)

Identifier for the user who created the record

START_DATE

NULLABLE

DATE

Start_date of this staffing profile as mentioned in it's header

FINISH_DATE

NULLABLE

DATE

Finish date of this staffing profile as mentioned in it's header

IS_BASELINE_FLAG

NULLABLE

VARCHAR2(150)

A flag to represent if this staffing profile is a base line staffing profile

IS_CONSIDERED_WORKLOAD_FLAG

NULLABLE

VARCHAR2(150)

A flag to represent if this staffing profile is considered as workload category

STATUS_CODE

NULLABLE

NUMBER

Status code of this staffing profile

STATUS

NULLABLE

VARCHAR2(150)

Status of this staffing profile. Meaning for the above status code for this SP

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_STAFF_PROFILES_N1

NONUNIQUE

1

STAFFING_PROFILE_ID

RPT_DIM_RM_STAFF_PROFILES_N2

NONUNIQUE

1

STAFFING_PROFILE_NAME

RPT_DIM_RM_STAFF_PROFILES_N3

NONUNIQUE

1

IS_BASELINE_FLAG

Sequences

This table uses no sequences.