Share this page

# 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.
REGION_ID | NULLABLE | NUMBER | Indicates the region of the position.
SHARED_RESOURCE_FLAG | NULLABLE | BOOLEAN | Added in version: 24.3 Indicates whether the position has assigned a shared resource.

## 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

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: