Search Results other_component_value

Overview

AMW.AMW_ASSESSMENT_COMPONENTS is a transactional table within the Oracle E-Business Suite 12.1.1 and 12.2.2 environment, owned by the AMW schema. In application terms, it stores the individual components that make up an assessment record created by the AMW (Assessment Management / quality and compliance) modules. Each row captures one evaluated component — for example a score, rating attribute, or free-form response — belonging to a parent assessment identified by ASSESSMENT_ID. The table resides in the APPS_TS_TX_DATA tablespace, confirming its classification as transactional (not reference) data, and is registered under FND Design Data as AMW.AMW_ASSESSMENT_COMPONENTS.

From a heuristic Data Vault perspective, the table is classified as standalone, with no inbound foreign keys defined in the documented metadata other than the hosted-environment reference to FND_SECURITY_GROUPS. This suggests modeling it as a standalone satellite (or, loosely, a hub-satellite pair) keyed on the surrogate ASSESSMENT_COMPONENT_ID, with ASSESSMENT_ID acting as a logical parent link to the assessment header rather than a physically enforced foreign key.

Key Information Stored

The table contains 29 documented columns, of which the following are the most significant:

• ASSESSMENT_COMPONENT_ID — the surrogate primary key (backed by unique index AMW_ASSESSMENT_COMPONENTS_U1), uniquely identifying each component row.
• ASSESSMENT_ID — the parent assessment identifier linking the component to its assessment header. This is the principal business-key candidate for grouping components into an assessment.
• COMPONENT_CODE (VARCHAR2, 30) — the assessment component code that determines which component the row represents. A value of 'O' specifically denotes the "Other" component.
• OTHER_COMPONENT_VALUE (VARCHAR2, 150) — the free-text value captured when the component code is 'O' (Other). This is the column the user searched for; it stores the descriptive response supplied by the assessor when none of the predefined component codes apply.
• ATTRIBUTE_CATEGORY (VARCHAR2, 30) — the descriptive flexfield structure-defining column, used to enable DFF segments.
• ATTRIBUTE1 through ATTRIBUTE15 (VARCHAR2, 150 each) — the descriptive flexfield segments available for customer-specific extension of assessment component data.
• SECURITY_GROUP_ID — used for hosted/multi-tenant environments; referenced from FND_SECURITY_GROUPS.
• OBJECT_VERSION_NUMBER — optimistic locking control column for concurrent update protection.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard WHO audit columns capturing creation and modification metadata.
• OBJECT_TYPE / OBJECT_ID — polymorphic references enabling the component to be associated with an external business object.

Common Use Cases and Queries

Typical usage centres on retrieving all components for an assessment, isolating "Other" free-text responses, and reporting DFF-extended attributes.

To list all components for a given assessment:

SELECT ASSESSMENT_COMPONENT_ID, COMPONENT_CODE, OTHER_COMPONENT_VALUE
FROM   AMW.AMW_ASSESSMENT_COMPONENTS
WHERE  ASSESSMENT_ID = :p_assessment_id;

To find "Other" responses (the common other_component_value search pattern):

SELECT ASSESSMENT_ID, OTHER_COMPONENT_VALUE
FROM   AMW.AMW_ASSESSMENT_COMPONENTS
WHERE  COMPONENT_CODE = 'O'
AND    OTHER_COMPONENT_VALUE IS NOT NULL;

Reporting scenarios commonly join to the parent assessment header and to lookup tables to translate COMPONENT_CODE into a display name. DFF-based reporting reads ATTRIBUTE_CATEGORY together with the relevant ATTRIBUTEn segment.

Related Objects

• AMW.AMW_ASSESSMENTS (or equivalent assessment header) — joined on AMW_ASSESSMENT_COMPONENTS.ASSESSMENT_ID = AMW_ASSESSMENTS.ASSESSMENT_ID, supplying header-level context.
• FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID for hosted-environment partitioning.
• FND_FLEX_VALUES / FND_FLEX_VALUE_SETS — used to validate and describe DFF segment values and component codes.
• FND_LOOKUPS — typically resolves COMPONENT_CODE into a meaningful component description.
• FND_OBJECTS / OBJECT_TYPE, OBJECT_ID — the polymorphic association links to external business entities.
• AMW_ASSESSMENT_COMPONENTS_PK / _U1 — the primary key constraint and unique index enforcing row integrity on ASSESSMENT_COMPONENT_ID.

Direct AMW public APIs are not documented in the supplied metadata; integration is generally performed through the owning application's concurrent programs or through the parent assessment workflow.