Search Results title_1

Overview

APPS.BEN_CWB_EQUITY_EDGE_ACT_INFO_V is a database view owned by the APPS schema within the Oracle E-Business Suite Advanced Benefits (BEN) module. Its FND Design Data entry, BEN.BEN_CWB_EQUITY_EDGE_ACT_INFO_V, confirms that it is a delivered, internally managed object rather than a customer-defined artifact. The view is documented as View Type "Internal" and carries the standard Oracle Internal Use Only warning, meaning that Oracle Corporation does not support direct access to applications data through this object except from standard Oracle Applications programs.

The view consolidates person, assignment, address, and benefit enrollment information into a single flattened structure, oriented toward Compensation Workbench processing and equity or insider reporting. It exposes employee identity attributes, contact and address details, organizational context, manager information, and a set of insider classification flags (director, officer, ten-percent owner, and other insider). This makes the view useful as an upstream source for equity plan eligibility, insider status validation, and benefit election verification. Because it is an internal view, it should generally be treated as a read-only reporting or integration surface rather than a transactional object.

Underlying Base Objects

The view is defined over a documented set of base objects spanning the BEN and PER schemas. The benefit-side components include BEN_ELIG_PER_ELCTBL_CHC, BEN_ENRT_RT, BEN_PER_IN_LER, BEN_PIL_ELCTBL_CHC_POPL, and BEN_PRTT_RT_VAL, which supply eligibility, enrollment, rate, and participant election data. The people and assignment core is represented by PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_F, PER_ADDRESSES, PER_JOBS, PER_BUSINESS_GROUPS_PERF, and HR_ORGANIZATION_UNITS. The HR_GENERAL and HR_SECURITY packages are referenced, indicating that the view applies standard HR security and concatenation or lookup logic. Referenced base objects are documented as synonyms distributed across these schemas, with PER_BUSINESS_GROUPS_PERF and HR_ORGANIZATION_UNITS exposed as views.

Key Columns

• Identity and person: LAST_NAME, FIRST_NAME, MIDDLE_NAME, EMPLOYEE_NUMBER, SSN, PERSON_ID, and BIND_PERSON_ID (person identifier).
• Address: ADDRESS_LINE1 through ADDRESS_LINE3, US_CITY_OR_INTNL_ADDR, US_STATE, EMP_ADDR_COUNTRY, and US_ZIP_CODE.
• Organizational context: TITLE_1, TITLE_2, BUS_GRP_COUNTRY, ORG_NAME, and WS_MGR_FULL_NAME (manager full name).
• Insider classification: DIRECTOR_FLAG, OFFICER_FLAG, TEN_PCT_OWNER_FLAG, and OTH_INSIDER_FLAG, each expressed as Y/N indicators.
• Employment and contact: EMPLOYEE_FLAG, HIRE_DATE, EMAIL, and ENRT_PERD_ID (enrollment period identifier).
• User-defined fields: USR_DFND_3 (numeric) and USR_DFND_6 (varchar2).

Common Use Cases and Queries

Typical scenarios include equity award eligibility checks, insider status reporting, and reconciliation of benefit enrollments against employee demographics. The following example retrieves active employees with their insider flags for a given enrollment period:

SELECT employee_number,
       last_name,
       first_name,
       title_1,
       hire_date,
       director_flag,
       officer_flag,
       ten_pct_owner_flag,
       oth_insider_flag,
       email
  FROM apps.ben_cwb_equity_edge_act_info_v
 WHERE employee_flag = 'Y'
   AND enrt_perd_id = :p_enrt_perd_id;

Because the view is marked internal and incorporates HR_SECURITY logic, access should be restricted to authorized programs and users, and results should be validated against supported Oracle APIs wherever write operations are contemplated.