Database Tables to Query Timesheet Hours

book

Article ID: 197934

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

We need table details to fetch the timesheet hours of each resource by project and date.

Environment

Release : 15.6.1

Component : CA PPM Time Management

Resolution

The following tables would need to be joined for this: 

  • PRASSIGNMENT
  • PRTASK
  • INV_INVESTMENTS
  • PRTIMEENTRY 
  • PRTIMESHEET
  • PRTIMEPERIOD
  • SRM_RESOURCES