Timecard Transactions

The Timecard Transactions entity provides detailed data related to each timekeeping transaction. It provides a row for each employee and each day, for all types of timecard transactions, such as Worked Shift Segment, Paycode Edit, Absence Exception, Historical Correction, and Hours Worked, and Overtime Approvals.

The Timecard Transactions entity enables a manager to view the actual duration and wages related to a timecard transaction. In addition, it makes available the paycode name and associated comments that are related to the transaction. You can also view the data in the Timecard Transactions entity by worked job or worked labor category when it is used with the Worked Job and Labor Category entity, respectively. It also allows you to see the in- and out-punches for a shift along with geolocation details related to each punch.

When you use data columns from the Timecard Transactions entity, you must include the Transaction Type data column. This data column is parameterized and requires you to select the desired types of transactions to include in the data it returns. Choose from the following options:

Transaction Type Description
Absence Exceptions Transaction type that returns excused and unexcused absence exceptions
Historical Correction Transaction type that returns Historical Correction transactions performed during the selected time period
Hours Worked

Transaction type that returns only Hours Worked transactions
Overtime Approvals

Symbolic transaction type that returns all Pending Overtime, Overtime Approval, and Overtime Denial transactions
Paycode Edit Transaction type will return only actual Paycode Edit transactions
Raw Total Transaction type that returns the totals as produced by the Totalizer. Data is returned for each worked span by employee, paycode, worked job, worked labor category, worked cost center, and worked work rule.
Raw Total By Calendar Day

Transaction type that returns the same data as the Raw Total transaction type, but worked spans that cross midnight will be split to provide the totals per day, regardless of the employee’s pay rule. Data is returned for each worked span by employee, paycode, worked job, worked labor category, worked cost center and worked work rule.
Raw Totals

Symbolic transaction type that returns all Raw Total and Raw Total By Calendar Day transactions
Time Detail

Symbolic transaction type that returns all Worked Shift Segment, Paycode Edit, Absence Exception, Historical Correction, Hours Worked, and Worked Holiday Edit transactions
Worked Holiday Edit Transaction type that returns only Worked Holiday Edit transactions
Worked Shift Segment

Transaction type that returns only Worked Shift Segment transactions
Employee Dataview Business Structure Dataview
X  

Provides one row per employee per timecard transaction type per date.

Label Description Key

Actual Days

  

TIMECARD_TRANS_ACTUAL_DAYS

Actual Hours

  

TIMECARD_TRANS_ACTUAL_HOURS

Actual Wages

  

TIMECARD_TRANS_ACTUAL_WAGES

Apply Date

  

TIMECARD_TRANS_APPLY_DATE
Calendar Date The calendar date to where this transaction was applied. TIMECARD_TRANS_CALENDAR_DATE

Comments Text

  

TIMECARD_TRANS_COMMENTS

End Date Time

  

TIMECARD_TRANS_END_DATETIME
End Date Time (Rounded) The rounded date and time of the employee’s out punch. TIMECARD_TRANS_END_DATETIME_ROUNDED
End Time End Time of the Timecard Transaction. TIMECARD_TRANS_END_TIME
End Time (Rounded) The rounded time of the employee’s out punch. TIMECARD_TRANS_END_TIME_ROUNDED
In Punch Accuracy The accuracy of an employee's in punch. IN_PUNCH_ACCURACY

In Punch Exceptions

Note: The Assignment must be set to Time Detail in order to use this column.

TIMECARD_TRANS_IN_EXCEPTIONS
In Punch Geofence Method Indicates how the geofence status of an employee's in punch was determined. IN_PUNCH_GEOMETHOD
In Punch Geolocation A concatenated string of the latitude, longitude, and accuracy coordinates of an in punch. IN_PUNCH_GEOLOCATION
In Punch Is Unverified Indicates if the employee's in punch has been verified against the defined known locations or not. IN_PUNCH_IS_UNVERIFIED
In Punch Known Place The name of the Known Place (when the in punch is determined to be inside a Known Place). IN_PUNCH_KNOWNPLACE
In Punch Latitude The latitude of an employee's in punch. IN_PUNCH_LATITUDE
In Punch Longitude The longitude of an employee's in punch. IN_PUNCH_LONGITUDE
In Punch Outside of Geofence Indicates if the employee's in punch was outside or inside the defined geofence. IN_PUNCH_OUTSIDE_GEOFENCE
In Punch QR Code The name of the QR Code (when the in punch “Geofence Method” == “QR Code”). IN_PUNCH_QRCODE
In Punch WiFi Access The name of the WiFi Access Point (when the in punch “Geofence Method” == “WiFi”). IN_PUNCH_ACCESSPOINT
In Punch WiFi Network The name of the WiFi Network (when the in punch “Geofence Method” == “WiFi”). IN_PUNCH_WIFINETWORK
Include In Totals Indicator Indicates if the historical correction made to the timecard is included in the calculated totals. TIMECARD_TRANS_INCLUDE_TOTALS

