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.

Employee Dataview Business Structure Dataview
X  

Provides one row per Accrual Code and Employee for the defined time period.

Label Description Key Select accrual code?
Prior Period Ending Probationary Balance (Seconds) The probationary balance at the end of the previous reporting period. TK_AS_RPRT_PRD_PRIOR_END_BLNC_PROB_SECONDS_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
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) The probationary balance for an hour-based Accrual in seconds at the end of a specific period, typically a reporting period or a probationary period. 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 a money-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 Vested Balance (Days) The ending vested balance in a day-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 a money-based accrual at the end of the previous reporting period. TK_AS_RPRT_PRD_PRIOR_END_BLNC_VSTD_MONEY_AMT Yes

Columns pertaining to the loaded timeframe of the Dataview or report.

Label Key Select accrual code?
Starting Vested Balance (Seconds) TK_AS_PRD_START_BLNC_VSTD_SECONDS_AMT Yes
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 Probationary Balance (Seconds) TK_AS_PRD_START_BLNC_PROB_SECONDS_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
Employee Organization Day Organizational Job Paycode Labor Category
X          
One-to-One One-to-Many
  X