Results for “cma_attribute1”
8 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
BEN_COMP_ASSET is a core configuration table within the Oracle Advanced Benefits (BEN) module of Oracle E-Business Suite, documented as valid in releases 12.1.1 and 12.2.2. The object is owned by the BEN schema and represents a compensation asset — an abstract container that funds one or more benefits offerings. In benefits plan design, compensation assets serve as the vehicle through which employer-provided funding (for example, a flexible credits allocation or a defined contribution source) is quantified, distributed, and ultimately tied to the benefit plans an eligible participant may elect. Each row in this table defines one such asset, its type, and its associated descriptive and extensible attributes.
From a heuristic Data Vault classification mined from the foreign-key structure, BEN_COMP_ASSET is best modeled as a hub-leaning entity: its primary key COMP_ASSET_ID is a surrogate identifier referenced by downstream transactional and relationship tables, such as BEN_PL_R_OIPL_ASSET_F, which points back to this table via COMP_ASSET_ID. This suggests the table functions primarily as a durable business key reference point rather than an associative link or descriptive satellite.
Key Information Stored
The table contains 41 documented columns. The most significant are:
- COMP_ASSET_ID — the surrogate primary key, enforced by the unique index BEN_COMP_ASSET_PK. This is the sole documented business-key candidate and the join column used by dependent tables.
- NAME — the user-defined descriptive name of the compensation asset.
- COMP_ASSET_TYP_CD — the code classifying the asset type, determining how the asset is interpreted during benefits processing.
- BUSINESS_GROUP_ID — the identifier scoping the asset to a specific business group (HR operating unit), which governs multi-organization access.
- CMA_ATTRIBUTE_CATEGORY and CMA_ATTRIBUTE1 through CMA_ATTRIBUTE30 — a descriptive flexfield (DFF) structure allowing implementers to capture additional client-specific attributes without schema change.
- OBJECT_VERSION_NUMBER — used for optimistic concurrency control in the OAF/BC4J framework.
- LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — standard WHO audit columns tracking creation and modification.
Common Use Cases and Queries
Typical usage centers on benefits plan configuration reporting and integration with downstream funding logic. A common query retrieves all assets for a business group along with their type:
- Listing assets:
SELECT comp_asset_id, name, comp_asset_typ_cd FROM ben.ben_comp_asset WHERE business_group_id = :p_bg_id ORDER BY name; - Joining to the dependent relationship table:
SELECT a.comp_asset_id, a.name, f.* FROM ben.ben_comp_asset a, ben.ben_pl_r_oipl_asset_f f WHERE a.comp_asset_id = f.comp_asset_id; - Audit tracking: filtering on LAST_UPDATE_DATE to identify recently modified asset definitions for change-management reports.
- Flexfield extraction: querying CMA_ATTRIBUTE1–30 for client-specific configuration reporting.
Related Objects
The most significant dependent object is BEN_PL_R_OIPL_ASSET_F, which references BEN_COMP_ASSET through the foreign key column COMP_ASSET_ID (constraint BEN_PL_R_OIPL_ASSET_F). This relationship table associates compensation assets with plan-level or offering-level funding structures. Because COMP_ASSET_ID is the hub key, any reporting on benefit funding flows, eligibility, or plan funding balances must traverse this join. Administrators should also be aware of the standard WHO audit columns shared across BEN tables when performing delta extracts or data warehouse loads.
-
Compensation asset , which funds one or more benefits.
-
Compensation asset , which funds one or more benefits.
-
VIEW: BEN.BEN_COMP_ASSET# 12.2.2
-
VIEW: BEN.BEN_COMP_ASSET# 12.2.2
-
TABLE: BEN.BEN_COMP_ASSET 12.1.1
-
TABLE: BEN.BEN_COMP_ASSET 12.2.2
-
eTRM - BEN Tables and Views 12.2.2
Start and End periods.
-
eTRM - BEN Tables and Views 12.1.1
Start and End periods.