Results for “rec_val”

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

Overview

BEN_CWB_PERSON_RATES is a transactional table within the Oracle Advanced Benefits (BEN) module of Oracle E-Business Suite, holding "CWB Person Rates" — the per-person compensation, salary, and rate values captured during a Compensation Workbench (CWB) cycle. The table resides in the BEN schema and is classified as VALID in ETRM 12.2.2, with a documented physical schema of 57 columns. It serves as the store of record for the individual-level monetary inputs that drive benefits eligibility, imputed income calculations, flexible credit allocation, and cost distribution during an enrollment or compensation planning cycle.

Based on the heuristic Data Vault classification mined from its foreign-key structure, the table is modeled as standalone. This classification is a modeling suggestion: although BEN_CWB_PERSON_RATES carries a surrogate primary key and several outbound foreign keys, it does not participate in a classic hub-and-link topology in the mined relationship graph. From a dimensional perspective, it behaves as a transaction-level fact table keyed at the person-rate grain, with descriptive context supplied by the tables it references.

Key Information Stored

The unique index BEN_CWB_PERSON_RATES_PK, defined on the column PERSON_RATE_ID, is the documented primary key and the surrogate identifier for each person-rate row. No separate business-key unique index is documented beyond this PK.

• PERSON_RATE_ID — surrogate primary key; unique row identifier.
• GROUP_PER_IN_LER_ID — foreign key to BEN_CWB_PERSON_INFO; links the rate record to the person's enrollment/plan information context.
• PERSON_ID and ASSIGNMENT_ID — identify the person and assignment to which the rates apply.
• PL_ID, OIPL_ID, GROUP_PL_ID, GROUP_OIPL_ID — plan, option-in-plan, and grouped plan references that scope the rates.
• ELIG_FLAG and INELIG_RSN_CD — eligibility status and the reason code where a person is ineligible.
• WS_VAL, WS_MN_VAL, WS_MX_VAL, WS_INCR_VAL — working salary value and its minimum, maximum, and increment bounds.
• ELIG_SAL_VAL, STAT_SAL_VAL, OTH_COMP_VAL, TOT_COMP_VAL — eligible salary, stated salary, other compensation, and total compensation.
• REC_VAL, REC_MN_VAL, REC_MX_VAL, REC_INCR_VAL — recommended value and its bounds/increment.
• PAY_PROPOSAL_ID — foreign key to PER_PAY_PROPOSALS; ties the rate to the associated salary proposal.
• CURRENCY — currency of the monetary values.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, OBJECT_VERSION_NUMBER — standard audit and optimistic-locking columns.

Common Use Cases and Queries

Typical scenarios include reconciling a person's captured CWB rates against the resulting pay proposal, validating eligibility outcomes, and reporting the spread between current and recommended salary. Because the table is scoped by plan and person context, queries commonly join to BEN_CWB_PERSON_INFO and PER_PAY_PROPOSALS.

• Reporting all rates for a person in a cycle: SELECT person_rate_id, person_id, ws_val, tot_comp_val, rec_val FROM ben.ben_cwb_person_rates WHERE person_id = :p_person_id;
• Joining rates to pay proposals: ... WHERE r.pay_proposal_id = p.pay_proposal_id;
• Filtering ineligible records via ELIG_FLAG / INELIG_RSN_CD and plan scope via PL_ID.
• Feeding downstream reporting through BEN_CWB_RPT_DETAIL, which references PERSON_RATE_ID.

Related Objects

• BEN_CWB_PERSON_INFO — referenced via GROUP_PER_IN_LER_ID; supplies person enrollment context.
• PER_PAY_PROPOSALS — referenced via PAY_PROPOSAL_ID; the resulting salary proposal.
• BEN_CWB_RPT_DETAIL — references this table via PERSON_RATE_ID for reporting detail.
• Standard WHO/audit columns link to FND_USER and related audit infrastructure.