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
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
Employee | Organization | Day | Organizational Job | Paycode | Labor Category |
---|---|---|---|---|---|
X |
Relationship
One-to-One | One-to-Many |
---|---|
X |