Results for “rounding_cd”

50+ results




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

Overview

BEN_SCHEDD_HRS_RT_F is a table in the BEN schema of Oracle E-Business Suite Advanced Benefits (BEN). It stores rates that are applicable to a scheduled hours value, forming part of the configuration and calculation logic used to determine benefits eligibility, coverage, and cost for plan participants. In EBS release 12.1.1 and 12.2.2, this table is documented as VALID and belongs to the BEN product family, which encompasses plan design, eligibility, rate determination, and enrollment processing.

The table carries a heuristic Data Vault classification of "standalone," meaning that the mined foreign-key structure does not reveal strong dependency relationships to other tables. From a modeling perspective, this suggests the object behaves more like a reference or configuration table rather than a transaction hub or link. It is a date-effective (non-history) table, evident from its _F suffix, and its effective-dating model is enforced by the composite primary key columns.

Key Information Stored

The table contains 52 documented columns. The most significant are summarized below.

The surrogate primary key is SCHEDD_HRS_RT_ID combined with the effective dates; no separate single-column unique index is documented beyond this composite key.

Common Use Cases and Queries

Typical scenarios include verifying that a rate exists for a given scheduled-hours band, auditing effective-dated rate changes, and reporting on rates tied to a business group. A common pattern restricts rows to a specific "as of" date using the effective dates:

  • Point-in-time lookup: SELECT * FROM ben.ben_schedd_hrs_rt_f WHERE schedd_hrs_rt_id = :id AND TRUNC(SYSDATE) BETWEEN effective_start_date AND effective_end_date;
  • Business group reporting: SELECT hrs_num, max_hrs_num, freq_cd FROM ben.ben_schedd_hrs_rt_f WHERE business_group_id = :bg_id AND SYSDATE BETWEEN effective_start_date AND effective_end_date ORDER BY ordr_num;
  • Rounding and determination audit: selecting DETERMINATION_CD, ROUNDING_CD, and VRBL_RT_PRFL_ID to trace how a rate is resolved.
  • DFF value extraction from SHR_ATTRIBUTE columns for downstream analytics.

Because the table is standalone and configuration-oriented, it is more commonly read than written by concurrent processes; updates normally flow through the Advanced Benefits setup forms or concurrent programs rather than direct DML.

Related Objects

Given its standalone Data Vault classification, no foreign-key relationships are documented in the provided metadata. The following objects are significant for practical work with this table:

  • BEN_SCHEDD_HRS_RT_F_PK — Composite primary key index (SCHEDD_HRS_RT_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE).
  • BEN.BEN_SCHEDD_HRS_RT — The corresponding non-date-tracked configuration entity, where applicable to the same scheduled-hours rate concept.
  • BEN.BEN_VRBL_RT_PRFL_F — Variable rate profile definition referenced via VRBL_RT_PRFL_ID.
  • BEN.BEN_PGM_F / BEN.BEN_PL_F — Program and plan definitions that consume rate configuration during eligibility and enrollment processing.
  • BEN.BEN_ROUNDING_RL / BEN.BEN_DETERMINATION_RL — Related-rule definitions matched to ROUNDING_RL and DETERMINATION_RL.
  • HR.HR_ORGANIZATION_UNITS — Source of BUSINESS_GROUP_ID context for multi-organization rate setup.
  • FND.FND_DESCR_FLEX_COL_USAGE_VL — Flexfield metadata underlying SHR_ATTRIBUTE_CATEGORY and the 30 attribute columns.

These associations rely on identifier columns rather than enforced foreign keys, consistent with the standalone classification.