Can some one help me with finding the DB table names where I can see the resources calendar shifts information?
What are you trying to accomplish?
The 'calendar' is not something you can directly retrieve from the database.
The Resource Availability amounts are computed based on the Availability rate and the resource's associated calendar. This is then sliced and you can retrieve the resource's daily availability hours from the slice tables.
Reference the following articles to see if this helps you in getting what you want:
TEC614153 : Where in the Database is the Resource Availability attribute stored?
TEC440068 : Why does the Availability field not reflect the calendar set for the resource?
TEC439197 : How to set the default resource availability rate
TEC510193 : How can we mark a resource as unavailable with respect to allocations?
Thanks for the reply Kathryn.
I am trying to see how the calendar shifts are set to resources. In my company Some resources has calendar shifts set from 10 AM -6 PM and for some 9-5 like that. Basically we are trying to set every resource shifts from 8-4 to maintain consistency and also for updating Resource shifts from another system .
A batch process that goes through XOG'ing resources out and checks the output would be able to provide those answers. I think it is the only supported / ootb method that would do so, although it can still take a while since the XOG would extract more than just the calendar and shifts data.
Alternatively, find out which calendars in your systems are having those shifts set through the UI - this should be a manageable number to go through and identify quickly even manually - and then you can query between prcalendar.prid = prj_resources.prcalendarid (and then if needed, prcalendar.prbasecalendarid = prcalendar.prid where the first prcalendar table's pruserid value is not null) and you could identify which resources are having which base calendars, and therefore those shifts.
Just wondering again...
While the shifts are so hard to display of query in the GUI, what is the actual business need to know them beyond the length of the working day, if I may ask.
Retrieving data ...