All About Extraction

(Read the newsletter containing this article.)

The word “Extraction” can mean many different things. If you’re a dentist, it means pulling a tooth; if you’re a soldier, it means removing someone from a hostile area. And if you’re a TimePilot user, it means something totally different, but equally important.

As employees clock in and out of your system, their clock-ins and clock-outs accumulate in TimePilot’s Current Transactions database on your PC or server. They build up fast: If you have 15 employees, all of whom clock in or out four times a day (“in” to start work, “out” for lunch, “in” after lunch and “out” at the end of the day), that’s 60 transactions a day, 300 a week, 1,200 a month, more than 14,000 a year.

Too many transactions in the database slow down the TimePilot software, as well as making it extremely unwieldy for supervisors to use. (Would you want to scroll through a thousand transactions to see when an employee clocked in nine months ago?)

That’s why we strongly recommend extracting your transactions at the end of your pay period. When you do this, you remove the transactions that occurred between two times and dates (usually the start and the end of your pay period) from Current Transactions and place those transactions in a separate database. From there, you can run reports, make corrections to individual transactions, etc.

To visualize the concept, imagine the database is a huge pot. Every day, the TimePilot timeclocks dump more clock-ins and clock-outs into the pot. Now it’s the end of a two-week pay period, so you want to remove just clock-ins and clock-outs for the last two weeks from the pot. With the TimePilot Central software, you “extract” just those transactions and move them to a separate, smaller pot. In the smaller pot, it’s much easier to see what you have and it keeps the big pot from eventually overflowing.

There are other benefits to extracting your transactions, too:

• It keeps all the transactions for one pay period in one place.
• Along with the saved transactions, it also saves all the software settings—overtime policy, shifts, employee profiles, etc.—that were in effect at the moment you extracted the period. This is important because if you later make changes to your company's work policies while working in Current Transactions, those changes will not affect any extracted periods. For instance, the software will prevent you from deleting an employee until that employee's transactions have been extracted from Current Transactions. If the software didn't do this, and you deleted an employee, you'd have "orphan" transactions—transactions without an owner.
• It enables you to save those transactions to a CD or backup drive.

Extracting a pay period is a simple process. Here’s how:

1. Start TimePilot Central
2. Click the “Periods” menu, then “Begin Extraction…”
3. Choose the company and the start and end dates and times in the pop-up box and then click “Begin Extraction.”

Questions and answers

Q. How do I view an extracted pay period?

A. Start TimePilot Central, click the “Periods” menu, then click “Open Past Time Period…” Choose your period (they’re listed by date) and click OK.

Q. How do I know whether I’ve opened my Current Transactions or an extracted pay period?

A. If you’re in Current Transactions, you’ll see a green bar across the top of the transactions in TimePilot Central; if you’re in an extracted pay period the bar will be yellow. Also, the title bar at the top of the TimePilot Central screen will contain the words "Current Transactions" or the dates of the extracted pay period.

Q. I extracted a pay period, but I got the dates wrong. What can I do?

A. You can return the extracted transactions to the database and re-extract with the correct dates. It’s called a “reverse extraction” and, using the concept mentioned above, it’s like dumping those incorrectly extracted transactions back into the soup pot and starting over. To perform a reverse extraction, open the incorrect extracted pay period in TimePilot Central, then click the “Administrative” menu and choose “Reverse Extraction.” When that's complete, extract again, this time using the correct dates.

Return to list of articles.