KRML_CALENDAR_MONTHS

This table stores information used by various Reporting Meta Layer views to handle the need to aggregate results based on calendar months. This table is for internal use only.

Foreign Keys

This table does not have any foreign keys.

Column Descriptions

Column Name

Null?

Data Type

Description

CALENDAR_MONTH

NOT NULL

DATE

Calendar month

START_DATE

NOT NULL

DATE

The first day of the month based on the CALENDAR_MONTH column

END_DATE

NOT NULL

DATE

The first day of the next month based on the CALENDAR_MONTH column

Indexes

Index Name

Index Type

Sequence

Column Name

KRML_CALENDAR_MONTHS_U1

UNIQUE

1

CALENDAR_MONTH

Sequences

This table uses no sequences.