Share this page

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

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: