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.