Modify TASK_PCT_WORK_COMP in MSP_TASKS directly

T

Thomas Pagel

Hi,

is there any reason NOT to modify TASK_PCT_WORK_COMP in MSP_TASKS directly
via SQL? Will that affect Project Server or anything else? Is that
officially "supported"?

Thanks,



Thomas
 
J

J Baird

Well, I've seen a lot of "don't edit the DB comments in the past, so there
are probably a lot of reasons not to do this.....

Three of the many possible problems that I can think of:
If you change the % work complete in the Tasks table, I don't think the Web
view fields, and the Project File's Actuals Fields (Actual task fields,
Actual Assignment fields, Actual resource fields, etc..), and fields that
relate to Actuals (Status, EV Fields, Remaining Work, etc..) won't be
updated, until after you open MSP and recalc (auto or manual).

When changing % Work Complete, in a task that hasn't started yet, the Actual
Start will probably be set to the Task.Start date, upon the first
calculation after the project is opened in MSP.

Work Complete affects Actual Work for an assigned resource, which in turn
could affect Resource Availability.
 
Top