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.
- SVC_AREA_RT_ID — surrogate primary key identifier for the service area rate record.
- EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — DateTrack columns that, together with SVC_AREA_RT_ID, form the composite primary key BEN_SVC_AREA_RT_F_PK and the sole documented unique index (the business-key candidate).
- SVC_AREA_ID — reference to the service area for which the rate applies.
- VRBL_RT_PRFL_ID — reference to the variable rate profile that defines how the rate is derived or calculated.
- EXCLD_FLAG — flag controlling exclusion behavior for the rate record.
- BUSINESS_GROUP_ID — the business group (legislative data group context) to which the record belongs.
- ORDR_NUM — ordering sequence used to control evaluation or display precedence.
- SAR_ATTRIBUTE_CATEGORY and SAR_ATTRIBUTE1 through SAR_ATTRIBUTE30 — a flexible descriptive-attribute (DFF) block enabling client-specific extensions on the rate record.
- OBJECT_VERSION_NUMBER — optimistic locking / concurrency control column required in EBS 12.2.x and available in 12.1.1.
- LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — standard audit Who-columns.
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.
-
Rates applicable to a service area.
-
Rates applicable to a service area.
-
TABLE: BEN.BEN_SVC_AREA_RT_F 12.2.2
-
TABLE: BEN.BEN_SVC_AREA_RT_F 12.1.1
-
View: BEN_SVC_AREA_RT_D 12.2.2
- Retrofitted
APPS.BEN_SVC_AREA_RT_D·↳ BEN_SVC_AREA_F·↳ BEN_SVC_AREA_RT_F·↳ BEN_VRBL_RT_PRFL_F·Explore BEN module →
-
PACKAGE: APPS.BEN_SAR_BUS 12.1.1
-
View: BEN_SVC_AREA_RT_D 12.1.1
- Retrofitted
APPS.BEN_SVC_AREA_RT_D·↳ BEN_SVC_AREA_F·↳ BEN_SVC_AREA_RT_F·↳ BEN_VRBL_RT_PRFL_F·Explore BEN module →
-
PACKAGE: APPS.BEN_SAR_BUS 12.2.2
-
VIEW: BEN.BEN_SVC_AREA_RT_F# 12.2.2
-
View: BEN_SVC_AREA_RT_V 12.2.2
- Retrofitted
APPS.BEN_SVC_AREA_RT_V·↳ BEN_SVC_AREA_RT_F·↳ FND_SESSIONS·Explore BEN module →
-
View: BEN_SVC_AREA_RT 12.2.2
- Retrofitted
APPS.BEN_SVC_AREA_RT·↳ BEN_SVC_AREA_RT_F·↳ FND_SESSIONS·Explore BEN module →
-
View: BEN_SVC_AREA_RT_X 12.2.2
- Retrofitted
APPS.BEN_SVC_AREA_RT_X·↳ BEN_SVC_AREA_RT_F·Explore BEN module →
-
PACKAGE: APPS.BEN_SAR_DEL 12.1.1
-
PACKAGE: APPS.BEN_SAR_SHD 12.2.2
-
View: BEN_SVC_AREA_RT_X 12.1.1
- Retrofitted
APPS.BEN_SVC_AREA_RT_X·↳ BEN_SVC_AREA_RT_F·Explore BEN module →
-
View: BEN_SVC_AREA_RT_V 12.1.1
- Retrofitted
APPS.BEN_SVC_AREA_RT_V·↳ BEN_SVC_AREA_RT_F·↳ FND_SESSIONS·Explore BEN module →
-
PACKAGE: APPS.BEN_SAR_SHD 12.1.1