Set Resource Calendar Based on Location
search cancel

Set Resource Calendar Based on Location

book

Article ID: 261045

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

There are different calendars that exist.  
Is there a way to set a resource's calendar based on the resource's location?



Environment

Release : 16.1.0

Resolution

It is possible to set the resource calendar from a selection of multiple calendars.
If this needs to be executed programmatically, there is not a resource object that can be used in a process, therefore a custom script would be needed and be developed by a partner or Services.

The following tables can be used for analysis.

select * from PRCALENDAR

select * from LOCATIONS

select * from SRM_RESOURCES 

select * from PRJ_RESOURCES --contains calendarid

select * from PAC_MNT_RESOURCES --contains locationid


Additional Information

To find out the calendar associated with a resource, the following query can be used:

select a.prid, a.prcalendarid, b.unique_name,
c.prname
from
PRJ_RESOURCES a, 
SRM_RESOURCES b,
PRCALENDAR c
where a.prid = b.id