Results for “csf_rating_scales_b”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CSF_RATING_SCALES_B is a table owned by the CSF schema within the Field Service (CSF) product family of Oracle E-Business Suite, present and VALID in release 12.1.1 and 12.2.2. The ETRM metadata describes the object broadly as holding "skill types," reflecting its role in the competency framework that underpins field service dispatch and resource assignment. Functionally, the table stores the header-level definitions of rating scales — the ranked measurement schemes against which individual skill levels and skill types are evaluated. A rating scale supplies the permissible range of proficiency values that the scheduling engine and skill-matching logic use to qualify a technician, an engineer, or other service resource for a task.

Heuristically, the table's extracted FK topology classifies it as hub-leaning under a Data Vault modeling interpretation, which is a modeling suggestion rather than a documented design fact. This classification aligns with the observed pattern: CSF_RATING_SCALES_B holds the durable business key (the rating scale identity) and is referenced by dependent child tables that attach descriptive, level-specific detail to it. The table is edition-enabled, as evidenced by the presence of the ZD_EDITION_NAME column and its inclusion in the unique index CSF_RATING_SCALES_B_U1, indicating compatibility with the Edition-Based Redefinition (EBR) architecture introduced in 12.2.

Key Information Stored

The table is documented with 28 columns in the 12.2.2 physical schema. The surrogate primary key is RATING_SCALE_ID, enforced through the constraint CSF_RATING_SCALE_B_PK. The documented unique index CSF_RATING_SCALES_B_U1 spans (RATING_SCALE_ID, ZD_EDITION_NAME), which is the business-key candidate; the addition of ZD_EDITION_NAME rather than a separate human-readable code reflects the edition-aware keying strategy.

The most significant columns include:

• RATING_SCALE_ID — surrogate primary key identifying each rating scale.
• START_DATE_ACTIVE and END_DATE_ACTIVE — the effective date range governing when the scale may be selected or applied.
• SEEDED_FLAG — indicates whether the row was delivered as seed data by Oracle versus defined by the customer.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, enabling multi-tenant data partitioning.
• OBJECT_VERSION_NUMBER — optimistic locking column used by the Oracle Applications Framework for concurrent-update control.
• ZD_EDITION_NAME — the edition identifier supporting Edition-Based Redefinition.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard WHO audit columns capturing row provenance.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the industry-standard descriptive flexfield (DFF) columns for customer-extensible data.

Common Use Cases and Queries

Typical reporting and integration scenarios involve retrieving active rating scales, validating skill-matching configuration, and auditing customer-defined versus seeded definitions. A representative query returning currently effective scales is:

• SELECT rating_scale_id, seeded_flag, start_date_active, end_date_active FROM csf.csf_rating_scales_b WHERE TRUNC(SYSDATE) BETWEEN NVL(start_date_active, SYSDATE) AND NVL(end_date_active, SYSDATE + 1);

To enumerate the skill levels and skill types governed by each scale, join the dependent tables on the shared foreign key:

• SELECT rs.rating_scale_id, sl.skill_level_id, st.skill_type_id FROM csf.csf_rating_scales_b rs LEFT JOIN csf.csf_skill_levels_b sl ON sl.rating_scale_id = rs.rating_scale_id LEFT JOIN csf.csf_skill_types_b st ON st.rating_scale_id = rs.rating_scale_id;

Security-group-scoped extracts commonly filter on SECURITY_GROUP_ID to respect responsibility-level data access. Because the table is EBR-enabled, any query executed under an editioned context should be aware that ZD_EDITION_NAME distinguishes row versions across editions.

Related Objects

The documented referential relationships identify the following significant dependencies:

• CSF_SKILL_LEVELS_B — references CSF_RATING_SCALES_B via CSF_SKILL_LEVELS_B.RATING_SCALE_ID, holding the individual proficiency levels within each scale.
• CSF_SKILL_TYPES_B — references CSF_RATING_SCALES_B via CSF_SKILL_TYPES_B.RATING_SCALE_ID, defining the categories of skill measured against a scale.
• FND_SECURITY_GROUPS — referenced by CSF_RATING_SCALES_B.SECURITY_GROUP_ID, providing the multi-tenant security partitioning of scale records.

Together these child tables form the competency hierarchy: a rating scale constrains the skill types it applies to and the discrete skill levels available within it, which downstream scheduling and assignment logic consume when matching resources to service requests.