Review Codes for Postal Matchers (China, Japan, Korea, Taiwan) - trillium_discovery - trillium_quality - Latest

Trillium Control Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Version
Latest
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Control Center
Copyright
2024
First publish date
2008
Last updated
2024-10-18
Published on
2024-10-18T15:02:04.502478

The Postal Matchers for China, Japan (standard), Korea, and Taiwan generate review codes for each record to highlight specific conditions describing how the record was processed. Review codes are written to the pr_review_code_nn (nn=01-20) attribute.

The following table lists the individual review codes. 

Code Description
000 No review codes written.
001

Found multiple Level 4 values in address data.

002 Postal code value changed from block number value in address line.
003 Postal code value changed from Level 4 value in address data.
004 Level 4 value created from an unknown string.
005 Invalid postal code value.
006 Postal code does not match the address/geography data.
007 More than one postal code can be valid for given address/geography data.
008 Add a number value to the Level 3.

009

Unknown token remaining after processing.
010 Unknown tokens remaining after matching front and back parts of string.
013 Level 1 value too long.
014 Level 2 value too long.
015 Level 3 value too long.
016 Level 4 value too long.
017

Postal code value too long.

018 Building number value too long.
019 House display value too long.

020

Building number display too long.
021 Apartment number display too long.
022 Building name too long.
023 Area name too long.
024 Added a number to Level 3.
025 Original Address too long.
026 Entrance number display too long.
027 PO Box too long.

029

General postcode is used. If the program cannot find a specific postcode match, it uses a general postcode that covers a large area.
030 Taiwan only. Three digit no match. This is used where there is new postcode, but the first three digits do not match the old three digit postcode in the address.
041 Business branch value too long.
042 Business type value too long.
043 Business name value too long.
044 No business name.
045 Business name and type too long for attribute.
051 Surname value not found in lookup table.
052 Surname value too long.
053 First (given) name value too long.
054 No surname.
055 No given name.
056 Honorific not found in table.
057 Honorific too long.
058 Unidentified token.
059 Korea only. Level switch. It is used when the program switches the level 2 and finds a match with the given level 3 and level 4.
061 Did not find Level 1 in address line.
062 Did not find Level 2 in address line.
063 Did not find Level 3 in address line.
064 Did not find Level 4 in address line.
065 Did not find Postal code in address line.
071 Did not find the Level 1 value in GAV tables.
072 Did not find the Level 2 value in GAV tables.
073 Did not find the Level 3 value in GAV tables.
074 Did not find the Level 4 value in GAV tables.
075 Did not find the postal code value in GAV tables.
076 Spelling corrected in Level1 value.
077 Spelling corrected in Level2 value.
078 Spelling corrected in Level3 value.

079

Spelling corrected in Level4 value.
081 Level 1 value not found, but found appropriate ending. Create an entry.
082 Level 2 value not found, but found appropriate ending. Create an entry.
083 Level 3 value not found, but found appropriate ending. Create an entry.
084 Level 4 value not found, but found appropriate ending. Create an entry.
091 Level 1 data entered with a different ending than the lookup table.
092 Level 2 data entered with a different ending than the lookup table.
093 Level 3 data entered with a different ending than the lookup table.
094 Level 4 data entered with a different ending than the lookup table.
101 Level 1 geography changed using the level-recode keyword.
102 Level 2 geography changed using the level-recode keyword.
103 Level 3 geography changed using the level-recode keyword.
104 Level 4 geography changed using the level-recode keyword.
121 Found Level 1 geography by adding appropriate ending.
122 Found Level 2 geography by adding appropriate ending.
123 Found Level 3 geography by adding appropriate ending.
124 Found Level 4 geography by adding appropriate ending.
212 Did not find Level 1 data but figured it out from the Level 2 data. Keep the new value.
213 Did not find Level 1 data but figured it out from the Level 3 data. Keep the new value.
214 Did not find Level 1 data but figured it out from the Level 4 data. Keep the new value.
215 Did not find Level 1 data but figured it out from the Postcode data. Keep the new value.
223 Did not find Level 2 data but figured it out from the Level 3 data. Keep the new value.
224 Did not find Level 2 data but figured it out from the Level 4 data. Keep the new value.
225 Did not find Level 2 data but figured it out from the postal code data. Keep the new value.
234 Did not find Level 3 data but figured it out from the Level 4 data. Keep the new value.
235 Did not find Level 3 data but figured it out from the postal code data. Keep the new value.
245 Did not find Level 4 data but figured it out from the Level 5 data. Keep the new value.
253 Did not find postal code but figured it out from the Level 3 data. Keep the new value.
254 Did not find postal code but figured it out from the Level 4 data. Keep the new value.
312 Found Level 1 data, but the Level 2 data dictates a different value. Keep the new value.
313 Found Level 1 data, but the Level 2 and 3 data dictate a different value. Keep the new value.
314 Found Level 1 data, but Level 2, 3 and 4 data dictate a different value. Keep the new value.
315 Found Level 1 data, but postcode dictates a different Level 1 value. Keep the new value.
323 Found Level 2 data, but the Level 3 data dictates a different Level 2 value. Keep the new value.
324 Found Level 2 data, but the Level 3 and 4 combination dictates a different Level 2 value. Keep the new value.
325 Found Level 2 data, but the Level 3, 4 and postcode data dictate a different Level 2 value. Keep the new value.
334 Found Level 3 data, but the Level 4 data dictates a different Level 3 value. Keep the new value.
335 Found Level 3 data, but the Level 4 and postcode combination dictates a different Level 3 value. Keep the new value.
345 Found Level 4 data, but the postcode data dictates a different Level 4 value. Keep the new value.
353 Found postal code but Level 3 data dictates a different postal code. Keep the new value.
354 Found postal code but Level 4 data dictates a different postal code. Keep the new value.
412 Found Level 2 data that is not valid for the Level 1 data but can be valid for more than one other Level 1 value. Keep the value as-is.
413 Found Level 3 data that is not valid for the Level 1 data but can be valid for more than one other Level 1 value. Keep the value as-is.
414 Found Level 4 data that is not valid for the Level 1 data but can be valid for more than one other Level 1 value. Keep the value as-is.
415 The postal code found was not valid for Level 1. Level 1 does not match the postal code.
423 Found Level 3 data that is not valid for the Level 2 data but can be valid for more than one other Level 2 value. Keep the value as-is.
424 Found Level 4 data that is not valid for the Level 2 data but can be valid for more than one other Level 2 value. Keep the value as-is.
434 Found Level 4 data that is not valid for the Level 3 data but can be valid for more than one other Level 3 value. Keep the value as-is.
435 The postal code found was not valid for Level 3. Level 3 does not match the postal code.
445 The postal code found was not valid for Level 4. Level 4 does not match the postal code.
901 Recoded Level 1 geography according to a word/pattern table entry.
902 Recoded Level 2 geography according to a word/pattern table entry.
903 Recoded Level 3 geography according to a word/pattern table entry.
904 Recoded Level 4 geography according to a word/pattern table entry.
906 Recoded sub-district or area according to a word/pattern table entry.
907 Recoded building name according to a word/pattern entry.
910 Recoded an entry from an abbreviation to the full name.
911 Recoded Level 1 geography according to a word/pattern table entry to correct a mistyped or misused word.
912 Recoded Level 2 geography according to a word/pattern table entry to correct a mistyped or misused word.
913 Recoded Level 3 geography according to a word/pattern table entry to correct a mistyped or misused word.
914 Recoded Level 4 geography according to a word/pattern table entry to correct a mistyped or misused word.
921 Recoded business name according to a word/pattern table entry to correct a mistyped or misused word.