14.1 sp238_ext_data_valid_defns
- Billy Sewell (Unlicensed)
Owned by Billy Sewell (Unlicensed)
Jan 26, 2024
Loading data...
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. |