PS 2007 Holidays

[Mike Mahoney]

We are not using the timesheet functionality so cannot use this to capture
and report holiday information. There is a holiday request process and
exception days are created in each resource calendar, with an appropriate
label for each absence. Is this data easily accessible by a SQL query to
produce a holiday report?

regards

Mike

 

[NZ Projects]

The Dev forum is probably a better place to post this question. AFAIK, this
could be done through the PSI. I'm not sure that querying SQL directly will
return the data you want.

 

[Rod Gill]

HI,

The reporting db does not provide calendar tables or Views, but the
MSP_EpmResourceByDay_UserView View has a BaseCapacity field that lists the
work hours available from the calendar. A Query that shows all days with
BaseCapacity=0 that are not Saturday or Sunday would be a start.

Hi NZProjects,

Are you based in New Zealand? I live about an hour north of Auckland near
Matakana, how about you?
Contact me via rodg AT project-systems DOT co DOT nz

--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx

 

[mike.mahoney]

HI,

The reporting db does not provide calendar tables or Views, but the
MSP_EpmResourceByDay_UserView View has a BaseCapacity field that lists the
work hours available from the calendar. A Query that shows all days with
BaseCapacity=0 that are not Saturday or Sunday would be a start.

Hi NZProjects,

Are you based in New Zealand? I live about an hour north of Auckland near
Matakana, how about you?
Contact me via rodg AT project-systems DOT co DOT nz

--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx

---------------------------------------------------------------------------­-------------------------







- Show quoted text -

Rod

Thanks

Mike