Search Results attain_schedule_id

Overview

The CN_ATTAIN_SCHEDULES table is a core data object within the Oracle E-Business Suite (EBS) Incentive Compensation (CN) module, specifically for versions 12.1.1 and 12.2.2. It serves as a master repository for defining attainment schedules, which are foundational components of compensation plans. An attainment schedule formally structures the relationship between performance levels (tiers) and the corresponding payout rates or multipliers. By centralizing the definition of these schedules, the table enables their consistent application across multiple compensation contracts, role models, and role details, ensuring standardized calculation logic for incentive earnings.

Key Information Stored

The primary data stored in this table is the unique identifier and descriptive name for each attainment schedule. While the full column list is not detailed in the provided metadata, the structure is anchored by the ATTAIN_SCHEDULE_ID column, which serves as the table's primary key (CN_ATTAIN_SCHEDULES_PK). This numeric or alphanumeric identifier is the critical foreign key referenced by dependent objects throughout the compensation setup. A column for the schedule's name is implied by the table's description, storing the human-readable label for the attainment schedule used in administrative interfaces. Additional columns likely exist to track metadata such as creation date, last update date, and active status.

Common Use Cases and Queries

This table is primarily accessed during the design, administration, and auditing of compensation plans. Common operational scenarios include querying all available schedules for assignment to a new contract, validating schedule usage, and identifying unused schedules for cleanup. A fundamental query to retrieve all defined schedules would be: SELECT attain_schedule_id, name FROM cn_attain_schedules WHERE NVL(end_date_active, SYSDATE) >= SYSDATE ORDER BY name;. For troubleshooting or impact analysis, administrators often join this table to its child objects to see where a specific schedule is applied, using the ATTAIN_SCHEDULE_ID to link to CN_ATTAIN_TIERS (which holds the detailed tier thresholds and rates), CN_ROLE_DETAILS, and CN_ROLE_MODELS_ALL.

Related Objects

The CN_ATTAIN_SCHEDULES table has defined relationships with several key Incentive Compensation tables, as confirmed by the foreign key metadata. Its primary key (ATTAIN_SCHEDULE_ID) is referenced by:

• CN_ATTAIN_TIERS: This is the most critical related table. It stores the detailed tier definitions (e.g., start range, end range, attainment percentage, rate) for each schedule.
• CN_ROLE_DETAILS: References the schedule to define compensation rules for specific roles.
• CN_ROLE_MODELS_ALL: References the schedule within compensation role models, which are templates for defining compensable positions.

These relationships establish CN_ATTAIN_SCHEDULES as a parent master table, ensuring data integrity and enabling centralized management of attainment logic across the compensation system.