D
dp22193
I am trying to read resource hours per task per day from MSP_VIEW_PROJ_ASSN_TP_BY_DAY. I have noticed several inaccuracies when compared to entries MSP_WEB_WORK
1. A fractional portion of the hours worked on a particular task (AssignmentTimeActualWork) is sometimes added to one day and subtracted from another. The total hours for the task are correct but the per day hours are not when compared to what was entered into the timesheet (MSP_WEB_WORK)
2. The summation of the hours recorded in MSP_VIEW_PROJ_ASSN_TP_BY_DAY.AssignmentTimeActualWork per resource and task is sometimes off by one or two minutes when compared to the summation of the hours recorded in MSP_WEB_WORK
3. The system does not appear to record additional per day hours expended by a resource on a particular task once that task is complete. The total hours for the task is correct but the days worked after the task is complete do not show up in MSP_VIEW_PROJ_ASSN_TP_BY_DAY. This situation occurs when a task is marked as complete but ends up requiring some additional work in the future
Does anyone have any thoughts on these issues
Thanks in advance.
1. A fractional portion of the hours worked on a particular task (AssignmentTimeActualWork) is sometimes added to one day and subtracted from another. The total hours for the task are correct but the per day hours are not when compared to what was entered into the timesheet (MSP_WEB_WORK)
2. The summation of the hours recorded in MSP_VIEW_PROJ_ASSN_TP_BY_DAY.AssignmentTimeActualWork per resource and task is sometimes off by one or two minutes when compared to the summation of the hours recorded in MSP_WEB_WORK
3. The system does not appear to record additional per day hours expended by a resource on a particular task once that task is complete. The total hours for the task is correct but the days worked after the task is complete do not show up in MSP_VIEW_PROJ_ASSN_TP_BY_DAY. This situation occurs when a task is marked as complete but ends up requiring some additional work in the future
Does anyone have any thoughts on these issues
Thanks in advance.