RPT_DIM_TM_PERIODS_MV

This table defines the time periods used in Time Management.

Foreign Keys

This table does not have any foreign keys.

Column Descriptions

Column Name

Null?

Data Type

Description

PERIOD_ID

NOT NULL

NUMBER

ID derived from the PPM KTMG_PERIODS table.

PERIOD_NAME

NOT NULL

VARCHAR2(80)

User defined name for the period.

PERIOD_TYPE_NAME

NOT NULL

VARCHAR2(80)

Name of the period type

START_DATE

NOT NULL

DATE

Date on which the period starts (inclusive).

END_DATE

NOT NULL

DATE

Date on which the period ends (inclusive).

Indexes

This table uses no indexes.

Sequences

This table uses no sequences.