Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Highlighted
Shravan Kathuri
Senior Member

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
Senior Member

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
Honored 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
Esteemed 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
//Add this to "OnDomLoad" event