Accrual Transactions

The Accrual Transactions entity provides data for all accrual transactions by employee, accrual code, and accrual transaction type (such as takings, grants, and probation period start).

Employee Dataview Business Structure Dataview
X  

Provides one row per Employee, Accrual Code, and Accrual Transaction Type for the defined time period.

Label Description Key
Accrual Amount (Days) The number of days attributed to the accrual transaction for a day-based accrual. TK_ACCRUAL_TRANSACTION_DAYS_AMOUNT
Accrual Amount (Hours) The number of hours attributed to the accrual transaction for an hour-based accrual. TK_ACCRUAL_TRANSACTION_HOURS_AMOUNT
Accrual Amount (Money) Money attributed to the accrual transaction for a money-based accrual. TK_ACCRUAL_TRANSACTION_MONEY_AMT
Accrual Amount (Seconds) The seconds attributed to the accrual transaction for an hour-based accrual. TK_ACCRUAL_TRANSACTION_SECONDS_AMOUNT
Accrual Code ID The ID of the accrual code. TK_ACCRUAL_TRANSACTION_ACCRUAL_CODE_ID
Accrual Code Name The name of the accrual code. TK_ACCRUAL_TRANSACTION_ACCRUAL_CODE_NAME
Accrual Code Type The type of the accrual code. TK_ACCRUAL_TRANSACTION_ACCRUAL_CODE_AMOUNT_TYPE
Accrual Data Source The source of the Accrual Data. TK_ACCRUAL_TRANSACTION_DATA_SOURCE
Accrual Transaction Type The type associated with the accrual transaction. TK_ACCRUAL_TRANSACTION_TYPE
Accrual Transaction Type (Display Name) Accrual Transaction Type (Display Name) TK_ACCRUAL_TRANSACTION_TYPE_DISP_NAME
Disqualified A Boolean indicator of whether or not the accrual transaction is disqualified. TK_ACCRUAL_TRANSACTION_IS_DISQUALIFIED
Edited By   TK_ACCRUAL_TRANSACTION_EDITED_BY
Edited Date   TK_ACCRUAL_TRANSACTION_EDIT_DATE
Effective Date   TK_ACCRUAL_TRANSACTION_EFFECTIVE_DATE
Limit Amount (Days)   TK_ACCRUAL_TRANSACTION_LIMIT_DAYS_AMOUNT
Limit Amount (Hours)   TK_ACCRUAL_TRANSACTION_LIMIT_HOURS_AMOUNT
Limit Amount (Money)   TK_ACCRUAL_TRANSACTION_LIMIT_MONEY_AMT
On Probation A Boolean indicator of whether or not the accrual transaction is on probation. TK_ACCRUAL_TRANSACTION_IS_ON_PROBATION
Probation Amount (Days)   TK_ACCRUAL_TRANSACTION_PROBATION_DAYS_AMOUNT
Probation Amount (Hours)   TK_ACCRUAL_TRANSACTION_PROBATION_HOURS_AMOUNT
Probation Amount (Money)   TK_ACCRUAL_TRANSACTION_PROBATION_MONEY_AMT
Probation Amount (Seconds)   TK_ACCRUAL_TRANSACTION_PROBATION_SECONDS_AMOUNT
Suspended A Boolean indicator of whether or not the accrual transaction is suspended. TK_ACCRUAL_TRANSACTION_IS_SUSPENDED
Update Date   TK_ACCRUAL_TRANSACTION_UDPATED_DATETIME
  • The Accrual Code entity is not used with the Accrual Transactions entity. The Accrual Transactions entity provides the Accrual Code data columns necessary for transaction-level reporting.
  • When building a Dataview using the Accrual Transactions entity, be sure to include the Employee Name, Accrual Code Name, Accrual Transaction Type, and Effective Date data columns to ensure that the transactional data that is returned includes all of the information that is needed to make it useable.
  • Do not use the Accrual Transactions entity with the Accrual Daily Balances and Accrual Reporting Period Balances entities. These entities are not related because they return data at different granularities. The combination of these entities is only possible if the column relationship rules are disabled. If they are used together, rows are returned that provide Accrual Transactions data plus separate rows that provide accrual balance data, with no clear relationship other than the associated Accrual Code.
Employee Organization Day Organizational Job Paycode Labor Category
X   X   X  
One-to-One One-to-Many
  X