Search Results evaluation_type

Overview

AMW.AMW_ASSESSMENTS_B is a transactional table in the Oracle E-Business Suite 12.1.1 and 12.2.2 environment, owned by the AMW schema. As documented in the ETRM metadata, the table "holds information about assessments," serving as the primary persistent store for assessment records generated within the Advanced Management Workbench (AMW) module, which is closely associated with Oracle's Learning and Talent Management applications, including iLearning and the broader Human Capital Management (HCM) footprint. The table is registered under FND Design Data as AMW.AMW_ASSESSMENTS_B and carries a VALID status, confirming it is an active, supported object in the EBS data dictionary.

From a Data Vault modeling perspective, the heuristic classification derived from the foreign key structure is standalone. The table does not participate as a dependent satellite or link through documented foreign key relationships, other than a reference to FND_SECURITY_GROUPS via the SECURITY_GROUP_ID column. This classification suggests the table functions as a self-contained hub-like entity for assessment data, with its business context supplied through code columns rather than hard referential constraints. The associated _B suffix convention typically indicates a base table that may be paired with a corresponding _TL table for translated, language-dependent attributes; consumers should verify whether a companion translation table exists in their specific instance.

Key Information Stored

The table comprises 35 documented columns. The most significant are:

• ASSESSMENT_ID — the primary surrogate key, enforced by unique index AMW_ASSESSMENTS_B_U1 and the primary key constraint AMW_ASSESSMENTS_B_PK. This is also the sole documented business-key candidate, though in practice it is a system-generated identifier rather than a natural key.
• ASSESSMENT_TYPE_CODE (VARCHAR2, 30) — classifies the category of assessment being recorded.
• ASSESSMENT_STATUS_CODE (VARCHAR2, 30) — tracks the lifecycle state of an assessment record.
• ASSESSMENT_OWNER_ID — identifies the party (typically a person or organization) responsible for the assessment.
• IES_SURVEY_ID, IES_CYCLE_ID, IES_DEPLOYMENT_ID — link the assessment to the iLearning/iRecruitment survey framework, its administration cycle, and its deployment instance.
• EVALUATION_TYPE and EVALUATION_CONTEXT — the columns most directly associated with the user's search term, distinguishing the nature of the evaluation and the context in which it is performed.
• START_DATE, EFFECTIVE_COMPLETION_DATE, PERIOD_NAME — temporal attributes supporting scheduling, completion tracking, and period-based reporting.
• Standard WHO columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN) and OBJECT_VERSION_NUMBER for concurrency control.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — descriptive flexfield segments available for client-specific extension.

Common Use Cases and Queries

Typical usage centers on assessment reporting, status tracking, and integration with survey-based learning evaluations. A common pattern joins assessments to their survey context:

SELECT a.assessment_id, a.assessment_type_code, a.assessment_status_code,
       a.evaluation_type, a.evaluation_context, a.start_date
FROM   amw.amw_assessments_b a
WHERE  a.assessment_status_code = :p_status
AND    a.evaluation_type = :p_eval_type;

Reporting queries frequently filter on EFFECTIVE_COMPLETION_DATE and PERIOD_NAME for period-end dashboards, or aggregate counts by ASSESSMENT_TYPE_CODE and ASSESSMENT_OWNER_ID. Because the table exposes a descriptive flexfield, client-specific filters on ATTRIBUTE_CATEGORY and the ATTRIBUTE columns are also common in custom reports.

Related Objects

The documented foreign key relationship is limited to the hosted-environment security group reference:

• FND_SECURITY_GROUPS — joined on AMW_ASSESSMENTS_B.SECURITY_GROUP_ID = FND_SECURITY_GROUPS.SECURITY_GROUP_ID.

Beyond documented constraints, assessment records are functionally associated with the iLearning survey objects referenced by IES_SURVEY_ID, IES_CYCLE_ID, and IES_DEPLOYMENT_ID, and with the AMW assessment configuration and response tables that share the ASSESSMENT_ID key. Implementers integrating this table should confirm the current list of dependent AMW objects in their instance, as the ETRM metadata documents only the security group reference explicitly.