Search Results ams_list_src_fields_uk1

Overview

The AMS_LIST_SRC_FIELDS table is a core metadata repository within the Oracle E-Business Suite Marketing (AMS) module. It functions as a central catalog, defining and storing the specific data fields or attributes that are available for use across various list source types. A list source type, defined in the related AMS_LIST_SRC_TYPES table, represents a category of data, such as a specific customer table or transaction interface. This table's primary role is to establish a reusable library of field definitions, enabling the configuration of marketing lists, data imports, and targeting criteria by providing a standardized reference to available columns from underlying application tables.

Key Information Stored

The table's structure is designed to uniquely identify a field within the context of its source. The primary key, LIST_SOURCE_FIELD_ID, provides a unique system identifier. The critical descriptive columns are FIELD_TABLE_NAME and FIELD_COLUMN_NAME, which together specify the physical database table and column that this metadata record represents. The LIST_SOURCE_TYPE_ID is a foreign key that links the field to its parent category or source type in the AMS_LIST_SRC_TYPES table. This relationship ensures fields are organized and accessible within their appropriate data context. The unique key constraint (AMS_LIST_SRC_FIELDS_UK1) on these three columns prevents duplicate field definitions for a given source type.

Common Use Cases and Queries

This table is essential for administrative setup and dynamic SQL generation within marketing processes. A common use case is retrieving all available fields for a specific list source to populate a user interface dropdown for list creation or segmentation. For example, to find all fields for a source type named 'CUSTOMERS', a query would join to AMS_LIST_SRC_TYPES. Another critical scenario involves data mapping during list imports or predictive model configuration, where the system references AMS_LIST_SRC_FIELDS to validate source-to-target field mappings. A typical reporting query might list all configured fields with their source types:

• SELECT lsft.name source_type, lsf.field_table_name, lsf.field_column_name FROM ams_list_src_fields lsf, ams_list_src_types_b lsft WHERE lsf.list_source_type_id = lsft.list_source_type_id ORDER BY 1, 2, 3;

Related Objects

As documented in the foreign key relationships, AMS_LIST_SRC_FIELDS is a foundational table referenced by several key marketing entities. Its primary relationship is with AMS_LIST_SRC_TYPES via the LIST_SOURCE_TYPE_ID column, defining the field's category. It is also referenced by AMS_LIST_FIELDS_B, which stores instances of these fields used in specific marketing lists. Crucially, the table is linked to Data Mining (DM) objects: AMS_DM_BIN_VALUES, AMS_DM_IMP_ATTRIBUTES, and AMS_DM_TARGETS_B all use the SOURCE_FIELD_ID to associate mining model attributes, bins, and targets with their original source field definition, ensuring traceability and consistency in analytical models.