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.