SQL Views Overview

There is a lot of data in your Timemaster system just waiting for you to access. Many of you will be accessing this through the numerous Crystal Reports we've written over the years. Others will be making good use out of the many on-screen reporting facilities within the software itself, or the OData data feeds we've included.

However, over more recent years we've noticed an increase in the requests for raw data to be exported where it can then be manipulated to suit specific needs.

Accessing data stored within a database in the correct format is a skilled job normally limited to database report writers.

It involves an in depth knowledge of the database tables, how they are joined to on another, and how the data in stored within them.

So, to bridge this gap, we've written several different database views that will allow you to export your raw data in a multitude of formats where you can then analyse it.

Once you have done so, you can make better, informed decisions to increase your project performance and ultimately, your profitability.

▪vw_timecharges	This view list a record for each timesheet entry made by a member of staff. It can be used to analyse;- ▪the amount of time booked against a project/task ▪the cost of this time (as a resource cost) ▪how much was charged out (or could have been charged out) ▪how many hours a staff member has booked to chargeable / not chargeable elements of work ▪how much time has been invoiced (or how much is in WIP) this list is not exclusive.
▪vw_staff	This view lists a record for each staff record. It can be used to specifically list;- ▪all staff ▪staff currently employed ▪staff by line manager ▪staff be resource group this list is not exclusive.
▪vw_project_list	This view lists basic, non aggregated project data.
▪vw_project_financials	This view sums various financial data for each project. It can be used to analyse;- ▪overall fees, time, expenses invoiced / currently in WIP ▪hours booked, in progress, invoiced, written off ▪target values this list is not exclusive.
▪vw_task_list	This view sums various data for each task. It can be used to analyse;- ▪the total amount of time booked against a task ▪the cost of this time (as a resource cost) ▪Current WIP and invoiced values (also split by Fees, Time and Expenses) this list is not exclusive.