Accessing RTC Timesheet Reports tables?
![]()
Hi all, I've have installed RTC 6.0.2 with DB2 database but am currently unsure about what the schema and tables names there are for RTC work item timesheets. We are aware that the RTC generated report "Personal Timesheet by Work Item" provides enough for most but this currently isn't enough as we use predefined and custom data to make use which means we need access the tables directly. We want to plug in additional data sources which will provide us with a complete up to date report of our timesheets for all our IT staff for the current working week. Is it possible to tell the schemas and tables for the reports because it is not available in main schemas which form the central data warehouse?
We are not looking to use any apis, just a BI solution no matter how complex as long as its possible. We are using DB2 web query
|