Is there any way to report on pending tasks within a service plan for a requested service?I am interested in things like scheduled start dates and queues.This would be used in progress reports to indicate percentage complete and predict future work loads.
I apologize for the difference in the name of the fact table. I was referencing a 2008 installation. You are correct that this is named ServiceTaskFact in the 2007 version.
The status flag for a task which would meet your criteria for Pending is New. This is the initial task status. A New task has been created but is dependent upon the completion of a previous task before it can begin.
Unfortunately, in the 2007 version the Schedule Start Date for a task is not available in