Implementation

The system is thoroughly atomized using FoxPro 6.0. The reason why we chose this package is that FoxPro 6.0 is the object-oriented database management system that allows you to create state-of-the-art enterprise database solutions. Besides being a member of the Visual Studio 6.0 family of development products, FoxPro provides all the tools you need to manage data, whether you are organizing tables of information and running queries, creating an integrated relational database system, or programming a fully-developed data management application for end users.

Process

As described in the E-R Diagram, presently, the below listed processes will be taken care by our product.

Maintaining Employee Personal Data:

Through this process, the HR personnel will be able to add, modify or delete an employee’s personal data in the system. Addition of data occurs when any employee joins the organization. When an employee gets promoted or transferred between departments, his records will be updated and an employee record will be deleted when he resigns from the company. When an employee’s record is modified or deleted, a copy of the record will be updated to Personnel Archive
file for future reference. So At any point of time the Employee data base reflect the current data.

Process:

Addition of new employee detail.
Modification of existing employee detail.
Deletion of resigned Employee detail

Tables: Employee.dbf, Employee_archive.dbf

Preparing Employee Pay-slip and recording salary paid

Each month the employee’s will gets his salary through electronic fund transfer from the company. So a pay slip will be presented to each employee for his reference/record of salary, Besides, every month the accounts department will be provided with salary report for the current month to credit account of the respective employee. If the employee has to pay a loan due, it wil l be reduced from his salary and properly credited to his loan account.

Process: Generation of pay slips and salary report.

Tables: Employee.dbf, Salary.dbf, Allowances.dbf and Loan.dbf.

Sanctioning Loan to an Employee and Recouping it
An employee can claim a loan from the company during his service period. If management sanctions loan, the employee’s loan account will be debited with the total amount sanctioned. The installments amount will be fixed subjectively by the Accounts Manager. This installment amount will be credited to an employee’s loan account every month after properly deductiing from his salary. An employee will be allowed to take up a only one loan at a time.

Process: Sanctioning Loan and Collecting Installments

Tables: Loan.dbf, Salary.dbf, Employee.dbf.

Data Dictionary

Table : Employee
Data Type Descriptin
EID NUMBER Employee Identification Number
ENAME TEXT Name of the employee
EADDR TEXT Address of the Employee
EDOB DATE Employee’s date of birth
EDOJ DATE Employee’s date of joining the company
EDEPT TEXT Employee’s current department
EGRADE NUMBER Level of authority
ETITLE TEXT Designation Occupied
EBASIC NUMBER Basic Pay
EQUALIF TEXT Academic Qualification

Table: Employee Archive
Data Type Description
EID NUMBER Empoyee Identification Number
ENAME TEXT Name of the employee
EADDR TEXT Address of the Employee
EDOB DATE Employee’s data of birth
EDOJ DATE Employee’s date of joining the Company
EDEPT TEXT Employee’s current department
EGRADE NUMBER Level of authority
ETITLE TEXT Designation Occupied
EBASIC NUMBER Basic pay
EQUALIF TEXT Academic Qualification
UPDATED DATE Updated date

Table: Salary
Data Type Description
EID NUMBER Empoyee Identification Number
EDEPT TEXT Department attached to
EGRADE NUMBER Level of authority
ETITLE TEXT Designation of Employee
EBASIC NUMBER Basic payment
DA NUMBER Dear ness allowance percent
HRA NUMBER House rent allowance percent
DEDUCT NUMBER Deductions if any
LOANCODE NUMBER Loan code if deduction made
MONTH NUMBER Month of payment
YEAR NUMBER Year of payment

Table : Allowance
Date Type Description
GRADE NUMBER Level of authority
DA NUMBER Dear ness allowance percent
HRA NUMBER House rent allowance percent

Table : Loan Transaction
Date Type Description
LOANCODE NUMBER Loan code if deduction made
EID NUMBER Employee Identification Number
STDATE DATE Loan sanction date
LOANAMT NUMBER Amount sanctioned
PAIDAMT NUMBER1 Amount paid by employee
DEDUCT NUMBER Deductible amound

Table : Loan Transaction
Date Type Description
LOANCODE NUMBER Loan code if deduction made
EID NUMBER Employee Identification Number
STDATE DATE Loan sanction date
LOANAMT NUMBER Amount sanctioned
DEDUCT NUMBER Deductible amount
EDDATE DATE Loan fully repaid date