Table slot9.WORLD.TSTA.INC_VALID_CONDITIONS
This table stores conditions for INCIDENT rule validation executed in the application
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
CONDITION_CODE varchar2 30
DISPATCH_EVENT_VEHICLES_VW.CONDITION_CODE Implied Constraint R
INC_VAL_COND_AGNC_CDE.CONDITION_CODE IVCAC_IVC_FK R
INC_VAL_COND_PROP_CDE.CONDITION_CODE IVCPC_IVC_FK R
Unique Primary key for each condition.
FACTOR_CODE varchar2 30
EJS_CODES.CODE IVC_FC_EJS_CODES_FK R
Foreign key to EJS_CODES to identify the Rules conditional element.
FACTOR_CODE_TYPE varchar2 30 'CONDITION_FACTOR_CODES'
EJS_CODES.CODE_TYPE IVC_FC_EJS_CODES_FK R
INC_VAL_CONDITION_FACTOR_CODES to identify the EJS_CODE_TYPE
FACTOR_OPERATOR varchar2 2 The operator that indicates the type of conditional operation to perform(e.g. EQ, LE).
FACTOR varchar2 255 The value related to the Factor Code that will be tested to satisfy the condition
INHERITANCE_RULE varchar2 30
EJS_CODES.CODE IVC_IR_EJS_CODES_FK R
Indicates prevalence when found in conjunction with a condition from a parent or child
INHERITANCE_TYPE_CODE varchar2 30 'RULE_INHERITANCE_CODES'
EJS_CODES.CODE_TYPE IVC_IR_EJS_CODES_FK R
NATURAL_PREFERENCE varchar2 30
EJS_CODES.CODE IVC_NP_EJS_CODES_FK R
Sets a preference to conflict resolution when another rule conflicts with this one
PREFERENCE_TYPE_CODE varchar2 30 'RULE_PREFERENCE_CODES'
EJS_CODES.CODE_TYPE IVC_NP_EJS_CODES_FK R
PREFERENTIAL_OVERRIDE varchar2 30
EJS_CODES.CODE IVC_PO_EJS_CODES_FK R
Sets the preferentiality of this rule when in conflict with another rule.
OVERRIDE_TYPE_CODE varchar2 30 'RULE_OVERRIDE_CODES'
EJS_CODES.CODE_TYPE IVC_PO_EJS_CODES_FK R
CREATOR_DATE date 7  √  null
CREATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
REC_ID number 0  √  null
FACTOR_SOURCE varchar2 100  √  null
FACTOR_FIELD_CODE varchar2 30  √  null
COND_EVAL_METHOD varchar2 256  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
FACTOR_OPERATOR IN ('EQ', 'NE', 'LT', 'LE', 'GT', 'GE') CK_IVC_FACTOR_OPERATOR
"CONDITION_CODE" IS NOT NULL IVC_COND_CODE_NN
"FACTOR_CODE_TYPE" IS NOT NULL IVC_FACD_TYPE_NN
"FACTOR_CODE" IS NOT NULL IVC_FACT_CODE_NN
"FACTOR" IS NOT NULL IVC_FACTOR_NN
"FACTOR_OPERATOR" IS NOT NULL IVC_FACTOR_OPERATOR_NN
"INHERITANCE_RULE" IS NOT NULL IVC_INH_RULE_NN
"INHERITANCE_TYPE_CODE" IS NOT NULL IVC_INHR_TYPE_NN
"NATURAL_PREFERENCE" IS NOT NULL IVC_NATURAL_PREF_NN
"OVERRIDE_TYPE_CODE" IS NOT NULL IVC_OVRD_TYPE_CODE_NN
"PREFERENTIAL_OVERRIDE" IS NOT NULL IVC_PREF_OVRD_NN
"PREFERENCE_TYPE_CODE" IS NOT NULL IVC_PREF_TYPE_CODE_NN

Indexes:
Column(s) Type Sort Constraint Name
CONDITION_CODE Primary key Asc IVC_PK
FACTOR_CODE_TYPE + FACTOR_CODE Performance Asc/Asc IVC_FC_EJS_CODES_FK_I
INHERITANCE_TYPE_CODE + INHERITANCE_RULE Performance Asc/Asc IVC_IR_EJS_CODES_FK_I
PREFERENCE_TYPE_CODE + NATURAL_PREFERENCE Performance Asc/Asc IVC_NP_EJS_CODES_FK_I
OVERRIDE_TYPE_CODE + PREFERENTIAL_OVERRIDE Performance Asc/Asc IVC_PO_EJS_CODES_FK_I

Close relationships  within of separation: