Project Detail

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.