Timesheet pending for approval

F

Fabrizio

Hello,

I'd like to know where and how I can find the timesheet that are waiting for
approval by the project manager (those submitted by project resources but not
yet approved or rejected) inside the Project database.

Thank you,
Fabrizio.
 
C

Chak

Hello Fabrizio,

All the details of the assignments appearing in timesheet, you can
find at MSP_WEB_ASSIGNMENTS table.

To get Project Name and Resource Names, you have to join the
MSP_WEB_PROJECTS and MSP_WEB_RESOURCES tables with MSP_WEB_ASSIGNMENTS
table.

SQL Queries:

1) Resource entered task update in time sheet and saved, but not yet
sumbitted

Select WPROJ_ID,WRES_ID,TASK_NAME
WASSN_SEND_UPDATE_NEEDED,WASSN_ACTUALS_PENDING,WASSN_UPDATE_STATUS,WASSN_SEND_UPDATE_DATE
from dbo.MSP_WEB_ASSIGNMENTS
Where WASSN_SEND_UPDATE_NEEDED = 1 and WASSN_ACTUALS_PENDING = 0 and
WASSN_UPDATE_STATUS = 1 and WASSN_SEND_UPDATE_DATE IS NULL


2) Resource Subimitted Task Update, but not yet approved by PM

Select WPROJ_ID,WRES_ID,TASK_NAME
WASSN_SEND_UPDATE_NEEDED,WASSN_ACTUALS_PENDING,WASSN_UPDATE_STATUS,WASSN_SEND_UPDATE_DATE
from dbo.MSP_WEB_ASSIGNMENTS
Where WASSN_SEND_UPDATE_NEEDED = 1 and WASSN_ACTUALS_PENDING = 1 and
WASSN_UPDATE_STATUS = 1 and WASSN_SEND_UPDATE_DATE IS NOT NULL


3) Task Updates approved by PM

Select WPROJ_ID,WRES_ID,TASK_NAME
WASSN_SEND_UPDATE_NEEDED,WASSN_ACTUALS_PENDING,WASSN_UPDATE_STATUS,WASSN_SEND_UPDATE_DATE
from dbo.MSP_WEB_ASSIGNMENTS
Where WASSN_SEND_UPDATE_NEEDED = 0 and WASSN_ACTUALS_PENDING = 0 and
WASSN_UPDATE_STATUS = 0 and WASSN_SEND_UPDATE_DATE IS NOT NULL

Thanks
Chak
 
C

Chak

All the details of the assignments appearing in timesheet, you can find
at MSP_WEB_ASSIGNMENTS table.

To get Project Name and Resource Names, you have to join the
MSP_WEB_PROJECTS and MSP_WEB_RESOURCES tables with MSP_WEB_ASSIGNMENTS
table.

SQL Queries:

1) Resource entered task update in time sheet and saved, but not yet
sumbitted

Select WPROJ_ID,WRES_ID,TASK_NAME,
WASSN_SEND_UPDATE_NEEDED,WASSN_ACTUALS_PENDING,WASSN_UPDATE_STATUS,WASSN_SEND_UPDATE_DATEFrom
dbo.MSP_WEB_ASSIGNMENTS
Where WASSN_SEND_UPDATE_NEEDED = 1 and WASSN_ACTUALS_PENDING = 0 and
WASSN_UPDATE_STATUS = 1 and WASSN_SEND_UPDATE_DATE IS NULL

2) Resource Subimitted Task Update, but not yet approved by PM

Select WPROJ_ID,WRES_ID,TASK_NAME
WASSN_SEND_UPDATE_NEEDED,WASSN_ACTUALS_PENDING,WASSN_UPDATE_STATUS,WASSN_SEND_UPDATE_DATEfrom
dbo.MSP_WEB_ASSIGNMENTS
Where WASSN_SEND_UPDATE_NEEDED = 1 and WASSN_ACTUALS_PENDING = 1 and
WASSN_UPDATE_STATUS = 1 and WASSN_SEND_UPDATE_DATE IS NOT NULL

3) Task Updates approved by PM

Select WPROJ_ID,WRES_ID,TASK_NAME
WASSN_SEND_UPDATE_NEEDED,WASSN_ACTUALS_PENDING,WASSN_UPDATE_STATUS,WASSN_SEND_UPDATE_DATE
from dbo.MSP_WEB_ASSIGNMENTS
Where WASSN_SEND_UPDATE_NEEDED = 0 and WASSN_ACTUALS_PENDING = 0 and
WASSN_UPDATE_STATUS = 0 and WASSN_SEND_UPDATE_DATE IS NOT NULL

Thanks
Chak
 
C

Chak

All the details of the assignments appearing in timesheet, you can find
at MSP_WEB_ASSIGNMENTS table.

To get Project Name and Resource Names, you have to join the
MSP_WEB_PROJECTS and MSP_WEB_RESOURCES tables with MSP_WEB_ASSIGNMENTS
table.

SQL Queries:

1) Resource entered task update in time sheet and saved, but not yet
sumbitted

Select WPROJ_ID,WRES_ID,TASK_NAME,
WASSN_SEND_UPDATE_NEEDED,WASSN_ACTUALS_PENDING,
WASSN_UPDATE_STATUS,WASSN_SEND_UPDATE_DATE
from dbo.MSP_WEB_ASSIGNMENTS
Where WASSN_SEND_UPDATE_NEEDED = 1 and WASSN_ACTUALS_PENDING = 0 and
WASSN_UPDATE_STATUS = 1 and WASSN_SEND_UPDATE_DATE IS NULL

2) Resource Subimitted Task Update, but not yet approved by PM

Select WPROJ_ID,WRES_ID,TASK_NAME
WASSN_SEND_UPDATE_NEEDED,WASSN_ACTUALS_PENDING,
WASSN_UPDATE_STATUS,WASSN_SEND_UPDATE_DATE
from dbo.MSP_WEB_ASSIGNMENTS
Where WASSN_SEND_UPDATE_NEEDED = 1 and WASSN_ACTUALS_PENDING = 1 and
WASSN_UPDATE_STATUS = 1 and WASSN_SEND_UPDATE_DATE IS NOT NULL

3) Task Updates approved by PM

Select WPROJ_ID,WRES_ID,TASK_NAME
WASSN_SEND_UPDATE_NEEDED,WASSN_ACTUALS_PENDING,WASSN_UPDATE_STATUS,
WASSN_SEND_UPDATE_DATE
from dbo.MSP_WEB_ASSIGNMENTS
Where WASSN_SEND_UPDATE_NEEDED = 0 and WASSN_ACTUALS_PENDING = 0 and
WASSN_UPDATE_STATUS = 0 and WASSN_SEND_UPDATE_DATE IS NOT NULL



Thanks
Chak
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Timesheets not going to Approver 0
Project Online Timesheets Actuals Mismatches - data not publishing to projects 0
Timesheet approval routes 0
how to avoid import timesheet in timesheet approval process 1
Timesheet and Timesheet Lines approval statuses 2
Admin Time handling and Reporting 1
PServer 2003 timesheet approval not following organizational RBS. 10

Top