ATS

1
ATS

• Automated Timekeeping System

2
What is ATS?

• Timekeeping system for US Army Corps of Engineers
• Management tool for Supervisors to track project
  funds

3
Why ATS?

• Primary development drivers
• Track Project charges
• Provide printable timesheets
• Secondary benefit
• A single point of entry for timekeepers

4
How timekeeping works

• Each employee has a timekeeper
• Timekeeper receives a timesheet from each
  employee
• Timekeeper checks it for corectness and it is
  signed by the supervisor and the employee
• Timekeeper enters the information into CEFMS
  (Corps of Engineers Financial Management System)
• Timekeeper deals with any issues regarding money
  and schedules (PT/FT)

5
Timekeeping history

• First Paper timesheets filled by hand
• Timekeeper has to go to each employee
  individually
• No way to know if there will be enough money
  until crunch time
• Timekeeper has to deal with everyones handwriting

6
Timekeeping History

• ETS (Electronic Timekeeping System)
• Access
• Issues
• Data Consistency
• User Interface
• Speed
• Single point of entry for Timekeepers and users
• Could track project charges somewhat, not very
  accurate
• Produced printable timesheets

7
Timekeeping History

• ATS Version 1
• Visual Basic 6.0
• SQL Server back end
• Issues
• User Interface Issues
• Database Non-viable
• Functional Difficulties
• Still a single point of entry
• Tracked Project charges more closely
• Produced printable timesheets

8
Renewed requirements for ATS

• Make it track project funds absolutely correctly
• Allow users to retrieve information about
  previous pay periods
• Improve User Interface Behavior

9
Development Hurdles

• Database was non-viable to make these changes
• Third-party controls sometimes has unexpected
  behavior
• Constricted development team schedule

10
Before SQL Database
11
After SQL Database
12
ATS Screenshots
13
ATS Screenshots
14
ATS Screenshots
15
Questions?