Original Days

  

TIMECARD_TRANS_ORIGINAL_DAYS

Original Hours

  

TIMECARD_TRANS_ORIGINAL_HOURS

Original Transaction Date

  

TIMECARD_TRANS_ORIGINAL_DATE

Original Wages

  

TIMECARD_TRANS_ORIGINAL_WAGES
Out Punch Accuracy The accuracy of an employee's out punch. OUT_PUNCH_ACCURACY

Out Punch Exceptions

Note: The Assignment must be set to Time Detail in order to use this column.

TIMECARD_TRANS_OUT_EXCEPTIONS
Out Punch Geofence Method Indicates how the geofence status of an employee's out punch was determined. OUT_PUNCH_GEOMETHOD
Out Punch Geolocation A concatenated string of the latitude, longitude, and accuracy coordinates of an out punch. OUT_PUNCH_GEOLOCATION
Out Punch Is Longitude The longitude of an employee's out punch. OUT_PUNCH_LONGITUDE
Out Punch Is Unverified Indicates if the employee's out punch has been verified against the defined known locations or not. OUT_PUNCH_IS_UNVERIFIED
Out Punch Known Place The name of the Known Place (when the out punch is determined to be inside a Known Place). OUT_PUNCH_KNOWNPLACE
Out Punch Latitude The latitude of an employee's out punch. OUT_PUNCH_LATITUDE
Out Punch Outside of Geofence Indicates if the employee's out punch was outside or inside the defined geofence. OUT_PUNCH_OUTSIDE_GEOFENCE
Out Punch QR Code The name of the QR Code (when the out punch “Geofence Method” == “QR Code”). OUT_PUNCH_QRCODE
Out Punch WiFi Access The name of the WiFi Access Point (when the out punch “Geofence Method” == “WiFi”). OUT_PUNCH_ACCESSPOINT
Out Punch WiFi Network The name of the WiFi Network (when the out punch “Geofence Method” == “WiFi”). OUT_PUNCH_WIFINETWORK

Paycode Name

  

TIMECARD_TRANS_APPLY_TO
Reviewed Date Date in which the Timecard Transaction was performed. TIMECARD_TRANS_UPDATE_DATETIME
Reviewer Name Name of person who reviewed the Timecard Transaction. TIMECARD_TRANS_UPDATE_USER

Start Date Time

  

TIMECARD_TRANS_START_DATETIME
Start Date Time (Rounded) The rounded date and time of the employee’s in punch. TIMECARD_TRANS_START_DATETIME_ROUNDED
Start Time Start Time of the Timecard Transaction. TIMECARD_TRANS_START_TIME
Start Time (Rounded) The rounded time of the employee’s in punch. TIMECARD_TRANS_START_TIME_ROUNDED

Transaction Type

  

TIMECARD_TRANS_TRANSACTION_TYPE
Wage Paycode Name The name of the Wage Paycode associated with the transaction TIMECARD_TRANS_WAGE_PAYCODE_NAME

Work Item ID

  

TIMECARD_TRANS_WORK_ITEM_ID

Work Rule Name

  

TIMECARD_TRANS_WORK_RULE

The Timecard Transactions entity provides two special Transaction Types named Raw Total and Raw Total by Calendar Day.

The Raw Total transaction type returns the raw data generated by the Totalizer at the worked span level. The data is provided by Employee, Paycode, “Worked” Job, “Worked” Labor Category, and “Worked” Work Rule. The Raw Total by Calendar Day transaction type is similar, except that it splits totals for worked spans that cross midnight into separate totals and ignores the employee’s assigned Pay Rule.

 

Employee Organization Day Organizational Job Paycode Labor Category
X   X X X X
One-to-One One-to-Many
  X