Share this page
RSC_STAFF_PROF_ALLOCATION
This table stores the daily allocated and actual effort (in hours) for staffing profile resource assignments.
Foreign Keys
|
Primary Key Table |
Primary Key Column |
Foreign Key Column |
|---|---|---|
|
KNTA_USERS |
USER_ID |
LAST_UPDATED_BY |
|
RSC_STAFFING_PROFILES |
STAFFING_PROFILE_ID |
STAFFING_PROFILE_ID |
|
KNTA_USERS |
USER_ID |
CREATED_BY |
|
RSC_RESOURCES |
RESOURCE_ID |
RESOURCE_ID |
|
KNTA_I18N_RESOURCES_NLS |
RESOURCE_ID |
RESOURCE_ID |
|
RSC_POSITIONS |
POSITION_ID |
POSITION_ID |
|
RSC_RESOURCE_ROLES |
RESOURCE_ID |
RESOURCE_ID |
|
RSC_RESOURCE_ASSIGNMENTS |
RESOURCE_ASSIGNMENT_ID |
ASSIGNMENT_ID |
|
RSC_STAFF_PROF_MANAGERS |
STAFFING_PROFILE_ID |
STAFFING_PROFILE_ID |
Column Descriptions
|
Column Name |
Null? |
Data Type |
Description |
|---|---|---|---|
|
STAFF_PROF_ALLOCATION_ID |
NOT NULL |
NUMBER |
System-generated identifier |
|
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 |
|
VERSION |
NOT NULL |
NUMBER |
System-generated |
|
ASSIGNMENT_ID |
NULLABLE |
NUMBER |
Indicates the staffing profile resource assignment. |
|
POSITION_ID |
NOT NULL |
NUMBER |
Indicates the staffing profile position |
|
RESOURCE_ID |
NOT NULL |
NUMBER |
Indicates the resource for the assignment |
|
STAFFING_PROFILE_ID |
NOT NULL |
NUMBER |
Indicates the staffing profile |
|
ALLOCATION_DATE |
NOT NULL |
DATE |
Indicates the date for the allocation |
|
ALLOCATION_VALUE |
NULLABLE |
NUMBER |
Indicates the allocated effort (for the resource assignment) in hours |
|
ACTUAL_VALUE |
NULLABLE |
NUMBER |
Indicates the actual effort in hours |
Indexes
|
Index Name |
Index Type |
Sequence |
Column Name |
|---|---|---|---|
|
RSC_STAFF_PROF_ALLOCATION_N1 |
NONUNIQUE |
1 |
ASSIGNMENT_ID |
|
RSC_STAFF_PROF_ALLOCATION_N2 |
NONUNIQUE |
1 |
POSITION_ID |
|
RSC_STAFF_PROF_ALLOCATION_N3 |
NONUNIQUE |
1 |
RESOURCE_ID |
|
RSC_STAFF_PROF_ALLOCATION_N4 |
NONUNIQUE |
1 |
STAFFING_PROFILE_ID |
|
RSC_STAFF_PROF_ALLOCATION_N5 |
NONUNIQUE |
1 |
POSITION_ID |
|
RSC_STAFF_PROF_ALLOCATION_N5 |
NONUNIQUE |
2 |
ALLOCATION_DATE |
|
RSC_STAFF_PROF_ALLOCATION_N5 |
NONUNIQUE |
3 |
ASSIGNMENT_ID |
|
SYS_C005201591 |
UNIQUE |
1 |
STAFF_PROF_ALLOCATION_ID |
Sequences
|
Sequence Name |
Sequence Type |
|---|---|
|
RSC_STAFF_PROF_ALLOCATION_S |
STAFF_PROF_ALLOCATION_ID |
