Share this page

# 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.

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: