Search Results qrm_analysis_atts_pk

Overview

QRM_ANALYSIS_ATTS is a configuration and metadata table within the Oracle Risk Management (QRM) module, delivered under the QRM schema and valid in both Oracle E-Business Suite 12.1.1 and 12.2.2. The table stores "Analysis Attributes Information" — that is, the definition of individual attributes that comprise a risk or control analysis. Each row associates a named attribute with a named analysis, effectively binding reusable attribute definitions to specific analysis configurations used by the QRM analytical engine.

From a Data Vault modeling perspective, the mined foreign-key structure suggests classifying QRM_ANALYSIS_ATTS as a link entity. It sits between QRM_ANA_ATTS_LOOKUPS (the attribute definition source) and QRM_ANALYSIS_SETTINGS (the analysis configuration), resolving the many-to-many relationship between attributes and analyses and carrying descriptive payload columns. This is a heuristic classification and should be treated as a modeling suggestion rather than a documented Oracle design statement.

Key Information Stored

The table contains 14 documented columns. The most significant are:

• ATTRIBUTE_NAME — Business identifier of the attribute; part of the composite primary key and a foreign key to QRM_ANA_ATTS_LOOKUPS.
• ANALYSIS_NAME — Business identifier of the parent analysis; part of the primary key and a foreign key to QRM_ANALYSIS_SETTINGS.
• HISTORY_FLAG — Flag governing historical handling of the attribute; also part of the primary key and referenced by the QRM_ANALYSIS_SETTINGS relationship.
• TYPE — Classifies the attribute (for example, a scoring, weighting, or categorical type) and drives downstream computation.
• ATT_ORDER — Display and processing sequence of the attribute within its analysis.
• TOTAL_AVERAGE — Indicates whether the attribute contributes to a total or an average aggregation.
• TOTAL_IND — Indicator controlling whether the attribute is included in the analysis total.
• PERCENTAGE — Weighting or percentage contribution applied to the attribute value.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS Who columns for audit and concurrency control.
• ZD_EDITION_NAME — Editioning column supporting EBS 12.2.2 online patching and edition-based redefinition.

The primary key is QRM_ANALYSIS_ATTS_PK over (ATTRIBUTE_NAME, ANALYSIS_NAME, HISTORY_FLAG). A second unique index, QRM_ANALYSIS_ATTS_U1, spans (ATTRIBUTE_NAME, ANALYSIS_NAME, HISTORY_FLAG, ZD_EDITION_NAME); because it adds the edition column, this index is an editioning integrity device rather than a business-key candidate. There is no separate surrogate key — the composite natural key serves as the row identifier.

Common Use Cases and Queries

Typical usage is administrative and reporting-oriented: reviewing which attributes belong to a given analysis, auditing attribute weighting, and tracing analysis configuration changes across editions.

• Attributes for one analysis: SELECT ATTRIBUTE_NAME, TYPE, ATT_ORDER, PERCENTAGE FROM QRM.QRM_ANALYSIS_ATTS WHERE ANALYSIS_NAME = :name ORDER BY ATT_ORDER;
• Weighting review: aggregate PERCENTAGE grouped by ANALYSIS_NAME to verify totals sum correctly.
• Join to attribute lookups: SELECT a.ATTRIBUTE_NAME, l.DESCRIPTION FROM QRM.QRM_ANALYSIS_ATTS a JOIN QRM.QRM_ANA_ATTS_LOOKUPS l ON a.ATTRIBUTE_NAME = l.ATTRIBUTE_NAME;
• Analysis composition report joining to QRM_ANALYSIS_SETTINGS on ANALYSIS_NAME.
• Change auditing using CREATION_DATE and LAST_UPDATE_DATE, segmented by ZD_EDITION_NAME for 12.2.2 patching comparisons.

Related Objects

• QRM_ANA_ATTS_LOOKUPS — referenced on ATTRIBUTE_NAME; holds attribute definitions and descriptions.
• QRM_ANALYSIS_SETTINGS — referenced on ANALYSIS_NAME and HISTORY_FLAG; defines analysis-level configuration.
• QRM_ANALYSIS_ATTS_PK / QRM_ANALYSIS_ATTS_U1 — primary key and unique editioning index enforcing row uniqueness.
• QRM_ANALYSIS_ATTS table owner QRM — queries should be schema-qualified to avoid synonyms.