ATS Automated Timekeeping System What is ATS n

ATS Automated Timekeeping System

What is ATS? n n Timekeeping system for US Army Corps of Engineers Management tool for Supervisors to track project funds

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

How timekeeping works n n n 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)

Timekeeping history n 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 everyone’s handwriting

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

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

Renewed requirements for ATS n n n Make it track project funds absolutely correctly Allow users to retrieve information about previous pay periods Improve User Interface Behavior

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

Before SQL Database

After SQL Database

ATS Screenshots

ATS Screenshots

ATS Screenshots

Questions?