Share this page
RPT_PPM_AGGR_WRK_DAYS_MV
This is a materialized view that aggregates the information in the KDRV_WORKING_DAYS with the help of PPM_FISCAL_PERIODS table to give the working hours for a given period.
Foreign Keys
This table does not have any foreign keys.
Column Descriptions
|
Column Name |
Null? |
Data Type |
Description |
|---|---|---|---|
|
CALENDAR_ID |
NOT NULL |
NUMBER |
The calendar ID is derived from PPM's KDRV_WORKING_DAYS.CALENDAR_ID or KDRV_CALENDARS.CALENDAR_ID. |
|
NUM_WRK_DAYS |
NULLABLE |
NUMBER |
NUM_WRK_DAYS is the sum of the working days in this given period and for this calendar. |
|
PERIOD_TYPE |
NOT NULL |
NUMBER |
PERIOD_TYPE is a number to indicate, whether this period is a week, month, quarter, half year or year. |
|
START_DATE |
NOT NULL |
DATE |
START_DATE indicates the start of the period. |
|
END_DATE |
NOT NULL |
DATE |
END_DATE indicates the end of the period. |
|
WORK_HRS_PER_DAY |
NOT NULL |
NUMBER |
WORK_HRS_PER_DAY is the number of work hours in the day for this calendar. Derived from PPM's KDRV_CALENDAR_SETUPS table. |
Indexes
This table uses no indexes.
Sequences
This table uses no sequences.
