Learning Center


Tech Note: Showing the approver's name in a report

Posted by Pacific Timesheet Support on Apr 21, 2011 7:04:00 PM

The reporting engine in Pacific Timesheet allows you to choose from a large number of data fields when reporting on employee time sheets. However, the employee's approver is not available from the pull down list of column fields. What to do? A SQL expression can help you - the following SQL will show the full name of the level 1 approver for an employee:

Read More

Creating annual reports that group data by week

Posted by Pacific Timesheet Support on Oct 6, 2010 7:07:00 PM

Sometimes you need to summarize timesheet data by week over a longer period, such as a year. In Pacific Timesheet you can use sql expressions to create an annual timesheet report that groups or summarizes data by week. Normally when running timesheet reports, such as Employee Hours, the data is totaled for the entire reporting period. For example, the Employee Hours by Task report looks something like this when run year-to-date:

You can have this report summarize the data in weekly groups by using the following SQL as a grouping:


This SQL is only valid for MySQL, but similar constructs can be made for Microsoft SQL Server and Oracle. When you group by this expression the hours data will now look like this:

Here you see the same data, only summarized by the week of the year.

A newer solution is Interval Reports found in the other reports section of the reports tab. Interval reports allow you to select an time interval such as a week, biweek, month or quarter over a defined time period.

Read More

Keeping Your Data Safe

Posted by Pacific Timesheet Support on Mar 19, 2010 7:18:00 PM

Your Pacific Timesheet software contains sensitive data, such as employee hours and pay rates, project bill rates, etc. The following tips will help you reduce the risk of unauthorized access to this sensitive data:

Read More

Reporting on "Regular Hours"

Posted by Pacific Timesheet Support on Mar 1, 2010 7:32:00 PM

What to do when regular hours include vacation, sick & other leave

Some organizations have a concept of "regular hours" that is different than the Pacific Timesheet "Regular Time" pay code hours. For instance, your company might consider "regular hours" to be all hours that are non-overtime work hours, plus any leave hours that are not 'Unpaid Time Off'. To report on employee "regular hours" you can create a new Employee Hours report on the Reports tab (click the New link to the right of the Employee Hours report). Then add the following SQL expression report column by clicking the Add SQL Expression column at the end of the columns list:

Read More

Leave-only Timesheets

Posted by Pacific Timesheet Support on Feb 21, 2010 7:48:00 PM

How to configure timesheets for employees
who only need to record leave

Pacific Timesheet allows you to create timesheet templates that only allow leave or time-off to be placed on them. If you have a group of employees that are only required to record leave, then all you have to do is go to their timesheet template and edit the advanced settings to only allow leave time entries:

Read More

Topics: Time Off Management, timesheet, Timesheet Software, Time Tracking Software, time tracking, leave timesheet

Turning Off Partial Day Leave Requests

Posted by Pacific Timesheet Support on Feb 5, 2010 7:42:00 PM

Disabling partial day leave requests for specific leave types

Partial day leave or time off requests are not always allowed in some organizations. For instance, you may require that employees take a full 8 hours of vacation for a day, or none at all. You can control this from your employee's policy on the System > Policies page. To disable partial day leave requests edit the policy's time entry rules:

Read More

Publishing Reports for Employees

Posted by Pacific Timesheet Support on Jan 14, 2010 7:55:00 PM

...and what the "(Self)" employee filter is all about

The Pacific Timesheet software has a variety of reports that managers and administrators can use and modify. But if you log in as an employee you may notice that there are no reports available out-of-the-box. The reason for this is that the specific fields and data an organization might want to make available to their employees varies greatly. Fortunately it is very easy to publish custom reports for your employees! Let's create a report that shows an employee's project hours:

Read More

Topics: Employee reports, timesheet, Timesheet Software, Time Tracking Software, time tracking, SaaS Timesheet

Missed Meal Penalties

Posted by Pacific Timesheet Support on Nov 19, 2009 8:03:00 PM

When you get a missed meal penalty may not always be obvious

Pacific Timesheet computes missed meals according to California labor and wage laws. To determine whether a day's work warrants a missed meal penalty the hours are divided into 5 hours blocks. Any block of work greater than 5 hours gets a missed meal penalty. Take the following example:

Read More

Keeping Your Timesheet Up to Date

Posted by Pacific Timesheet Support on Oct 12, 2009 8:01:00 PM

Ways to motivate employees to keep better track of their time

We recognizant at Pacific Timesheet that it can be difficult for employees to always keep their timesheets up-to-date. We recommend daily time entry, especially if you are in a DCAA environment that requires strong auditing. While we design Pacific Timesheet software to make it as quick and painless as possible to enter time (timers, timesheet memory, memorized projects and tasks, mobile, web and telephone interfaces, etc.), it sometimes helps to add a little extra motivation to improve your employee's time tracking compliance. Here are some positive and negative approaches you can consider that have proven effective for some organizations:

Read More

Topics: timesheet, Timesheet Software, Time Tracking Software, time tracking, SaaS Timesheet, Online Timesheet, Web TimeSheet