Create a single online portal which will utilize multiple online databases, that all communicate and work together on a single MAC OSX Server, that have very detailed calculation, reporting and printing abilities used to manage all employee info, time sheets, payrol calculations and government remittances.? I would like it to be built modularized, so if we need to build new pieces in the future, we only need to develop the new module.
1: Employee Tracker
• Employees can have access to their own record, but not able to edit any of the information. • Employees supervisors can have access to the records of the employees they are over, but not able to edit any of employee's the information, other than their timesheets. • Only HR and Managers are able to create and modify records, but are not able to delete any records • Only Admin are able to access every privilege and have the ability to delete records if necessary. • Abbreviated Full Name: Uneditable, only calculated from Following Fields: (ie: Moore II, James E.) • Employee Picture • Employee Number: (Auto Generated) • Employee Status: (Options: • Hire Date • Termination Date • Campaign Assignment: (Options generated from client database) • First Name • Middle Name • Last Name • Suffix • TIN Number: (Format, ###-###-###) • SSS Number: (Format, ##-#######-#) • Pag-Ibig Number: (Format, ####-####-####) • Philhealth Number: (Format, ##-#########-#) • Date of Birth (Calendar Select) • Sex (Options: Male, Female) • Civil Status (Options: Z, S, M, S1, M1, S2, M2, S3, M3, S4, M4) • Address • Phone Number • Alternate Number 2: Employee Work Schedule • Employee can request time off • Employee can request to change a scheduled work day with another employee 3: Time Clock Tracker
• Clock In • Clock Out • Track Pay period Hours worked by Employee • Track Pay period Hours worked by Campaign (Admin Only) • Track Pay period Hours worked by Company (Admin Only) 4: Time Card Generator
• Generate Time Clock Reports (Admin Only) • Generate Time Sheets for previous pay period, printable for signoff) 5: Commission Tracker
• Commission are earned weekly, but are paid out each payday. • In order for an employee to qualify for his or her commission, they must not be late for work during the week. There is a 1x exception of upto 10min, but only once in any given week. Otherwise they do not qualify. • AHT: Goal/Actual - Amount Earned • Compliance: Goal/Actual - Amount Earned • Quality: Goal/Actual - Amount Earned 6: Payroll Calulator • I will provide the necessary calculation formulas to the winning bidder • Payperiods are 26-10, payable on the 15th, 11-25 on the last day of the month, unless one of those days are a weekend or a holiday, and then its paid on the previous business day. • I will need a report generated with 4 figures, Total SSS to Remit, Total Pag-ibig to Remit, Total Philhealth to Remit and Total Witholding Tax to Remit • I need to have the ability to select any date in a pay period as a holiday if necessary, as its common for the Philippines to introduce a new special holiday at Random. Here are a list of the current Holidays for 2011: ** Regular Holidays ** • New Year’s Day ??" January 1 (Saturday) • Araw ng Kagitingan ??" April 9 (Saturday) • Maundy Thursday ??" April 21 • Good Friday ??" April 22 • Labor Day ??" May 1 (Sunday) • Independence Day ??" June 12 (Sunday) • National Heroes Day ??" August 29 (Last Monday of August) • Bonifacio Day ??" November 30 (Wednesday) • Christmas Day ??" December 25 (Sunday) • Rizal Day ??" December 30 (Friday) ** Special (Non-Working) Days ** • Ninoy Aquino Day ??" August 21 (Sunday) • All Saints Day ??" November 1 (Tuesday) • Last Day of the Year ??" December 31 (Saturday) ** Here is how the Holidays need to be calculated ** • [url removed, login to view] 7. Pay Slip Generator I will provide the payslip template Currently I do this entire process manually, using 9 Microsoft Spreadsheets to calculate everything for me.? I will be attaching the spreadsheets that I use and will go over them in extreme detail with the person whom I award this project to.
Mac OS X Server HTML CSS MySQL PHP Flash or Cold Fusion (Doesn't matter, as long as everything looks good, works well, and produces the necessary reports)