can I add a column to MSP_TimesheetClass table with SQL?

S

Shawn Everingham

Timesheet Class has 3 different types of work: Standard = 0, Non-Working
Admin = 1, Working Admin = 2

I need to have Holiday = 9, Bereavement = 12, etc...

can I just add a column and populate it with values that I care about? will
this do any damage to the database? Should I do it in Reporting and published
databases? Thoughts? Help?

thanks!
 
M

Marc Soester [MVP]

Hi Shawn,

you should not just add columns to the timsheet calss table, this will cause
issues. If you need new Administrative tasks why dont you just create them in
Project Web Access?

The class table by the way determins only the class of Admin task you
create, which is more for "internal" Project Server use.

If you want to report against specific admin tasks like Holiday, Bereavement
etc all you need to do is create Admin Tasks with these names. By using the
Data Analyser you will then be able to report against those tasks.

I hope this makes sense. Please feel free to ask any questions to clear any
confusion mate :)
Thanks
 
Top