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.