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.

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_RPRT_PRD_SPAN Date No
Ending Balance Date TK_AS_RPRT_PRD_END_BLNC_DATE Date No
Ending Probationary Balance (Days) The ending probationary balance for a day-based accrual. TK_AS_RPRT_PRD_END_PROB_DAYS_AMT Number Yes
Ending Probationary Balance (Hours) The ending probationary balance for an hour-based accrual. TK_AS_RPRT_PRD_END_BLNC_PROB_HOURS_AMT Number Yes
Ending Probationary Balance (Money) The ending probationary balance for a money-based accrual. TK_AS_RPRT_PRD_END_BLNC_PROB_MONEY_AMT Number Yes
Ending Vested Balance (Days) The ending vested balance for a day-based accrual. TK_AS_RPRT_PRD_END_BLNC_VSTD_DAYS_AMT Number Yes
Ending Vested Balance (Hours) The ending vested balance for an hour-based accrual. TK_AS_RPRT_PRD_END_BLNC_VSTD_HOURS_AMT Number Yes
Ending Vested Balance (Money) The ending vested balance for a money-based accrual. TK_AS_RPRT_PRD_END_BLNC_VSTD_MONEY_AMT Number Yes
Opening Balance Date TK_AS_RPRT_PRD_OPN_BLNC_DATE Date No
Opening Probationary Balance (Days) The opening probationary balance for a day-based accrual. TK_AS_RPRT_PRD_OPN_BLNC_PROB_DAYS_AMT Number Yes
Opening Probationary Balance (Hours) The opening probationary balance for an hour-based accrual. TK_AS_RPRT_PRD_OPN_BLNC_PROB_HOURS_AMT Number Yes
Opening Probationary Balance (Money) The opening probationary balance for a money-based accrual. TK_AS_RPRT_PRD_OPN_BLNC_PROB_MONEY_AMT Number Yes
Opening Vested Balance (Days) The opening vested balance for a day-based accrual. TK_AS_RPRT_PRD_OPN_BLNC_VSTD_DAYS_AMT Number Yes
Opening Vested Balance (Hours) The opening vested balance for an hour-based accrual. TK_AS_RPRT_PRD_OPN_BLNC_VSTD_HOURS_AMT Number Yes
Opening Vested Balance (Money) The opening vested balance for a money-based accrual. TK_AS_RPRT_PRD_OPN_BLNC_VSTD_MONEY_AMT Number Yes
Prior Period Ending Balance Date TK_AS_RPRT_PRD_PRIOR_END_BLNC_DATE Date No
Prior Period Ending Probationary Balance (Days) The prior reporting period ending probationary balance for a day-based accrual. TK_AS_RPRT_PRD_PRIOR_END_BLNC_PROB_DAYS_AMT Number Yes
Prior Period Ending Probationary Balance (Hours) The prior reporting period ending probationary balance for an hour-based accrual. TK_AS_RPRT_PRD_PRIOR_END_BLNC_PROB_HOURS_AMT Number Yes
Prior Period Ending Probationary Balance (Money) The prior reporting period ending probationary balance for a money-based accrual. TK_AS_RPRT_PRD_PRIOR_END_BLNC_PROB_MONEY_AMT Number Yes
Prior Period Ending Vested Balance (Days) The prior reporting period ending vested balance for a day-based accrual. TK_AS_RPRT_PRD_PRIOR_END_BLNC_VSTD_DAYS_AMT Number Yes
Prior Period Ending Vested Balance (Hours) The prior reporting period ending vested balance for an hour-based accrual. TK_AS_RPRT_PRD_PRIOR_END_BLNC_VSTD_HOURS_AMT Number Yes
Prior Period Ending Vested Balance (Money) The prior reporting period ending vested balance for a money-based accrual. TK_AS_RPRT_PRD_PRIOR_END_BLNC_VSTD_MONEY_AMT Number Yes

Core Entity

EmployeeOrganizationDayOrganizational JobPaycodeLabor CategoryActivityWork UnitWork GroupProcedure Code

Relationship

One-to-One One-to-Many