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