Search Results csf_rating_scales_b




Overview
Explore in AI Chat

Overview

The CSF_RATING_SCALES_B table is a core data object within the Oracle E-Business Suite (EBS) Field Service (CSF) module. It functions as the master repository for defining rating scales, which are foundational to the system's skill and competency management framework. In the context of service delivery, these scales provide the standardized measurement criteria against which technician skills and proficiencies are assessed and categorized. The table's role is to establish the permissible rating values—such as numeric scores or descriptive levels—that can be assigned to skill types and their corresponding skill levels, ensuring consistency in resource qualification and assignment.

Key Information Stored

As a base table following the Oracle EBS convention, CSF_RATING_SCALES_B primarily stores the unique identifier and fundamental attributes for each rating scale. The primary and most critical column is RATING_SCALE_ID, which serves as the unique primary key for each scale definition. While the provided ETRM excerpt does not list additional columns, typical columns in such a table would include fields for the scale's name, a description, an enabled flag, and creation/update metadata (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE). The data in this table is essential for enforcing data integrity in related skill management tables.

Common Use Cases and Queries

This table is central to administrative setups and reporting within Field Service. Common use cases include the initial configuration of the skill management system, where an administrator defines scales like "1-5 Proficiency" or "Beginner, Intermediate, Expert." It is also critical for generating reports on skill distribution across the service workforce. A typical query would involve joining this table to its related child tables to list all defined scales and their associated skill types.

  • Retrieving all active rating scales: 
    SELECT rating_scale_id, name FROM csf_rating_scales_b WHERE enabled_flag = 'Y' ORDER BY name;
  • Finding skill types linked to a specific rating scale: 
    SELECT st.skill_type_name, rs.name as scale_name
FROM csf_rating_scales_b rs, csf_skill_types_b st
WHERE rs.rating_scale_id = st.rating_scale_id
AND rs.rating_scale_id = :p_scale_id;

Related Objects

The CSF_RATING_SCALES_B table is a parent table with defined foreign key relationships to two key skill management entities, as documented in the ETRM. These relationships are fundamental to the data model.

  • CSF_SKILL_TYPES_B: This table references CSF_RATING_SCALES_B via the foreign key column RATING_SCALE_ID. This links each defined skill type (e.g., "HVAC Repair," "Software Installation") to a specific rating scale used to measure proficiency in that skill.
  • CSF_SKILL_LEVELS_B: This table also references CSF_RATING_SCALES_B via the foreign key column RATING_SCALE_ID. This relationship ties individual competency levels (e.g., "Level 1," "Expert") to the overarching rating scale, defining the discrete values within that scale.

These relationships ensure that all skill definitions and their proficiency levels are governed by a consistent, centrally managed rating scale, maintaining referential integrity across the Field Service skill hierarchy.