Creating annual reports that group data by week

With a little SQL you can group your timesheet data by week...

This blog post discusses how you can 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:

STR_TO_DATE(CONCAT(YEARWEEK(t_timeentry.strt,0),'0'),'%x%v%w')

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. You can contact Pacific Timesheet support or your application specialist for a more detailed solution document that describes how to do this.

Crew Timesheet Tips: Automating Cost Code and Craft Level Assignment

Many believe that the main benefit of automating field services and crew time tracking is reducing administrative costs and eliminating double data entry. While this benefit is significant, perhaps even more important is automating crew assignments.

With advanced assignment automation a system would allow supervisors to login and see a completely populated crew timesheet, including job, cost code and craft level assignments to workers. Another feature of automation would restrict the supervisor, when making or modifying assignments, to only see those cost codes or craft levels a worker is permitted to be assigned.

Distributing assignment-making ability into the field with the supervisor allows crew timesheets to be adjusted throughout the day as workers leave early or replacements show up. All of this means more accurate time tracking throughout the day and automated tabulation of hours and costs at the end of the day.

The majority of construction and field services operations use daily paper crew timesheets to track time by job, cost or craft codes. The paper timesheets need to be created, printed and distributed by administrative staff at the job site.

A difficulty of automating this process is that the crew timesheet needs to be setup with these assignments in advance, or supervisors need to easily be able to make these assignments or change them in the field.

With crew timesheet automation a field services operation has two new options:

1) have administrative staff setup crew timesheets at the beginning of the day, or even modify assignments throughout the day for supervisors tracking time. The supervisors would be go to fully populated crew timesheet screens and enter hours and details throughout or at the end of the day.

2) Where setup of a crew timesheet does not vary from day to day, a copy previous day feature can carry forward the previous day's assignments and thereby completely eliminate any administrative preparation of a new daily crew timesheet. A supervisor can make minor adjustments to the crew timesheet setup and enter hours throughout the day.

Pacific Timesheet Announces New Customers

Pacific Timesheet continues helping new customers save more money with software as a service and online time tracking solutions in time off and absence management, payroll time tracking and project time tracking.

Las Vegas, NV — September 14, 2010 — Pacific Timesheet has announced several new important customers during the last quarter, including leading government contractors, universities, and for-profit corporations. Among these are Fiserv Federal (a leading global provider of information management and electronic commerce systems for the financial services industry), Pinal County Government, Our Kids of Miami (an important non-profit in Dade County Florida), Wavsys (a leading technical staffing company), Ironhouse Sanitary District, and The Dartmouth Institute.

Jim Dickerson, VP of Operations stated, "Many of our new customers have been taking advantage of advanced features delivered by our software as a service solutions. In particular, our integration utilities are now state of the art, supporting advanced ftp and encryption features not offered by most of our direct competitors." In particular, Pacific Timesheet's leading time off and absence management solutions and payroll time tracking have shown a significant increased growth during the last three business quarters.

About Pacific Timesheet Enterprise

Pacific Timesheet is a leading provider of time and attendance, time off and absence management, time and labor tracking and project/job and work order time tracking software and services. Its main product, Pacific Timesheet Enterprise, is known for its unprecedented ease-of-use, flexibility and reliability. Pacific Timesheet is platform, database, and browser-independent and provided as a software as a service (SaaS) or on-premise software solution. Pacific Timesheet's Time Management Systems are used across more than 40 industries and by some of the world's leading organizations such as Applied Materials, Ceres, City of Albuquerque, FMC, Joy Mining, Openwave Technologies, Ontario Institute for Cancer Research, NOAA, New Visions for Public Schools, Turner Construction, The Clinton Foundation, University of Massachusetts, University of Virginia, and many more. The Company has resellers in North America, South America, Europe, Africa and Asia. For additional information about Pacific Timesheet go to http://www.pacifictimesheet.com, or in North America call 866-416-2061 ext. 1., from outside North America call +1 650-641-2760.

Pacific Timesheet Announces Partnership with Barcodes Inc.

Las Vegas, NV — April 19, 2010 — Pacific Timesheet has announced a strategic partnership with Barcodes Inc. to provide integrated time tracking solutions where employee, job and work order data are collected using barcode scanner systems, mobile computing, point of sale and RFID solutions.

