Results for “source_field_id”

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

Overview

AMS_DM_IMP_ATTRIBUTES is a Marketing (AMS) module table in Oracle E-Business Suite that stores the importance ranking of attributes used during data-mining model building. Within the Oracle Marketing data-mining framework, models are constructed from source fields drawn from lists and other marketing data sources. This table records, for each model, the relative importance assigned to each contributing source field, together with the computed importance value. It therefore functions as the persisted output of the attribute-evaluation phase of model creation.

Under the heuristic Data Vault classification derived from its foreign-key structure, the table is best modeled as a link, since it resolves associations between a model (AMS_DM_MODELS_ALL_B) and a source field (AMS_LIST_SRC_FIELDS) while carrying descriptive measures (RANK and VALUE) on the relationship itself. The table resides in the AMS schema and is documented as VALID in ETRM 12.2.2, with 12 physical columns. It should not be confused with transactional marketing tables; it is a supporting analytical structure for the Oracle Advanced Marketing / data-mining model repository.

Key Information Stored

The table's documented metadata identifies the following significant columns:

• IMP_ATTRIBUTE_ID — the surrogate primary key, enforced by AMS_DM_IMP_ATTRIBUTES_PK and also by the unique index AMS_DM_IMP_ATTRIBUTES_U1. It provides a system-generated identifier for each importance-ranking row.
• MODEL_ID — foreign key to AMS_DM_MODELS_ALL_B, identifying the data-mining model to which the attribute ranking belongs. Together with SOURCE_FIELD_ID, it forms the business-key candidate unique index AMS_DM_IMP_ATTRIBUTES_U2 (and the documented unique key AMS_DM_IMP_ATTRIBUTES_UK1).
• SOURCE_FIELD_ID — foreign key to AMS_LIST_SRC_FIELDS, identifying the source field whose importance is being ranked.
• RANK — the ordinal importance position of the attribute relative to other attributes in the same model.
• VALUE — the computed importance value or score associated with the attribute.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, supporting multi-organization / security-group access control.

The remaining documented columns are standard EBS audit and concurrency attributes: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, and OBJECT_VERSION_NUMBER. These provide WHO-column auditability and optimistic locking for the row.

Common Use Cases and Queries

Typical usage centers on reporting which attributes most influence a marketing data-mining model and on validating model configuration. A user searching for source_field_id is usually resolving a ranking row back to its originating source-field definition.

• List the ranked attributes for a given model, resolving the source field name:

SELECT i.rank, i.value, f.source_field_id, f.field_name
FROM   ams.ams_dm_imp_attributes i,
       ams.ams_list_src_fields  f
WHERE  i.source_field_id = f.source_field_id
AND    i.model_id = :model_id
ORDER BY i.rank;

• Confirm uniqueness of an attribute within a model using the U2 business key:

SELECT model_id, source_field_id, rank, value
FROM   ams.ams_dm_imp_attributes
WHERE  model_id = :model_id
AND    source_field_id = :source_field_id;

• Join to AMS_DM_MODELS_ALL_B to report the model name alongside top-ranked attributes.
• Audit rows by CREATED_BY / LAST_UPDATED_BY to trace who introduced an importance ranking.
• Feed dashboards showing the most influential attributes across all active models, ordered by VALUE descending.

Because the table is model-metadata rather than transactional data, queries are predominantly read-only and low-volume.

Related Objects

• AMS_DM_MODELS_ALL_B — joined on MODEL_ID; the parent model definition. This is the primary dependency.
• AMS_LIST_SRC_FIELDS — joined on SOURCE_FIELD_ID; defines the source field being ranked.
• FND_SECURITY_GROUPS — joined on SECURITY_GROUP_ID; governs row-level security-group access.
• AMS_DM_IMP_ATTRIBUTES_PK / _U1 / _U2 — primary key and unique indexes enforcing surrogate and business-key integrity.
• AMS_DM_MODELS_ALL_TL — the translation table for model names, typically joined to AMS_DM_MODELS_ALL_B for display reporting.
• Other AMS data-mining model-detail tables keyed by MODEL_ID, which together describe model inputs, outputs, and performance.

Collectively these objects form the Oracle Marketing data-mining model repository, with AMS_DM_IMP_ATTRIBUTES providing the attribute-importance dimension of that repository.