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
 
Top