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.

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: