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

Data Granularity

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

Supported Dataview/RDO Type

Employee Business Structure Employee - Time Series Business Structure - Time Series Work Unit Work Unit - Time Series

Columns
Actual Days TIMECARD_TRANS_ACTUAL_DAYS Number No
Actual Hours TIMECARD_TRANS_ACTUAL_HOURS Number No
Actual Wages TIMECARD_TRANS_ACTUAL_WAGES Number No
Apply Date TIMECARD_TRANS_APPLY_DATE Date No
Calendar Date The calendar date to where this transaction was applied TIMECARD_TRANS_CALENDAR_DATE Date No
Comments Text TIMECARD_TRANS_COMMENTS String No
End Date Time TIMECARD_TRANS_END_DATETIME DateTime No
End Date Time (Rounded) The rounded date and time of the employee's out punch TIMECARD_TRANS_END_DATETIME_ROUNDED DateTime No
End Time End Time of the Timecard Transaction TIMECARD_TRANS_END_TIME Time No
End Time (Rounded) The rounded time of the employee's out punch TIMECARD_TRANS_END_TIME_ROUNDED Time No
In Punch Accuracy The accuracy of an employee's in punch IN_PUNCH_ACCURACY Number No
In Punch Exceptions TIMECARD_TRANS_IN_EXCEPTIONS String No
In Punch Geofence Method Indicates how the geofence status of an employee's in punch was determined IN_PUNCH_GEOMETHOD String No
In Punch Geolocation A concatenated string of the latitude, longitude, and accuracy coordinates of an in punch IN_PUNCH_GEOLOCATION String No
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 Boolean No
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 String No
In Punch Latitude The latitude of an employee's in punch IN_PUNCH_LATITUDE Number No
In Punch Longitude The longitude of an employee's in punch IN_PUNCH_LONGITUDE Number No
In Punch Outside of Geofence Indicates if the employee's in punch was outside or inside the defined geofence IN_PUNCH_OUTSIDE_GEOFENCE Boolean No
In Punch QR Code The name of the QR Code (when the in punch “Geofence Method” == “QR Code”) IN_PUNCH_QRCODE String No
In Punch WiFi Access The name of the WiFi Access Point (when the in punch “Geofence Method” == “WiFi”) IN_PUNCH_ACCESSPOINT String No
In Punch WiFi Network The name of the WiFi Network (when the in punch “Geofence Method” == “WiFi”) IN_PUNCH_WIFINETWORK String No
Include In Totals Indicator Indicates if the historical correction made to the timecard is included in the calculated totals TIMECARD_TRANS_INCLUDE_TOTALS Boolean No
Original Days TIMECARD_TRANS_ORIGINAL_DAYS Number No
Original Hours TIMECARD_TRANS_ORIGINAL_HOURS Number No
Original Transaction Date TIMECARD_TRANS_ORIGINAL_DATE Date No
Original Wages TIMECARD_TRANS_ORIGINAL_WAGES Number No
Out Punch Accuracy The accuracy of an employee's out punch OUT_PUNCH_ACCURACY Number No
Out Punch Exceptions TIMECARD_TRANS_OUT_EXCEPTIONS String No
Out Punch Geofence Method Indicates how the geofence status of an employee's out punch was determined OUT_PUNCH_GEOMETHOD String No
Out Punch Geolocation A concatenated string of the latitude, longitude, and accuracy coordinates of an out punch OUT_PUNCH_GEOLOCATION String No
Out Punch Is Longitude The longitude of an employee's out punch OUT_PUNCH_LONGITUDE Number No
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 Boolean No
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 String No
Out Punch Latitude The latitude of an employee's out punch OUT_PUNCH_LATITUDE Number No
Out Punch Outside of Geofence Indicates if the employee's out punch was outside or inside the defined geofence OUT_PUNCH_OUTSIDE_GEOFENCE Boolean No
Out Punch QR Code The name of the QR Code (when the out punch “Geofence Method” == “QR Code”) OUT_PUNCH_QRCODE String No
Out Punch WiFi Access The name of the WiFi Access Point (when the out punch “Geofence Method” == “WiFi”) OUT_PUNCH_ACCESSPOINT String No
Out Punch WiFi Network The name of the WiFi Network (when the out punch “Geofence Method” == “WiFi”) OUT_PUNCH_WIFINETWORK String No
Paycode Name TIMECARD_TRANS_APPLY_TO String No
Reviewed Date Date in which the Timecard Transaction was performed TIMECARD_TRANS_UPDATE_DATETIME Date No
Reviewer Name Name of person who reviewed the Timecard Transaction TIMECARD_TRANS_UPDATE_USER String No
Start Date Time TIMECARD_TRANS_START_DATETIME DateTime No
Start Date Time (Rounded) The rounded date and time of the employee's in punch TIMECARD_TRANS_START_DATETIME_ROUNDED DateTime No
Start Time Start Time of the Timecard Transaction TIMECARD_TRANS_START_TIME Time No
Start Time (Rounded) The rounded time of the employee's in punch TIMECARD_TRANS_START_TIME_ROUNDED Time No
Transaction Type TIMECARD_TRANS_TRANSACTION_TYPE String Yes
Wage Paycode Name The name of the Wage Paycode associated with the transaction TIMECARD_TRANS_WAGE_PAYCODE_NAME String No
Work Item ID TIMECARD_TRANS_WORK_ITEM_ID String No
Work Rule Name TIMECARD_TRANS_WORK_RULE String No

Related Entities

Additional Info

  • 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

Core Entity

EmployeeOrganizationDayOrganizational JobPaycodeLabor CategoryActivityWork UnitWork GroupProcedure Code

Relationship

One-to-One One-to-Many