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.