Keeping Your Data Safe
Pacific Timesheet software features that help you secure your data
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:
1. Know your password security options
Password security is among the most important aspects of keeping your system secure. Pacific Timesheet software helps enforce best practices by making sure your employees have sufficiently complex passwords, and that they change them on a regular basis. Password security options include:
- Old passwords are expired
- Passwords must be of a minimum length
- Passwords must contain upper or lower case letters
- Passwords must contain numbers
- Passwords must contain special characters such as !, #, etc.
- Employee is locked out after too many invalid failed attempts
There are more options, which you can review on the System > Security page. Also note that login (both successful and failed) are recorded in the audit log, including the IP address of remote computer. You can review the audit and login logs on the Reports page.
What the Open Web Means To Me
Mozilla.org recently asked this very important question
The idea of open systems and standards is not new but took some time to take hold. An open web of course is an important extension of that idea. For anything that extends the ability of individuals to communicate and work more productively, or stay abreast of what's important to their lives or the lives of their coleagues, family and freinds, is a force for good in this world. The essence of free markets is a free and fair exchange of ideas and information, filtered up and out rather than down and in. What I mean by that is as filters function more to include what's important to us, rather than to exclude what's noise the open web will truly become more of a reality. And in 2010 I think it's finally starting to happen. We see this with the smart search utilities of Amazon.com, social media such as Digg.com and delicious.com and others. All of these are the next generation of helping us stay abreast of what's important and think and talk about what's most important now, but what is becoming important to us, maybe even before we quite know it. At my own company, Pacific Timesheet, we work with customers and their employees on tracking time, work and leave to help them understand what is most important and what is becoming important to their company, their work and their jobs. Over time we are seeking appropriate ways to migrate social media technology into our products and services, in effect to generate a cumulative benefit that we should expect from any knowledgebase of how people spend their time. Any ideas on how you would like to see this happen at your workplace or within your company? We are all ears. We hope to get there with your help and the help of our customers and employees.
Visit Mozilla.org and tell them what the Open Web means to you:
Reporting on "Regular Hours"
What to do when regular hours include vacation, sick and 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:
ISNULL(
(SELECT SUM(te.hours) FROM t_timeentry as te
LEFT OUTER JOIN t_user AS tu ON te.userid=tu.id
LEFT OUTER JOIN t_paycode AS tp ON te.paycodeid=tp.id
WHERE tu.fullname=t_user.fullname
AND te.strt>=$P{startDate}
AND te.strt<$P{finishDate}
AND te.type='Leave'
AND tp.name NOT IN ('Unpaid Time Off')),0)
+ISNULL(
(SUM(t_timeentry.paycode1)),0)
The above expression adds all leave hours except for the one named 'Unpaid Time Off', as well as the regular time hours (t_timeentry.paycode1). You would change the name 'Unpaid Time Off' to whatever pay code name you use for non-paid work hours. The ISNULL function is a standard SQL function that will handle null values by returning zero. Note that the above expression has been tested with SQL Server but could require changes for MySQL or Oracle.