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.
Supported Dataview types
|
Employee Dataview |
Business Structure Dataview |
|---|---|
|
X |
Data granularity
Provides one row per accrual code and employee for the defined time period.
Columns
|
Label | Description |
Key |
Type |
Select accrual code? |
|---|---|---|---|---|
|
Accrual Reporting Period | The timeframe for reporting accrual data. |
TK_AS_DLY_SMRY_RPRT_PRD |
String |
No |
|
Available Balance (Days) | The encumbered balance for a day type accrual code. The encumbered balance is the amount available on the selected day, after future requests and grants are taken into consideration. The balance is based on all time, not limited to the Accrual reporting period or the loaded timeframe. |
TK_AS_DLY_SMRY_AVBL_BLNC_DAYS |
Number |
Yes |
|
Available Balance (Hours) | The encumbered balance for an hour type accrual code. The encumbered balance is the amount available on the selected day, after future requests and grants are taken into consideration. The balance is based on all time, not limited to the Accrual reporting period or the loaded timeframe. |
TK_AS_DLY_SMRY_AVBL_BLNC_HOURS |
Number |
Yes |
|
Available Balance (Money) | The encumbered balance for a money type accrual code. The encumbered balance is the amount available on the selected day, after future requests and grants are taken into consideration. The balance is based on all time, not limited to the Accrual reporting period or the loaded timeframe. |
TK_AS_DLY_SMRY_AVBL_BLNC_MONEY_AMT |
Number |
Yes |
| Available Balance (Seconds) | The encumbered balance for an hour type accrual code in seconds. The encumbered balance is the amount available on the selected day, after future requests and grants are taken into consideration. The balance is based on all time, not limited to the Accrual reporting period or the loaded timeframe. | TK_AS_DLY_SMRY_AVBL_BLNC_SECONDS | 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 amount of time off or accruals in a day-based accrual code that an employee has accrued but has not yet been fully earned or vested. |
TK_AS_DLY_SMRY_CURR_BLNC_PROB_DAYS_AMT |
Number |
Yes |
|
Current Probationary Balance (Hours) | The accrued time off or accruals in an hour-based accrual code that an employee has accrued but has not yet fully vested. |
TK_AS_DLY_SMRY_CURR_BLNC_PROB_HOURS_AMT |
Number |
Yes |
|
Current Probationary Balance (Money) | The accrued time off or accruals in a money-based accrual code that an employee has accrued but has not yet fully vested. |
TK_AS_DLY_SMRY_CURR_BLNC_PROB_MONEY_AMT |
Number |
Yes |
| Current Probationary Balance (Seconds) | The amount of time off or accruals in 'seconds' for an hour-based accrual code that an employee has accrued but has not yet been fully earned or vested. | TK_AS_DLY_SMRY_CURR_BLNC_PROB_SECONDS_AMT | Number | Yes |
|
Current Vested Balance (Days) | The current balance for a day-based accrual code without upcoming grants or requests for the same time period. |
TK_AS_DLY_SMRY_CURR_BLNC_VSTD_DAYS_AMT |
Number |
Yes |
|
Current Vested Balance (Hours) | The current balance for an hour-based accrual code without upcoming grants or requests for the same time period. |
TK_AS_DLY_SMRY_CURR_BLNC_VSTD_HOURS_AMT |
Number |
Yes |
|
Current Vested Balance (Money) | The current balance for a money accrual code without upcoming grants or requests for the same time period. |
TK_AS_DLY_SMRY_CURR_BLNC_VSTD_MONEY_AMT |
Number |
Yes |
| Current Vested Balance (Seconds) | The current balance for an hour-based accrual code in seconds without upcoming grants or requests for the same time period. | TK_AS_DLY_SMRY_CURR_BLNC_VSTD_SECONDS_AMT | Number | Yes |
|
Earned to Date (Days) | The amount of any day type accrual grants, implicit or explicit (except negative takings), between the opening balance and the As-of date. |
TK_AS_DLY_SMRY_ERND_TODATE_DAYS |
Number |
Yes |
|
Earned to Date (Hours) | The amount of any hour type accrual grants, implicit or explicit (except negative takings), between the opening balance and the As-of date. |
TK_AS_DLY_SMRY_ERND_TODATE_HOURS |
Number |
Yes |
|
Earned to Date (Money) | The amount of any money type accrual grants, implicit or explicit (except negative takings), between the opening balance and the As-of date. |
TK_AS_DLY_SMRY_ERND_TODATE_MONEY_AMT |
Number |
Yes |
|
Pending Grants (Days) | Grants for a day-based accruals, expected to occur between the "as-of" date and the end of the reporting period. This column can be blank or marked N/A if the As of date is not within the reporting period, or the accrual policy contains earned grants. |
TK_AS_DLY_SMRY_PNDG_GRNT_DAYS |
Number |
Yes |
|
Pending Grants (Hours) | Grants for an hour-based accruals, expected to occur between the "as-of" date and the end of the reporting period. This column can be blank or marked N/A if the As of date is not within the reporting period, or the accrual policy contains earned grants. |
TK_AS_DLY_SMRY_PNDG_GRNT_HOURS |
Number |
Yes |
|
Pending Grants (Money) | Grants for a money-based accruals, expected to occur between the "as-of" date and the end of the reporting period. This column can be blank or marked N/A if the As of date is not within the reporting period, or the accrual policy contains earned grants. |
TK_AS_DLY_SMRY_PNDG_GRNT_MONEY_AMT |
Number |
Yes |
|
Planned Takings (Days) | Withdrawals, or Takings, from a day-based accrual that are entered between the "as-of" date and the end of the reporting period. |
TK_AS_DLY_SMRY_PLN_TKNG_DAYS |
Number |
Yes |
|
Planned Takings (Hours) | Withdrawals, or Takings, from an hour-based accrual that are entered between the "as-of" date and the end of the reporting period. |
TK_AS_DLY_SMRY_PLN_TKNG_HOURS |
Number |
Yes |
|
Planned Takings (Money) | Withdrawals, or Takings, from a money-based accrual that are entered between the "as-of" date and the end of the reporting period. |
TK_AS_DLY_SMRY_PLN_TKNG_MONEY_AMT |
Number |
Yes |
|
Taken to Date (Days) | Withdrawals, or takings, from a day-based accrual between the first day of the reporting period and the "as of" date. |
TK_AS_DLY_SMRY_TKN_TODATE_DAYS |
Number |
Yes |
|
Taken to Date (Hours) | Withdrawals, or takings, from an hour-based accrual between the first day of the reporting period and the "as of" date. |
TK_AS_DLY_SMRY_TKN_TODATE_HOURS |
Number |
Yes |
|
Taken to Date (Money) | Withdrawals, or takings, from a money-based accrual between the first day of the reporting period and the "as of" date. |
TK_AS_DLY_SMRY_TKN_TODATE_MONEY_AMT |
Number |
Yes |
| Taken to Date (Seconds) | Withdrawals, or takings, from an hour-based accrual in seconds, between the first day of the reporting period and the "as of" date. | TK_AS_DLY_SMRY_TKN_TODATE_SECONDS | Number | Yes |
Related entities
Additional information
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
| Employee | Organization | Day | Organizational Job | Paycode | Labor Category |
|---|---|---|---|---|---|
| X |
Relationship
|
One-to-One | One-to-Many |
|---|---|
|
X |