We need a time clock program. Employees will use an iPad to clock in and clock out. It will need to use a SQL database. We use SQL server 2003. The database needs to have places for first name, last name, address, phone number, hire date, full time/part time, and work schedule.
1). Place for employee information screen on computer side of program
2) reports for each individual employee and cumulative reports giving regular hours, and overtime hours. Also exceptions database and correlation with work schedule.
3). Employees will clock in on an iPad or iPad mini. Each employee will have an employee Id number and password that will be set by us.
4). I need to have an admin access panel to be able to access the data from office staff iPads and hr iPads.
5). We need to be able to efficiently provide scheduling for each employee with ease and quickness from both PCM and iPad along with recall scheduling from previous week.
6) graphs that break down employee hours per week month and year. Both regular time and overtime.
7). Needs to be able to recall data quickly and efficiently.
8) employee clock in must be quick and efficient and in real time. Clock iPad must hold all data and must act as a backup I case server is down and must sync with server in real time.
9) exception reports need to auto generated and emailed for employees who go over hours or miss scheduled days.
10) access ip will be a dans forwarding service like dyndns or no-ip. Needs to have settings to put this in.
11). There needs to be the ability to put logins into the system to control access.
12). Need to be able to edit employee time for any day of the week and any employee.
13) need to able to print all data with well formatted reports
If anything comes up we will post clarifications.
I WILL NOT WIRE MONEY OUTSIDE OF FREELANCER. SO DO NOT ASK. THOSE WHO ASK FOR MONEY OUTSIDE OF FREELANCER WILL BE REPORTED!