Share this page

# KRML_CALENDAR_DAYS

This table stores information used by various Reporting Meta Layer views to handle the need to aggregate results based on calendar days. 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_DATE | NOT NULL | DATE | Actual day of the calendar date
CALENDAR_MONTH | NOT NULL | DATE | Month in which the CALENDAR_DATE belongs
CALENDAR_YEAR | NOT NULL | DATE | Year in which the CALENDAR_DATE belongs
SEQ_PERIOD_TYPE_1 | NOT NULL | NUMBER | This value indicates the sequence of the period type this day falls in for the period defined as period type 1 in the PPM_FISCAL_PERIODS table.
SEQ_PERIOD_TYPE_2 | NOT NULL | NUMBER | This value indicates the sequence of the period type this day falls in for the period defined as period type 2 in the PPM_FISCAL_PERIODS table.
SEQ_PERIOD_TYPE_3 | NOT NULL | NUMBER | This value indicates the sequence of the period type this day falls in for the period defined as period type 3 in the PPM_FISCAL_PERIODS table.
SEQ_PERIOD_TYPE_4 | NULLABLE | NUMBER | This value indicates the sequence of the period type this day falls in for the period defined as period type 4 in the PPM_FISCAL_PERIODS table.
SEQ_CUSTOM_1 | NULLABLE | NUMBER | This column is reserved for future use.
SEQ_CUSTOM_2 | NULLABLE | NUMBER | This column is reserved for future use.
SEQ_CUSTOM_3 | NULLABLE | NUMBER | This column is reserved for future use.
SEQ_CUSTOM_4 | NULLABLE | NUMBER | This column is reserved for future use.
SEQ_CUSTOM_5 | NULLABLE | NUMBER | This column is reserved for future use.

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KRML_CALENDAR_DAYS_N1 | NONUNIQUE | 1 | SEQ_PERIOD_TYPE_1
KRML_CALENDAR_DAYS_N2 | NONUNIQUE | 1 | SEQ_PERIOD_TYPE_2
KRML_CALENDAR_DAYS_N3 | NONUNIQUE | 1 | SEQ_PERIOD_TYPE_3
KRML_CALENDAR_DAYS_N4 | NONUNIQUE | 1 | SEQ_PERIOD_TYPE_4
KRML_CALENDAR_DAYS_U1 | UNIQUE | 1 | CALENDAR_DATE

## Sequences

This table uses no sequences.

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: