Board of Investments of Sri Lanka: Attendance Recording System

Abstract

This Final Report was generated by Ms. A.E.S. Ekanayake of the M. Sc. in Information Technology batch-2, which describes the Attendance Recording System project undertaken for the Board of Investment of Sri Lanka. Entire process is divided as five modules or sub processes as Data Entry Module, File Maintenance Module, Inquiry Module, Overtime Calculation Module and Report Generation Module. Attendance Recording System takes in the employee time in and time out data to calculate the daily attendance records. The new system enhances the existing functionalities of the Attendance Recording System and adds more capabilities The recorded attendance details directly affect the employee pay and incentives. Visual Basic 6 is used as the front end tool and SQL Server 2000 as the back end database. In addition to these the Crystal Report 8 is used to give the reporting aspect of the system more flexibility and dynamic query ability. Thus the developed system is more technologically advanced, efficient, and compatible with other systems already developed and deployed in the BOI as well as being more user-friendly. As special features, it focuses on special adjustments the employees can make in their attendance records. Moreover, the short leave is automatically calculated except for the short leave taken during the lunch break, which can be entered in to the system manually by using the interface provided. Furthermore, special excuse dates for which all the employees are excused for late arrival regardless of their categories are taken into consideration. In addition to these the Breast Feeding Mothers approved daily late or early leave of one hour is automatically updated for six months. The system focuses on file maintenance of the related database. One of the most important characteristic is the reporting part of the system. This adds value to the system as the user can dynamically query to retrieve a report in predefined formats. All the project goals, which were set, were achieved in terms of Data Entry, File Maintenance, Inquiry, Overtime Calculation and Report Generation. Thus, adding value, efficiency and effectiveness, by streamlining the Attendance Process through this project.