Results for “ben_batch_rate_info”
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.
- BATCH_RT_ID — the surrogate primary key defined by BEN_BATCH_RATE_INFO_PK. This is the unique identifier for each batch rate record.
- BENEFIT_ACTION_ID — the foreign key linking the rate record to BEN_BENEFIT_ACTIONS; this is the business-key candidate connecting rate output to the triggering action.
- PERSON_ID, PGM_ID, PL_ID, OIPL_ID — participant, program, plan, and option-in-plan identifiers that scope the rate to the correct benefit offering.
- ENRT_CVG_STRT_DT, ENRT_CVG_THRU_DT, RT_STRT_DT — enrollment coverage start, coverage through, and rate effective start dates that anchor the rate in time.
- BNFT_RT_TYP_CD, TX_TYP_CD, ACTY_TYP_CD — rate type, tax type, and activity type codes that classify the nature of the calculated amount.
- VAL, DFLT_VAL, OLD_VAL — the computed rate value, its default value, and the prior value, supporting change comparison.
- MN_ELCN_VAL, MX_ELCN_VAL, INCRMT_ELCN_VAL — minimum, maximum, and increment election values that bound allowable participant selections.
- DFLT_FLAG, ACTN_CD, CLOSE_ACTN_ITM_DT — default indicator, action code, and action item close date.
- BUSINESS_GROUP_ID — the operating unit/legislative data group context for multi-organization filtering.
- LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE, OBJECT_VERSION_NUMBER — standard audit and concurrency columns.
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.
-
Rate information created during batch run.
-
Rate information created during batch run.
-
PACKAGE: APPS.BEN_BRI_DEL 12.2.2
-
PACKAGE: APPS.BEN_BRI_DEL 12.1.1
-
PACKAGE: APPS.BEN_BRI_UPD 12.1.1
-
PACKAGE: APPS.BEN_BRI_INS 12.2.2
-
PACKAGE: APPS.BEN_BRI_UPD 12.2.2
-
View: BEN_WFREP_RATE_INFO_VW 12.1.1
APPS.BEN_WFREP_RATE_INFO_VW·↳ BEN_BATCH_RATE_INFO·↳ BEN_BENEFIT_ACTIONS·↳ BEN_OIPL_F·Explore BEN module →
-
PACKAGE: APPS.BEN_BRI_BUS 12.2.2
-
View: BEN_WFREP_RATE_INFO_VW 12.2.2
APPS.BEN_WFREP_RATE_INFO_VW·↳ BEN_BATCH_RATE_INFO·↳ BEN_BENEFIT_ACTIONS·↳ BEN_OIPL_F·Explore BEN module →
-
PACKAGE: APPS.BEN_BRI_INS 12.1.1