Results for “ben_acrs_ptip_cvg_d”

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

Overview

The BEN_ACRS_PTIP_CVG_D view is a reporting and integration object in the Oracle E-Business Suite Advanced Benefits (BEN) module, owned by the APPS schema. It exposes coverage-related attributes for a Participant Eligibility (PTIP) coverage record, including the minimum and maximum coverage allowed amounts. In ETRM metadata the object is flagged as "Retrofitted," indicating it was introduced or standardized to provide a consistent, upward-compatible interface across releases such as 12.1.1 and 12.2.2. The view is documented as VALID in both release lines.

The view's principal role is to present a denormalized, read-oriented projection of a single base table (BEN_ACRS_PTIP_CVG_F) joined to FND_USER to resolve the identity of the last person who updated the record. Because the underlying table is a "_F" (date-tracked/effective-dated) entity, the view surfaces the effective start and end dates alongside the coverage amounts, enabling consumers to reason about which version of a coverage rule was active at a given point in time.

The user search term mn_cvg_alwd_amt maps to the MN_CVG_ALWD_AMT column, which carries the minimum coverage allowed amount for the PTIP coverage configuration. This is the field most commonly needed when validating or reporting coverage floors.

Underlying Base Objects

The view is defined over two documented base objects, both referenced through APPS synonyms:

• BEN_ACRS_PTIP_CVG_F (SYNONYM) — the effective-dated coverage table holding the PTIP coverage rows. This is the primary source for all coverage attributes exposed by the view.
• FND_USER (SYNONYM) — the standard Oracle Applications user table, used to translate the LAST_UPDATED_BY identifier into user context.

The join is implemented as an outer join (FUSER.USER_ID (+) = APC.LAST_UPDATED_BY), so coverage rows whose updating user cannot be resolved are still returned. The view selects the base table's ROWID as ROW_ID, preserving a stable row reference.

Key Columns

• ROW_ID — the ROWID of the underlying BEN_ACRS_PTIP_CVG_F row.
• ACRS_PTIP_CVG_ID — primary identifier for the PTIP coverage record.
• NAME — name of the coverage configuration.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — the date-tracked validity window for the record.
• MX_CVG_ALWD_AMT — maximum coverage allowed amount.
• MN_CVG_ALWD_AMT — minimum coverage allowed amount (the field referenced by the search term).
• LAST_UPDATE_DATE, LAST_UPDATED_BY — audit columns identifying when and by whom the record was last modified.

Common Use Cases and Queries

Typical uses include coverage validation, audit reporting, and integration extracts. A representative query retrieving coverage amounts for a specific PTIP coverage ID is shown below.

• Validating that a configured coverage falls within its allowed minimum and maximum bounds.
• Auditing who last changed coverage limits and when.
• Extracting effective-dated coverage amounts for downstream interfaces.

SELECT row_id, acrs_ptip_cvg_id, name, effective_start_date, effective_end_date, mn_cvg_alwd_amt, mx_cvg_alwd_amt FROM apps.ben_acrs_ptip_cvg_d WHERE acrs_ptip_cvg_id = :p_cvg_id;

Because the view is effective-dated but does not itself filter by date, consumers should apply SYSDATE or an effective_start_date <= :as_of AND (effective_end_date IS NULL OR effective_end_date >= :as_of) predicate to obtain the currently effective coverage row.