Share this page

# RSC_RESOURCE_ASSIGNMENTS

This table stores all the assignments done for the positions in a staffing profile.

## 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_POSITIONS | POSITION_ID | POSITION_ID
RSC_RESOURCES | RESOURCE_ID | RESOURCE_ID
RSC_RESOURCE_POOLS | RESOURCE_POOL_ID | RESOURCE_POOL_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
RESOURCE_ASSIGNMENT_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 | The code that represents the status of the resource assignments. The code is decoded by the application to represent the meaning on the UI. The status of the assignment could be Soft-booked, committed, and so on
RESOURCE_ID | NULLABLE | NUMBER | This is the foreign key to RSC_RESOURCES table. The resource to whom this assignment is for.
RESPONSE_DATE | NULLABLE | DATE | Indicates the date when the first response was given to the position's request. Could be same as created date, but created date is mostly used for auditing purposes.
DEFAULT_VIEW_EFFORT_TYPE | NULLABLE | NUMBER | This is the effort type (FTE, month, person days), the end user wishes to see the data in.
POSITION_ID | NULLABLE | NUMBER | This is the foreign key to RSC_POSITIONS table, and the position to which this assignment belongs to.
RESOURCE_POOL_ID | NULLABLE | NUMBER | This is the foreign key to rsc_resource_pools table. Indicates the resource pool to which the resource for this assignment belongs to.
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
POSITION_SEQ | NULLABLE | NUMBER | This is just the sequence used to order the assignments on the UI as they were created.
DEF_VIEW_PERIOD_TYPE | NULLABLE | NUMBER | Not Used
START_DATE | NULLABLE | DATE | Restricted - Internal Use
FINISH_DATE | NULLABLE | DATE | Restricted - Internal Use
SIMPLE_ASK_ALLOCATION | NULLABLE | NUMBER | Restricted - Internal Use
SIMPLE_ASK_READY | NULLABLE | Varchar2(1) | Flags whether or not the system converts data if the assignment is displayed in the Gantt view. By default, the value is `N`, meaning the system will perform data conversion.

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
FKA1F58E72A1B1A5A3_I | NONUNIQUE | 1 | RESOURCE_ID
FKA1F58E72A85CA660_I | NONUNIQUE | 1 | RESOURCE_POOL_ID
FKA1F58E72D2FB4F95_I | NONUNIQUE | 1 | POSITION_ID
SYS_C005201577 | UNIQUE | 1 | RESOURCE_ASSIGNMENT_ID

## Sequences

Sequence Name | Sequence Type
--- | ---
RSC_RESOURCE_ASSIGNMENTS_S | RESOURCE_ASSIGNMENT_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: