Need someone to design a HR Database. I am open to any existing platforms if you have anything ready.
Just a quick overview of what I want.
1. Access database which will have Admin Area & Staff Area.
2. Admin logs in to input all staff data such as name, address, Date of Birth, Joining Date, Nationality, phone number, next of kin, emergency number, Passport information, Joining Date, Leaving Date, Holiday Allowance, Rate of Pay, User ID, Passcode, Contracted Working hours (per week). Admin should also have the option to set a payroll date – for example From 01/01/2019 – 31/01/2019. Upload Payslips
3. Employees signing in with their own codes from the employee area.
4. In the employee section, employee will have option to view their own individual records, such as number of hours worked, holiday entitlement, holidays taken, holidays left, any advance money they have taken etc.
5. There should be a button “Sign In/ Sign Out”. Upon hitting "Sign in" or "Sign Out", the computer records the time.
6. While doing payroll, there should be an option to generate an automated flat file in excel giving employee working hours, based on the payroll date range set by admin. And calculates pay
7. During the payroll creation, admin should also be prompted to enter Area, which will be included in the flat file, such as Holidays taken, any advance, Any sick period, Any Maternity Pay, Maternity Start Date/ End Date,
8. Admin should be able to add more details such as notes etc.
9. Some Graphical Reporting such as payroll budget, etc (not very important)
Please let me know if this is something you can do.
Create an account now and send a proposal now to get this project.Sign up
Clarification Board Ask a Question
Sam, would you require a database designed for the above requirement, or would you want the panel to be developed wherein employees can record their presence, and admin can calculate their payouts, etc.? As per the description, mere database designing may not suffice.