RSC_SIMPLE_ASK_ALLOCATIONS

This table stores the allocation range and effort (in FTE) assigned to a resource.

Foreign Keys

This table does not have any foreign keys.

Column Descriptions

Column Name

Null?

Data Type

Description

ID

NOT NULL

NUMBER(20)

System-generated identifier

START_DATE

NOT NULL

DATE

Start date of allocation range

FINISH_DATE

NOT NULL

DATE

End date of allocation range

EFFORT

NOT NULL

NUMBER

Allocation effort value (in FTE)

ASSIGNMENT_ID

NULLABLE

NUMBER

Assignment ID

CREATED_BY

NOT NULL

NUMBER(19)

Identifier for the user that created the record

CREATION_DATE

NOT NULL

DATE

Date record was created

LAST_UPDATED_BY

NOT NULL

NUMBER(19)

Identifier for the user that last updated the record

LAST_UPDATE_DATE

NOT NULL

DATE

Date record was last updated

VERSION

NULLABLE

NUMBER

System-generated version for the entity

Indexes

Index Name

Index Type

Sequence

Column Name

RSC_SIMPLE_ASK_ALLOCATIONS_N1

NONUNIQUE

1

ASSIGNMENT_ID

Sequences

Sequence Name

Sequence Type

RSC_SIMPLE_ASK_ALLOCATIONS_S

ID