WP_SCHEDULE_WARNINGS

This table stores information about the warnings a task can have regarding its schedule. The warnings include starting late and dependency conflict.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

WP_CALENDAR_CONSTRAINTS

CALENDARCONSTRAINT_ID

CALENDAR_CONSTRAINT_ID

KNTA_USERS

USER_ID

CREATED_BY

WP_DEPENDENCIES

DEPENDENCY_ID

DEPENDENCY_ID

KNTA_USERS

USER_ID

LAST_UPDATED_BY

WP_TASK_OWNERS

TASK_ID

TASK_ID

Column Descriptions

Column Name

Null?

Data Type

Description

SCHEDULE_WARNING_ID

NOT NULL

NUMBER

System-generated identifier

TYPE

NOT NULL

VARCHAR2(255)

Describes the type of the warning. For example, PS = Partial Schedule, OP = Out Of Project Range.

VERSION

NOT NULL

NUMBER

System-generated version for the entity. This column must not be updated manually

TASK_ID

NULLABLE

NUMBER

Identifier for the task this schedule warning 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

CALENDAR_CONSTRAINT_ID

NULLABLE

NUMBER

Identifies the violated constraint for a calendar constraint violation type of warning

DEPENDENCY_ID

NULLABLE

NUMBER

Identifies the violated dependency for a dependency violation type of warning

EFFECTIVE_DATE

NULLABLE

DATE

Not used

SCHEDULECODE

NULLABLE

NUMBER

Indicates the type of scheduling that was used when the resource was found unavailable: 1=Include days in schedule when all resources are avail, 2=when at least one is, 3=ignore resource avail (only applicable to resource unavailable warnings).

DURATION

NULLABLE

FLOAT

Indicates the scheduled duration of the task this warning belongs to (only applicable to resource unavailable warnings)

STARTDATE

NULLABLE

DATE

Indicates the scheduled start date of the task this warning belongs to (only applicable to resource unavailable warnings)

Indexes

Index Name

Index Type

Sequence

Column Name

FKB22D311939B3C473_I

NONUNIQUE

1

CALENDAR_CONSTRAINT_ID

FKB22D31197A2FF716_I

NONUNIQUE

1

DEPENDENCY_ID

FKB22D3119DED8B1D6_I

NONUNIQUE

1

TASK_ID

SYS_C005201609

UNIQUE

1

SCHEDULE_WARNING_ID

Sequences

Sequence Name

Sequence Type

WP_SCHEDULE_WARNINGS_S

SCHEDULE_WARNING_ID