sp238_ext_data_valid_defns

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.