Search Results ben_ext_incl_data_elmt




Overview
Explore in AI Chat

Overview

BEN_EXT_INCL_DATA_ELMT is a transactional configuration table within the Oracle Advanced Benefits (BEN) product module, delivered under the BEN schema in Oracle E-Business Suite 12.1.1 and 12.2.2. The table participates in the Benefits extract framework, which governs how participant data is pulled from EBS and formatted for transmission to external benefits carriers, third-party administrators, and payroll providers. The object name expands to "Benefits Extract Include Data Element," indicating that it controls which extract data elements are included within a given record layout or record-in-file definition.

The table is a child of the broader BEN_EXT_* extract infrastructure and operates as a dependent configuration entity rather than as a transactional master. From a Data Vault modeling perspective, the metadata heuristic classifies this table as a link, since it primarily resolves relationships between extract data elements, record-in-file definitions, and in-record data element placements. This classification is a modeling suggestion based on the foreign key structure and should not be interpreted as a physical Data Vault implementation.

Key Information Stored

The table contains twelve documented columns. The surrogate primary key is EXT_INCL_DATA_ELMT_ID, defined by the unique index BEN_EXT_INCL_DATA_ELMT_PK. This identifier uniquely distinguishes each include-data-element configuration row and serves as the technical anchor for foreign key references from dependent objects.

The most significant business columns are:

Common Use Cases and Queries

Typical usage involves diagnosing extract output, verifying configuration completeness, and auditing carrier file definitions. A common query retrieves all included elements for a record-in-file:

  • SELECT i.ext_incl_data_elmt_id, i.ext_data_elmt_id, i.legislation_code FROM ben.ben_ext_incl_data_elmt i WHERE i.ext_rcd_in_file_id = :p_rcd_in_file_id;
  • Joining to BEN_EXT_DATA_ELMT to resolve element names and data types for reporting.
  • Joining to BEN_EXT_DATA_ELMT_IN_RCD to validate positional layout of elements within a record.
  • Exception reporting for elements configured against an obsolete record layout or inactive legislation.

Related Objects

  • BEN_EXT_DATA_ELMT — parent of the included element via EXT_DATA_ELMT_ID.
  • BEN_EXT_RCD_IN_FILE — defines the record layout via EXT_RCD_IN_FILE_ID.
  • BEN_EXT_DATA_ELMT_IN_RCD — positions the element within the record via EXT_DATA_ELMT_IN_RCD_ID.
  • BEN_EXT_RCD_IN_FILE_STRUC — upstream record structure definitions.
  • BEN_EXT_ELIG_PRFL and related extract eligibility tables that scope which participants are extracted.