Share this page
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.
