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.
