ZCA_SIGNAL_EVENTS
ZCA_SIGNAL_EVENTS : This table records the occurrence of an Update, Create or Delete event on a business object registered to generate signals.
Details
-
Schema: FUSION
-
Object owner: ZCA
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
ZCA_SIGNAL_EVENTS_PK |
SIGNAL_EVENT_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
SIGNAL_EVENT_ID | NUMBER | 18 | Yes | Auto generated primary key of the table | |
EVENT_TYPE | VARCHAR2 | 30 | Yes | Type of Event that generated the Signal (e.g. CREATE, UPDATE, DELETE) Will require new ORA_ZCA_SIGNAL_EVENT_TYPE "system" Lookup Type to be defined, with three values and associated description. | |
OBJECT_TYPE | VARCHAR2 | 128 | Yes | The name of the Object that owns the Signal definition. e.g. "Opportunity" | |
OBJECT_ID | VARCHAR2 | 512 | Yes | Primary Key ID of Business Object that generated the Signal e.g. OpptyId of original Object. Use VARCHAR2 instead of NUMBER, as some potential source Business Objects (e.g. Lightbox) have UUID values instead of Numbers. May also include compound Key values (e.g. ContactVO with PartyId, PersonProfileId and SalesProfileId). Compound keys will be stored using the same hashing algorithm as ADF Rest uses to generate identifiers when no PUID is identified. | |
REL_OBJECT_TYPE | VARCHAR2 | 128 | The name of the related (child) Object that generated the Signal, if appropriate. e.g. "OpportunityResource" | ||
REL_OBJECT_ID | VARCHAR2 | 512 | Primary Key ID of child (related) Object that generated the Signal Only present for Signals generated for related Object link (e.g. OpptyResourceId). Same identification criteria as OBJECT_ID. | ||
CORRELATION_ID | VARCHAR2 | 256 | Yes | Unique ID shared by all Signal Events created from the same single transaction commit, derived from ECID. | |
SIGNAL_TIMESTAMP | TIMESTAMP | Yes | Last Update Date from the Object that generated the Signal | ||
SIGNAL_CREATED_BY | VARCHAR2 | 64 | Yes | The user that executed the event that generated the Signal | |
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
zca_signals | zca_signal_events | SIGNAL_EVENT_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
ZCA_SIGNAL_EVENTS_N1 | Non Unique | Default | EVENT_TYPE, OBJECT_TYPE, REL_OBJECT_TYPE, SIGNAL_TIMESTAMP |
ZCA_SIGNAL_EVENTS_N2 | Non Unique | Default | SIGNAL_TIMESTAMP |
ZCA_SIGNAL_EVENTS_N3 | Non Unique | Default | EVENT_TYPE, OBJECT_TYPE, REL_OBJECT_TYPE, CREATION_DATE |
ZCA_SIGNAL_EVENTS_N4 | Non Unique | Default | CREATION_DATE |
ZCA_SIGNAL_EVENTS_U1 | Unique | Default | SIGNAL_EVENT_ID |
ZCA_SIGNAL_EVENTS_U2 | Unique | Default | CORRELATION_ID, EVENT_TYPE, OBJECT_TYPE, OBJECT_ID, REL_OBJECT_TYPE, REL_OBJECT_ID, SIGNAL_TIMESTAMP |