Accrual Reporting Period Balances
The Accrual Reporting Period Balances entity provides accrual balance data based on the defined accrual reporting period for each defined accrual code. This information includes the vested and probationary balances for the beginning and end of the accrual reporting period that is associated with the accrual code, including the ending balance for the previous reporting period.
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
Columns pertaining to the accrual reporting period
|
Label | Desc |
Key |
Select accrual code? |
|---|---|---|---|
|
Accrual Reporting Period | The timeframe during which accrual transactions were recorded and tracked for employees. |
TK_AS_RPRT_PRD_SPAN |
No |
|
Ending Balance Date |
TK_AS_RPRT_PRD_END_BLNC_DATE |
No | |
|
Ending Probationary Balance (Days) | The probationary balance for a day-based accrual at the end of a specific period, typically a reporting period or a probationary period. |
TK_AS_RPRT_PRD_END_BLNC_PROB_DAYS_AMT |
Yes |
|
Ending Probationary Balance (Hours) | The probationary balance for an hour-based accrual at the end of a specific period, typically a reporting period or a probationary period. |
TK_AS_RPRT_PRD_END_BLNC_PROB_HOURS_AMT |
Yes |
|
Ending Probationary Balance (Money) | The probationary balance for a money-based accrual at the end of a specific period, typically a reporting period or a probationary period. |
TK_AS_RPRT_PRD_END_BLNC_PROB_MONEY_AMT |
Yes |
| Ending Probationary Balance (Seconds) | TK_AS_RPRT_PRD_END_BLNC_PROB_SECONDS_AMT | TK_AS_RPRT_PRD_END_BLNC_PROB_SECONDS_AMT | Yes |
|
Ending Vested Balance (Days) | The vested balance in a day-based accrual on the last day of the reporting period. |
TK_AS_RPRT_PRD_END_BLNC_VSTD_DAYS_AMT |
Yes |
|
Ending Vested Balance (Hours) | The vested balance in an hour-based accrual on the last day of the reporting period. |
TK_AS_RPRT_PRD_END_BLNC_VSTD_HOURS_AMT |
Yes |
|
Ending Vested Balance (Money) | The vested balance in an hour-based accrual on the last day of the reporting period. |
TK_AS_RPRT_PRD_END_BLNC_VSTD_MONEY_AMT |
Yes |
| Ending Vested Balance (Seconds) | The vested balance in an hour-based accrual in seconds on the last day of the reporting period. | TK_AS_RPRT_PRD_END_BLNC_VSTD_SECONDS_AMT | Yes |
|
Opening Balance Date | The balance that was carried over from the previous year into the 1st of January for the Reporting Period |
TK_AS_RPRT_PRD_OPN_BLNC_DATE |
No |
|
Opening Probationary Balance (Days) | Probationary balance for a day-based accrual on the first day of the reporting period. |
TK_AS_RPRT_PRD_OPN_BLNC_PROB_DAYS_AMT |
Yes |
|
Opening Probationary Balance (Hours) | Probationary balance for an hour-based accrual on the first day of the reporting period. |
TK_AS_RPRT_PRD_OPN_BLNC_PROB_HOURS_AMT |
Yes |
|
Opening Probationary Balance (Money) | Probationary balance for a money-based accrual on the first day of the reporting period. |
TK_AS_RPRT_PRD_OPN_BLNC_PROB_MONEY_AMT |
Yes |
| Opening Probationary Balance (Seconds) | Probationary balance for an hour-based accrual in seconds on the first day of the reporting period. | TK_AS_RPRT_PRD_OPN_BLNC_PROB_SECONDS_AMT | Yes |
|
Opening Vested Balance (Days) | The vested balance in the day-based accrual on the first day of the reporting period. |
TK_AS_RPRT_PRD_OPN_BLNC_VSTD_DAYS_AMT |
Yes |
|
Opening Vested Balance (Hours) | The vested balance in the hour-based accrual on the first day of the reporting period. |
TK_AS_RPRT_PRD_OPN_BLNC_VSTD_HOURS_AMT |
Yes |
|
Opening Vested Balance (Money) | The vested balance in the money-based accrual on the first day of the reporting period. |
TK_AS_RPRT_PRD_OPN_BLNC_VSTD_MONEY_AMT |
Yes |
| Opening Vested Balance (Seconds) | The vested balance in the hour-based accrual in seconds on the first day of the reporting period. | TK_AS_RPRT_PRD_OPN_BLNC_VSTD_SECONDS_AMT | Yes |
|
Prior Period Ending Balance Date |
TK_AS_RPRT_PRD_PRIOR_END_BLNC_DATE |
No | |
|
Prior Period Ending Probationary Balance (Days) | The ending probationary balance in a day-based accrual at the end of the previous reporting period. |
TK_AS_RPRT_PRD_PRIOR_END_BLNC_PROB_DAYS_AMT |
Yes |
|
Prior Period Ending Probationary Balance (Hours) | The ending probationary balance in an hour-based accrual at the end of the previous reporting period. |
TK_AS_RPRT_PRD_PRIOR_END_BLNC_PROB_HOURS_AMT |
Yes |
|
Prior Period Ending Probationary Balance (Money) | The ending probationary balance in a money-based accrual at the end of the previous reporting period. |
TK_AS_RPRT_PRD_PRIOR_END_BLNC_PROB_MONEY_AMT |
Yes |
| Prior Period Ending Probationary Balance (Seconds) | The probationary balance at the end of the previous reporting period. | Prior Period Ending Probationary Balance (Seconds) | Yes |
|
Prior Period Ending Vested Balance (Days) | The ending probationary balance in a money-based accrual at the end of the previous reporting period. |
TK_AS_RPRT_PRD_PRIOR_END_BLNC_VSTD_DAYS_AMT |
Yes |
|
Prior Period Ending Vested Balance (Hours) | The ending vested balance in an hour-based accrual at the end of the previous reporting period. |
TK_AS_RPRT_PRD_PRIOR_END_BLNC_VSTD_HOURS_AMT |
Yes |
|
Prior Period Ending Vested Balance (Money) | The ending vested balance in an hour-based accrual at the end of the previous reporting period. |
TK_AS_RPRT_PRD_PRIOR_END_BLNC_VSTD_MONEY_AMT |
Yes |
| Prior Period Ending Vested Balance (Seconds) | The vested balance at the end of the previous reporting period. | TK_AS_RPRT_PRD_PRIOR_END_BLNC_VSTD_SECONDS_AMT | Yes |
Columns pertaining to the loaded timeframe of the Dataview or report.
|
Label |
Key |
Select accrual code? |
|---|---|---|
|
Starting Balance Date |
TK_AS_PRD_START_BLNC_DATE |
No |
|
Starting Probationary Balance (Days) |
TK_AS_PRD_START_BLNC_PROB_DAYS_AMT |
Yes |
|
Starting Probationary Balance (Hours) |
TK_AS_PRD_START_BLNC_PROB_HOURS_AMT |
Yes |
|
Starting Probationary Balance (Money) |
TK_AS_PRD_START_BLNC_PROB_MONEY_AMT |
Yes |
|
Starting Vested Balance (Days) |
TK_AS_PRD_START_BLNC_VSTD_DAYS_AMT |
Yes |
|
Starting Vested Balance (Hours) |
TK_AS_PRD_START_BLNC_VSTD_HOURS_AMT |
Yes |
|
Starting Vested Balance (Money) |
TK_AS_PRD_START_BLNC_VSTD_MONEY_AMT |
Yes |
Related entities
Core entity
| Employee | Organization | Day | Organizational Job | Paycode | Labor Category |
|---|---|---|---|---|---|
| X |
Relationship
|
One-to-One | One-to-Many |
|---|---|
|
X |