Search Results role_model_id

Overview

The CN_ROLE_MODELS_ALL table is a core data structure within the Oracle E-Business Suite Incentive Compensation module (CN). It serves as the primary repository for storing different agreement versions, or models, associated with a specific compensation role. In the context of incentive compensation, a role defines a participant's position and responsibilities, such as a sales representative or manager. This table enables the management of multiple, versioned compensation plans (agreements) for a single role over time, allowing for historical tracking and plan evolution without losing prior configurations. Its ALL suffix indicates it is a multi-organization enabled table, storing data partitioned by operating unit.

Key Information Stored

While the specific column list is not detailed in the provided metadata, the primary and foreign key relationships define its critical data elements. The table's primary key is ROLE_MODEL_ID, a unique identifier for each role model record. Based on standard EBS design patterns and the documented foreign keys, the table likely stores columns such as ROLE_ID (linking to the base role definition), a version number or effective date range for the model, and status indicators. Crucially, it contains an ATTAIN_SCHEDULE_ID, a foreign key to CN_ATTAIN_SCHEDULES, which links the role model to a specific attainment schedule governing quota and performance calculations.

Common Use Cases and Queries

This table is central to queries involving the history and structure of compensation plans. A common use case is retrieving all active agreement models for a specific role or operating unit to validate current plan configurations. Another is historical reporting to compare how a role's compensation terms have changed across different fiscal periods. Database administrators or implementers may query this table to diagnose data integrity issues related to quota assignments. A typical analytical query would join CN_ROLE_MODELS_ALL with CN_SRP_ROLE_DTLS_ALL to analyze role model assignments by salesperson.

SELECT rm.role_model_id, rm.role_id, srd.salesrep_id
FROM cn_role_models_all rm,
     cn_srp_role_dtls_all srd
WHERE rm.role_model_id = srd.role_model_id
AND rm.org_id = :p_org_id;

Related Objects

The CN_ROLE_MODELS_ALL table has integral relationships with several other Incentive Compensation tables, as defined by its foreign key constraints. It is a parent table to CN_ROLE_QUOTA_CATES, CN_SRP_QUOTA_CATES_ALL, and CN_SRP_ROLE_DTLS_ALL, which store quota category assignments and detailed salesperson role mappings, respectively. Conversely, it is a child table to CN_ATTAIN_SCHEDULES via the ATTAIN_SCHEDULE_ID column, linking each role model version to its performance calculation schedule. These relationships form a key part of the data model for defining and assigning compensation plans.