Accrual Balances by Day

The Accrual Balances by Day entity allows an administrator to create a Dataview or report data object that lists accrual balances for all accrual codes or for a selected accrual code. The Accrual Balances by Day entity is a replica of the Accrual Daily Balancesentity but, instead of providing the balance data as of the end date of the defined time period, the Accrual Balances by Day entity provides the balance data for each day in the selected time period.

Supported Dataview types

Employee Dataview	Business Structure Dataview
X

Data granularity

Provides one row per employee per accrual code per date.

Parameterized Columns

The following data columns have been parameterized to allow the user to choose "All" or a specific accrual code from the available accrual codes. When the user chooses "All," the Dataview or report data object returns data for all accrual codes with one row per employee, per accrual code.

Label	Description	Key	Type
Accrual Reporting Period	The accrual reporting period of the accrual balance.	TK_ACCRL_DAY_RPRT_PRD	String
Available Balance by Day (Days)	The available accrual balance by day for a day-based accrual.	TK_ACCRL_DAY_AVBL_BLNC_DAYS	Number
Available Balance by Day (Hours)	The available accrual balance by day for an hours-based accrual.	TK_ACCRL_DAY_AVBL_BLNC_HOURS	Number
Available Balance by Day (Money)	The available accrual balance by day for a money-based accrual.	TK_ACCRL_DAY_AVBL_BLNC_MONEY	Number
Balance Date	The date of the accrual balance.	TK_ACCRL_DAY_BLNC_DATE	Date
Current Probationary Balance by Day (Days)	The current probationary balance by day for a day-based accrual.	TK_ACCRL_DAY_CURR_BLNC_PROB_DAYS	Number
Current Probationary Balance by Day (Hours)	The current probationary balance by day for an hours-based accrual.	TK_ACCRL_DAY_CURR_BLNC_PROB_HOURS	Number
Current Probationary Balance by Day (Money)	The current probationary balance by day for a money-based accrual.	TK_ACCRL_DAY_CURR_BLNC_PROB_MONEY	Number
Current Vested Balance by Day (Days)	The current vested balance by day for a day-based accrual.	TK_ACCRL_DAY_CURR_BLNC_VSTD_DAYS	Number
Current Vested Balance by Day (Hours)	The current vested balance by day for an hours-based accrual.	TK_ACCRL_DAY_CURR_BLNC_VSTD_HOURS	Number
Current Vested Balance by Day (Money)	The current vested balance by day for a money-based accrual.	TK_ACCRL_DAY_CURR_BLNC_VSTD_MONEY	Number

Non-Parameterized Columns

Label	Description	Key	Type
Balance Date	The date of the accrual balance.	TK_ACCRL_DAY_BLNC_DATE	Date
Accrual Reporting Period	Start date and end date of the accrual reporting period of the accrual balance.	TK_ACCRL_DAY_RPRT_PRD	String

Related entities

Core entity

Employee	Organization	Day	Organizational Job	Paycode	Labor Category
X

Relationship

One-to-One	One-to-Many
X