Table slot9.WORLD.TSTA.EXTERNAL_SYSTEM_DELETES
This table stores external system delete 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_EXPUNGEMENTS.TRANSACTION_ID Implied Constraint R
Unique transaction ID.
REFERENCE_ID varchar2 50 The unique record identifier within the external system.
REMARKS varchar2 100  √  null Information about or related to the delete transaction.
EXTERNAL_SYSTEM varchar2 10  √  null
EXTERNAL_SYSTEM_CODES.CODE ESD_EXSYS_FK R
The external system receiving the delete transaction request.
AGENCY_CODE varchar2 30  √  null
AGENCY_CODES.AGENCY_CODE ESD_AGNCY_CD_FK R
Agency Code associated with the delete transaction.
PROCESSED varchar2 1  √  null Flag used to indicate a delete transaction request was submitted to an external entity.
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_ESD_PROCESSED
"REFERENCE_ID" IS NOT NULL ESD_REF_ID_NN
"TRANSACTION_ID" IS NOT NULL ESD_TRANS_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
TRANSACTION_ID Primary key Asc ESD_PK
AGENCY_CODE Performance Asc ESD_AGNCY_CD_FK_I
EXTERNAL_SYSTEM Performance Asc ESD_EXSYS_FK_I

Close relationships  within of separation: