Results for “pred_abdn_limit”

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

Overview

The IEO.IEO_SYSTEM_CAMPS_ALL table is a foundational data object within the Oracle E-Business Suite (EBS) Interaction Center Technology (IEO) product module. In EBS 12.1.1 and 12.2.2, the IEO module underpins the Telephony and Interaction Center infrastructure, serving as the integration layer between Oracle's CRM applications (such as Oracle Marketing, Oracle TeleSales, and Oracle Service) and external or distributed campaign data sources. The documented description identifies this table as a "Centralized Gateway to IEO_CAMPAIGNS_ALL, which may be distributed," indicating that it acts as a control-plane registry directing the application to campaign definitions that may reside in remote, federated databases rather than within the local EBS instance.

Physically, the table resides in the IEO schema and is documented as VALID at 23 columns in the ETRM 12.2.2 repository. Based on the foreign-key structure and the presence of a single surrogate primary key (SYSCAMP_PK) with minimal dependent relationships, the heuristic Data Vault classification is satellite-leaning. This classification should be treated as a modeling suggestion: the table primarily stores descriptive and configuration attributes tied to a system campaign identity, rather than serving as an integrating hub or a many-to-many link resolver.

Key Information Stored

The table's 23 columns revolve around identifying a system campaign and describing how and where its associated campaign data is sourced. The most significant columns are:

• SYSTEM_CAMP_ID — The surrogate primary key (documented as SYSCAMP_PK). This is the internal technical identifier for each system campaign record and is the primary join key to dependent tables.
• LIST_SRV_NAME — Foreign key to IEO_SYST_CP_SVCS_ALL; identifies the list service provider or campaign source service.
• SREF_TYPE — Source reference type, used alongside LIST_SRV_NAME to classify the external campaign source.
• REF_TYPE and REF_NAME — Business reference identifiers linking the system campaign to an external or remote campaign definition.
• SHORT_DESCRIPTION — Human-readable label for the system campaign.
• PHYSICAL_DB and ODBC_DSN_NAME — Define the physical database and ODBC data source name for distributed (federated) campaign data, supporting the "may be distributed" design.
• LIST_MANAGER_Y_N and ACTIVE_Y_N — Operational flags controlling whether list management and the campaign record are enabled.
• PRIORITY_NUMBER — Ordering priority for campaign selection.
• VERSA_ENABLED_Y_N and PRED_ABDN_LIMIT — Configuration flags governing predictive/adaptive dialing and abandonment behavior.
• ORG_ID — Multi-org operating unit discriminator, enabling data partitioning across business units.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, enforcing row-level security.

Standard EBS audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and OBJECT_VERSION_NUMBER for optimistic locking are also present. The primary key, SYSTEM_CAMP_ID, is the only documented unique identifier; no separate business-key unique index is described.

Common Use Cases and Queries

Typical applications of this table center on campaign administration, list-service configuration, and reporting on distributed campaign sources.

• Listing all active system campaigns for an operating unit:

  SELECT system_camp_id, short_description, ref_name FROM ieo.ieo_system_camps_all WHERE active_y_n = 'Y' AND org_id = :p_org_id;

• Identifying campaigns sourced from a specific list service:

  SELECT c.system_camp_id, c.short_description FROM ieo.ieo_system_camps_all c, ieo.ieo_syst_cp_svcs_all s WHERE c.list_srv_name = s.list_srv_name AND c.sref_type = s.sref_type;

• Auditing distributed campaign connectivity via PHYSICAL_DB and ODBC_DSN_NAME for integration troubleshooting.
• Reporting on predictive dialer configuration using VERSA_ENABLED_Y_N and PRED_ABDN_LIMIT.

Related Objects

• IEO_SYST_CP_SVCS_ALL — Referenced via LIST_SRV_NAME and SREF_TYPE; defines the list service providing campaign data.
• IEO_CAMPAIGNS_ALL — The downstream campaign definition table for which this table acts as a centralized gateway.
• FND_SECURITY_GROUPS — Referenced via SECURITY_GROUP_ID; governs row-level security access.
• FND_APPLICATION and FND_ORG — Supporting lookups for module and operating-unit context (ORG_ID).
• IEO_CAMPAIGN_MEMBERS — Dependent membership data selected through the campaign identity resolved here.