KINS_PROJECT_WORKING_DAY_CONV

This table stores projects that have been converted when the working day (# of hours and start time) are redefined. Once all the start and end times of each task are converted, this table is cleared.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

Column Descriptions

Column Name

Null?

Data Type

Description

MASTER_PROJECT_ID

NOT NULL

NUMBER

System-generated identifier

CREATION_DATE

NOT NULL

DATE

Date record was created

CREATED_BY

NOT NULL

NUMBER

Identifier for the user who created the record

LAST_UPDATE_DATE

NOT NULL

DATE

Date record was last updated

LAST_UPDATED_BY

NOT NULL

NUMBER

Identifier for the user who last updated the record

OLD_START

NOT NULL

NUMBER

Old start time of the global day.

OLD_LENGTH

NOT NULL

NUMBER

Old length of the global day.

NEW_START

NOT NULL

NUMBER

New start time of the global day.

NEW_LENGTH

NOT NULL

NUMBER

New length of the global day.

Indexes

Index Name

Index Type

Sequence

Column Name

KINS_PROJECT_WORK_DAY_CONV_U1

UNIQUE

1

MASTER_PROJECT_ID

Sequences

This table uses no sequences.