KDRV_WORKING_DAYS

This table stores working day information for each Regional Calendar. There is one row per Regional Calendar per day.

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

WORKING_DAY_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

WORKING_DAY_DATE

NOT NULL

DATE

Calendar date

WORKING_DAY_FLAG

NOT NULL

VARCHAR2(1)

Flag to indicate if this date is a working day

CALENDAR_ID

NOT NULL

NUMBER

Identifier for the calendar which uses this information

Indexes

Index Name

Index Type

Sequence

Column Name

KDRV_WORKING_DAYS_U1

UNIQUE

1

WORKING_DAY_ID

KDRV_WORKING_DAYS_U2

UNIQUE

1

CALENDAR_ID

KDRV_WORKING_DAYS_U2

UNIQUE

2

WORKING_DAY_DATE

Sequences

Sequence Name

Sequence Type

KDRV_WORKING_DAYS_S

WORKING_DAY_ID