Results for “batch_rt_id”

50+ results




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

Overview

BEN_BATCH_RATE_INFO is a table in the BEN (Advanced Benefits) product schema of Oracle E-Business Suite, present in both release 12.1.1 and 12.2.2. The ETRM metadata describes the object as holding "Rate information created during batch run," indicating that it captures the rate values computed and stored by the Benefits batch processes that evaluate eligibility, electability, and rate determination for participants. Rather than representing the definitive rate configuration, this table records the transient output of batch rate calculation runs, linking each rate record back to a specific benefit action.

The table is owned by the BEN schema and carries a documented physical schema of 28 columns. Its primary key is BEN_BATCH_RATE_INFO_PK, defined on the BATCH_RT_ID column, which serves as the surrogate identifier for each rate row. The single documented foreign key is BEN_BATCH_RATE_INFO.BENEFIT_ACTION_ID, which references BEN_BENEFIT_ACTIONS. Based on the mined foreign key structure, the heuristic Data Vault classification for this object is satellite-leaning, suggesting it is best modeled as a descriptive satellite attached to the benefit action hub rather than as a hub or link in its own right.

Key Information Stored

The most significant columns in BEN_BATCH_RATE_INFO fall into several functional categories.

Common Use Cases and Queries

Because this table stores batch-generated rate output, it is most commonly queried to audit or report on rate calculations produced by batch runs. Typical patterns include retrieving all rates tied to a participant or benefit action, comparing current and prior values, and filtering rates by type or effective date.

  • Auditing rate changes by comparing VAL against OLD_VAL for a given BENEFIT_ACTION_ID.
  • Reporting participant rate amounts joined to program/plan for a business group.
  • Validating election boundaries against MN_ELCN_VAL and MX_ELCN_VAL.
  • Reconciling batch results to enrollment coverage dates using ENRT_CVG_STRT_DT and ENRT_CVG_THRU_DT.

A representative query joins the table to its parent action: SELECT r.BATCH_RT_ID, r.PERSON_ID, r.PL_ID, r.BNFT_RT_TYP_CD, r.VAL FROM BEN.BEN_BATCH_RATE_INFO r WHERE r.BENEFIT_ACTION_ID = :action_id.

Related Objects

The principal related object is the parent table BEN_BENEFIT_ACTIONS, joined on BEN_BATCH_RATE_INFO.BENEFIT_ACTION_ID = BEN_BENEFIT_ACTIONS.BENEFIT_ACTION_ID. Downstream reporting frequently joins the table to BEN_PER_PL_F (participant plan enrollment) via PERSON_ID and PL_ID, to BEN_PGM_F (program) via PGM_ID, and to BEN_PL_F (plan) via PL_ID. Rate configuration validation commonly references BEN_BNFT_RT_TYP, and audit reporting may join to FND_USER for the LAST_UPDATED_BY column. Because the documented relationship data is limited to the single foreign key, these additional associations should be confirmed against the live 12.2.2 schema prior to production use.