Results for “carrier_name”

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

Overview

PAY_WCI_ACCOUNTS_V is a PL/SQL view owned by the APPS schema in Oracle E-Business Suite (validated across 12.1.1 and 12.2.2). It exposes Workers' Compensation Insurance (WCI) account information maintained in the Payroll (PAY) product. The view joins Payroll WCI account records to Human Resources organization data so that each WCI account is presented together with its carrier name and provincial information. This denormalized presentation is intended for reporting and integration scenarios where the carrier's descriptive identity is required alongside the account data, rather than the carrier's internal identifier alone. The object is a read-only view; all maintenance is performed against the underlying base table.

Underlying Base Objects

The documented base objects referenced by PAY_WCI_ACCOUNTS_V are:

• PAY_WCI_ACCOUNTS (SYNONYM) — the base table storing Workers' Compensation Insurance account records for a business group.
• HR_ORGANIZATION_UNITS (VIEW) — the HR organization view supplying the carrier organization name.
• HR_ORGANIZATION_INFORMATION (SYNONYM) — the HR organization information table supplying the province/state attribute in the 'WORKERS COMP INFO.' context.
• HR_GENERAL (PACKAGE) and HR_SECURITY (PACKAGE) — supporting packages that provide date-tracked and security-related logic used within the HR objects.

The view is defined with a DISTINCT projection. It joins PAY_WCI_ACCOUNTS to HR_ORGANIZATION_UNITS on CARRIER_ID = ORGANIZATION_ID (that is, the carrier is modelled as an HR organization), and joins HR_ORGANIZATION_UNITS to HR_ORGANIZATION_INFORMATION on ORGANIZATION_ID where ORG_INFORMATION_CONTEXT equals 'WORKERS COMP INFO.'. This restricts the informational join to the WCI-specific context, yielding the carrier's province alongside the account.

Key Columns

• ACCOUNT_ID — Primary identifier for the WCI account record.
• BUSINESS_GROUP_ID — The business group that owns the account, supporting multi-organization segregation.
• CARRIER_ID — Identifier of the Workers' Compensation carrier organization.
• CARRIER_NAME — The carrier's name (HOU.NAME), the descriptive label commonly used to resolve carrier_name searches.
• PROVINCE — Province or state from HR_ORGANIZATION_INFORMATION (ORG_INFORMATION1) in the WCI context.
• LOCATION_ID — Location associated with the WCI account.
• NAME — The account's descriptive name.
• ACCOUNT_NUMBER — The account number held with the carrier.
• LAST_UPDATED_BY, LAST_UPDATE_LOGIN, LAST_UPDATE_DATE, CREATED_BY, CREATION_DATE — Standard WHO audit columns.
• OBJECT_VERSION_NUMBER — Optimistic locking version identifier.

Common Use Cases and Queries

Typical uses include reporting all WCI accounts with carrier names for a business group, listing accounts filtered by carrier_name, and integration extracts that require a human-readable carrier label. A simple listing query follows:

SELECT account_id, carrier_id, carrier_name, province, name, account_number FROM apps.pay_wci_accounts_v WHERE business_group_id = :p_business_group_id;

To locate accounts for a specific carrier by name:

SELECT account_id, carrier_name, account_number FROM apps.pay_wci_accounts_v WHERE carrier_name = :p_carrier_name;

Because the view applies DISTINCT and joins to HR organization information, queries should filter on BUSINESS_GROUP_ID or CARRIER_ID where possible to limit result sets. Due to HR security package involvement in the underlying organization objects, returned rows may be constrained by the operating user's HR security profile.