This table defines the set of actual validation rules applied to individual external data types by the GUI when accepting external data input.

Table Definition

Field	Type	Default	Nullable
external_data_type	number(9)
validation_property	number (2)
validation_value	varchar2(30)

Keys

Primary key (external_data_type, validation_property)
Foreign key (external_data_type) references sp231_ext_data_types (external_data_type)
Foreign key (validation_property) references sp237_ext_data_validation(validation_property)

Column Descriptions

Field	Description
external_data_type	Identifier of the data type
validation_property	Identifier of the validation type
validation_rule	The value used with the rule to test against the value supplied in the GUI. For example, with a validation_property referencing the validation_rule 'max value' and a display rule defined here as '20' the validation would accept input of numbers 0-20.

Browser not supported