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).

Supported Dataview types

Employee Dataview	Business Structure Dataview
X

Data granularity

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

Columns

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 days attributed to the accrual transaction for a day-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 source of the Accrual Data.	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
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

Related entities

Additional information

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.

Core entity

Employee	Organization	Day	Organizational Job	Paycode	Labor Category
X		X		X

Relationship

One-to-One	One-to-Many
	X