TimePilot Central Tips and Tricks: Guide to Column Headers

(Read the newsletter containing this article.)

In our last issue, we listed all the icons that can appear in the first or second column of TimePilot Central’s Transaction Manager and explained what they mean. If you missed that issue, it’s here.

This time we’ll run down the column headers that can appear in Transaction Manager. You probably won’t see all of them when you start the software, but you can add and subtract them to see exactly the data you want to see. There are two sets of headers; one set accompanies transactions; the other accompanies your employees’ profiles.

Transaction List headers

In this article, we’ll concentrate on the set of headers that accompanies transactions. First, a few facts:

  • Available Transaction List columnsThe headers appear in the green or yellow bar at the top of the list of transactions. If the bar is green, that’s an indication that you’re looking at Current Transactions. If it’s yellow, you’re looking at the transactions in an Extracted Pay Period. (What’s an Extracted Pay Period? Click here to find out.)
  • You can add and subtract headers by clicking on the “View” menu in the menu bar and then clicking “View/Hide Columns – All… .” Another way to see the list of headers is to right-click the green or yellow bar.
  • You can sort your data by clicking some of the headers. The “Date” column lists the transactions in chronological order. If you click the Date header, the transactions will sort oldest to newest; click it again, and it will re-sort, newest to oldest. Other headers that will sort are “Reg. T” (Regular time), “Reg. Ttl” (Regular Total), all the OT (Overtime) totals, all the PR totals (Pay Rate). If you want to sort other columns, you can export your transactions to a spreadsheet and sort all you want. (http://www.timepilot.com/links.htm#Microsoft_Excel)
  • You can add and subtract columns as much as you want. You won’t delete or alter any data by doing so.

Now let’s take a look at the possibilities. You can get a short description of each header by placing your cursor on the header. A tooltip will appear with an explanation. Here’s the rundown, from left to right:

Heading Meaning
OK Transactions approved by supervisor
Blank In/Out Status
Date Date of Transaction
Date w/R Date with Rules Applied
Day Day of the Week with Rules applied
Time w/R Time with Rules applied
+Time Amount of time inserted
Lunch Time subtracted for lunch
TransType Type of Transaction
Trans Total time between in and out transactions
Daily Total time for the day
Weekly Total time for the week
Running Running total of time since the first transaction
Reg. T Regular Time amount
OT1, OT2, OT3 First tier, second tier and third tier of overtime hours
PR4, PR5, PR6 Pay Rates 4, 5 and 6
Reg. Ttl Regular time total
OT1Ttl, OT2Ttl, OT3Ttl Total of overtime hours in first, second and third tiers
PR4 Ttl, PR5 Ttl, PR6 Ttl Total of pay rates 4, 5 and 6
Ignore If box is checked, transaction is ignored when calculating hours
Inserted If box is checked, transaction has been inserted by a supervisor
Snap If box is checked, this transaction has been snapped as specified in the Snap-To setup
On-Time Gives late/early status
Note If a note icon appears, there’s a note accompanying this transaction. Double-click the icon to read it.
+Pay Bonus pay
Clock Name Name of clock where transaction took place
Name of Employee Name of employee
Location Location of employee, as specified in his/her profile
Department Employee’s department, as specified in his/her profile
Company Employee’s company, as specified in his/her profile
Shift Employee’s shift, as specified in his/her profile
SnapToEnable Snap-To is turned on for this employee in his/her profile

Return to list of articles.