Share this page
RPT_DIM_REGIONS_MV
This is a materialized view over PPM's KNTA_REGIONS, KDRV_CALENDARS and KCST_CURRENCIES tables. This keeps the information of a region, it's associated calendar and the currency.
Foreign Keys
This table does not have any foreign keys.
Column Descriptions
|
Column Name |
Null? |
Data Type |
Description |
|---|---|---|---|
|
REGION_ID |
NOT NULL |
NUMBER |
REGION_ID is the ID derived from PPM's KNTA_REGIONS table. |
|
REGION_NAME |
NOT NULL |
VARCHAR2(100) |
Name of this region |
|
DESCRIPTION |
NULLABLE |
VARCHAR2(200) |
Description for this region |
|
CALENAR_ID |
NOT NULL |
NUMBER |
ID of the calendar associated with this region derived from PPM's KDRV_CALENDARS table. |
|
CALENDAR_NAME |
NULLABLE |
VARCHAR2(100) |
Name of this calendar |
|
CURRENCY_ID |
NOT NULL |
NUMBER |
ID of the currency associated with this region, derived from PPM's KCST_CURRENCIES table. |
|
CURRENCY_NAME |
NOT NULL |
VARCHAR2(100) |
Name of this currency |
|
ENABLED_FLAG |
NOT NULL |
VARCHAR2(1) |
A flag to indicate if this region is enabled or disabled |
Indexes
This table uses no indexes.
Sequences
This table uses no sequences.
