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 |