Search Results ben_ext_crit_prfl_pk

Overview

BEN_EXT_CRIT_PRFL is a table in the BEN (Advanced Benefits) product schema of Oracle E-Business Suite, documented in ETRM as the "Extract criteria profile." It stores the reusable definitions that determine which participants, plan enrollments, or benefit records are selected when an extract process is executed. In Oracle Advanced Benefits, extracts are commonly used to feed carriers, payroll interfaces, third-party administrators, and regulatory reporting routines; the criteria profile supplies the filter and grouping logic that those extracts apply.

The table is owned by BEN and is marked VALID in the documented 12.2.2 physical schema, where it carries 43 columns. Its primary key is BEN_EXT_CRIT_PRFL_PK, defined on the surrogate identifier EXT_CRIT_PRFL_ID together with ZD_EDITION_NAME, reflecting the Oracle EBS 12.2 online patching and editioning model. From a modeling perspective, the supplied metadata classifies this object as hub-leaning under a heuristic Data Vault interpretation: it holds a durable, uniquely identified business concept—the criteria profile—referenced by other tables through foreign keys, rather than representing a transaction or a pure descriptive satellite.

Key Information Stored

The column layout reflects a profile header plus a large block of descriptive flexfield attributes, typical of Oracle EBS configuration tables.

• EXT_CRIT_PRFL_ID — the surrogate primary key that uniquely identifies each criteria profile.
• NAME — the user-facing name of the criteria profile, the principal business identifier used when selecting a profile in setup or extract definition screens.
• ZD_EDITION_NAME — the editioning column; part of the unique index BEN_EXT_CRIT_PRFL_PK and central to 12.2 online patching behavior.
• BUSINESS_GROUP_ID — the operating unit / business group context, supporting multi-organization segregation of setup data.
• LEGISLATION_CODE — the legislative context in which the profile is valid, allowing country-specific criteria.
• EXT_GLOBAL_FLAG — indicates whether the profile is treated as global across the enterprise.
• OBJECT_VERSION_NUMBER — optimistic locking column maintained by the Oracle EBS framework.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — standard WHO audit columns.
• XCR_ATTRIBUTE_CATEGORY and XCR_ATTRIBUTE1 through XCR_ATTRIBUTE30 — the descriptive flexfield segment block associated with the profile, providing extensibility without schema change.

The business-key candidate documented for the table is the same unique index used for the primary key, meaning EXT_CRIT_PRFL_ID is the sole documented unique identifier; the semantic identity of a profile is its NAME within its business group and legislation context.

Common Use Cases and Queries

Typical uses include auditing extract configuration, tracing which global or legislative profiles exist for a business group, and joining profile headers to their criteria type rows. A representative query retrieving profiles and their update audit trail:

• SELECT p.ext_crit_prfl_id, p.name, p.business_group_id, p.legislation_code, p.ext_global_flag, p.last_update_date FROM ben.ben_ext_crit_prfl p WHERE p.business_group_id = :p_bg_id ORDER BY p.name;

To relate a profile to the criteria type definitions that reference it:

• SELECT p.ext_crit_prfl_id, p.name, t.ext_crit_typ_id FROM ben.ben_ext_crit_prfl p, ben.ben_ext_crit_typ t WHERE t.ext_crit_prfl_id = p.ext_crit_prfl_id;

Reporting requirements frequently center on change control—identifying profiles modified after a cutoff date, or listing profiles carrying populated XCR_ATTRIBUTE flexfield segments—as well as on reconciliation between the extract definition and the criteria profile used at run time.

Related Objects

The documented foreign-key relationships show that BEN_EXT_CRIT_PRFL is referenced by related Advanced Benefits extract metadata rather than owning the relationships itself, confirming its hub-like role.

• BEN_EXT_CRIT_TYP — references BEN_EXT_CRIT_PRFL via BEN_EXT_CRIT_TYP.EXT_CRIT_PRFL_ID; holds the individual criteria types belonging to a profile.
• BEN_EXT_DFN — references BEN_EXT_CRIT_PRFL via BEN_EXT_DFN.EXT_CRIT_PRFL_ID; the extract definition that consumes the criteria profile.

Because the supplied metadata lists only these two inbound foreign keys, they constitute the primary documented dependents. Additional Benefit extract setup and run-time objects typically reference the criteria profile indirectly through BEN_EXT_DFN and BEN_EXT_CRIT_TYP, so those two tables should be treated as the principal join points when navigating from the extract definition to the criteria profile.