Results for “ben_back_out_prtt_rt_val_v”

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

Overview

BEN_BACK_OUT_PRTT_RT_VAL_V is a PL/SQL view owned by the APPS schema in Oracle E-Business Suite, part of the Advanced Benefits (BEN) product family. It is registered as VALID in both EBS 12.1.1 and 12.2.2, and is available to any responsibility or concurrent program that has been granted SELECT privileges on the underlying APPS synonym. The view exposes participant rate values (BEN_PRTT_RT_VAL) that have been backed out during a life-event collapse processed by the Benefits back-out engine, and it enriches each row with the effective end date recorded in the life-event collapse/restore table (BEN_LE_CLSN_N_RSTR). Its practical role is to present the historical or "rolled-back" state of a participant's rate across the thirty developer extendable attributes (PRV_ATTRIBUTE1 through PRV_ATTRIBUTE30), making it a primary source for audits, reconciliations, and back-out diagnostics. Users searching for "prv_attribute30" are typically trying to locate where the thirtieth descriptive flexfield segment of a participant rate value is persisted after a back-out operation, and this view is the correct access point.

Underlying Base Objects

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

• BEN_PRTT_RT_VAL (aliased PRV) — the master participant rate value table, which stores the rate applied to an enrollment result for a coverage or activity.
• BEN_LE_CLSN_N_RSTR (aliased LCR) — the life-event collapse and restore table, which records identifiers of records that were collapsed or restored by the back-out process.

The join is an outer join on PRV.PRTT_RT_VAL_ID = LCR.BKUP_TBL_ID (+) with the additional predicate LCR.BKUP_TBL_TYP_CD (+) = 'BEN_PRTT_RT_VAL'. This means the view returns all participant rate value rows, and only those with a matching back-out record in the collapse/restore table will have a non-null end date. The effective end date returned is NVL(LCR.RT_END_DT, PRV.RT_END_DT) — the collapse record's end date takes precedence over the rate's own stored end date, which is the key semantic of the "back out" version.

Key Columns

• PRTT_RT_VAL_ID — primary identifier of the participant rate value row.
• RT_STRT_DT / RT_END_DT — the effective start and end dates of the rate; RT_END_DT here is the coalesced value described above.
• RT_TYP_CD, RT_VAL, ANN_RT_VAL, CMCD_RT_VAL — rate type code and the actual, annualized, and communicated rate amounts.
• BNFT_RT_TYP_CD, ACTY_TYP_CD, MLT_CD, ACTY_REF_PERD_CD — benefit rate type, activity type, multiplier, and reference period qualifiers.
• PRTT_ENRT_RSLT_ID — links the rate back to the participant enrollment result.
• ACTL_PREM_ID, COMP_LVL_FCTR_ID, ELEMENT_ENTRY_VALUE_ID, PER_IN_LER_ID — foreign keys to premium, compensation level factor, payroll element entry, and person-in-learner contexts.
• PRV_ATTRIBUTE_CATEGORY and PRV_ATTRIBUTE1 … PRV_ATTRIBUTE30 — the descriptive flexfield context and its thirty attribute segments. PRV_ATTRIBUTE30 is the final segment exposed; it carries whatever value the DFF context defines for that column. These attributes are preserved from the base table, so back-out rows retain the same flexfield data as the live rows.
• PRTT_RT_VAL_STAT_CD, RT_OVRIDN_FLAG, RT_OVRIDN_THRU_DT — rate status and override control columns.
• LAST_UPDATE_DATE, CREATED_BY, OBJECT_VERSION_NUMBER — standard Who columns and optimistic locking column.

Common Use Cases and Queries

Typical uses include auditing back-out events, comparing live versus backed-out rates, and reporting on flexfield segments such as PRV_ATTRIBUTE30 that were captured at enrollment time. Example query to retrieve the thirtieth flexfield segment for backed-out rates of a participant:

• SELECT p.PRTT_RT_VAL_ID, p.RT_STRT_DT, p.RT_END_DT, p.RT_TYP_CD, p.RT_VAL, p.PRV_ATTRIBUTE_CATEGORY, p.PRV_ATTRIBUTE30 FROM apps.BEN_BACK_OUT_PRTT_RT_VAL_V p WHERE p.PRTT_ENRT_RSLT_ID = :enrt_rslt_id ORDER BY p.RT_STRT_DT;
• Diagnostic join to confirm which rows were collapsed: select rows where the view's RT_END_DT differs from BEN_PRTT_RT_VAL.RT_END_DT for the same PRTT_RT_VAL_ID.
• Reconciliation report listing backed-out rates by benefit rate type for a business group: ... WHERE p.BUSINESS_GROUP_ID = :bg_id AND p.RT_TYP_CD = :rt_typ.

Because the view is a simple two-table outer join with no aggregation, it performs efficiently against the primary key of BEN_PRTT_RT_VAL and can be safely used in concurrent programs, BI Publisher data templates, and OAF-based inquiries. All access should be granted through the APPS synonym and, in 12.2.2, the corresponding editioned object for online patching compatibility.