Table slot9.WORLD.TSTA.EXTERNAL_SYSTEM_EXPUNGEMENTS
This table stores external system expungement transaction information.
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
TRANSACTION_ID number 0
EXTERNAL_SYSTEM_DELETES.TRANSACTION_ID Implied Constraint R
Unique transaction ID.
INCIDENT_ID varchar2 50 The incident id to be processed.
EXTERNAL_SYSTEM varchar2 10  √  null
EXTERNAL_SYSTEM_CODES.CODE ESE_EXSYS_FK R
The external system for the transaction request.
PROCESSED varchar2 1  √  null Flag used to indicate a transaction request has been processed.
CREATOR_ID varchar2 100  √  null Created by User ID.
CREATOR_DATE date 7  √  null Date the record was created.
UPDATOR_ID varchar2 100  √  null Updated by User ID.
UPDATOR_DATE date 7  √  null Date the record was last updated.
REC_ID number 0  √  null Unique system record identifier.

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
PROCESSED IN ( 'Y','N') CK_ESE_PROCESSED
"INCIDENT_ID" IS NOT NULL ESE_INC_ID_NN
"TRANSACTION_ID" IS NOT NULL ESE_TRANS_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
TRANSACTION_ID Primary key Asc ESE_PK
EXTERNAL_SYSTEM Performance Asc ESE_EXSYS_FK_I

Close relationships  within of separation: