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 |
