Results for “step_value”

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

Overview

CSF_SKILL_LEVELS_B is a foundational configuration table in the Oracle E-Business Suite Field Service (CSF) module. It stores the defined skill levels that can be associated with resources and required skills. Each row represents a distinct proficiency level — for example, "Beginner," "Intermediate," or "Expert" — and is tied to a rating scale that governs how that level is measured and scored. Because skill levels are referenced throughout field service assignment, scheduling, dispatch, and resource qualification workflows, this table acts as a central reference point for competency modeling within the application.

The heuristic Data Vault classification for this object is hub-leaning. This suggests that, in a dimensional or Data Vault model, CSF_SKILL_LEVELS_B is best treated as the hub that defines the business concept of a skill level, with its descriptive attributes (step value, correction factor, active dates) potentially modeled as a satellite. The surrogate primary key, SKILL_LEVEL_ID, provides stable identity across the model.

Key Information Stored

The most important columns in CSF_SKILL_LEVELS_B include:

• SKILL_LEVEL_ID — the surrogate primary key (CSF_SKILL_LEVELS_B_PK) uniquely identifying each skill level record.
• RATING_SCALE_ID — foreign key to CSF_RATING_SCALES_B, linking the skill level to its governing rating scale.
• STEP_VALUE — the numeric or ordinal position of the skill level within its rating scale, determining relative ranking.
• CORRECTION_FACTOR — a numeric adjustment applied when evaluating or scoring a resource's proficiency at this level.
• START_DATE_ACTIVE and END_DATE_ACTIVE — date range controlling the active period of the skill level.
• SEEDED_FLAG — indicates whether the record was delivered by Oracle as seed data.
• OBJECT_VERSION_NUMBER — optimistic locking column used by the framework for concurrent update control.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, governing row-level security access.
• ATTRIBUTE1 through ATTRIBUTE15 and ATTRIBUTE_CATEGORY — the standard Oracle EBS descriptive flexfield (DFF) columns supporting customer-defined extensions.
• ZD_EDITION_NAME — the editioning column supporting Online Patching in EBS 12.2, part of the unique index CSF_SKILL_LEVELS_B_U1 (SKILL_LEVEL_ID, ZD_EDITION_NAME).

The business-key candidate is the unique index comprising SKILL_LEVEL_ID and ZD_EDITION_NAME, though SKILL_LEVEL_ID alone serves as the effective business identity in practice.

Common Use Cases and Queries

Typical reporting and integration scenarios include:

• Listing all active skill levels for a given rating scale, ordered by STEP_VALUE:

SELECT sl.SKILL_LEVEL_ID, sl.STEP_VALUE, sl.CORRECTION_FACTOR, sl.START_DATE_ACTIVE, sl.END_DATE_ACTIVE
FROM   CSF_SKILL_LEVELS_B sl
WHERE  sl.RATING_SCALE_ID = :rating_scale_id
AND    TRUNC(SYSDATE) BETWEEN NVL(sl.START_DATE_ACTIVE, TRUNC(SYSDATE)) AND NVL(sl.END_DATE_ACTIVE, TRUNC(SYSDATE));

• Joining to CSF_RESOURCE_SKILLS_B to determine which resources hold a particular skill level.
• Joining to CSF_REQUIRED_SKILLS_B to find the required proficiency for a given service request or task.
• Building validation lookups in custom forms or concurrent programs that constrain user input to valid skill levels.

Because the table participates in Field Service assignment logic, reports on resource qualification gaps typically join through CSF_RESOURCE_SKILLS_B and CSF_REQUIRED_SKILLS_B using SKILL_LEVEL_ID.

Related Objects

• CSF_RATING_SCALES_B — parent of CSF_SKILL_LEVELS_B via RATING_SCALE_ID; defines the scale that the skill level belongs to.
• CSF_REQUIRED_SKILLS_B — references CSF_SKILL_LEVELS_B through SKILL_LEVEL_ID, defining required proficiency for tasks.
• CSF_RESOURCE_SKILLS_B — references CSF_SKILL_LEVELS_B through SKILL_LEVEL_ID, capturing skills held by resources.
• FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID for row-level security enforcement.
• CSF_SKILL_LEVELS_TL — the translation table (implied by the _B suffix) holding language-specific names and descriptions.
• Field Service APIs and concurrent programs that resolve resource qualification and dispatch decisions read from this table indirectly through the skill relationships above.