Result Codes - Profiler Object

Result Codes - Profiler Object#

Record Level Result Codes#

Profiler Error#

Code

Short Description

Long Description

QE01

Illegal UTF-8 Byte Sequence

The value contains an illegal UTF-8 byte sequence.

QE03

Invalid Integer

The value’s integer value is invalid.

QE04

Invalid Decimal

The value’s decimal value is invalid.

QE05

Invalid Floating Point

The value’s floating point value is invalid.

QE06

Invalid Date/Time

The value’s date/time value is invalid.

QE07

Invalid Boolean Value

The value’s boolean value is invalid.

QE08

Over Range

The value is above the user-specified range.

QE09

Under Range

The value is below the user-specified range.

QE10

Length Size Exceeded

The value’s length exceeds the user-specified size.

QE11

Precision Exceeded

The value’s precision exceeds the user-specified precision.

QE12

Precision Scale Exceeded

The value’s precision exceeds the user-specified scale.

QE13

No Regular Expression Match

The value does not match any of the user-specified regular expressions.

QE14

Data Type Mismatch

The value is inconsistent with the user-specified DataType (e.g. an address field containing a phone number.)

QE30

Unrecognized State/Province

The value contains an unrecognized state or province.

QE40

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.

QE41

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.

QE42

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.

QE43

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.

QE50

Unrecognized Country

The value contains an unrecognized country name.

QE60

Incorrect E-mail Syntax

The value contains an e-mail address with an incorrect syntax.

QE61

Misspelled Domain

The value contains an e-mail with a misspelled domain.

QE70

Unrecognizable Phone

The value contains an unrecognizable phone number.

QE90

Unbalanced Text Qualifiers

The record contained unbalancd text qualifiers.

QE91

Un-escaped Text Qualifiers

The record contained un-escaped text qualifiers.

Profiler Status#

Code

Short Description

Long Description

QS01

Empty Value

The value is empty or contains only spaces.

QS02

NULL Value

The value is NULL.

QS03

Default Value

The value is equal to the user-specified default.

QS04

Non-Printing Characters

The value contains non-printing characters (e.g. printer control characters, etc.)

QS05

Diacritic Characters

The value contains diacritic characters (e.g. accented characters.)

QS06

Non-English Characters

The value contains non-English characters.

QS07

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.

QS08

Alphabetic Characters

The value contains only alphabetic characters.

QS09

Numeric Characters

The value contains only numeric characters.

QS10

Alphabetic and Numeric Characters

The value contains both alphabetic and numeric characters.

QS11

Upper-Case Alphabetic Characters

The value contains only upper-case alphabetic characters, and may contain non-alphabetic characters.

QS12

Lower-Case Alphabetic Characters

The value contains only lower-case alphabetic characters, and may contain non-alphabetic characters.

QS13

Upper and Lower Alphabetic Characters

The value contains both upper and lower-case alphabetic characters, and may contain non-alphabetic characters.

QS14

Single Space

Only a single space separates the words in value.

QS15

Multiple Spaces

Multiple spaces separate the words in value.

QS16

Leading Spaces

The value contains leading spaces.

QS17

Trailing Spaces

The value contains trailing spaces.

QS18

Profanity

The value contains profanity.

QS19

2-digit Year

The date/time value lacks the year’s century.

QS20

Inconsistent Name

The name value contains a name where the order is inconsistent with the user-specified data type.

QS21

Multiple Names

The name value contains more than one contact name.

QS22

Suspicious Name

The name value contains a suspicious name.

QS30

Non-Standard State/Province

The State/Province value contains a non-standard US state or Canadian province (i.e. not the official postal abbreviation).

QS40

5-digit ZIP/Postal Code

The ZIP/Postal Code value has a 5-digit Zip Code with no Plus 4.

QS50

Unrecognized Country ISO

The country value does not match any standard ISO country representation.

QS60

Mobile Domain

The e-mail value contains a mobile (cell phone) domain.

QS61

Spam Trap Domain

The e-mail value contains a known spam trap domain.

QS62

Disposable Domain

The e-mail value contains a known ‘disposable’ domain.

QS90

Embedded Row Delimiter

The record contained an embedded row delimiter.

QS91

Missing Fields

Not all fields were present in the record.

QS92

Extra Fields

Extra fields were present in the record.