Search Results csd_sc_work_entities




Overview
Explore in AI Chat

Overview

CSD_SC_WORK_ENTITIES is a transactional configuration table in the Oracle E-Business Suite Depot Repair (CSD) module. It stores service code work entities — the association records that bind a defined service code to one or more concrete work entities such as items, resources, or organizational units used in repair and service execution. In Oracle EBS 12.1.1 and 12.2.2 the table resides in the CSD schema, is flagged VALID, and is defined as Oracle-proprietary, confidential structure. It is populated and maintained by Depot Repair service code setup flows rather than by end users directly, and it functions as the linkage layer that tells the repair engine which work entities a given service code is permitted to operate against.

From a heuristic Data Vault classification (mined from the documented foreign key structure), the table is modeled as standalone. This suggests it is best treated as a reference or lookup entity rather than as a hub, link, or satellite in the strict Data Vault sense. Its single outgoing foreign key to CSD_SERVICE_CODES_B gives it one clear parent, but the internal work-entity references (WORK_ENTITY_ID1, WORK_ENTITY_ID2, WORK_ENTITY_ID3) are not resolved by FK constraints in the documented metadata, which reinforces the standalone heuristic classification as a modeling suggestion only.

Key Information Stored

The documented physical schema contains 28 columns. The most operationally significant are:

  • SC_WORK_ENTITY_ID — the surrogate primary key, enforced by unique index CSD_SC_WORK_ENTITIES_U1 and by constraint CSD_SC_WORK_ENTITIES_PK1. This is the single-column unique business-key candidate documented for the table.
  • SERVICE_CODE_ID — foreign key to CSD_SERVICE_CODES_B. This is the business link that anchors each work-entity row to its owning service code.
  • WORK_ENTITY_TYPE_CODE — discriminator identifying the category of the associated work entity (for example item, resource, or unit).
  • WORK_ENTITY_ID1, WORK_ENTITY_ID2, WORK_ENTITY_ID3 — flexible reference columns that hold the identifiers of the related work entities. Their meaning is conditioned on WORK_ENTITY_TYPE_CODE.
  • OBJECT_VERSION_NUMBER — concurrency-control column used by the framework to detect conflicting updates.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns tracking who created and last modified each row.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard DFF (descriptive flexfield) columns reserved for customer-specific extension data.

Note that SC_WORK_ENTITY_ID is both the primary key and the sole documented unique index, so no alternate natural business key is exposed in the ETRM metadata; any business uniqueness must be inferred from the combination of SERVICE_CODE_ID and the work-entity columns.

Common Use Cases and Queries

Typical usage centers on answering which work entities a service code is authorized for, and on validating service code setup during Depot Repair order entry. A representative query joins the table to its parent service code table:

  • Retrieve all work entities for a service code: SELECT scw.sc_work_entity_id, scw.service_code_id, scw.work_entity_type_code, scw.work_entity_id1, scw.work_entity_id2, scw.work_entity_id3 FROM csd.csd_sc_work_entities scw WHERE scw.service_code_id = :p_service_code_id;
  • List service codes that reference a specific work entity: SELECT * FROM csd.csd_sc_work_entities WHERE work_entity_id1 = :p_entity_id;
  • Reconcile configuration against the parent: SELECT scb.service_code, scw.* FROM csd.csd_sc_work_entities scw, csd.csd_service_codes_b scb WHERE scw.service_code_id = scb.service_code_id;
  • Extract DFF context for reporting or migration: SELECT sc_work_entity_id, attribute_category, attribute1, attribute2 FROM csd.csd_sc_work_entities;

These patterns support service code setup audits, data migration validation, and reporting on Depot Repair configuration coverage. Because the table is configuration data, it is also commonly extracted for comparison across environments when promoting setups.

Related Objects

  • CSD_SERVICE_CODES_B — the parent table, joined via CSD_SC_WORK_ENTITIES.SERVICE_CODE_ID = CSD_SERVICE_CODES_B.SERVICE_CODE_ID. This is the only documented foreign key relationship.
  • CSD_SERVICE_CODES_TL — translation table for service codes; join through SERVICE_CODE_ID to obtain language-specific names and descriptions alongside work entities.
  • CSD_REPAIRS and related repair order tables — consume service code configuration to determine permitted work entities during repair execution.
  • CSD_SC_WORK_ENTITIES_PK1 and CSD_SC_WORK_ENTITIES_U1 — the primary key constraint and unique index that enforce row identity on SC_WORK_ENTITY_ID and govern all joins from dependent logic.
  • CSD_SC_WORK_ENTITIES attribute columns (ATTRIBUTE_CATEGORY / ATTRIBUTE1–15) — surfaced through Oracle EBS descriptive flexfield UI, not a separate object but a dependent metadata layer for site-specific extension.