The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

report for Time Sheet Compliance

Highlighted
kev marks
Regular Collector

report for Time Sheet Compliance

We need to create a report (SQL or Portlet etc) that shows Time Sheet Compliance.

We know PPM has the Delinquent Time Sheet report, but this doesnt have enough info, like manager.

 

We want to have something that reports Compliance %'s. for example...

Manager A had 80% compliance for the week of Jan 1 to Jan 7, 4 out of 5 resources inputted time.

 

We also want to see which users did not put in the time sheet or has it still in the unsubmitted or rework status, like Delinquent Time sheets.

 

Anybody have any suggestion on where to start with this. Is there code from the Delinquent Time Sheet report that we can reuse?

 

Thanks in advance.

Kevin

3 REPLIES
Celil
Esteemed Contributor

Re: report for Time Sheet Compliance

Hi Kevin,

You should use DataModel guide of HP. It has table names, what them consist and relations. With this book you can do SQL easily.
Celil

IT Governance Professional
& PPM Solution Architect
AlexSavencu
Honored Contributor

Re: report for Time Sheet Compliance

Hi, Kevin,

 

adding to Celil's post: in workbench, go to Configuration -> Report Types and from there you should find the link to the page that contains the code for this report.

 

I think the best option for you is to enhance this report with the extra information - therefore, this is the best place to start.

 

cheers

alex


--remember to kudos people who helped solve your problem
DavidW0DHG
Acclaimed Contributor

Re: report for Time Sheet Compliance

So what did you end up doing here? We have a similar desire and it would be great to see where you ended up, before I recreate the wheel!  We are using PPM and HP Executive Scorecard and want to show in Scorecard time sheet compliance....

 

Thanks! 

//Add this to "OnDomLoad" event