Results for “calculation_method”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PAYBV_WC_FUNDS_V is a read-only Oracle EBS view owned by the APPS schema in the Payroll (PAY) product. It presents workers' compensation fund configuration data held in the underlying PAY_WC_FUNDS table, filtered by the business group secured through the HR_BIS package. The view carries a documented status of VALID and is defined with the WITH READ ONLY clause, indicating that it is intended strictly for query and reporting rather than maintenance DML. Because it exposes fields such as calculation methods, carrier, and location, it serves as a security-aware integration and reporting layer over the base workers' compensation setup table.

The view's role is to externalize workers' compensation fund records while automatically honoring the session's security profile. Only rows whose BUSINESS_GROUP_ID matches the business group returned by HR_BIS.GET_SEC_PROFILE_BG_ID are visible, so downstream reports, extracts, and integrations inherit row-level security without additional coding.

Underlying Base Objects

The view is defined over two documented referenced objects: the synonym PAY_WC_FUNDS and the package HR_BIS. The synonym resolves to the base workers' compensation funds table, aliased as PWCF in the view text. The package HR_BIS supplies the security function GET_SEC_PROFILE_BG_ID, which returns the business group identifier for the current session.

The WHERE clause applies NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, PWCF.BUSINESS_GROUP_ID), meaning that when a security profile business group is returned, only matching rows are exposed; when the function returns null, the predicate collapses to the row's own business group value and all rows remain visible. The view inherits its column set directly from PWCF, projecting a subset of that table's columns without joins, aggregation, or transformation.

Key Columns

• STATE_ABBREV — State code associated with the workers' compensation fund; note that the view text selects STATE_CODE from the base table while the documented column list names it STATE_ABBREV.
• CALCULATION_METHOD — Primary calculation method defining how the workers' compensation contribution is derived.
• CALCULATION_METHOD2 — Second calculation method, the column most commonly targeted when users search for "calculation_method2".
• CALCULATION_METHOD3 — Third calculation method available for the fund record.
• COMMENTS — Free-text descriptive comments attached to the fund configuration.
• FUND_ID — Primary identifier for the workers' compensation fund record.
• BUSINESS_GROUP_ID — Business group owning the record; also the column used by the security predicate.
• CARRIER_ID — Identifier of the insurance carrier associated with the fund.
• LOCATION_ID — Identifier of the location tied to the fund.
• WHO columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, and CREATION_DATE provide standard audit information.

Common Use Cases and Queries

Typical scenarios include auditing workers' compensation fund setup, reporting which calculation methods apply per state and carrier, and validating that records fall within the correct business group. To retrieve the calculation methods for the current security profile:

SELECT fund_id, state_abbrev, calculation_method, calculation_method2, calculation_method3, carrier_id, location_id FROM apps.paybv_wc_funds_v WHERE calculation_method2 IS NOT NULL;

To list all funds for a specific carrier:

SELECT fund_id, state_abbrev, calculation_method FROM apps.paybv_wc_funds_v WHERE carrier_id = :p_carrier_id;

To review recently maintained records:

SELECT fund_id, calculation_method2, last_update_date, last_updated_by FROM apps.paybv_wc_funds_v ORDER BY last_update_date DESC;

Because the view is READ ONLY and security-filtered via HR_BIS, it is well suited to BI Publisher reports, custom concurrent program extracts, and integration queries where row-level business group isolation is required.