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.