Result Codes - Profiler Object#
Record Level Result Codes#
Profiler Error#
Code |
Short Description |
Long Description |
---|---|---|
|
Illegal UTF-8 Byte Sequence |
The value contains an illegal UTF-8 byte sequence. |
|
Invalid Integer |
The value’s integer value is invalid. |
|
Invalid Decimal |
The value’s decimal value is invalid. |
|
Invalid Floating Point |
The value’s floating point value is invalid. |
|
Invalid Date/Time |
The value’s date/time value is invalid. |
|
Invalid Boolean Value |
The value’s boolean value is invalid. |
|
Over Range |
The value is above the user-specified range. |
|
Under Range |
The value is below the user-specified range. |
|
Length Size Exceeded |
The value’s length exceeds the user-specified size. |
|
Precision Exceeded |
The value’s precision exceeds the user-specified precision. |
|
Precision Scale Exceeded |
The value’s precision exceeds the user-specified scale. |
|
No Regular Expression Match |
The value does not match any of the user-specified regular expressions. |
|
Data Type Mismatch |
The value is inconsistent with the user-specified DataType (e.g. an address field containing a phone number.) |
|
Unrecognized State/Province |
The value contains an unrecognized state or province. |
|
Invalid ZIP Code |
The value contains a US ZIP code that is not valid (only the 5 digit zip is validated in this way.) This is returned only when getting the results for a column with a data type set as DataTypeZipOrPostalCode. |
|
Invalid Postal Code |
The value contains a Canadian Postal Code that is not valid. This is returned only when getting the results for a column with a data type set as DataTypeZipOrPostalCode. |
|
ZIP Code Mismatch |
The value’s Zip Code does not correctly correspond to the specified US State. This is returned only when getting the results for a column with a data type set as DataTypeStateOrProvince. |
|
Postal Code Mismatch |
The value’s Postal Code does not correctly correspond to the specified Canadian Province. This is returned only when getting the results for a column with a data type set as DataTypeStateOrProvince. |
|
Unrecognized Country |
The value contains an unrecognized country name. |
|
Incorrect E-mail Syntax |
The value contains an e-mail address with an incorrect syntax. |
|
Misspelled Domain |
The value contains an e-mail with a misspelled domain. |
|
Unrecognizable Phone |
The value contains an unrecognizable phone number. |
|
Unbalanced Text Qualifiers |
The record contained unbalancd text qualifiers. |
|
Un-escaped Text Qualifiers |
The record contained un-escaped text qualifiers. |
Profiler Status#
Code |
Short Description |
Long Description |
---|---|---|
|
Empty Value |
The value is empty or contains only spaces. |
|
NULL Value |
The value is NULL. |
|
Default Value |
The value is equal to the user-specified default. |
|
Non-Printing Characters |
The value contains non-printing characters (e.g. printer control characters, etc.) |
|
Diacritic Characters |
The value contains diacritic characters (e.g. accented characters.) |
|
Non-English Characters |
The value contains non-English characters. |
|
Decorative Characters |
The value contains decorative characters. Decorative characters are tabs, commas, or double quotes, found in the beginning or ending of the value. This may indicate an import issue where delimiters made their way into the value being evaluated. |
|
Alphabetic Characters |
The value contains only alphabetic characters. |
|
Numeric Characters |
The value contains only numeric characters. |
|
Alphabetic and Numeric Characters |
The value contains both alphabetic and numeric characters. |
|
Upper-Case Alphabetic Characters |
The value contains only upper-case alphabetic characters, and may contain non-alphabetic characters. |
|
Lower-Case Alphabetic Characters |
The value contains only lower-case alphabetic characters, and may contain non-alphabetic characters. |
|
Upper and Lower Alphabetic Characters |
The value contains both upper and lower-case alphabetic characters, and may contain non-alphabetic characters. |
|
Single Space |
Only a single space separates the words in value. |
|
Multiple Spaces |
Multiple spaces separate the words in value. |
|
Leading Spaces |
The value contains leading spaces. |
|
Trailing Spaces |
The value contains trailing spaces. |
|
Profanity |
The value contains profanity. |
|
2-digit Year |
The date/time value lacks the year’s century. |
|
Inconsistent Name |
The name value contains a name where the order is inconsistent with the user-specified data type. |
|
Multiple Names |
The name value contains more than one contact name. |
|
Suspicious Name |
The name value contains a suspicious name. |
|
Non-Standard State/Province |
The State/Province value contains a non-standard US state or Canadian province (i.e. not the official postal abbreviation). |
|
5-digit ZIP/Postal Code |
The ZIP/Postal Code value has a 5-digit Zip Code with no Plus 4. |
|
Unrecognized Country ISO |
The country value does not match any standard ISO country representation. |
|
Mobile Domain |
The e-mail value contains a mobile (cell phone) domain. |
|
Spam Trap Domain |
The e-mail value contains a known spam trap domain. |
|
Disposable Domain |
The e-mail value contains a known ‘disposable’ domain. |
|
Embedded Row Delimiter |
The record contained an embedded row delimiter. |
|
Missing Fields |
Not all fields were present in the record. |
|
Extra Fields |
Extra fields were present in the record. |