Search Results comp_lvl_fctr_name




Overview
Explore in AI Chat

Overview

APPS.BEN_COMP_LVL_RT_D is a reporting view in the Oracle E-Business Suite Advanced Benefits (BEN) module. It presents compensation level rate records with denormalized, user-readable descriptive information joined from several related configuration tables. The view is defined over the BEN_COMP_LVL_FCTR, BEN_COMP_LVL_RT_F, BEN_VRBL_RT_PRFL_F, FND_USER, and HR_LOOKUPS objects, and it exposes both the surrogate identifiers and the descriptive names required for reporting and integration consumption.

The object is particularly relevant to queries involving the comp_lvl_fctr (compensation level factor) column, since the factor name is surfaced directly as a NAME column rather than requiring a separate join to BEN_COMP_LVL_FCTR. Its role is to support inquiry screens, concurrent reports, and extracts where a user needs to see compensation level rates alongside the associated factor, variable rate profile, exclusion indicator, and last-updated audit information in a single pass.

Underlying Base Objects

The view is defined over the following documented base objects:

  • BEN_COMP_LVL_RT_F — the primary driving table, aliased CLR, supplying the compensation level rate rows, effective dates, order number, exclusion flag, and audit columns.
  • BEN_COMP_LVL_FCTR — aliased COMP_LVL_FCTR, joined on COMP_LVL_FCTR_ID to provide the compensation level factor name. This is the object most directly associated with the comp_lvl_fctr search term.
  • BEN_VRBL_RT_PRFL_F — aliased VRBL_RT_PRFL, joined on VRBL_RT_PRFL_ID, with the join further constrained by effective date range so that the profile name in context is returned.
  • FND_USER — aliased FUSER, outer-joined on LAST_UPDATED_BY to return the user name of the last modifier.
  • HR_LOOKUPS — aliased EXCLD, outer-joined on LOOKUP_CODE = EXCLD_FLAG and LOOKUP_TYPE = 'YES_NO' to translate the flag into a meaning.
  • HR_API — a package reference documented among the base objects, supporting the date-effective logic typical of BEN date-tracked entities.

All joins other than the driving table are outer joins, so the view returns the core rate row even when a related factor, profile, lookup, or user record is not found.

Key Columns

  • ROW_ID — the ROWID of the underlying BEN_COMP_LVL_RT_F row, useful for direct DML or row identification.
  • COMP_LVL_RT_ID — the primary key of the compensation level rate record.
  • EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — the date-effective range of the rate row.
  • NAME — appears twice in the select list: first as the compensation level factor name and second as the variable rate profile name. Consumers should reference these positionally or via a wrapping query with explicit aliases.
  • ORDR_NUM — the ordering sequence number for the rate row.
  • MEANING — the decoded YES/NO meaning of the exclusion flag from HR_LOOKUPS.
  • LAST_UPDATE_DATE — audit timestamp of the most recent change.
  • USER_NAME — the FND_USER name of the last updater.

Common Use Cases and Queries

The view is typically used to report compensation level rates with their contextual factor and profile names, or to validate configuration during implementation and data migration. A representative query filtering on the compensation level factor is:

  • SELECT comp_lvl_rt_id, effective_start_date, effective_end_date, ordr_num, meaning, last_update_date, user_name FROM apps.ben_comp_lvl_rt_d WHERE effective_start_date <= SYSDATE AND effective_end_date >= SYSDATE;
  • To isolate rows tied to a specific factor, wrap the view and reference the factor NAME column positionally or by alias in an inline view, since the view text does not alias the duplicate NAME columns.
  • To exclude inactive or excluded rates, filter on meaning = 'No' or the corresponding EXCLD_FLAG value.

Because the view applies date-effective logic to both the driving table and the variable rate profile, integrations should always constrain or account for effective ranges to avoid returning unintended historical rows.