Share this page

# RSC_STAFFING_PROFILES

The RSC_STAFFING_PROFILES table stores the details of staffing profile, such as the resource pool it is associated with and its period.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KCST_BUDGETS | BUDGET_ID | BUDGET_ID
KNTA_USERS | USER_ID | CREATED_BY
KNTA_USERS | USER_ID | LAST_UPDATED_BY
KNTA_REGIONS_NLS | REGION_ID | REGION_ID
RSC_RESOURCE_POOLS | RESOURCE_POOL_ID | RESOURCE_POOL_ID
ITG_SECURABLE_ENTITIES | SECURABLE_ENTITY_ID | SECURABLE_ENTITY_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
STAFFING_PROFILE_ID | NOT NULL | NUMBER | System-generated identifier
VERSION | NOT NULL | NUMBER | System-generated version for the entity. This column must not be updated manually
STATUS_CODE | NULLABLE | NUMBER | Indicates the status of the staffing profile that is decoded by the application. The status_code meaning includes: In Planning, Active, and Completed.
STAFFING_PROFILE_NAME | NOT NULL | VARCHAR2(300) | User entered name for this staffing profile.
BUDGET_ID | NULLABLE | NUMBER | The budget with which the staffing profile can be synchronized.
IS_SYNCH_BUDGET | NULLABLE | VARCHAR2(1) | Specifies if the staffing profile is synchronized with the selected budget or no. The values could be 'Y' or 'N'
DESCRIPTION | NULLABLE | VARCHAR2(650) | User entered description for this staffing profile.
USER_DATA1-20 | NULLABLE | VARCHAR2(255) | User data segment
VISIBLE_USER_DATA1-20 | NULLABLE | VARCHAR2(255) | User data segment
DEFAULT_VIEW_EFFORT_TYPE_CODE | NULLABLE | NUMBER | User preferred effort type (FTE, month, Person Days) to view position's demand.
IS_ACTIVE_FLAG | NULLABLE | VARCHAR2(1) | Used to say if the staffing profile is active or not. Used mainly when a baseline is created and the flag is set to 'N'
START_DATE | NULLABLE | DATE | The start date of this staffing profile.
FINISH_DATE | NULLABLE | DATE | The finish date of this staffing profile.
REGION_ID | NULLABLE | NUMBER | Region with which this staffing profile is associated with.
RESOURCE_POOL_ID | NULLABLE | NUMBER | The resource pool associated to this staffing profile. Positions inherit this resource pool by default but can be overridden.
IS_CONSIDERED_WORKLOAD_FLAG | NULLABLE | VARCHAR2(1) | A flag to indicate if this staffing profile should show as workload. Values could be 'Y' or 'N'
SECURABLE_ENTITY_ID | NULLABLE | NUMBER | This is a foreign key to ITG_SECURABLE_ENTITIES table.
WORK_LOAD_CATEGORY_CODE | NULLABLE | VARCHAR2(255) | Indicates what this staffing profile is used for, such as Strategic Projects and Legacy systems.
CONTAINER_ENTITY_ID | NULLABLE | NUMBER | Foreign key to one of the container entity tables. This depends on the container_entity_type column.
CONTAINER_ENTITY_TYPE_CODE | NULLABLE | NUMBER | Specifies if this staffing profile is for project or org_unit or asset or freestanding, and so on. The entity type is decoded by the application.
CREATED_BY | NOT NULL | NUMBER | Identifier for the user who created the record
CREATION_DATE | NOT NULL | DATE | Date record was created
LAST_UPDATED_BY | NOT NULL | NUMBER | Identifier for the user who last updated the record
LAST_UPDATE_DATE | NOT NULL | DATE | Date record was last updated
DEF_VIEW_PERIOD_TYPE | NULLABLE | NUMBER | Indicates the default period type while viewing the staffing profile
PARENT_STAFFING_PROFILE_ID | NULLABLE | NUMBER(19) | Staffing profile ID from which it is baselined This column is not used in PPM and can be safely ignored.
IS_SENSITIVE_FLAG | NOT NULL | VARCHAR2(1) | Flag to indicate if the position of this staffing profile is searchable in Position Finder This column is not used in PPM and can be safely ignored.
EIDT_MODE | NOT NULL | VARCHAR2(1) | A flag to indicate under which view can effort be edited

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
FKDF4ACDCA388F3C_I | NONUNIQUE | 1 | SECURABLE_ENTITY_ID
FKDF4ACDCA505BB933_I | NONUNIQUE | 1 | REGION_ID
FKDF4ACDCAA85CA660_I | NONUNIQUE | 1 | RESOURCE_POOL_ID
RSC_STAFFING_PROFILES_N1 | NONUNIQUE | 1 | CONTAINER_ENTITY_ID
RSC_STAFFING_PROFILES_N1 | NONUNIQUE | 2 | CONTAINER_ENTITY_TYPE_CODE
SYS_C00109354631 | UNIQUE | 1 | STAFFING_PROFILE_NAME
SYS_C00109356183 | UNIQUE | 1 | STAFFING_PROFILE_ID

## Sequences

Sequence Name | Sequence Type
--- | ---
RSC_STAFFING_PROFILES_S | STAFFING_PROFILE_ID

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: