|
|
| |
|
Enterprise Tasks Details
The following script generates the list of enterprise tasks details (task name, start/finish dates, work, actual work, outline code level, % complete and % work complete etc.)
SELECT dbo.MSP_PROJECTS.PROJ_NAME,
TASKS.TASK_UID,
TASKS.TASK_OUTLINE_NUM,
TASKS.TASK_NAME,
TASKS.TASK_IS_SUMMARY,
TASKS.TASK_START_DATE,
TASKS.TASK_FINISH_DATE ,
TASKS.TASK_WORK / 60000 AS TASK_WORK_HRS,
TASKS.TASK_ACT_WORK/ 60000 AS TASK_ACT_WORK_HRS,
TASK_PCT_COMP,TASK_PCT_WORK_COMP
FROM
dbo.MSP_TASKS TASKS INNER JOIN
dbo.MSP_PROJECTS ON TASKS.PROJ_ID =
dbo.MSP_PROJECTS.PROJ_ID LEFT OUTER JOIN
dbo.MSP_VIEW_PROJ_TASKS_ENT ENTTASKS
ON ENTTASKS.ENT_ProjectUniqueID = TASKS .PROJ_ID
AND ENTTASKS.ENT_TaskUniqueID =
TASKS.TASK_UID
WHERE (TASKS.PROJ_ID NOT IN
(SELECT PROJ_ID
FROM dbo.MSP_PROJECTS
WHERE PROJ_TYPE <> 0)) AND (TASKS.TASK_UID > 0)
| |
|
|