BarcodesInc. is the largest provider of barcode, mobile computing, point of sales and RFID products and solutions in North America.

Pacific Timesheet VP of Operations Jim Dickerson stated, “We are very pleased to formalize our partnership with BarcodesInc. This partnership significantly enhances our product and service offerings into segments requiring important barcode, point of sale and mobile computing solutions. In particular, this helps our customers track time on jobs and work orders in manufacturing, distribution and supply chain operations.”

Raul Cepeda Jr., BarcodesInc. Business Development Manager, stated, “We are very excited to partner with Pacific Timesheet! Bringing together BarcodesInc’s customer service offering and hardware expertise along with Pacific Timesheet’s cutting edge software will provide the market with the best-in-class Time and Attendance Solution.”

Dickerson further explained that this partnership will provide additional specialty solutions tracking time, student and patient activities in various social service agencies, educational and training institutions. “Adding BarcodesInc.'s capabilities with our time and attendance, payroll time tracking, time off and absence management, and scheduling on-premise and SaaS solutions, Pacific Timesheet will now be able to provide complete end-to-end time tracking solutions in manufacturing, distribution and supply chain operations.”

About Pacific Timesheet Enterprise
Pacific Timesheet is a leader provider of time and attendance, time off and absence management, time and labor tracking and project time tracking software as a service (SaaS) and on-premises time tracking software. Its main product, Pacific Timesheet Enterprise, provides unprecedented ease-of-use, flexibility and reliability for time and attendance, time off and absence management, payroll timesheets and project/job time tracking. Built on platform, database, and browser-independent technologies that can be implemented as a SaaS or on-premise solution, Pacific Timesheet provides an enterprise-ready solution that is easy to use and implement for companies worldwide.

The Company is headquartered in Las Vegas, Nevada, and has resellers throughout North America and Europe. Pacific Timesheet is an equal opportunity employer always in search of talented professionals interested in the development and application of proven software technologies. Pacific Timesheet's Time Management Systems are used across more than 40 industries and by some of the world's leading organizations such as Applied Materials, BCD Travel, Joy Mining, Ontario Institute for Cancer Research, NOAA, New Visions for Public Schools, University of Massachusetts and many more. If you need additional information about Pacific Timesheet go to http://www.pacifictimesheet.com, or in North America call 866-416-2061 ext. 1., from outside North America call +1 650-641-2760.

About BarcodesInc.
BarcodesInc is North America's leading provider of barcode, mobile computing, and RFID solutions. Over the past fifteen years, the company has worked hard to earn a reputation for being dedicated, reliable, and customer-oriented. Additionally, they are product experts with deep experience in field mobility, inventory and point-of-sale solutions.

http://pcdistrict.com/news/business/time-and-attendance-software-video-24892-20.html

http://pcdistrict.com/news/business/time-and-attendance-software-video-24892-20.html

Posted using ShareThis

New release! Pacific Timesheet 6.72

A new version of Pacific Timesheet is now available, version 6.72. This version has two key features a number of customers have requested:

• New Accrual Option - Forecasting Only
  A new accrual option is available that, if checked, will cause accruals to only be used to compute or forecast available leave for requests. The accruals will not be added to the actual balance. This is useful for situations where you are importing or setting balances from an external HR or payroll system, but would still like leave requests to show future available balances. To find out more go to the System > Policies > Balance and Accrual Rules page and click the online help link.
• Minimum Work Hours Per Day
  There is a new time entry rule, "Minimum Work Hours Per Day", that allows you to require that employees account for each work day, Monday through Friday. This rule is run when the timesheet is submitted, and both work and leave hours are counted when totaling the number of hours worked each day.

You can see all of the changes here:

www.pacifictimesheet.com/timesheet_support/pacific_timesheet_release_notes.htm

If you are using the online service, it will be updated to this version within a few weeks. If you are self-hosting Pacific Timesheet, you should receive an email with download instructions, or you can contact support@pacifictimesheet.com.

Pacific Timesheet Announces Shift Differential Enhancements

Additional more configurable support for shift differential regular and overtime rules.

Las Vegas, NV — February 10, 2010 — Pacific Timesheet has announced significant enhancements to its time and attendance support for shift differential regular time, shift differential overtime and shift differential double time rules.

