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

SYS_C005201591

UNIQUE

1

STAFF_PROF_ALLOCATION_ID

Sequences

Sequence Name

Sequence Type

RSC_STAFF_PROF_ALLOCATION_S

STAFF_PROF_ALLOCATION_ID