Search Results cn_attain_tiers




Overview
Explore in AI Chat

Overview

The CN_ATTAIN_TIERS table is a core data object within the Oracle E-Business Suite Incentive Compensation module (CN). It functions as a repository for the tiered attainment percentages defined within an attainment schedule. An attainment schedule is a critical component of compensation plans, establishing performance thresholds that determine payout rates. This table stores the specific percentage levels of attainment that are visually presented and calculated within compensation contracts. Its primary role is to provide the structured, tiered data necessary for the system to evaluate performance against targets and compute corresponding incentive earnings accurately.

Key Information Stored

The table's structure is designed to link attainment percentages to their parent schedule and define their order. The most critical column is the primary key, ATTAIN_TIER_ID, which uniquely identifies each attainment percentage record. Another essential column is ATTAIN_SCHEDULE_ID, a foreign key that links each tier to its parent attainment schedule in the CN_ATTAIN_SCHEDULES table. This relationship is fundamental for grouping tiers. While the exact column list is not fully detailed in the provided metadata, based on its described purpose, the table must also contain columns such as ATTAINMENT_PERCENTAGE (or similar) to store the specific percentage value for the tier, and likely a SEQUENCE_NUMBER or TIER_NUMBER to define the order of tiers within a schedule for proper evaluation logic.

Common Use Cases and Queries

This table is central to operations involving the configuration and reporting of compensation plans. A common use case is the generation of contract documents, where the defined attainment tiers are displayed to outline the compensation structure. From a reporting perspective, analysts often query this table to audit or list all attainment percentages for a given schedule. A typical SQL pattern involves joining to the parent schedule table to provide context.

  • Listing Tiers for a Schedule: SELECT attain_tier_id, attainment_percentage FROM cn_attain_tiers WHERE attain_schedule_id = &SCHED_ID ORDER BY sequence_num;
  • Validating Schedule Configuration: Queries are used to ensure schedules have logically ordered tiers (e.g., ascending percentages) and no gaps, which is crucial for accurate commission calculations during payroll processing.

Related Objects

The CN_ATTAIN_TIERS table exists within a tightly integrated schema. Its most direct relationship is defined by its foreign key constraint (CN_ATTAIN_TIERS.ATTAIN_SCHEDULE_ID) referencing the CN_ATTAIN_SCHEDULES table. Attainment schedules, and by extension their tiers, are ultimately assigned to compensation plans and quotas. Therefore, this table has indirect but important dependencies with core compensation objects like CN_QUOTAS and CN_COMMISSION_PAYMENTS. Data from CN_ATTAIN_TIERS is also surfaced through various Incentive Compensation views and is accessed by the module's APIs for plan configuration and calculation engines.