Results for “csd_rules_tl”

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

Overview

CSD_RULES_TL is a translation table owned by the CSD schema in Oracle E-Business Suite, part of the Depot Repair (CSD) module. It stores the language-specific, translated attributes of repair rules defined in the Depot Repair application. As a "_TL" table, it follows the standard Oracle EBS multilingual pattern: the base table (CSD_RULES_B) holds language-independent columns, while CSD_RULES_TL holds the translatable text (such as the rule name and description) for each installed language. This separation allows a single rule definition to be presented in multiple languages without duplicating structural data.

The object carries a VALID status in the documented ETRM 12.2.2 schema and is classified as a standalone physical table. Under the heuristic Data Vault classification supplied in the metadata, CSD_RULES_TL is best modeled as a satellite, since it holds descriptive, language-dependent attributes keyed to a parent rule identifier rather than representing an independent business entity or an associative relationship. In practice it is a dependent child of the base rule record, driven by RULE_ID and LANGUAGE.

Key Information Stored

The table is documented with 10 columns. The primary key, constraint CSD_RULES_TL_PK1, is a composite of RULE_ID and LANGUAGE, which uniquely identifies the translated row for a given rule in a given language. RULE_ID is the surrogate/foreign key linking back to the base rule definition; it is not a standalone business key but a join key to the parent entity.

• RULE_ID — Identifier of the parent repair rule; component of the composite primary key and the join key to the base table.
• LANGUAGE — The language code for the translated content; the second component of the primary key.
• SOURCE_LANG — The language in which the source text was originally authored, used by the translation framework to track derivation.
• NAME — The translatable, user-facing name of the rule as displayed in the selected language.
• DESCRIPTION — The translatable description or explanation of the rule's purpose.
• CREATED_BY, CREATION_DATE — Standard WHO audit columns capturing the creating user and timestamp.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns capturing the last modifying user, timestamp, and login context.

The audit columns follow Oracle's concurrent-manager-populated WHO convention and are common to virtually all EBS transactional and setup tables.

Common Use Cases and Queries

Typical reporting and integration scenarios include retrieving the display name of a rule in a specific language for user-facing screens, audit reporting on when rule text was last changed, and extraction of translated rule metadata for data-warehouse loads. A common pattern joins the translation table to the base table and filters by the runtime language:

• Rule lookup by ID and language: SELECT name, description FROM csd_rules_tl WHERE rule_id = :rule_id AND language = USERENV('LANG');
• Listing all languages available for a rule: SELECT language, name FROM csd_rules_tl WHERE rule_id = :rule_id;
• Change audit: SELECT rule_id, language, last_updated_by, last_update_date FROM csd_rules_tl WHERE last_update_date >= :cutoff;

Because the table is language-partitioned by the LANGUAGE column, reports should always constrain on LANGUAGE to avoid returning duplicate names for the same rule across installed languages.

Related Objects

CSD_RULES_TL is documented as standalone in the FK structure, meaning there are no enforced foreign keys to other objects. Its logical relationships are nonetheless defined by its key columns:

• CSD_RULES_B — the base (language-independent) rules table, joined on RULE_ID; the "_B"/"_TL" pairing is the canonical EBS pattern.
• CSD_RULES_VL — the multilingual view that typically unions or joins CSD_RULES_B and CSD_RULES_TL to expose translated columns for a given language.
• FND_LANGUAGES — reference table validating LANGUAGE and SOURCE_LANG values.
• FND_USER — reference for CREATED_BY and LAST_UPDATED_BY user identifiers.
• CSD_RULE_* child tables — dependent rule detail or assignment tables in the Depot Repair schema that reference RULE_ID from CSD_RULES_B, and are therefore related to this translation table through the shared rule identifier.

All joins to CSD_RULES_TL should key on RULE_ID (to the parent) and LANGUAGE (to select the desired locale).