Non working time SQ DB

Y

Yoav

Hi,
Do you know where in Project Server 2007 DBs stored Standard calendar non
working times? e.g. weekends, hollydays and so on...
Thanks!!
 
B

Barbara - Austria

Hi Yoav,

on resource level you can retrieve that information from
MSP_EpmResourceByDay_UserView. 'Base Capacity' are hours per day for each
user, based on calendar. 'Capacity' will give you information if absence was
entered in timesheet or if working time was changed for that user.

Does that help?
Regards
Barbara
 
Y

Yoav

Hi, Barbara
Thanks for your answer.
How can i see this kind of data for Standard calendar, not related to a
specific resource?
 
B

Barbara - Austria

Hi Yoav,

sorry, I hope someone else can tell where to find that!
Since I haven't been successful in getting that information without using
PSI, I am using Administrator's information as workaround - no vacation is
entered there.

Regards
Barbara
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Please help: 'Change working time' does NOT change working time 1
"Working times" for calendars incorrect 0
How to change a standard calender 0
Non working time not diplaying in the "View Resource availability" 6
Tracking and reporting Admin/support non project time 2
Changing a Calendar from a Project/Project Template 5
how to get "EndDate" of a project? 2
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0

Top