Customer Data Parser Review Codes/Review Groups - trillium_discovery - trillium_quality

Review codes are produced for many different data conditions. These codes can be evaluated in a post parsing process to trigger specific record handling or review. For example, if a business wanted to review every record that had received a review code of 26 (Unknown Street Pattern), a subsequent step following the parsing process could redirect all records with this condition by selecting the records with this code.

The code values are represented on the record by a position in the attribute that corresponds to the line type. For each of these attributes, a flag value of '1' is placed in the position in the attribute that corresponds to the value of the condition. For example if a review code of 26 was reported, you would find a '1' in the attribute pr_street_review_codes at position 26.

The attribute names that must be used in the CDP output schema to contain these codes are:

Name review code - pr_name_review_codes
Street review code - pr_street_review_codes
Geography review code - pr_geog_review_codes
Misc review code - pr_misc_review_codes
Global review code - pr_global_review_codes

Note for Misc Review Code

The pr_misc_review_codes attribute is divided into 10 parts, for 10 possible parser lines. There are 150 possible review codes for each line (100 - 149 are reserved for future ). For example, if the review code of 084 applies to the second line, there is no flag for line 1, and no flags for line 2 until position 84 on that line which is 150 + 84. This means that you find a '1' at position 234. Note that the default length of pr_misc_review_codes is 3000 bytes to store 150 characters X 10 as UCS2 in the Control Center takes 2 bytes for each character.

Review Codes

The following table lists review codes, the review group to which each code belongs, and descriptions for the Customer Data Parser.

Review Code	Review Group	Description
Review Codes Can Belong To Multiple Review Code Attributes:
000	000	No review code found
Name Review Code
001	008	Unknown name pattern
002	009	Standardized first name too long
003	009	Display first name too long
004	009	Total number of export names gt max
005	009	Standardized middle name too long
006	009	Display middle name too long
007	009	Too many middle names
008	009	Standardized last name too long
009	009	Display last name too long
010	009	Standardized title too long
011	009	Display title too long
012	009	Too many titles
013	009	Standardized connector too long
014	009	Display connector too long
015	009	Standardized relation too long
016	009	Display relation too long
017	009	Standardized business too long
018	009	Display business too long
019	009	Derived genders conflict
020	009	Standardized generation too long
021	009	Display generation too long
022	010	More than one middle name
Street Review Code
026	011	Unknown street pattern
027	011	Standardized street type too long
028	011	Display street type too long
029	011	Too many street types
030	012	Standardized direction too long
031	012	Display direction too long
032	012	Too many directions
033	013	Standardized street title too long
034	013	Display street title too long
035	013	Standardized complex name too long
036	013	Display complex name too long
037	013	Standardized house number too long
038	013	Display house number too long
039	013	Unusual house number
040	013	Display dwelling too long
041	013	Standardized dwelling too long
042	013	Too many dwellings
043	013	Unusual dwelling value
044	013	Too many dwelling values
045	013	Display box too long
046	013	Standardized box too long
047	013	Unusual box value
048	013	Display route too long
049	013	Standardized route too long
050	013	Standardized route number too long
051	013	Display route number too long
052	013	Unusual route value
053	013	Standardized complex type too long
054	013	Display complex type too long
055	013	Standardized dwelling number too long
056	013	Standardized box number too long
057	013	Display box number too long
058	013	Display dwelling number too long
059	020	Duplicate street line types
Geography Review Code
061	014	No city name found in records
062	014	No state found in records
063	014	Standardized city too long
064	014	Display city too long
066	015	Standardized state/province/county too long
067	015	Display state/province/county too long
070	015	Standardized country too long
071	015	Display country too long
072	015	Standardized neighborhood too long
073	015	Display neighborhood too long
074	015	Standardized post code too long
075	015	Display post code too long
076	015	Unusual post code value
077	016	Corrected city name too long
078	000	City name change used for city
079	017	Conflicting geographic types
080	018	Domestic city name present but could not be verified
Global Review Code/Misc Review Code
083	001	Unidentified token
084	019	Unidentified line
085	001	Invalid token definitions
086	001	Label or label element too long
087	001	Miscellaneous data for line too long
088	001	Too many categories
089	001	Too many names for export
090	002	Mixed name forms present
091	003	Hold mail element present
092	004	Foreign address element found
093	005	No names identified
094	006	No street identified
095	007	No geography identified
096 - 099		Currently unassigned

Review Groups

The following table lists review groups and descriptions for the Customer Data Parser.

Review Group	Description
000	No targeted condition found
001	Unidentified item
002	Mixed name forms
003	Hold mail
004	Foreign address Note: The review group 004 is set if there is a token with an attribute of COUNTRY. It is also set to 004 if any of the tokens has an attribute of COUNTRY, PROVINCE, or STATE and has a category that starts with 'F'.
005	No names identified
006	No street identified
007	No geography identified
008	Unknown name pattern
009	Derived genders conflict
010	More than one middle name
011	Unknown street pattern
012	Invalid directional
013	Unusual or long address
014	No city or county identified
015	Geography too long
016	Corrected city name too long
017	Conflicting geography types
018	Unable to verify city name
019	Unidentified line
020	Multiple street line types

Customer Data Parser Review Codes/Review Groups - trillium_discovery - trillium_quality - 17.1

Inline Quality and Discovery

Note for Misc Review Code

Review Codes

Review Groups