RPT_DIM_PPM_FISCAL_PERIODS

This is a dimensional table in the reporting star schema. It is derived from the PPM_FISCAL_PERIODS table. All the period names (week, month, quarter, half year and year) are stored at day level.

Foreign Keys

This table does not have any foreign keys.

Column Descriptions

Column Name

Null?

Data Type

Description

DATE_OF_THE_DAY

NULLABLE

DATE

Date in the calendar that is between start and the end etl boundaries.

PERIOD_ID_WEEK

NULLABLE

NUMBER

ID of the (parent) week in which this date falls in.

PERIOD_ID_MONTH

NULLABLE

NUMBER

ID of the (parent) month in which this date falls in.

PERIOD_ID_QUARTER

NULLABLE

NUMBER

ID of the (parent) quarter in which this date falls in.

PERIOD_ID_HALF_YEAR

NULLABLE

NUMBER

ID of the (parent) half year in which this date falls in.

PERIOD_ID_YEAR

NULLABLE

NUMBER

ID of the (parent) year in which this date falls in.

PERIOD_NAME_WEEK

NULLABLE

VARCHAR2(100)

Name of the (parent) week in which this date falls in.

PERIOD_NAME_MONTH

NULLABLE

VARCHAR2(100)

Name of the (parent) month in which this date falls in.

PERIOD_NAME_QUARTER

NULLABLE

VARCHAR2(100)

Name of the (parent) quarter in which this date falls in.

PERIOD_NAME_HALF_YEAR

NULLABLE

VARCHAR2(100)

Name of the (parent) half year in which this date falls in.

PERIOD_NAME_YEAR

NULLABLE

VARCHAR2(100)

Name of the (parent) year in which this date falls in.

BEGIN_FISCAL_MONTH

NULLABLE

CHAR

A flag to indicate if this date is the beginning of the month.

BEGIN_FISCAL_YEAR

NULLABLE

CHAR

A flag to indicate if this date is the beginning of the year.

Indexes

Index Name

Index Type

Sequence

Column Name

RPT_DIM_PPM_FISCAL_PERIODS_N1

NONUNIQUE

1

PERIOD_NAME_MONTH

RPT_DIM_PPM_FISCAL_PERIODS_N2

NONUNIQUE

1

PERIOD_ID_MONTH

RPT_DIM_PPM_FISCAL_PERIODS_N3

NONUNIQUE

1

BEGIN_FISCAL_MONTH

RPT_DIM_PPM_FISCAL_PERIODS_N4

NONUNIQUE

1

DATE_OF_THE_DAY

RPT_DIM_PPM_FISCAL_PERIODS_N5

NONUNIQUE

1

PERIOD_ID_YEAR

RPT_DIM_PPM_FISCAL_PERIODS_N6

NONUNIQUE

1

BEGIN_FISCAL_YEAR

RPT_DIM_PPM_FISCAL_PERIODS_N7

NONUNIQUE

1

PERIOD_NAME_WEEK

Sequences

This table uses no sequences.