Results for “csf_resource_skills_b”

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

Overview

CSF_RESOURCE_SKILLS_B is a core table within the Oracle E-Business Suite Field Service (CSF) module. It stores the definition of skill types and the association between service resources and the skills they possess. In release 12.1.1 and 12.2.2 the object resides in the CSF schema and carries a VALID status in the data dictionary, indicating it is actively used by the Field Service application and its dependent concurrent programs, forms, and APIs.

From a Data Vault modeling perspective, the metadata classifies this object heuristically as a link. This classification reflects the table's role as an associative entity that connects a field service resource to a skill, skill type, and skill level. Rather than describing the resource or the skill independently, CSF_RESOURCE_SKILLS_B captures the relationship between them, which is the defining characteristic of a link table. This suggestion is consistent with the presence of multiple foreign keys flowing outward to CSF_SKILL_TYPES_B, CSF_SKILLS_B, and CSF_SKILL_LEVELS_B.

Key Information Stored

The table comprises 31 documented columns. The most significant columns include:

• RESOURCE_SKILL_ID — the surrogate primary key, enforced by CSF_RESOURCE_SKILLS_B_PK and also backed by the unique index CSF_RESOURCE_SKILLS_B_U1.
• SKILL_TYPE_ID — foreign key to CSF_SKILL_TYPES_B, identifying the category of the skill.
• SKILL_ID — foreign key to CSF_SKILLS_B, identifying the specific skill assigned.
• SKILL_LEVEL_ID — foreign key to CSF_SKILL_LEVELS_B, expressing the proficiency level of the resource for that skill.
• RESOURCE_TYPE and RESOURCE_ID — together define the resource (for example a technician or crew) that owns the skill record.
• START_DATE_ACTIVE and END_DATE_ACTIVE — the effective dating window for the skill assignment.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, supporting multi-org and data security partitioning.
• OBJECT_VERSION_NUMBER — the optimistic locking column used by the Oracle Application Framework (OAF) and Forms.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard WHO audit columns.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the DFF (Descriptive Flexfield) columns for customer-specific extensions.

RESOURCE_SKILL_ID is both the surrogate primary key and the business-key candidate documented through the unique index CSF_RESOURCE_SKILLS_B_U1. The remaining identifying relationships (resource plus skill) are expressed through the foreign-key columns rather than a separate composite unique key.

Common Use Cases and Queries

Typical reporting and integration scenarios include retrieving the full skill profile of a field service technician, identifying resources qualified for a specific skill level prior to dispatching a work order, and validating that a scheduled resource holds a required skill for a task type. A representative query joining the primary relationship tables follows:

• SELECT rs.RESOURCE_SKILL_ID, rs.RESOURCE_ID, s.SKILL_NAME, l.SKILL_LEVEL_NAME FROM CSF_RESOURCE_SKILLS_B rs, CSF_SKILLS_B s, CSF_SKILL_LEVELS_B l WHERE rs.SKILL_ID = s.SKILL_ID AND rs.SKILL_LEVEL_ID = l.SKILL_LEVEL_ID AND rs.RESOURCE_ID = :resource_id;
• Effective-dating filters commonly add AND SYSDATE BETWEEN rs.START_DATE_ACTIVE AND NVL(rs.END_DATE_ACTIVE, SYSDATE) to return only current assignments.
• Skill gap analysis queries compare the skills held in CSF_RESOURCE_SKILLS_B against the skills required by a task, surfacing unqualified resources.
• Security-filtered extracts restrict results by rs.SECURITY_GROUP_ID for multi-org deployments.

Related Objects

The following objects are the most significant dependencies, established through the documented foreign keys and primary key relationships:

• CSF_SKILL_TYPES_B — referenced via CSF_RESOURCE_SKILLS_B.SKILL_TYPE_ID.
• CSF_SKILLS_B — referenced via CSF_RESOURCE_SKILLS_B.SKILL_ID.
• CSF_SKILL_LEVELS_B — referenced via CSF_RESOURCE_SKILLS_B.SKILL_LEVEL_ID.
• FND_SECURITY_GROUPS — referenced via CSF_RESOURCE_SKILLS_B.SECURITY_GROUP_ID.
• CSF_RESOURCE_SKILLS_B_PK / CSF_RESOURCE_SKILLS_B_U1 — the primary key constraint and unique index that anchor the record identity.

These joins form the backbone of resource qualification and scheduling logic in the Field Service module, supporting both transactional dispatch routines and analytical reporting on workforce competency.