Results for “csf_l_sods”

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

Overview

CSF_L_SODS is a Service Order Description table that resides in the CSF schema, the database account associated with the Oracle Field Service (Service) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. The table stores descriptive and definitional metadata for service orders and their associated templates. It holds the human-readable text labels, header and footer file names, item patterns, and task-type associations that drive how service order templates and their generated documents are rendered in Field Service.

The object is registered as VALID in the ETRM repository with thirty-one documented columns. Its primary key, CSF_L_SODS_PK, is defined on the SOD_ID column. Based on the heuristic Data Vault classification derived from the foreign key structure, CSF_L_SODS is modeled as a standalone object. This classification is a mining suggestion rather than a formal designation; it reflects that the table has no inbound foreign key dependencies documented in the ETRM repository, while it retains outbound references to CSF_L_SOTS and FND_SECURITY_GROUPS.

Key Information Stored

The most significant columns in CSF_L_SODS are as follows:

• SOD_ID — The surrogate primary key, defined by CSF_L_SODS_PK. Every row is uniquely identified by this value.
• SOT_ID — A foreign key to CSF_L_SOTS that ties each description record to its parent service order template. This is the principal business-link candidate in the table.
• SODTYPE — Identifies the description type or category, allowing the table to hold several classes of descriptive entries per template.
• SODDESCR — The descriptive text itself, the core payload of the row.
• FILENAMEHDR and FILENAMEFTR — Header and footer file names used when the description is incorporated into generated documents.
• DEFSOD_ID — A self-referencing definition identifier that points to a default or source description record.
• TASK_TYPE_ID — Associates the description with a specific task type.
• ITEM_PATTERN — A pattern string used to match or generate item references.
• SECURITY_GROUP_ID — A foreign key to FND_SECURITY_GROUPS that enforces multi-tenant data isolation, commonly used in hosted or shared-services deployments.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — The standard Oracle EBS descriptive flexfield columns, available for customer-specific extensions without schema modification.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN — The standard WHO audit columns that record the identity and timing of row creation and modification.

Common Use Cases and Queries

Typical applications include listing all descriptions belonging to a service order template, restricting output to a particular description type, and joining to task or item structures for reporting. A representative query resolves the parent template name alongside each description:

SELECT s.SOD_ID, s.SODTYPE, s.SODDESCR, t.SOT_ID
FROM CSF.CSF_L_SODS s, CSF.CSF_L_SOTS t
WHERE s.SOT_ID = t.SOT_ID
AND s.SECURITY_GROUP_ID = :p_security_group;

Reporting use cases include auditing which templates carry header and footer document file names, identifying rows that use descriptive flexfield attributes for custom classification, and validating referential integrity between descriptions and their templates before a migration or upgrade. Because the table supports descriptive flexfields, an ATTRIBUTE_CATEGORY filter is frequently added when extracting customer-specific data.

Related Objects

The most significant related objects follow directly from the documented foreign keys. CSF_L_SOTS is referenced through CSF_L_SODS.SOT_ID and is the parent template table from which descriptions inherit context. FND_SECURITY_GROUPS is referenced through CSF_L_SODS.SECURITY_GROUP_ID and provides the multi-tenant partitioning for every row. The primary key constraint CSF_L_SODS_PK governs uniqueness of SOD_ID, and the DEFSOD_ID and TASK_TYPE_ID columns imply additional internal references to default description and task-type entities. In practice, CSF_L_SODS is consumed alongside these template and security objects when Field Service builds, renders, or reports on service order documentation.