Accrual Daily Balances No CT

The Accrual Daily Balances No CT entity provides the available, vested, and probationary accrual balances for each unique employee and accrual code combination. This entity provides similar data as the Accrual Daily Balancesentity, but for this entity No callable totalization (CT) occurs so that totalized data loads faster.

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

Note: When included in a Dataview or report, the indicated columns allow the creator of the DataView or report to select the accrual code for which the column data is populated.

Label

Description

Key

Type

Select accrual code?

Available Balance (Days) No CT

Available Balance (Days). No callable totalization (CT) occurs so that totalized data loads faster

TK_AS_DLY_SMRY_AVBL_BLNC_DAYS_NO_CT

Number

Yes

Available Balance (Hours) No CT

Available Balance (Hours). No callable totalization (CT) occurs so that totalized data loads faster

TK_AS_DLY_SMRY_AVBL_BLNC_HOURS_NO_CT

Number

Yes

Available Balance (Money) No CT

Available Balance (Money). No callable totalization (CT) occurs so that totalized data loads faster

TK_AS_DLY_SMRY_AVBL_BLNC_MONEY_AMT_NO_CT

Number

Yes

Current Probationary Balance (Days) No CT

Current Probationary Balance (Days). No callable totalization (CT) occurs so that totalized data loads faster

TK_AS_DLY_SMRY_CURR_BLNC_PROB_DAYS_AMT_NO_CT

Number

Yes

Current Probationary Balance (Hours) No CT

Current Probationary Balance (Hours). No callable totalization (CT) occurs so that totalized data loads faster

TK_AS_DLY_SMRY_CURR_BLNC_PROB_HOURS_AMT_NO_CT

Number

Yes

Current Probationary Balance (Money) No CT

Current Probationary Balance (Money). No callable totalization (CT) occurs so that totalized data loads faster

TK_AS_DLY_SMRY_CURR_BLNC_PROB_MONEY_AMT_NO_CT

Number

Yes

Current Vested Balance (Days) No CT

Current Vested Balance (Days). No callable totalization (CT) occurs so that totalized data loads faster

TK_AS_DLY_SMRY_CURR_BLNC_VSTD_DAYS_AMT_NO_CT

Number

Yes

Current Vested Balance (Hours) No CT

Current Vested Balance (Hours). No callable totalization (CT) occurs so that totalized data loads faster

TK_AS_DLY_SMRY_CURR_BLNC_VSTD_HOURS_AMT_NO_CT

Number

Yes

Current Vested Balance (Money) No CT

Current Vested Balance (Money). No callable totalization (CT) occurs so that totalized data loads faster

TK_AS_DLY_SMRY_CURR_BLNC_VSTD_MONEY_AMT_NO_CT

Number

Yes

Recent Grants (Hours) No CT

Recent Grants (Hours) No CT. No callable totalization (CT) occurs so that totalized data loads faster

TK_AS_DLY_SMRY_RCT_GRNT_HOURS_NO_CT

Recent Grants (Days) No CT

Recent Grants (Days) No CT. No callable totalization (CT) occurs so that totalized data loads faster

TK_AS_DLY_SMRY_RCT_GRNT_DAYS_NO_CT

Recent Grants (Money) No CT

Recent Grants (Money) No CT. No callable totalization (CT) occurs so that totalized data loads faster

TK_AS_DLY_SMRY_RCT_GRNT_MONEY_AMT_NO_CT

Recent Takings (Hours) No CT

Anticipated Takings (Hours) No CT. No callable totalization (CT) occurs so that totalized data loads faster

TK_AS_DLY_SMRY_ATCP_TKN_HOURS_NO_CT

Recent Takings (Days) No CT

Recent Takings (Days) No CT. No callable totalization (CT) occurs so that totalized data loads faster

TK_AS_DLY_SMRY_RCT_TKN_DAYS_NO_CT

Recent Takings (Money) No CT

Anticipated Takings (Money) No CT. No callable totalization (CT) occurs so that totalized data loads faster

TK_AS_DLY_SMRY_ATCP_TKN_MONEY_AMT_NO_CT

Anticipated Grants (Hours) No CT

Anticipated Grants (Hours) No CT. No callable totalization (CT) occurs so that totalized data loads faster

TK_AS_DLY_SMRY_ATCP_GRNT_HOURS_NO_CT

Anticipated Grants (Days) No CT

Anticipated Grants (Days) No CT. No callable totalization (CT) occurs so that totalized data loads faster

TK_AS_DLY_SMRY_ATCP_GRNT_DAYS_NO_CT

Anticipated Grants (Money) No CT

Recent Grants (Money) No CT. No callable totalization (CT) occurs so that totalized data loads faster

TK_AS_DLY_SMRY_RCT_GRNT_MONEY_AMT_NO_CT

Anticipated Takings (Hours) No CT

Recent Takings (Hours) No CT. No callable totalization (CT) occurs so that totalized data loads faster

TK_AS_DLY_SMRY_RCT_TKN_HOURS_NO_CT

Anticipated Takings (Days) No CT

Recent Takings (Days) No CT. No callable totalization (CT) occurs so that totalized data loads faster

TK_AS_DLY_SMRY_RCT_TKN_DAYS_NO_CT

Anticipated Takings (Money) No CT

Recent Takings (Money) No CT. No callable totalization (CT) occurs so that totalized data loads faster

TK_AS_DLY_SMRY_RCT_TKN_MONEY_AMT_NO_CT

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

EmployeeOrganizationDayOrganizational JobPaycodeLabor Category
X

Relationship

One-to-One

One-to-Many

X