Results for “csf_skill_types_tl”

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

Overview

CSF_SKILL_TYPES_TL is the translation table for skill types within the Oracle E-Business Suite Field Service (CSF) module. It stores the language-specific names and descriptions of the skill categories used to qualify field service technicians and to match them against service request requirements. In Oracle EBS 12.1.1 and 12.2.2, this table works in tandem with a base table (CSF_SKILL_TYPES_B) that holds the language-independent attributes, while the _TL suffix indicates that this object carries translated (multi-language) columns. The Data Vault classification mined from the foreign key structure is standalone, which suggests modeling this object as its own hub rather than as a satellite subordinate to a larger parent entity; the presence of a security group reference is a security/access attribute, not a business parent relationship.

Key Information Stored

The table holds twelve documented columns. The most significant are listed below.

• SKILL_TYPE_ID — Surrogate primary key of the skill type. It is the single column of the primary key constraint CSF_SKILL_TYPES_TL_PK and is inherited from the base CSF_SKILL_TYPES_B row. The user search term "skill_type_id" resolves directly to this identifier.
• NAME — The translated, display-name of the skill type, shown to users in the current session language.
• DESCRIPTION — The translated long description of the skill type.
• LANGUAGE — The NLS language code for the translated NAME and DESCRIPTION values. Combined with SKILL_TYPE_ID and ZD_EDITION_NAME, it forms the unique business-key candidate CSF_SKILL_TYPES_TL_U1.
• SOURCE_LANG — The language in which the row was originally authored, used by the translation framework to determine the base-language record.
• ZD_EDITION_NAME — The editioning column introduced with EBS 12.2 online patching, enabling edition-based redefinition of the row; part of the unique index.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, governing which access control group may view the skill type.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS WHO-column audit attributes recording row creation and modification.

The surrogate key (SKILL_TYPE_ID) should be distinguished from the business-key candidate, which is the composite of SKILL_TYPE_ID, LANGUAGE, and ZD_EDITION_NAME enforced by CSF_SKILL_TYPES_TL_U1.

Common Use Cases and Queries

Typical use cases include qualifying technicians for service requests, populating LOVs on skill assignment forms, and reporting skill coverage by language. A representative query to retrieve a skill type name for a given language is:

• SELECT s.name, s.description FROM csf.csf_skill_types_tl s WHERE s.skill_type_id = :p_skill_type_id AND s.language = USERENV('LANG');
• SELECT b.skill_type_id, t.name FROM csf.csf_skill_types_b b, csf.csf_skill_types_tl t WHERE b.skill_type_id = t.skill_type_id AND t.language = USERENV('LANG');

Reporting scenarios usually join this table to the base table to obtain both the language-independent attributes and the localized text, and filter by SECURITY_GROUP_ID to respect access control.

Related Objects

• CSF_SKILL_TYPES_B — Base table holding the language-independent skill type definition; joined on SKILL_TYPE_ID.
• FND_SECURITY_GROUPS — Referenced by SECURITY_GROUP_ID, defining the security group for the skill type.
• JTF_RS_SKILLS / FND_LOOKUPS — Downstream reference points for skill assignment in resource management, tied through SKILL_TYPE_ID.
• CSF_SKILL_TYPES_TL_PK — Primary key constraint enforcing SKILL_TYPE_ID uniqueness per row.
• CSF_SKILL_TYPES_TL_U1 — Unique index on SKILL_TYPE_ID, LANGUAGE, and ZD_EDITION_NAME, identifying the business key.