Results for “wcb_sum”
4 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APPS.PAY_CA_WCB_GRP_LEVEL_V is a reporting view within the Oracle E-Business Suite Payroll module, specifically oriented to Canadian Workers' Compensation Board (WCB) processing. It exposes group-level balance information that ties WCB assessment accounts and rates to the balance set definitions and balance types used by the payroll run. The view is designed to return, for each WCB account/province/rate combination, the effective payroll balances that feed WCB reporting and premium calculation. Rather than storing data itself, it dynamically derives results by invoking the PL/SQL function pay_ca_group_level_bal_pkg.ca_group_level_balance at query time.
The central purpose of the view is to surface the "balance_name" mapping that underpins WCB group-level balances. Balance sets in this context carry naming conventions beginning with WCB_SUM% and hold pointers (in attribute_1 through attribute_4) to the underlying balance types. The view resolves those pointers into human-readable balance names in taxable, liability, and excess categories, then computes payable-year-to-date (PYDATE) and other-period-to-date (OTD) aggregates.
Underlying Base Objects
The view is defined over a combination of synonyms, a view, and a package. The documented referenced base objects include:
- PAY_WCI_ACCOUNTS_V (view) and PAY_WCI_RATES — supply the WCB account number, province, rate identifier, rate code, rate value, and description.
- PAY_BALANCE_SETS — provides the balance set name and the attribute columns that store base balance names and the dimension attribute.
- PAY_BALANCE_TYPES and PAY_BALANCE_TYPES_TL — joined three times to translate the taxable, liability, and excess balance identifiers into the translated
balance_name. - FND_SESSIONS — joined via
userenv('sessionid')to obtain the effective date from the current session context. - PAY_CA_GROUP_LEVEL_BAL_PKG — a PL/SQL package supplying the group-level balance function.
- Also referenced: FF_CONTEXTS, HR_GENERAL, HR_SECURITY, and PAY_ACTION_CONTEXTS — typically implicated through the package and security predicates.
Key Columns
account_number,province,rate_id,code,rate,description— identify the WCB account, jurisdiction, and assessment rate.business_group_id— the HR business group context for the returned data.balance_set_name— the WCB summary balance set driving the mapping.base_bal_name_taxable,base_bal_name_liability,base_bal_name_excess— the base balance names from the balance set attributes.tl_bal_name_taxable,tl_bal_name_liability,tl_bal_name_excess— translated balance names resolved throughPAY_BALANCE_TYPES_TL.balance_name.dimension— optional dimensional grouping attribute (attribute_4).legislation_code— the legislative context, filtered to 'CA'.effective_date— session-derived date used in balance calculation.PYDATE_TAXABLE,PYDATE_LIABILITY,PYDATE_EXCESS— payable-year-to-date group-level balances.OTD_TAXABLE,OTD_LIABILITY,OTD_EXCESS— other-period-to-date balances, returned as zero when the dimension is null.
Common Use Cases and Queries
Consulting and reporting teams use this view to reconcile WCB premium components against payroll balances and to validate that the correct balance_name assignments are attached to each WCB summary balance set. A representative query retrieves balances for a specific account and rate:
SELECT account_number, province, code, rate,
balance_set_name, tl_bal_name_taxable,
PYDATE_TAXABLE, OTD_TAXABLE
FROM apps.pay_ca_wcb_grp_level_v
WHERE account_number = :p_account
AND rate_id = :p_rate_id;
Analysts searching by "balance_name" typically join or filter on the tl_bal_name_* columns to trace which balance types are mapped into the taxable, liability, and excess WCB categories. Because results depend on the active session and FND_SESSIONS effective date, queries should normally be executed from within an EBS session context rather than an external SQL client without a valid session identifier.