Results for “ams_user_statuses_b”

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

Overview

AMS_USER_STATUSES_B is the base table in the AMS (Oracle Marketing) schema that stores user-defined status information for marketing objects. It functions as a central reference or lookup table within the Oracle EBS 12.1.1 and 12.2.2 data model, providing the set of statuses that can be assigned to campaign, event, offer, dialog, list, and deliverable entities. Because it is the "_B" (base) table, its translatable attributes are held separately in AMS_USER_STATUSES_TL, giving the object multilingual capability typical of Oracle EBS marketing and CRM components.

The table is owned by the AMS schema and is marked VALID in the documented ETRM metadata. It anchors a wide web of dependent marketing tables, making it a foundational element for status-driven workflow and reporting across the Marketing module. In Data Vault terms, the mined relationship structure classifies this object as hub-leaning, since it is referenced by a large number of foreign keys while itself carrying few outward references. From a modeling perspective, it is best understood as the hub for user status business keys, with descriptive and historical attributes potentially normalized into satellite structures.

Key Information Stored

The table contains 17 documented columns. The most significant include:

• USER_STATUS_ID — the surrogate primary key, defined by the constraint AMS_USER_STATUSES_B_PK, which is the identifier reported when the AMS_USER_STATUSES_B_PK index is queried.
• SYSTEM_STATUS_TYPE and SYSTEM_STATUS_CODE — classify the status according to system-defined semantics.
• ENABLED_FLAG — indicates whether the status is active and selectable.
• DEFAULT_FLAG — marks the status applied by default to a new marketing object.
• START_DATE_ACTIVE and END_DATE_ACTIVE — define the effective date window during which the status is valid.
• SEEDED_FLAG — distinguishes Oracle-seeded statuses from user-created ones.
• SECURITY_GROUP_ID — the foreign key to FND_SECURITY_GROUPS that enforces row-level security.
• APPLICATION_ID — identifies the owning Oracle application.