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.