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 |