Many union contracts and more complicated work rules require, in addition to shift differential rates or payment amounts, that workers are paid certain separate regular, overtime or double time rates for shift work. In addition, shift differential rules can require configurable definitions of which shift hours are included in these calculations, such as starting before a shift, during a shift, or the entire shift. Pacific Timesheet Time and Attendance software handles this support while providing seamless integration with more than 250 payrolls, accounting and ERP systems. Pacific Timesheet Time and Attendance software also supports an unlimited number complex shifts for any day, combinations or days and hours.

Jim Dickerson, VP of Operation stated, "Many of our customers require flexibility in shift differential software to support highly complex work and pay rules. Pacific Timesheet's highly configurable shift differential support allows for multiple shift rules, shift premiums and shift schedules."

Pacific Timesheet Time and Attendance software allows customers to track time and attendance and time off by job. With a variety of rules exceptions, such as including holidays in overtime calculations, for support for meal penalties and split shift differentials, Pacific Timesheet Time and Attendance software allow employers to track any kind of work rules and policies. Dickerson continued, "Pacific Timesheet's shift differential support provides the same ease of use and administration as our other enterprise class features. As well, our customers continue to work closely with us on our product road map to ensure the product continues to meet increasingly complex labor rules while retaining its core flexibility."

About Pacific Timesheet Enterprise

Pacific Timesheet is a leader in providing time and attendance software, time and labor tracking, timesheet software as a service and time tracking software. Its flagship product, Pacific Timesheet, provides unprecedented ease-of-use, flexibility and reliability for time and attendance, time off and absence management, payroll timesheets and project/job time tracking. Built on platform, database, and browser-independent technologies that can be implemented either on-premise or on-demand, Pacific Timesheet provides an enterprise-ready solution that is easy to use and implement for companies across the globe.

The Company is headquartered in Las Vegas, Nevada, and has offices throughout North America and Europe. Pacific Timesheet is an equal opportunity employer always in search of talented professionals interested in the development and application of proven software technologies. Pacific Timesheet's Time Management Systems are used by some of the world's leading organizations such as Applied Materials, BCD Travel, Joy Mining, Ontario Institute for Cancer Research, NOAA, New Visions for Public Schools, University of Massachusetts and many more. If you need additional information about Pacific Timesheet go to www.pacifictimesheet.com, or call 866-416-2061 ext. 1.

Time and Attendance Software

Pacific Timesheet now lets you give different colors to Holiday, Vacation, Sick and other time-off pay codes. This let's employees and managers quickly see the types of leave being taken, and is one of many nice improvements in version 6.71. For more information about our time and attendance software please visit http://www.pacifictimesheet.com.

Timesheet Leave Request Made Easy

A new feature for the upcoming 6.71 release of Pacific Timesheet (www.pacifictimesheet.com) that keeps employees from submitting leave requests if their date conflicts with existing leave requests. In addition, leave requests in the new release follow time entry rules for maximum and minimum hours. If you like you'll be able to keep employees from submitting partial day vacation requests, for instance.

Pacific Timesheet Announces California Labor Rules Enhancements

Las Vegas, NV — January 25, 2010 — Pacific Timesheet has announced that it has significantly enhanced its support for California labor rules such as meal penalty rules and split shift premium rules.

The state of California requires that certain classified non-exempt or hourly employees are paid a meal penalty equal to one regular hour of pay if they miss a meal after more than five hours of continuous work. In addition, California requires employers to pay non-exempt or hourly employees a premium if the time that lapses between shifts is more than one hour.

Jim Dickerson, VP of Operation stated, "The challenge of complying with California labor laws is not just how they are defined today. Ongoing cases each year have made complying somewhat of a moving target. Pacific Timesheet's highly configurable support for complying with these laws has been an advantage our customers with operations in California have been looking for."

According to the California Labor Code, “In California, an employer may not employ an employee for a work period of more than five hours per day without providing the employee with a meal period of not less than thirty minutes, except that if the total work period per day of the employee is no more than six hours, the meal period may be waived by mutual consent of both the employer and employee. A second meal period of not less than thirty minutes is required if an employee works more than ten hours per day, except that if the total hours worked is no more than 12 hours, the second meal period may be waived by mutual consent of the employer and employee only if the first meal period was not waived.”

