Results for “ben_svc_area_rt_f”

50+ results




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

Overview

BEN_SVC_AREA_RT_F is a dated (effective-dated) table within the Oracle Advanced Benefits (BEN) product module, owned by the BEN schema. Its documented purpose is to store the rates applicable to a service area, providing the rate configuration that drives eligibility and cost calculations when a service area is used in a benefits offering. The "_F" suffix denotes an effective-dated (date-tracked) entity, and the table therefore carries the standard DateTrack key columns EFFECTIVE_START_DATE and EFFECTIVE_END_DATE alongside its surrogate identifier.

Under the heuristic Data Vault classification mined from the foreign-key structure, this object is modeled as standalone. In Data Vault terms, a standalone classification suggests the table is best treated as a reference or lookup entity rather than a dependent link or a pure satellite, because its documented FK structure does not resolve into an obvious parent hub-and-link grouping. This is offered strictly as a modeling suggestion; the physical object remains a standard EBS dated table with a composite primary key.

Key Information Stored

The table exposes 45 documented columns. The most significant are the identity, DateTrack, and relationship columns; the remaining columns are audit and descriptive attribute fields.

No surrogate-to-business-key distinction beyond the composite PK is documented; the PK itself serves as the business-key candidate unique index.

Common Use Cases and Queries

The table is queried predominantly in benefits configuration and rate-determining reports. A common pattern resolves currently effective rates for a service area by filtering on the DateTrack columns:

  • Look up active rates: SELECT svc_area_rt_id, svc_area_id, vrbl_rt_prfl_id, ordr_num FROM ben.ben_svc_area_rt_f WHERE svc_area_id = :p_svc_area_id AND TRUNC(SYSDATE) BETWEEN effective_start_date AND effective_end_date ORDER BY ordr_num;
  • Audit a rate record's change history by querying all DateTrack versions for a single SVC_AREA_RT_ID.
  • Join to variable-rate profile tables (via VRBL_RT_PRFL_ID) to expose calculation definitions for reporting.
  • Extract DFF values (SAR_ATTRIBUTE_CATEGORY plus SAR_ATTRIBUTE1..30) for regulatory or client-specific extracts.
  • Reconcile exclusion logic by inspecting EXCLD_FLAG when building eligibility extracts.

Because the "_F" table is DateTrack-enabled, all reporting queries should constrain on effective dates; failing to do so will return historical versions and inflate result sets.

Related Objects

The mined relationship data classifies this table as standalone, so no outbound foreign keys are documented. The following related objects are the most significant for joins and dependency analysis:

  • BEN_SVC_AREA_F (or the service area definition entity) — joined via SVC_AREA_ID to obtain service area attributes.
  • Variable rate profile tables — joined via VRBL_RT_PRFL_ID to resolve rate calculation definitions.
  • BEN_SVC_AREA_RT_F_PK — the primary key constraint and unique index, used for direct key-based access.
  • Business group / HR organization tables — joined via BUSINESS_GROUP_ID for reporting segmentation.
  • Standard EBS DateTrack and Who-column infrastructure — the audit and effective-dating columns inherited by all BEN dated entities and referenced by concurrent processes and the Benefits APIs that maintain this table.

Maintenance of the table is performed through the Advanced Benefits configuration UI and its underlying date-tracked DML, so direct DML should be avoided in production.