Touchstone 2022 Database Reference
tValidationErrorType Table
AIRReference Database : tValidationErrorType Table
Description
Stores the possible types of validation errors.
Properties
Creation Date8/9/2016 1:50 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows5
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key ValidationErrorTypeCode

Code that represents the type of a validation error.

  • BUS = The provided value fails business rule validation.
  • DATA = Value is outside of acceptable parameters.
  • DATATYPE = The provided value does not match the expected data type.
  • GEOCODE = Error during geocoding process.
  • WARNING = Value is invalid, but non-critical. It has either been ignored or replaced with a correct value.
varchar10   
 ValidationErrorTypeShort name for the code.varchar40   
 DescriptionDescription of the code.varchar1024  
Objects that depend on tValidationErrorType
 Database ObjectObject TypeDescriptionDep Level
tValidationError tabletValidationErrorTable

Stores import validation error codes, validation rules, and error messages. When a validation error occurs, the error is written to the import log file using the following format: ERROR CODE | Contract ID: XXX Location ID XXX | Summary Message.

1
See Also

Related Objects

AIRReference Database

 

 

Verisk Analytics Client Confidential

© 2022. AIR Worldwide is now Extreme Event Solutions. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact Verisk Analytics with questions or comments.