Results for “apc_attribute1”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

BEN_ACRS_PTIP_CVG_V is a reporting view in the Oracle Advanced Benefits (BEN) module, owned by the APPS schema and defined over the coverage-level data used by the Participation Type in Program (PTIP) processing framework. It exposes a date-effective, session-filtered projection of the underlying flexfield-enabled coverage records stored in BEN_ACRS_PTIP_CVG_F. The object takes its name from the acronym ACRS (Activity Rate/Coverage Setup) combined with PTIP (Participation Type in Program) and CVG (coverage), reflecting its role in identifying the permitted minimum and maximum coverage amounts available to a participant within a specific program.

The view is registered as VALID in the EBS data dictionary, making it a supported read interface for both reporting and integration purposes. Because it joins to FND_SESSIONS, the view is implicitly governed by the effective date associated with the current application session, so queries automatically return only those rows valid as of the session effective date rather than the full history held in the base table.

Underlying Base Objects

The view is defined over two documented base objects:

• BEN_ACRS_PTIP_CVG_F — the primary coverage table (a _F suffixed date-effective table), which stores coverage definitions including min/max allowed amounts, program references, and 30 descriptive flexfield attribute columns.
• FND_SESSIONS — the Oracle Applications session table, used here to derive the session effective date via the join SE.SESSION_ID = USERENV('SESSIONID') and the predicate SE.EFFECTIVE_DATE BETWEEN APC.EFFECTIVE_START_DATE AND APC.EFFECTIVE_END_DATE.

Both are referenced through public synonyms in the APPS schema. The view text also exposes the base row's ROWID as ROW_ID, which can be useful for correlated updates or drill-down lookups.

Key Columns

The view returns the following significant columns:

• ROW_ID — the ROWID of the base coverage row.
• ACRS_PTIP_CVG_ID — primary key of the coverage record.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — the date-effective range governing visibility.
• NAME — the coverage definition name.
• MX_CVG_ALWD_AMT / MN_CVG_ALWD_AMT — maximum and minimum allowed coverage amounts.
• PGM_ID — the program to which the coverage belongs.
• BUSINESS_GROUP_ID — the HR business group for multi-organization filtering.
• APC_ATTRIBUTE_CATEGORY and APC_ATTRIBUTE1 through APC_ATTRIBUTE30 — the descriptive flexfield context and segment columns.
• Standard WHO audit columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE) plus OBJECT_VERSION_NUMBER for optimistic locking.

Users searching on "apc_attribute1" will find that this is the first descriptive flexfield segment exposed directly by the view, allowing attribute-based segmentation without joining the underlying table.

Common Use Cases and Queries

This view is typically used to report coverage limits, extract flexfield attribute values, and drive integration loads into downstream benefits or payroll systems. A representative query is:

• SELECT ACRS_PTIP_CVG_ID, NAME, MN_CVG_ALWD_AMT, MX_CVG_ALWD_AMT, APC_ATTRIBUTE1 FROM BEN_ACRS_PTIP_CVG_V WHERE BUSINESS_GROUP_ID = :p_bg_id;
• SELECT PGM_ID, COUNT(*) FROM BEN_ACRS_PTIP_CVG_V GROUP BY PGM_ID;
• SELECT ACRS_PTIP_CVG_ID, APC_ATTRIBUTE_CATEGORY, APC_ATTRIBUTE1 FROM BEN_ACRS_PTIP_CVG_V WHERE APC_ATTRIBUTE_CATEGORY = :p_category;

Because the view is bound to the active session effective date, it is well suited to concurrent programs and OAF pages that must respect the effective dating of benefits setup, but it should not be used where full historical coverage data is required — the base table should be queried directly in that case.