Accrual Daily Balances

The Accrual Daily Balances entity provides the available, vested, and probationary accrual balances for each unique employee and accrual code combination. This information includes the current available accrual balance which factors in future planned takings. In addition, the Accrual Daily Balances entity provides data columns that show the accruals that the employee has earned to date and taken to date, as well as its pending grants and planned takings.

Data Granularity

Provides one row per accrual code and employee for the defined time period.

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_AS_DLY_SMRY_RPRT_PRD Date No
Available Balance (Days) The available balance for a day-based accrual. TK_AS_DLY_SMRY_AVBL_BLNC_DAYS Number Yes
Available Balance (Hours) The available balance for an hour-based accrual. TK_AS_DLY_SMRY_AVBL_BLNC_HOURS Number Yes
Available Balance (Money) The available balance for a money-based accrual. TK_AS_DLY_SMRY_AVBL_BLNC_MONEY_AMT Number Yes
Balance Date TK_AS_DLY_SMRY_BLNC_DATE Date No
Current Balance Date TK_AS_DLY_SMRY_CURR_BLNC_DATE Date No
Current Probationary Balance (Days) The current probationary balance for a day-based accrual. TK_AS_DLY_SMRY_CURR_BLNC_PROB_DAYS_AMT Number Yes
Current Probationary Balance (Hours) The current probationary balance for an hour-based accrual. TK_AS_DLY_SMRY_CURR_BLNC_PROB_HOURS_AMT Number Yes
Current Probationary Balance (Money) The current probationary balance for a money-based accrual. TK_AS_DLY_SMRY_CURR_BLNC_PROB_MONEY_AMT Number Yes
Current Vested Balance (Days) The current vested balance for a day-based accrual. TK_AS_DLY_SMRY_CURR_BLNC_VSTD_DAYS_AMT Number Yes
Current Vested Balance (Hours) The current vested balance for an hour-based accrual. TK_AS_DLY_SMRY_CURR_BLNC_VSTD_HOURS_AMT Number Yes
Current Vested Balance (Money) The current vested balance for a money-based accrual. TK_AS_DLY_SMRY_CURR_BLNC_VSTD_MONEY_AMT Number Yes
Earned to Date (Days) The earned to date for a day-based accrual. TK_AS_DLY_SMRY_ERND_TODATE_DAYS Number Yes
Earned to Date (Hours) The earned to date for an hour-based accrual. TK_AS_DLY_SMRY_ERND_TODATE_HOURS Number Yes
Earned to Date (Money) The earned to date for a money-based accrual. TK_AS_DLY_SMRY_ERND_TODATE_MONEY_AMT Number Yes
Pending Grants (Days) The pending grants for a day-based accrual. TK_AS_DLY_SMRY_PNDG_GRNT_DAYS Number Yes
Pending Grants (Hours) The pending grants for an hour-based accrual. TK_AS_DLY_SMRY_PNDG_GRNT_HOURS Number Yes
Pending Grants (Money) The pending grants for a money-based accrual. TK_AS_DLY_SMRY_PNDG_GRNT_MONEY_AMT Number Yes
Planned Takings (Days) The planned takings for a day-based accrual. TK_AS_DLY_SMRY_PLN_TKNG_DAYS Number Yes
Planned Takings (Hours) The planned takings for an hour-based accrual. TK_AS_DLY_SMRY_PLN_TKNG_HOURS Number Yes
Planned Takings (Money) The planned takings for a money-based accrual. TK_AS_DLY_SMRY_PLN_TKNG_MONEY_AMT Number Yes
Taken to Date (Days) The taken to date for a day-based accrual. TK_AS_DLY_SMRY_TKN_TODATE_DAYS Number Yes
Taken to Date (Hours) The taken to date for an hour-based accrual. TK_AS_DLY_SMRY_TKN_TODATE_HOURS Number Yes
Taken to Date (Money) The taken to date for a money-based accrual. TK_AS_DLY_SMRY_TKN_TODATE_MONEY_AMT Number Yes

Additional Info

Balances provided for a defined time period are based on the last day of the time period. For example, if the time period date range is from January 1 to January 7, the data that is returned by these columns will be based on January 7.

Core Entity

EmployeeOrganizationDayOrganizational JobPaycodeLabor CategoryActivityWork UnitWork GroupProcedure Code

Relationship

One-to-One One-to-Many