RSC_POSITIONS

This table stores the line items - positions of a staffing profile. These are the items used to forecast the resource demand and request them from the resource pools.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

RSC_RESOURCE_POOLS

RESOURCE_POOL_ID

RESOURCE_POOL_ID

RSC_STAFFING_PROFILES

STAFFING_PROFILE_ID

STAFFING_PROFILE_ID

Column Descriptions

Column Name

Null?

Data Type

Description

POSITION_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 Position's status. It is a code and it is then decoded in the application to meaningful words.

VIEW_EFFORT_TYPE

NULLABLE

NUMBER

Indicates the user's preference for effort type to view the positions demands.

ASK_DATE

NULLABLE

DATE

Indicates the date when a position's demand is requested.

If the position has not sent resource request yet, the date is the position's creation date.

NEED_BY_DATE

NULLABLE

DATE

This is the date mentioned for the position's response needed by date.

REQUESTED_BY

NULLABLE

NUMBER

User who sent the position's unmet demand request.

RESOURCE_TYPE_CODE

NULLABLE

VARCHAR2(255)

Indicates the type of resource needed by this position. For example, Full time, Part time, Contractor, and so on

RESOURCE_POOL_ID

NULLABLE

NUMBER

Indicates the resource pool from which the position's demand for resources is assigned from. It is a foreign key to RSC_RESOURCE_POOLS table.

POSITION_NAME

NULLABLE

VARCHAR2(255)

Indicates the user entered name to the position.

ROLE_ID

NOT NULL

NUMBER

The role this position needs to be filled by. This is a foreign key to the rsc_roles table.

STAFFING_PROFILE_ID

NULLABLE

NUMBER

Indicates the staffing profile this position belongs to. It is a foreign key to the RSC_STAFFING_PROFILES table.

USER_DATA1-100

NULLABLE

VARCHAR2(255)

User data segment

VISIBLE_USER_DATA1-100

NULLABLE

VARCHAR2(255)

User data segment

POSITION_COMMENT

NULLABLE

VARCHAR2(2000)

The text entered by the user who created/updated this position.

EXPENSE_TYPE

NULLABLE

VARCHAR2(255)

Indicates the selection user made between capex or opex or both.

CAPITAL_RATIO

NULLABLE

NUMBER

Indicates the ratio between capital and operating cost. Filled in when both the expense types are selected in expense_type column.

LABOR_CATEGORY

NULLABLE

VARCHAR2(255)

Labor category. For example, Employee, Contractor, and so on

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

STAFFING_PROFILE_SEQ

NULLABLE

NUMBER

The sequence entered as the position is created. This is used to display the positions in the order they were created.

DEF_VIEW_PERIOD_TYPE

NULLABLE

NUMBER

Default value of fiscal period type

RESOURCES_REQUESTED

NULLABLE

VARCHAR2(200)

The specific resource this position would like to be filled by

START_DATE

NULLABLE

DATE

Restricted - Internal Use

FINISH_DATE

NULLABLE

DATE

Restricted - Internal Use

SIMPLE_ASK_FORECAST

NULLABLE

NUMBER

Restricted - Internal Use

SIMPLE_ASK_READY NULLABLE Varchar2(1) Flags whether or not the system converts data if the position is displayed in the Gantt view. By defalut, the value is N, meaning the system will perform data conversion.
PARENT_POSITION_ID NULLABLE NUMBER This column is not used in PPM and can be safely ignored.
FORECAST_STATUS NULLABLE NUMBER This column is not used in PPM and can be safely ignored.

Indexes

Index Name

Index Type

Sequence

Column Name

FK4C98D6AD1C1523B3_I

NONUNIQUE

1

REQUESTED_BY

FK4C98D6AD26AE1775_I

NONUNIQUE

1

ROLE_ID

FK4C98D6AD3F9006BA_I

NONUNIQUE

1

STAFFING_PROFILE_ID

FK4C98D6ADA85CA660_I

NONUNIQUE

1

RESOURCE_POOL_ID

RSC_POSITIONS_N1

NONUNIQUE

1

POSITION_NAME

SYS_C005201574

UNIQUE

1

POSITION_ID

Sequences

Sequence Name

Sequence Type

RSC_POSITIONS_S

POSITION_ID