Dickerson continued, “Pacific Timesheet provides support for an unlimited number of rule combinations, which includes rules for employees who sign a meal penalty waiver and those who do not sign a meal penalty waiver.” In addition, Pacific Timesheet has provided support that allows for individual meal penalty overrides or split shift overrides or waivers with a detailed comment for auditing for circumstances where the penalty or premium needs to be modified according to the California labor code. Pacific Timesheet also provides extensive support for California overtime rules, including consecutive-day overtime rules.

About Pacific Timesheet Enterprise

Pacific Timesheet is a leader in providing timesheet software as a service and time tracking software. Its flagship product, Pacific Timesheet, provides unprecedented ease-of-use, flexibility and reliability for time and attendance, time off and absence management, payroll timesheets and project/job time tracking. Built on platform, database, and browser-independent technologies that can be implemented either on-premise or on-demand, Pacific Timesheet provides an enterprise-ready solution that is easy to use and implement for companies across the globe.

The Company is headquartered in Las Vegas, Nevada, and has offices throughout North America and Europe. Pacific Timesheet is an equal opportunity employer always in search of talented professionals interested in the development and application of proven software technologies. Pacific Timesheet's Time Management Systems are used by some of the world's leading organizations such as Applied Materials, BCD Travel, Joy Mining, Ontario Institute for Cancer Research, NOAA, New Visions for Public Schools, University of Massachusetts and many more. If you need additional information about Pacific Timesheet go to www.pacifictimesheet.com, or call 866-416-2061 ext. 1.

Variable Bill and Pay Rates

Pacific Timesheet has a very flexible bill and pay rate engine. This allows you to configure your rates to depend on not just the employee or the project, but to have rates that also depend on tasks, jobs, projects or cost centers. You configure which system objects rates depend on from the System > General > Bill Rate Options and Pay Rate Options pages. For instance, you can configure bill rates to depend on the employee and project. You would then set a default bill rate on the employee’s profile (Employees tab), and add project-specific rates as needed below the profile. Note that bill and pay rates take effect for the current timesheet period and will not affect submitted timesheets.

Pacific TImesheet Customers benefitting from superior support for complex labor rules.

Las Vegas, NV - January 18, 2010 - Pacific Timesheet announces record sales and customer acquisition in its 4th quarter of 2009. New customers demonstrate the wide variety of industry and functional solutions Pacific Timesheet provides its customers. Among many others, new customers include The William J. Clinton Foundation, FMC Corporation, Openwave Systems, Bethel Church, Jewish Family Service of Los Angeles, Florida Aquarium, Township of Mahwah New Jersey, Teton Land Trust and the BC Association of Aboriginal Friendship Centres. Most customers are using Pacific Timesheet to for payroll and project time tracking, time off requests and tracking and integrating data with payroll, accounting or enterprise systems. In many cases, new customers have chosen Pacific Timesheet because of its more extensive support labor rules and policies such as California missed meal penalties and split shift premiums.

Jim Dickerson, VP of Operations stated, "During the fourth quarter of 2009 our sales grew by more than 50% over the previous quarter, indicating that even during a difficult economy there are customers who understand the cost savings from automating rules and policy processing, payroll time tracking, job costing and billing." Pacific Timesheet's existing customers continue to increase their number of U.S. and non-U.S. employees using Pacific Timesheet.


About Pacific Timesheet Enterprise

Pacific Timesheet is a leader in providing on-demand timesheet and time tracking software. Its flagship product, Pacific Timesheet, provides unprecedented ease-of-use, flexibility and reliability. Pacific Timesheet is known for its superior support of complex labor rules such as missed meal penalties, split shift premiums, shift and shift differential. Built on platform, database, and browser-independent technologies that can be implemented either on-premise or on-demand, Pacific Timesheet provides enterprise-ready solutions that are easy to use and implement for companies across the globe.

The Company is headquartered in Las Vegas, Nevada, and has offices throughout North America and Europe. Pacific Timesheet is an equal opportunity employer always in search of talented professionals interested in the development and application of proven software technologies. Pacific Timesheet's Time Management Systems are used by some of the world's largest corporations such as Applied Materials, BCD Travel, Joy Mining, NOAA and . If you need additional information about Pacific Timesheet go to www.pacifictimesheet.com, or call 866-416-2061 ext. 1.