GetAFreelancer.com - 1 Report for attendance database

1 Report for attendance database

1 Report for attendance database is project number 165290 posted at GetAFreelancer.com. Click here to post your own project.

Closed
(Selected Service Provider netcoder)

Status: Closed

Budget: $30-100

Created: 08/04/2007 at 15:49 EDT

Bidding Ends: 08/06/2007 at 15:49 EDT

Project Creator: peterclam
Buyer Rating:
(1 reviews)

Description: 1 Report module to be created for attendance database

General requirements:
1. User does not own MS Access, reports needs to be generated as a pdf automatically every business day
2. If additional library is needed, those library needs to be included as deliverable
3. Version of MS Access is 2000
4. All Source code will be delivered and tested before payment is paid
5. If code is delivered in 2 days upon approval, an additional $50 bonus will be granted

Report requirements:
1. Attendance and entry exception report (for previous and current month)
1a. The report needs to sort out repetitive records within X minutes (ie, 5 min)
For example,
20070806 09:04am | login
20070806 09:05am | login
20070806 09:06am | login
In this case, 20070806 09:04am | login should be used as the login record

1b. The report needs to alert the employee administrator on un-matching records
For example,
20070806 09:04am | login
20070806 12:23pm | logout
20070806 18:33pm | logout
In this case, 20070806 18:33pm | logout should be alerted as an orphan record in the report

1c. The report needs to sort out errorous records within X minutes (ie, 5 min)
For example,
20070806 09:04am | login
20070806 09:05am | logout
20070806 12:23pm | logout
In this case, 20070806 logout should be ignored

1d. Report
Sample data:
20070806 09:04am | login
20070806 09:05am | login
20070806 09:06am | login
20070806 09:04am | login
20070806 12:23pm | logout
20070806 18:33pm | logout

Summary:
Month | User | Worktime
200708 | Jane Doe | 180:30 (hr:mm)
200708 | John Doe | 158:23 (hr:mm)

Detail
Jane Doe
Date | worktime
20070801(Wed) | 8:15 (hr:mm)
20070802(Thu) | 8:02 (hr:mm)
20070803(Fri) | 8:10 (hr:mm)
20070806(Mon) | 3:19 (hr:mm) with Exception (Orphan records)

John Doe
Date | Worktime
20070801(Wed) | 8:15 (hr:mm)
20070802(Thu) | 8:02 (hr:mm)
20070803(Fri) | 8:10 (hr:mm)

...

1e. There may be other exception that needs to be handled.

Job Type:

.NET
Data Processing
Visual Basic

Database: MS Access

Operating system: MS Windows

Bid count: 4

Average bid: N/A

Related project

ONLINE & DISTRIBUTABLE SOFTWARE GAME ^Featured

posted by oceanpro
Budget: $1-300

Messages Posted: 2

If you are the project creator or one of the bidders for more options

Service Providers	PMB	Bid	Delivery Within	Time of Bid	Provider Rating
Bids are hidden by project creator. as the project creator or as one of the bidders to view bids.

[ Web Forms ] [ Join GAF Free ] [ View All Projects ] [ Web Development ] [ Outsourcing ] [ Secure Forms ]

What is GetAFreelancer.com? ( Read about the company )

Outsourcing is hiring an outside organization to perform services such as information processing and applications development. Our mission is to find the best possible freelance workers at the best possible price. Deposit money and don't purchase until your project is completed.

Bookmark our homepage to make sure you don't forget about our website next time you need to develop an IT project for yourself or your company. We provide a safe escrow environment and you don't release the money until project is completed. Our site is global and we have freelancers from India, Romania, Russia, Ukraine, United States, UK and many other parts of the world.

Find Webmaster Resources and Webmaster Forum. Take a look at Search Engine Submission.