S
Stephan Steiner
Hi
Despite DB diagram and the Data Reference, I'm still puzzled about the
MSP_WEB_WORK_ADJUSTED table. What do entries in that table signify? We're
currently faced with the question that we export all the approved timesheet
data on a weekly basis for import into SAP. Since it can happen at export
time that hours have been reported by an employee, but not approved by the
project admin, those hours will not be exported. We have means to note that
and inform the project manager in question (or get a sub to approve those
hours), but then we need to re-export, and ideally only what has been
changed since the last export time, so we're wondering if the table in
question could help, as the MSP_WEB_WORK only returns what's currently shown
in the timesheet of an employee. Furthermore, would the ADJUSTED table allow
tracking of what was entered (if e.g. somebody first reports 10 hours on a
task per accident, then reduces the amount to 4, or a more likely scenario,
reports too little, that amount gets approved, then the employee increases
the amount of hours on the same task on the same day, and the change is
approved again).
Regards
Stephan
Despite DB diagram and the Data Reference, I'm still puzzled about the
MSP_WEB_WORK_ADJUSTED table. What do entries in that table signify? We're
currently faced with the question that we export all the approved timesheet
data on a weekly basis for import into SAP. Since it can happen at export
time that hours have been reported by an employee, but not approved by the
project admin, those hours will not be exported. We have means to note that
and inform the project manager in question (or get a sub to approve those
hours), but then we need to re-export, and ideally only what has been
changed since the last export time, so we're wondering if the table in
question could help, as the MSP_WEB_WORK only returns what's currently shown
in the timesheet of an employee. Furthermore, would the ADJUSTED table allow
tracking of what was entered (if e.g. somebody first reports 10 hours on a
task per accident, then reduces the amount to 4, or a more likely scenario,
reports too little, that amount gets approved, then the employee increases
the amount of hours on the same task on the same day, and the change is
approved again).
Regards
Stephan