Project: Time Off Reporting

Organization

Interactive Intelligence*, a manufacturer of business interaction management software for contact centers, enterprises, and service providers.

Project Description

Interactive Intelligence needed a way to track the time off (vacations, sick time, etc.) taken by each of their approximately 400 employees. The company had outgrown its casual, e-mail-based system and required something more robust and reliable. An important feature of the new system would be to enable employees to enter their own time off reports via the company's intranet web site.

Solution

Paul Woods created the Time Off Reporting System on the company's intranet web site using Active Server Pages integrated with a SQL Server 2000 database. The system had the following features:

• Employees could report time off, associate each report with the appropriate time off category, and see how much time off they had reported in each category for the year. They could also see a complete list of all time off reported for any year since the system went into operation, and whether those reports had been entered into the company's payroll system.
• Supervisors were able to view the time off reports of each member of their team and had the ability to enter time off reports for them as well. Supervisors also received an e-mail notification whenever a team member reported time off.
• Administrators were able to view the time off reports of any employee in the system, as well as those of terminated employees. Reports could be run that showed which time off reports still needed to be entered into the payroll system, and allowed administrators to mark them as "entered" once that had been done. Reports were also available that would list the time off taken by all employees in a given time off category for a given time period. Administrators also had the ability to leave notes for individual employees via the system and could manage supervisor/employee relationships as well.

The Time Off Reporting System was a vast improvement over the previous methods used and resulted in huge time savings for the company's Human Resources staff.

* Unless otherwise noted, projects at Interactive Intelligence were performed by Paul Woods as a full-time employee of the company. See Paul's resume for details.