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 Balances entity 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.

Data Granularity

Provides one row per employee per accrual code per date.

Supported Dataview/RDO Type

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

Columns


Accrual Reporting Period	The accrual reporting period of the accrual balance.	TK_ACCRL_DAY_RPRT_PRD	Date	Yes
Accrual Balance by Day (Days)	The available accrual balance by day for a day-based accrual.	TK_ACCRL_DAY_AVBL_BLNC_DAYS	Number	Yes
Accrual Balance by Day (Hours)	The available accrual balance by day for an hour-based accrual.	TK_ACCRL_DAY_AVBL_BLNC_HOURS	Number	Yes
Accrual Balance by Day (Money)	The available accrual balance by day for a money-based accrual.	TK_ACCRL_DAY_AVBL_BLNC_MONEY	Number	Yes
Balance Date	The date of the accrual balance.	TK_ACCRL_DAY_BLNC_DATE	Date	Yes
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	Yes
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	Yes
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	Yes
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	Yes
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	Yes
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	Yes
Balance Date	The date of the accrual balance.	TK_ACCRL_DAY_BLNC_DATE	Date	No
Accrual Reporting Period	Start date and end date of the accrual reporting period of the accrual balance.	TK_ACCRL_DAY_RPRT_PRD	Date	No

Core Entity

Employee	Organization	Day	Organizational Job	Paycode	Labor Category	Activity	Work Unit	Work Group	Procedure Code

Relationship

One-to-One	One-to-Many