Taxonomy Validation Table structure

2 Taxonomy Validation Table structure

DIGX_FW_LOCALE_DATA_TYPE

This table holds the complete list of predefined data types in Out of the box OBAPI application. The default locale used to define data type is ‘en’. Separate entries for data types can be made for required locales. All the taxonomy data is validated against these data types. The validation pattern for specific data type is formed based on the column values of this table which is as follows:

Column Name	Type	Description
`ID`	`VARCHAR2(100)`	Unique identifier of the data type
`LOCALE`	`VARCHAR2(3)`	Locale identifier for which validation pattern is required
`DESCRIPTION`	`VARCHAR2(255)`	Description of the taxonomy
`MINLENGTH`	`NUMBER`	minimum length required for the field
`MAXLENGTH`	`NUMBER`	maximum length allowed for the field
`PATTERN`	`VARCHAR2(255)`	regex pattern required to be validated(if any)
`ERRORCODE`	`VARCHAR2(255)`	the default error code if the pattern validation fails
`LENGTHERRORCODE`	`VARCHAR2(255)`	error code thrown if length criteria fails
`VALIDATION_CLASS`	`VARCHAR2(255)`	Fully qualified name of the class that needs to be invoked for the validation.

DIGX_FW_TAXONOMY_DATA_TYPE_MAP

This table is used to define taxonomy and map it to the desired data type. The taxonomy can be defined at class level or field level in this table. The validation pattern for the taxonomy can be defined using following columns.

Column Name	Type	Description
`ID`	`VARCHAR2(255)`	Unique identifier of the field to be validated. This can be only field name, field name in class hierarchy or complex fields parameters
`TYPE`	`VARCHAR2(20)`	(FIELD/CLASS/COMPLEX)
`DATATYPEID`	`VARCHAR2(100)`	Identifier of the Data Type to be applied on taxonomy
`MINLENGTH`	`NUMBER`	minimum length required for the field
`MAXLENGTH`	`NUMBER`	maximum length allowed for the field
`MANDATORY`	`VARCHAR2(1)`	Is the field value mandatorily required (Values - Y/N)
`ERRORCODE`	`VARCHAR2(255)`	the default error code if the pattern validation fails
`LENGTHERROCODE`	`VARCHAR2(255)`	error code thrown if length criteria fails
`MANDATORYERRORCODE`	`VARCHAR2(255)`	error code thrown if mandatory criteria fails

Note:

For all the fields which are common in both the tables, the field value in


                    'DIGX_FW_TAXONOMY_DATA_TYPE_MAP'

will take the precedence.