Search Results csd_service_codes

Overview

CSD.CSD_SC_DOMAINS is a transactional base table in the Oracle E-Business Suite Service (CSD) schema that stores service code domains. Within the ETRM (E-Business Suite Technical Reference Model) repository, a domain defines which area the resolution of a repair belongs to, effectively classifying the service context in which a service code is applied. The table resides in the APPS_TS_TX_DATA tablespace with PCTFREE 10 and is flagged VALID in release 12.1.1 and 12.2.2. It is owned by the CSD schema and carries the FND Design Data identifier CSD.CSD_SC_DOMAINS.

Because the table stores attribute-driven domain definitions keyed by a singular surrogate identity and references a service code parent, a Data Vault classification heuristic would most plausibly model it as a satellite attached to the CSD_SERVICE_CODES hub, since it holds descriptive and classification attributes (domain type, item, category) that change over time and are contextually dependent on the parent service code. The heuristic also notes a standalone classification, reflecting the fact that the table's dependencies are limited to one upstream foreign key and one downstream reference; both interpretations are valid modeling suggestions rather than definitive constraints.

Key Information Stored

The table is defined with 28 documented columns. The most significant are:

• SC_DOMAIN_ID (NUMBER, NOT NULL) — the surrogate primary key, enforced by the unique index CSD_SC_DOMAINS_U1 in APPS_TS_TX_IDX and the constraint CSD_SC_DOMAINS_PK1. This is the single business-key candidate documented for the table.
• SERVICE_CODE_ID (NUMBER) — foreign key to CSD_SERVICE_CODES_B, linking each domain record to its parent service code.
• DOMAIN_TYPE_CODE (VARCHAR2(30)) — identifies the domain type; it heads the nonunique index CSD_SC_DOMAINS_N1 alongside SERVICE_CODE_ID.
• INVENTORY_ITEM_ID (NUMBER) — the inventory item to which the domain resolution applies.
• CATEGORY_ID and CATEGORY_SET_ID (NUMBER) — the item category and its category set, allowing domain assignment at category level.
• OBJECT_VERSION_NUMBER (NUMBER) — optimistic locking / concurrency control.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 (VARCHAR2) — descriptive flexfield structure and segment columns used for extensible domain attributes.
• Standard WHO audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical scenarios include determining which repair resolution area a service code maps to, reporting on domain coverage by item or category, and joining domains to downstream repair recommendations. A common reporting query joins the domain to the service code and to recommendation records:

• List domains for a service code: SELECT sc_domain_id, domain_type_code, inventory_item_id, category_id FROM csd.csd_sc_domains WHERE service_code_id = :p_service_code_id;
• Domain-to-service-code lookup: SELECT d.sc_domain_id, d.domain_type_code, s.service_code FROM csd.csd_sc_domains d, csd.csd_service_codes_b s WHERE d.service_code_id = s.service_code_id;
• Recommendation join by domain: SELECT r.sc_domain_id, d.domain_type_code, r.* FROM csd.csd_sc_recommendations_b r, csd.csd_sc_domains d WHERE r.sc_domain_id = d.sc_domain_id;
• Category-level analysis: SELECT category_set_id, category_id, COUNT(*) FROM csd.csd_sc_domains GROUP BY category_set_id, category_id;

Related Objects

• CSD.CSD_SERVICE_CODES_B — parent table; CSD_SC_DOMAINS.SERVICE_CODE_ID references CSD_SERVICE_CODES_B.
• CSD.CSD_SC_RECOMMENDATIONS_B — child table; CSD_SC_RECOMMENDATIONS_B.SC_DOMAIN_ID references CSD_SC_DOMAINS, making the domain the pivot between service codes and recommended resolutions.
• CSD_SERVICE_CODES_TL — translated service code names, useful for reporting joins.
• MTL_SYSTEM_ITEMS_B — inventory item master, joined via INVENTORY_ITEM_ID.
• MTL_CATEGORIES_B and MTL_CATEGORY_SETS_B — joined via CATEGORY_ID and CATEGORY_SET_ID.
• FND_USER — referenced by CREATED_BY and LAST_UPDATED_BY.
• FND_LOGINS — referenced by LAST_UPDATE_LOGIN.