If you are not using timesheet approval feature in Project Server 2003, then PWA users keep getting messages on PWA homepage under timesheet section. The message states something like ‘You have timesheets pending approval for the period…..’ or ‘You have not submitted timesheet …..’ Those message might fill up the PWA homepage for users.
The following query removes the timesheet messages from the user’s
PWA homepage.
insert MSP_WEB_WORK_APPROVAL(
WASSN_ID,
WRES_ID,
WPRD_START_DATE,
WPRD_FINISH_DATE,
WRES_ID_APPROVER,
WAPPROVAL_STATUS,
WAPPROVAL_NOTIFICATION_SENT)
SELECT WASSN_ID,
WRES_ID,
WPRD_START_DATE,
WPRD_FINISH_DATE,
WRES_ID,
1,
0
FROM MSP_WEB_ASSIGNMENTS MWA, MSP_WEB_TIME_PERIODS mwp
WHERE Not Exists (select * from MSP_WEB_WORK_APPROVAL
where CONVERT(VARCHAR, CONVERT(DATETIME, WPRD_START_DATE), 110) =
CONVERT(VARCHAR, CONVERT(DATETIME, MWP.WPRD_START_DATE), 110)
AND CONVERT(VARCHAR, CONVERT(DATETIME, WPRD_FINISH_DATE), 110) =
CONVERT(VARCHAR, CONVERT(DATETIME, MWP.WPRD_FINISH_DATE), 110)
AND WASSN_ID = MWA.WASSN_ID
AND WRES_ID = MWA.WRES_ID)
Go
UPDATE MSP_WEB_WORK_APPROVAL
SET WAPPROVAL_STATUS = ‘1’
WHERE WAPPROVAL_STATUS = ‘0’
Go
(Test this query in your lab environment first. I can’t guarantee this query or anything which might be effected by this query in your environment. Consult your DBA &/or Project Administrator & use it at your own risk)