Table slot9.WORLD.TSTA.EJS_XML_TAG_NAMES
This table is an administration table that is used for processing XML documents being loaded into the database
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
ROW_TAG_ID number 0
EJS_TAG_SCREEN_PARAMS.ROW_TAG_ID ETSP_EXTN_FK R
EJS_XML_SUMMARY_TAGS.ROW_TAG_ID EXST_EXTN_FK R
EJS_XML_TAG_VALUES.ROW_TAG_ID EXTV_EXTN_FK R
EJS_XML_ROW_TAGS.ROW_TAG_ID EXTN_EXRTP_FK R
A unique number used to identify a row tag.
TAG_NAME varchar2 80
EJS_TAG_SCREEN_PARAMS.TAG_NAME ETSP_EXTN_FK R
EJS_XML_SUMMARY_TAGS.TAG_NAME EXST_EXTN_FK R
EJS_XML_TAG_VALUES.TAG_NAME EXTV_EXTN_FK R
The tag name being catured from an XML document.
FIELD_NAME varchar2 20  √  null
USER_DATA_FIELDS.FIELD_NAME EXTN_UDDF_FK R
DATA_ELEMENT varchar2 20  √  null
USER_DATA_FIELDS.DATA_ELEMENT EXTN_UDDF_FK R
TAG_TYPE_CODE varchar2 30  √  null
EJS_CODES.CODE EXTN_TAG_TYPE_CODE_EJS_CODE_FK R
The type of tag being processed. (i.e. Narrative, attachment,image...)
DEST_COLUMN_NAME varchar2 80  √  null The EJS column name that will be used during the upload process.
ROW_TAG_LEVEL number 38  √  null the level of the row tag being captured.
TAG_LABEL varchar2 80  √  null he label that will appear during Matching
MAPPING_CODE varchar2 30  √  null Used to define the keyword necessary for code translation.
UPPER_CASE varchar2 1  √  'N' A check box to flag if the tag should be upper case.
MAX_LENGTH number 0  √  null A number used to specify length for parser.
TAG_TYPE_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE EXTN_TAG_TYPE_CODE_EJS_CODE_FK R
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
UPPER_CASE IN ('N', 'Y') CK_EXTN_UPPER_CASE
"ROW_TAG_ID" IS NOT NULL EXTN_ROW_TAG_ID_NN
"TAG_NAME" IS NOT NULL EXTN_TAG_NAME_NN

Indexes:
Column(s) Type Sort Constraint Name
ROW_TAG_ID + TAG_NAME Primary key Asc/Asc EXTN_PK
ROW_TAG_ID Performance Asc EXTN_EXRTP_FK_I
TAG_TYPE_CODE Performance Asc EXTN_EXTTC_FK_I
TAG_NAME Performance Asc EXTN_TAG_NAME_I
TAG_TYPE_CODE_TYPE + TAG_TYPE_CODE Performance Asc/Asc EXTN_TAG_TYPE_CODE_EJS_CODE_I
FIELD_NAME + DATA_ELEMENT Performance Asc/Asc EXTN_UDDF_FK_I

Close relationships  within of separation: