RSC_STAFFING_PROFILES

RSC_STAFFING_PROFILES stores the details of staffing profile, the resource pool it is associated with, the budget, its period, and so on.

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. Examples of status_code meaning: In Planning, Active, Completed, and so on

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 - Strategic Projects, Legacy systems, and so on

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