Project and Portfolio Management Practitioners Forum
cancel

Query to get the No of Hours per day in PPM Regional Calendar?

Highlighted
Shravan Kathuri
Honored Contributor.

Query to get the No of Hours per day in PPM Regional Calendar?

Hi

Can anyone give me the query to find the Hours per day in the PPM Regional calendar. Or Can any one provide me the tables to get the hours per day information for particular calendar?

Thanks
Shravan Kumar.K
3 REPLIES
Shravan Kathuri
Honored Contributor.

Re: Query to get the No of Hours per day in PPM Regional Calendar?

I got it from the table kdrv_calendar_setups
table. My actual requirement is to get the total time of the month based on regional calendar of the user. For Ex: If the user has the US regional calendar, then I need the query to get the total time of the user's regional calendar. How to get it?

Thanks
Shravan Kumar.K
Mahen M
Acclaimed Contributor.

Re: Query to get the No of Hours per day in PPM Regional Calendar?

Hi,
'kdrv_working_days' contains the working days.

'KDRV_CALENDAR_EXCEPTIONS' contains the manual change in the regional calendar and resource calendar.

'kdrv_calendars' is the main calandar table.

Regards,
Mahendran M
Semenov Alexand
Acclaimed Contributor.

Re: Query to get the No of Hours per day in PPM Regional Calendar?

Hi,see attach (formula SE_FOR_DAY for schedule effortt).
Good Luck