Search Results assess_procedure_id




Overview
Explore in AI Chat

Overview

AMW.AMW_ASSESS_PROCEDURES_TL is the translation (TL) table associated with the base table AMW.AMW_ASSESS_PROCEDURES_B within the Oracle E-Business Suite AMW schema, the schema that underpins Oracle Enterprise Asset Management (eAM) and related Environmental, Health and Safety (EHS) functionality. The table stores the language-specific name and description attributes for assessment procedures, allowing the same underlying business entity to carry distinct display text per installed language. This is the canonical Oracle EBS "_TL" pattern: the "_B" table holds language-independent columns and the "_TL" table holds language-dependent text keyed by both the entity identifier and a language code. The object is documented as VALID in the ETRM repository for 12.1.1 and carries the same design in 12.2.2, with physical storage in the APPS_TS_TX_DATA tablespace at PCTFREE 10. Its FND Design Data registration is AMW.AMW_ASSESS_PROCEDURES_TL. Under the heuristic Data Vault classification mined from its foreign-key structure, the table is classified as standalone; from a dimensional modeling perspective it is most naturally treated as a satellite attached to the AMW_ASSESS_PROCEDURES_B hub, with the language code contributing to the satellite's descriptive grain.

Key Information Stored

The table has a composite primary key defined by AMW_ASSESS_PROCEDURES_TL_PK, comprising ASSESS_PROCEDURE_ID and LANGUAGE. ASSESS_PROCEDURE_ID is the numeric assessment procedure identifier and serves as the foreign-key join column back to the base table; it is not unique on its own within this table. LANGUAGE is the language code that supplies the second half of the surrogate key, while SOURCE_LANG records the source language code used for translation comparison and fallback logic. The business-facing descriptive content is carried by NAME (VARCHAR2 240), the translated short name of the assessment procedure, and DESCRIPTION (VARCHAR2 4000), the translated long description. Both are language-dependent and are the primary columns consumed by user interfaces and reports. The remaining columns are the standard Oracle WHO audit attributes present on nearly every EBS transactional and setup table: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN. These support auditing, change tracking, and concurrent-program attribution. No additional non-key business identifiers are documented beyond the composite primary key.

Common Use Cases and Queries

The most frequent use of this table is retrieval of the localized name and description for an assessment procedure identified by ASSESS_PROCEDURE_ID, typically filtered to the session or reporting language. A representative query joins the base and translation tables:

  • SELECT b.assess_procedure_id, t.name, t.description FROM amw.amw_assess_procedures_b b, amw.amw_assess_procedures_tl t WHERE b.assess_procedure_id = t.assess_procedure_id AND t.language = USERENV('LANG');
  • Translation completeness reporting: compare rows per ASSESS_PROCEDURE_ID across LANGUAGE and SOURCE_LANG to detect missing or stale translations.
  • Audit and change analysis using LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN to trace who modified a translated name or description.
  • Extract and interface loads where assessment procedure master data must be delivered with the correct language-specific NAME and DESCRIPTION for downstream systems.
  • Data-quality checks confirming that every LANGUAGE value has a corresponding base row and that mandatory name values are populated.

Related Objects

The principal related object is AMW.AMW_ASSESS_PROCEDURES_B, joined on ASSESS_PROCEDURE_ID; it holds the language-independent attributes and is the parent of this translation table. The dependency metadata indicates that AMW_ASSESS_PROCEDURES_TL is referenced by APPS and by AMW_ASSESS_PROCEDURES_TL itself (typically through synonyms or view definitions exposed to the APPS schema). Practically, the table also participates in relationships with assessment and question-related AMW tables that reference assessment procedures by ASSESS_PROCEDURE_ID, that is, child entities that consume the procedure identified here. Reporting and setup tools that display assessment procedure lists rely on the join to this table for the displayed NAME and DESCRIPTION. Because the documented dependency list is narrow, integrators should treat AMW_ASSESS_PROCEDURES_B as the authoritative join target and resolve any additional AMW assessment objects through the shared ASSESS_PROCEDURE_ID key.