Results for “shr_attribute_category”
36 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.
- SCHEDD_HRS_RT_ID — Surrogate identifier for the scheduled-hours rate record; part of the primary key.
- EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — Date-effective bounds that, together with SCHEDD_HRS_RT_ID, constitute the composite primary key BEN_SCHEDD_HRS_RT_F_PK and act as the business-key candidate.
- BUSINESS_GROUP_ID — Identifies the HR business group to which the rate row belongs, enabling multi-organization partitioning of setup data.
- EXCLD_FLAG — Exclusion indicator, typically used to stipulate whether the rate applies or is excluded from a given calculation context.
- HRS_NUM — The scheduled hours quantity associated with the rate.
- MAX_HRS_NUM — Ceiling on hours applied when determining the rate.
- FREQ_CD — Frequency code defining the interval over which the rate is expressed.
- VRBL_RT_PRFL_ID — Reference to a variable rate profile used in rate determination.
- DETERMINATION_CD / DETERMINATION_RL — The determination code and its related-rule reference, governing how the rate is selected.
- ROUNDING_CD / ROUNDING_RL — Rounding rule code and related-rule reference applied to computed amounts.
- SCHEDD_HRS_RL — Related-rule reference for the scheduled hours logic.
- ORDR_NUM — Ordering sequence for evaluation of rate rows.
- SHR_ATTRIBUTE_CATEGORY and SHR_ATTRIBUTE1–30 — Descriptive flexfield (DFF) columns supporting the scheduled-hours rate flexfield context.
- OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE — Standard WHO columns for concurrency control and audit.
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.
-
Rates applicable to a scheduled hours.
-
Rates applicable to a scheduled hours.
-
View: BEN_SCHEDD_HRS_RT 12.1.1
- Retrofitted
APPS.BEN_SCHEDD_HRS_RT·↳ BEN_SCHEDD_HRS_RT_F·↳ FND_SESSIONS·Explore BEN module →
-
View: BEN_SCHEDD_HRS_RT_V 12.1.1
- Retrofitted
APPS.BEN_SCHEDD_HRS_RT_V·↳ BEN_SCHEDD_HRS_RT_F·↳ FND_SESSIONS·Explore BEN module →
-
View: BEN_SCHEDD_HRS_RT_V 12.2.2
- Retrofitted
APPS.BEN_SCHEDD_HRS_RT_V·↳ BEN_SCHEDD_HRS_RT_F·↳ FND_SESSIONS·Explore BEN module →
-
View: BEN_SCHEDD_HRS_RT_X 12.2.2
- Retrofitted
APPS.BEN_SCHEDD_HRS_RT_X·↳ BEN_SCHEDD_HRS_RT_F·Explore BEN module →
-
View: BEN_SCHEDD_HRS_RT_X 12.1.1
- Retrofitted
APPS.BEN_SCHEDD_HRS_RT_X·↳ BEN_SCHEDD_HRS_RT_F·Explore BEN module →
-
View: BEN_SCHEDD_HRS_RT 12.2.2
- Retrofitted
APPS.BEN_SCHEDD_HRS_RT·↳ BEN_SCHEDD_HRS_RT_F·↳ FND_SESSIONS·Explore BEN module →
-
VIEW: APPS.BEN_SCHEDD_HRS_RT 12.2.2
-
VIEW: APPS.BEN_SCHEDD_HRS_RT 12.1.1
-
PACKAGE: APPS.BEN_SHR_SHD 12.1.1
-
PACKAGE: APPS.BEN_SHR_SHD 12.2.2
-
eTRM - BEN Tables and Views 12.1.1
Start and End periods.
-
eTRM - BEN Tables and Views 12.2.2
Start and End periods.