Search Results ben_ext_data_elmt_in_rcd




Overview
Explore in AI Chat

Overview

BEN_EXT_DATA_ELMT_IN_RCD is a table in the BEN (Advanced Benefits) schema of Oracle E-Business Suite, valid in releases 12.1.1 and 12.2.2. It represents the association of an extract data element with an extract record, forming the basis of the Oracle Advanced Benefits extract engine. This engine drives the generation of outbound benefit data files such as carrier tapes, 401(k) feeds, and third-party interfaces, where each record defines the structure of a written output row and each data element defines a field appearing within that row.

The ETRM metadata describes the object as "Extract data element in record." Functionally, the table acts as a junction connecting BEN_EXT_DATA_ELMT to BEN_EXT_RCD, and it carries additional attribute information that governs where and how the element appears within the record. The heuristic Data Vault classification supplied with the metadata is hub-leaning, suggesting that BEN_EXT_DATA_ELMT_IN_RCD could be modelled as a hub entity with its own identity (EXT_DATA_ELMT_IN_RCD_ID) and a small number of descriptive attributes, rather than as a pure link or satellite.

Key Information Stored

The table is owned by BEN and contains 19 documented columns. The primary key is the unique index BEN_EXT_DATA_ELMT_IN_RCD_PK, defined on EXT_DATA_ELMT_IN_RCD_ID and ZD_EDITION_NAME. The inclusion of ZD_EDITION_NAME reflects the multi-tenant, edition-based architecture introduced with EBS 12.2, allowing multiple editions of the same configuration to coexist.

  • EXT_DATA_ELMT_IN_RCD_ID — the surrogate primary key and the FK target for all dependent objects.
  • EXT_DATA_ELMT_ID — foreign key to BEN_EXT_DATA_ELMT, identifying the data element assigned to this record.
  • EXT_RCD_ID — foreign key to BEN_EXT_RCD, identifying the parent extract record.
  • SEQ_NUM — ordinal position of the data element within the record, controlling output column ordering.
  • STRT_POS — starting character position for fixed-width extract output.
  • DLMTR_VAL — delimiter value separating this element from the next in delimited file formats.
  • RQD_FLAG — indicates whether the data element is required in the record.
  • HIDE_FLAG — controls whether the element is hidden from the generated output.
  • SPRS_CD — suppression code logic governing conditional omission of the element.
  • ANY_OR_ALL_CD — operator controlling whether any or all qualifying rows satisfy inclusion criteria.
  • LEGISLATION_CODE — legal jurisdiction associated with the configuration.
  • BUSINESS_GROUP_ID — the business group for which the definition applies.
  • OBJECT_VERSION_NUMBER — optimistic locking column used by the Oracle Applications Framework.
  • ZD_EDITION_NAME — edition identifier supporting the 12.2 online patching model.
  • Audit columns LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, and CREATION_DATE provide standard change tracking.

Common Use Cases and Queries

The most common reporting scenario is reconstructing the layout of a given extract record, for example to verify column order, start positions, and delimiters before troubleshooting a carrier interface. A typical pattern joins to BEN_EXT_RCD and BEN_EXT_DATA_ELMT:

SELECT rcd.NAME, elmt.NAME, d.SEQ_NUM, d.STRT_POS, d.DLMTR_VAL
FROM BEN_EXT_DATA_ELMT_IN_RCD d, BEN_EXT_RCD rcd, BEN_EXT_DATA_ELMT elmt
WHERE d.EXT_RCD_ID = rcd.EXT_RCD_ID
AND d.EXT_DATA_ELMT_ID = elmt.EXT_DATA_ELMT_ID
ORDER BY rcd.NAME, d.SEQ_NUM;

Other use cases include auditing which records reference a specific data element before changing the element definition, identifying hidden or suppressed elements that unexpectedly omit data from output files, and verifying legislation-specific configurations following an upgrade. Because BEN_EXT_RCD_IN_FILE stores SORT1 through SORT4 references to this table, administrators frequently query it to determine which data elements drive record sort order.

Related Objects

The principal objects linked to BEN_EXT_DATA_ELMT_IN_RCD are as follows:

Together these objects form the configuration backbone of the Advanced Benefits extract framework, and any modification to BEN_EXT_DATA_ELMT_IN_RCD propagates directly into the generated files consumed by external benefits providers.