DOO_TRANSACTION_EVENTS
This table will store the triggering event point code and will determine when the event will be published depending on the attribute process status code.
Details
-
Schema: FUSION
-
Object owner: DOO
-
Object type: TABLE
-
Tablespace: SUMMARY
Primary Key
| Name | Columns |
|---|---|
|
DOO_TRANSACTION_EVENTS_PK |
TRANSACTION_EVENT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TRANSACTION_EVENT_ID | NUMBER | 18 | Yes | Unique identifier of the DOO Transaction Events | |
| AGGREGATED_EVENT_ID | NUMBER | 18 | Yes | Refers to a Unique Identifier to aggregate event details for eligible entity and its children as setup by the users. | |
| EVENT_POINT_CODE | VARCHAR2 | 30 | Yes | Refers to the business event trigger point to which the event details are applicable | |
| PROCESSING_STATUS_CODE | VARCHAR2 | 30 | Yes | Refers to the Status of the Transaction Event whether it is eligible to publish the event. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| doo_transaction_event_details | doo_transaction_events | TRANSACTION_EVENT_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| DOO_TRANSACTION_EVENTS_N1 | Non Unique | Default | EVENT_POINT_CODE, PROCESSING_STATUS_CODE |
| DOO_TRANSACTION_EVENTS_N2 | Non Unique | Default | AGGREGATED_EVENT_ID |
| DOO_TRANSACTION_EVENTS_PK | Unique | Default | TRANSACTION_EVENT_ID |