Share this page

# RSC_TEAM_ASSIGNMENTS

The table stores team assignments to the positions in a staffing profile.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
RSC_RESOURCE_POOLS | RESOURCE_POOL_ID | RESOURCE_POOL_ID
RSC_POSITIONS | POSITION_ID | POSITION_ID
TEAM_TEAMS | TEAM_ID | TEAM_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
TEAM_ASSIGNMENT_ID | NOT NULL | NUMBER | ID of the team assignment
VERSION | NOT NULL | NUMBER | System-generated version for the entity.
STATUS_CODE | NULLABLE | NUMBER | Indicates the status of the staffing profile that is decoded by the application.
TEAM_ID | NULLABLE | NUMBER | ID of the team assigned to the position The team could be parent teams and subteams. It is null if a resource from the team is assigned to the position.
RESOURCE_ID | NULLABLE | NUMBER | ID of the team resource assigned to the position It is null if no team resource is assigned to the position.
POSITION_ID | NULLABLE | NUMBER | ID of the position that gets assigned
RESOURCE_POOL_ID | NULLABLE | NUMBER | If a parent team is assigned to the position, it is the ID of the position's resource pool. If a subteam or a parent team resource is assigned to the position, it is the ID of parent team's resource pool.
CREATED_BY | NOT NULL | NUMBER | ID of the user who created the record
CREATION_DATE | NOT NULL | DATE | Date when the record was created
LAST_UPDATED_BY | NOT NULL | NUMBER | ID of the user who last updated the record
LAST_UPDATE_DATE | NOT NULL | DATE | Date when the 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.
PARENT_ID | NULLABLE | NUMBER | If a subteam or a parent team resource is assigned to the position, it is the ID of the parent team assignment.
START_DATE | NULLABLE | DATE | Start date of the assignment
FINISH_DATE | NULLABLE | DATE | Finish date of the assignment
SIMPLE_ASK_ALLOCATION | NULLABLE | NUMBER | Restricted - Internal Use
SIMPLE_ASK_READY | NULLABLE | VARCHAR2(1 CHAR) | Flags whether or not the system converts data if the position 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
--- | --- | --- | ---
SYS_C00185415 | UNIQUE | 1 | TEAM_ASSIGNMENT_ID
RSC_TEAM_ASSIGNMENTS_N1 | NONUNIQUE | 1 | RESOURCE_POOL_ID
RSC_TEAM_ASSIGNMENTS_N2 | NONUNIQUE | 1 | TEAM_ID
RSC_TEAM_ASSIGNMENTS_N3 | NONUNIQUE | 1 | POSITION_ID

## Sequences

This table does not have any sequences.

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: