Table slot9.WORLD.TSTA.EXTERNAL_SYSTEM_CODES
This table is used for external searches. This table is not used at this time
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
CODE varchar2 10
DS_IBR_FIELD_SYSTEMS.EXTSYS_CODE DSIBRFLDSY_EXSYS_FK R
DS_IBR_SEGMENT_DETAILS.EXTSYS_CODE DSIBRSEGDET_EXSYS_FK R
DS_ICR_FILE_REFERENCES.EXTSYS_CODE DSICRFREF_EXTSYS_FK R
DS_ICR_HEADER_FILES.EXT_SYS_CODE DSICRHF_EXSYS_FK R
DS_ICR_HEADER_MESSAGES.EXT_SYS_CODE DSICRHM_EXSYS_FK R
EXTERNAL_SYSTEM_AGENCIES.EXSYS_CODE EXSYS_EXSA_FK R
EXTERNAL_SYSTEM_AGENCIES_VW.CODE Implied Constraint R
EXTERNAL_SYSTEM_DELETES.EXTERNAL_SYSTEM ESD_EXSYS_FK R
EXTERNAL_SYSTEM_EXPUNGEMENTS.EXTERNAL_SYSTEM ESE_EXSYS_FK R
EXTERNAL_SYSTEM_MAPPINGS.EXT_SYSTEM_CODE ESM_EXSYS_FK C
INCIDENT_DELETE.LOADED_BY ID_EXSYS_FK R
USER_LOV_CODES.CODE Implied Constraint R
The code used to identify the external system.
DESCRIPTION varchar2 80  √  null The description of the external system.
PROCEDURE_NAME varchar2 80  √  null The database procedure used in conjunction with the external system.
EXSYS_DOC_CATEGORY_CODE varchar2 3  √  null
XML_DOCUMENT_CATEGORY_CODES.DOC_CATEGORY_CODE DCC_EXSYS_FK R
The XML document category code associated with the external system.
REC_ID number 0  √  null Unique system record identifier.
DS_INTERFACE varchar2 1  √  null
EXTERNAL_DELETE varchar2 1  √  null Flag used to indicate external delete transactions are supported and activated
NEW_SERVICE_FLAG varchar2 1  √  'N' If Set to Y, this interface supports file generation by the new IBR Service
SUBMISSION_SERVICE_NAME varchar2 100  √  null
LEGACY_SERVICE_FLAG varchar2 1  √  'N'

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
EXTERNAL_DELETE IN ('Y','N') CK_EXSYS_EXTERNAL_DELETE
"CODE" IS NOT NULL EXSYS_CODE_NN

Indexes:
Column(s) Type Sort Constraint Name
CODE Primary key Asc EXSYS_PK
EXSYS_DOC_CATEGORY_CODE Performance Asc EXSYS_DCC_FK_I

Close relationships  within of separation: