resume
start page
TT allows to record the time that employees have spent on tasks and generate necessary reports for any pay period. Data is collected on weekly basis (pay period) and kept for current and previous financial year for each employee. Data entering is provides by employees which fill in a Time-Sheet form on user screen. Each entry captures date, duration, project, tasks, work category, and work description (notes). Every Time-Sheet is subject for "authorization" procedure that employee's supervisor performs using "Authorization" screen. If a Time-Sheet is approved - data is sent to payroll, if not - Time-Sheet is got "reject" status and an e-mail notice is sent to certain employee. Besides this, TT stores necessary data for Human Resources, Project Managers, Supervisors and Divisional Administration. Administrative users can update sensitive information including user passwords, employee and workgroup status. TT provides multilevel access for team members, project leaders and managers, human resources, and system and divisional administration.
"Time Tracker" was realized as a LAN based (server - Novell, clients - MS Windows ) multiuser database application developed in VB 4.0 Professional Edition environment. Locating on several workstations, TT provides for end users access to the data in remote MS Access database that resides on file server. TT is compiled as 16-bit and 32-bit application .
Structure of database is based on data model that defines the logical data element relationships among persons, projects, pay periods and so on. Accordingly to this model, all data element within the database are organized into 8 tables to reflect these relationships.
The tables represent the following entities: "Persons"; "Periods"; "Projects"; "Supervisors"; "Time Sheet Entries"; "Time Sheet Complete"; "Overtime"; "Security parameters". Each table represents a different entity, which is described by different fields, every field in a table directly describes a single instance of the entity, the tables do not include repeating groups of identical fields and do not consist calculated fields - in other words database is normalized (all tables minimum are in Third Normal Form).
Procedures for maintaining, modifying database and for data manipulation are written using data definition language (DDL) methods and data manipulation language (DML) methods of data access objects (DAO) model. Data manipulation procedures also utilize so called "relational model" based on SQL statements that provide necessary data for performing TT's functional tasks.
Data reflection on user screens is provided by using data control, DAO programming interface and several bound controls shipping with VB 4.0. In addition to this, OLE control - "TrueGrid Pro 4.0" was used in the Time-Sheet form.
resume
start page