KDRV_CALENDAR_SETUPS

This table stores settings information for regional calendars.

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

CALENDAR_SETUP_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

CALENDAR_ID

NOT NULL

NUMBER

Identifier for the calendar that uses these settings

SUNDAY_FLAG

NOT NULL

VARCHAR2(1)

Flag to indicate if Sunday is a working day by default

MONDAY_FLAG

NOT NULL

VARCHAR2(1)

Flag to indicate if Monday is a working day by default

TUESDAY_FLAG

NOT NULL

VARCHAR2(1)

Flag to indicate if Tuesday is a working day by default

WEDNESDAY_FLAG

NOT NULL

VARCHAR2(1)

Flag to indicate if Wednesday is a working day by default

THURSDAY_FLAG

NOT NULL

VARCHAR2(1)

Flag to indicate if Thursday is a working day by default

FRIDAY_FLAG

NOT NULL

VARCHAR2(1)

Flag to indicate if Friday is a working day by default

SATURDAY_FLAG

NOT NULL

VARCHAR2(1)

Flag to indicate if Saturday is a working day by default

FIRST_DAY_OF_WEEK

NOT NULL

NUMBER

Value to indicate the first day of the week. The value can be 1-7 with Sunday = 1 and Saturday = 7

START_TIME

NOT NULL

NUMBER

Hour that is the start of a working day

END_TIME

NOT NULL

NUMBER

Hour that is the end of a working day

DURATION

NOT NULL

NUMBER

Duration, in hours, of a working day

Indexes

Index Name

Index Type

Sequence

Column Name

KDRV_CALENDAR_SETUPS_U1

UNIQUE

1

CALENDAR_SETUP_ID

KDRV_CALENDAR_SETUPS_U2

UNIQUE

1

CALENDAR_ID

Sequences

Sequence Name

Sequence Type

KDRV_CALENDAR_SETUPS_S

CALENDAR_SETUP_ID