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:

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 through PAY_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.