S
Stephan Steiner
Hi
After long unfruitful attempts I finally discovered the DB documentation and
a few links that helped to explain how the MSP_WEB_WORK table works. I'm
still puzzled about something though: I have just added three timesheet
entries, that the project manager has yet to approve. The corresponding
entries in MSP_WEB_WORK all have WWORK_UPDATE_STATUS set to 1, and
WWORK_APPROVAL_STATUS is also set to 1.
Approved hours have WWORK_UPDATE_STATUS set to 0 and WWORK_APPROVAL_STATUS
remains set to 1. Shouldn't unapproved hours have an approval status 0 since
they've never been approved?
Also, is there any way to find entries that the project manager (not
resource manager, I know those should be in MSP_WEB_WORK_APPROVAL) declined?
And while I'm at the subject of timesheets, what would cause an entry in the
MSP_WEB_WORK_ADJUSTED table?
Regards
Stephan
After long unfruitful attempts I finally discovered the DB documentation and
a few links that helped to explain how the MSP_WEB_WORK table works. I'm
still puzzled about something though: I have just added three timesheet
entries, that the project manager has yet to approve. The corresponding
entries in MSP_WEB_WORK all have WWORK_UPDATE_STATUS set to 1, and
WWORK_APPROVAL_STATUS is also set to 1.
Approved hours have WWORK_UPDATE_STATUS set to 0 and WWORK_APPROVAL_STATUS
remains set to 1. Shouldn't unapproved hours have an approval status 0 since
they've never been approved?
Also, is there any way to find entries that the project manager (not
resource manager, I know those should be in MSP_WEB_WORK_APPROVAL) declined?
And while I'm at the subject of timesheets, what would cause an entry in the
MSP_WEB_WORK_ADJUSTED table?
Regards
Stephan