Search Results usr_dfnd_3

Overview

BEN_CWB_EQUITY_EDGE_ACT_INFO_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the BEN (Advanced Benefits) product family. It exposes stock account information — specifically the participant and enrollment detail required for equity or stock purchase plan processing and for third-party stock plan administrators. In the context of the Compensation Workbench and Equity/Edge style stock plan integrations, the view flattens the relationship between an enrolled person, their election, the enrollment activity, and their assignment, address, and job attributes into a single denormalized row per participant enrollment.

The view is defined in ETRM 12.2.2 with a status of VALID and is treated as a stable integration surface. External payroll, brokerage, or equity administration systems typically consume the view rather than querying the underlying BEN and PER tables directly, because it already resolves the effective-dated and security-related joins that those base objects require.

Underlying Base Objects

The view is defined over a mixture of BEN, PER, and HR objects joined through synonyms and view wrappers:

• BEN_ELIG_PER_ELCTBL_CHC — the eligibility-driven electable choice record (aliased CHC2), the driving table for the enrollment context.
• BEN_ENRT_RT — the enrollment rate header (aliased ENR), restricted to ACTY_TYP_CD = 'CWBWS'.
• BEN_PRTT_RT_VAL — the participant rate value (aliased PRT), outer-joined and filtered to RT_VAL > 0.
• BEN_PER_IN_LER — the person-in-learned-earner (learner) relationship used to anchor the eligibility rows.
• BEN_PIL_ELCTBL_CHC_POPL — the learner/electable choice population, exposing ENRT_PERD_ID for the enrollment period.
• PER_ALL_PEOPLE_F — used twice: once as the employee (PER2) and once as the workflow manager (PPF), each bounded by effective dates.
• PER_ALL_ASSIGNMENTS_F — the assignment row linking the person to the assignment used in the choice definition.
• PER_JOBS, HR_ORGANIZATION_UNITS, PER_BUSINESS_GROUPS_PERF — job title, organization name, and legislation code.
• PER_ADDRESSES — address lines, city, region, postal code, and country for the participant.
• HR_GENERAL and HR_SECURITY — package references used for security and descriptive-flex logic.

Key Columns

The projection is arranged in the layout expected by stock plan administrators: LAST_NAME, FIRST_NAME, MIDDLE_NAME, and EMPLOYEE_NUMBER identify the participant. SSN is derived as NATIONAL_IDENTIFIER only when the address country is 'US', and the address fields are similarly localized — US_CITY_OR_INTNL_ADDR concatenates city, region, and postal code for non-US countries, while US_STATE and US_ZIP_CODE are populated only for US records.

The EMPLOYEE_FLAG column is a literal constant 'Y', indicating that every row returned represents an employee rather than a non-employee participant; the companion columns DIRECTOR_FLAG, OFFICER_FLAG, TEN_PCT_OWNER_FLAG, and OTH_INSIDER_FLAG are all defined as NULL and are intended as placeholders for downstream Section 16 classification. TITLE_1 and TITLE_2 carry the job name split into two 30-character segments. Other notable columns include ORG_NAME, BUS_GRP_COUNTRY, HIRE_DATE, EMAIL, ENRT_PERD_ID, and BIND_PERSON_ID, which supplies the manager's PERSON_ID for downstream binding.

Common Use Cases and Queries

The primary use case is extraction of candidate participants for an equity or stock purchase offering, filtered by enrollment period. Because the view drives from the electable choice and restricts the enrollment rate activity type to CWBWS, a typical query filters on ENRT_PERD_ID and selects the participant identity and address columns:

• SELECT person_id, employee_number, last_name, first_name, email, employee_flag FROM apps.ben_cwb_equity_edge_act_info_v WHERE enrt_perd_id = :p_period_id;
• SELECT employee_number, us_city_or_intnl_addr, us_state, us_zip_code FROM apps.ben_cwb_equity_edge_act_info_v WHERE country = 'US';
• SELECT employee_number, title_1, title_2, org_name FROM apps.ben_cwb_equity_edge_act_info_v WHERE bus_grp_country = 'US';

Because the view references HR_SECURITY, users must hold the appropriate HR security profile to see all participant rows. Query performance is best served by filtering on ENRT_PERD_ID and person_id, as the joins to the effective-dated PER_ALL_PEOPLE_F and PER_ALL_ASSIGNMENTS_F tables otherwise span large date ranges. The literal EMPLOYEE_FLAG of 'Y' should be treated as informational only; filtering on it never reduces the result set.