Unsubmitted timesheets

[DCarter]

I am an administrator for PWA and responsible for collecting all of the
timesheet data. Under the Timesheet section where it shows the report
for Resources that have unsubmitted timesheets, I have several
resources that do not show up on this report even though I know they
have not submitted a timesheet. Is there a way to reset this report or
validate the query?

Thanks

 

[Doug]

If you can run queries aganist the database try this report before processing
any updates for the period.

-- attempt to id non-reporters
--find full list of resources
select wr.res_name
from MSP_WEB_RESOURCES WR,MSP_TEXT_FIELDS TXTFLD, MSP_CONVERSIONS CONV
where WR.RES_EUID = TXTFLD.TEXT_REF_UID
and TXTFLD.TEXT_FIELD_ID = CONV.CONV_VALUE
and TXTFLD.text_category = 1
and proj_id = 1
and conv_string = 'Resource Group'
and wr.RES_NAME not in
( -- list of resources who have pending task updates.
select distinct R.RES_NAME
from MSP_WEB_ASSIGNMENTS A, MSP_WEB_PROJECTS P, MSP_WEB_RESOURCES R
where A.WASSN_ACTUALS_PENDING =1 -- flag to indicate task is pending
manager approval
and A.wproj_id = P.WPROJ_ID
AND R.WRES_ID = A.WRES_ID
)
order by res_name