Difference between revisions of "Listware:Codes"

From Melissa Data Wiki
Jump to navigation Jump to search
Line 1: Line 1:
Also see [[Response Results Codes]] and [[Listware:Codes|Listware Codes]].
Also see [[Response Result Codes]] and [[Listware:Codes|Listware Codes]].





Revision as of 16:57, 22 November 2013

Also see Response Result Codes and Listware Codes.


Address Error Codes

Code Description
C Canadian ZIP Code.
E Delivery Plus record. This address is not deliverable by USPS, but it exists.
L Length error. The address is valid but the address field is not long enough to standardize.
M Multiple Addresses. The national database found two or more ranges for your address.
N No Data Available for City. Address data for this city is not in the database. If you are using a regional data file, check to see that the address is located in that region.
R Address Out of Range. The address is not within the delivery range.
S The default building address was verified, but the secondary address (suite, unite, apt, etc) is missing or invalid.
T Multiple Components. More than one component of your address is in error. Address components are the pre-direction, post-direction, and suffix.
U Unknown Street. No street could be found within the city that matches the street name given in the address field.
V Vacant. The address is not currently occupied.
W Early Warning System. This address has been identified in the Early Warning System (EWS) data file, and should be included in the next national database update.
X Nondelivery Address. The location given in the address field physically exists in the city but the Post Office has indicated that there are no houses there. This may occur when one side of the street has railroad tracks or a river along side it.
Z ZIP Code is invalid or does not match the city name.


Area Code Update Codes

Code Description
A The area code does not exist in the database or the area code, prefix, or suffix contains a character in the numeric pattern.
B The phone number is blank.
D This distance error indicates that the area code and ZIP locations are too far apart as specified on the Phone Check Options screen.
E The numerical phone number format is incorrect.
F The field length for the chosen phone number format is incorrect.
M This multiple match error indicates that there is a duplicate phone number.
P The prefix does not exist in the database.
Z The ZIP Code does not exist in the database.


Business Codes

Number of Employees Range

Code Description
A 1-4
B 5-9
C 10-19
D 20-49
E 50-99
F 100-249
G 250-499
H 500-999
I 1,000-4,999
J 5,000-9,999
K 10,000+


Annual Sales Volume Range

Code Description
A 1-499
B 500-999
C 1,000-2,499
D 2,500-4,999
E 5,000-9,999
F 10,000-19,999
G 20,000-49,999
H 50,000-99,999
I 100,000-499,999
J 500,000-999,999
K 1,000,000+E


Headquarters / Branch (Field Name: BusinessStatusCode)

Code Description
0 Single Location
1 Headquarters
2 Branch


Match Level Codes for Business Appends

Code Description
Level 1 This level is based on a tight match of address and company information.
Level 2 This level is based on a tight match of address information and a somewhat looser match of company name elements. This level will capture matches where there are minor variations or errors in the spelling of company name.
Level 3 This level is based upon a very tight company name match and a somewhat looser address match.
Level 4 This level is based on a tight match of address information, where the company information does not readily match. This level will catch companies doing business under differing names.
Level 5 This level is based on close matches of address and company information. In addition, some of these records have also been flagged as having secondary address errors such as missing or incorrect suite numbers. It may capture different companies at the same address.


Consumer Enhancement Codes

Income - Estimated Household

Code Description
1 Less than $15,000
2 $15,000 - $19,999
3 $20,000 - $29,999
4 $30,000 - $39,999
5 $40,000 - $49,999
6 $50,000 - $74,999
7 $75,000 - $99,999
8 $100,000 - $124,999
9 Greater than $124,999


Age in Two-Year Increments

Code Description
17 Age less than 18
18 Age 18 - 19
20 Age 20 - 21
22 Age 22 - 23
24 Age 24 - 25
26 Age 26 - 27
28 Age 28 - 29
30 Age 30 - 31
32 Age 32 - 33
34 Age 34 - 35
36 Age 36 - 37
38 Age 38 - 39
40 Age 40 - 41
42 Age 42 - 43
44 Age 44 - 45
46 Age 46 - 47
48 Age 48 - 49
50 Age 50 - 51
52 Age 52 - 53
54 Age 54 - 55
56 Age 56 - 57
58 Age 58 - 59
60 Age 60 - 61
62 Age 62 - 63
64 Age 64 - 65
66 Age 66 - 67
68 Age 68 - 69
70 Age 70 - 71
72 Age 72 - 73
74 Age 74 - 75
76 Age 76 - 77
78 Age 78 - 79
80 Age 80 - 81
82 Age 82 - 83
84 Age 84 - 85
86 Age 86 - 87
88 Age 88 - 89
90 Age 90 - 91
92 Age 92 - 93
94 Age 94 - 95
96 Age 96 - 97
98 Age 98 - 99
99 Age greater than 99


Gender - Input Individual

Code Description
M Male
F Female


Children's Age Ranges Present in Household

Code Description
Pos. 1 1 Males 00 - 02
Pos. 2 1 Females 00 - 02
Pos. 3 1 Unknown Gender 00 - 02
Pos. 4 1 Males 03 - 05
Pos. 5 1 Females 03 - 05
Pos. 6 1 Unknown Gender 03 - 05
Pos. 7 1 Males 06 - 10
Pos. 8 1 Females 06 - 10
Pos. 9 1 Unknown Gender 06 - 10
Pos. 10 1 Males 11 - 15
Pos. 11 1 Females 11 - 15
Pos. 12 1 Unknown Gender 11 - 15
Pos. 13 1 Males 16 - 17
Pos. 14 1 Females 16 - 17
Pos. 15 1 Unknown Gender 16 - 17


Number of Adults - 100%

Code Description
1 1 Adult
2 2 Adults
3 3 Adults
4 4 Adults
5 5 Adults
6 Greater than 5 Adults


Marital Status

Code Description
M Married
S Single
A Inferred Married
B Inferred Single


Home Owner / Renter

Code Description
O Home Owner
R Renter


Length of Residence

Code Description
00 Less than 1 Year
01 1 Year
02 2 Years
03 3 Years
04 4 years
05 5 Years
06 6 Years
07 7 Years
08 8 Years
09 9 Years
10 10 Years
11 11 Years
12 12 Years
13 13 Years
14 14 Years
15 Greater than 14 Years


Dwelling Type

Code Description
M Multiple Family Dwelling Unit
S Single Family Dwelling Unit


Credit Card

Code Description
Pos. 1 1 Bank Card Holder
Pos. 2 1 Gas/Department/Retail Card Holder
Pos. 3 1 Travel and Entertainment Card Holder
Pos. 4 1 Credit Card Holder - Unknown Type
Pos. 5 1 Premium Card Holder
Pos. 6 1 Upscale Card Holder


Delivery Drop (DEL_DROP)

Code Description
C Commercial Mail Box Company
N Delivery Point is not a Drop
Y Delivery Point is a Drop


Delivery Type (DEL_TYPE)

Code Description
A Mail delivery to Residential
I Mail delivery to Business
N Business Contract Box - A PO Box for a business customer who is located in a contract unit.


DSF Type (DSF_TYPE)

Code Description
F The matched record contains Firm data.
G The matched record contains General Delivery data.
H The matched record contains Highrise data.
P The matched record contains PO Box data.
R The matched record contains Rural Route or Contract Route data.
S The matched record contains Street data.


Name Parse Codes

Code Description
M Male
F Female
N Neutral (Pat, Chris etc.)
U Unknown


GeoCoding Error Codes

Code Description
Z Incomplete, incorrect, or missing ZIP+4 Code.
N No data available for the ZIP+4 Code


Mail Score (NCOA only)

Code Description
1 NCOA move found and supplied a new mailing address which also matches DPV.
2 This is a newly supplied address based off of Return Codes 91 and 92. The address is accurate enough to match DPV and supplied a new mailing address which also matches DPV.
3 Submitted record is not a move but was standardized.
4 Not currently coded in updated score system.
5 Not currently coded in updated score system.
6 Not currently coded in updated score system.
7 Serious problems prevent the address from matching Delivery Point Validation (DPV) and ZIP+4. Or Possible Canadian/Foreign Address, Record Not Processed and usually flagged with an ADDERR or a poor Return Code.


NCOALink Codes

Move Type Codes

Code Description
I Individual Moved, new address provided
F Family Moved, new address provided
B Firm Moved, new address provided
CRRT Carrier Route (used for mailing)
DPBC Delivery Point Barcode (use for mailing)


Return Codes

Code Description
A Matched record and a new address has been provided (NCOAlink 18Month Service code only). New move indicator is provided in Movetype field under B (business),I (individual), or F (family).
00 No Match (NCOAlink 18 month Service code only)
01 Found COA: Foreign Move - The input record matched to a business, individual or family type master file record but the new address was outside USPS delivery area.
02 Found COA: Moved Left No Address (MLNA) - The input record matched to a business, individual or family type master file record and the new address was not provided to USPS.
03 Found COA: Box Closed No Order (BCNO) - The Input record matched to a business, individual or family type master file record which contains an old address of PO BOX that has been closed without a forwarding address provided.
04 Cannot match COA: Street Address with Secondary - In the STANDARD mode utilizing Family matching logic the input record matched to a family record type on the master file with an old address that contained secondary information which obtained a ZIP+4 street level match. The input record does not contain secondary information. This address match situation requires individual name matching logic to obtain a match and individual names do not match.
05 Found COA: New 11-digit DPBC is Ambiguous - The input record matched to a business, individual or family type master file record. The new address on the master file record could not be converted to a deliverable address because the DPBC represents more than one delivery point.
06 Cannot Match COA: Conflicting Directions: Middle Name Related -There is more than one COA (individual or family type) record for the match algorithm and the middle names or initials on the COAs are different. Therefore, a single match result could not be determined.
07 Cannot Match COA: Conflicting Directions: Gender Related -There is more than one COA (individual or family type) record for the match algorithm and the genders of the names on the COAs are different. Therefore, a single match result could not be determined.
08 Cannot Match COA: Other Conflicting Instructions - The input record matched to two master file (business, individual or family type) records. The two records in the master file were compared and due to differences in the new addresses, a match could not be made.
09 Cannot Match COA: High-rise Default - The input record matched to a family record on the master file from a High- rise address ZIP+4 coded to the building default. This address match situation requires individual name matching logic to obtain a match and individual names do not match.
10 Cannot Match COA: Rural Default - The input record matched to a family record on the master file from a Rural Route or Highway Contract Route address ZIP+4 coded to the route default. This address situation requires individual name matching logic to obtain a match and individual names do not match.
11 Cannot Match COA: Individual Match: Insufficient COA Name for Match - There is a master file (individual or family type) record with the same surname and address but there is insufficient name information on the master file record to produce a match using individual matching logic.
12 Cannot Match COA: Middle Name Test Failed - The input record matched to an individual or family record on the master file with the same address and surname. However, a match cannot be made because the input name contains a conflict with the middle name or initials on the master file record.
13 Cannot Match COA: Gender Test Failed - The input record matched to a master file (individual or family type) record. A match cannot be made because the gender of the name on the input record conflicts with the gender of the name on the master file record.
14 Found COA: New Address Would Not Convert at Run Time - The input record matched to a master file (business, individual or family type) record. The new address could not be converted to a deliverable address.
15 Cannot Match COA: Individual Name Insufficient - There is a master file record with the same address and surname. A match cannot be made because the input record does not contain a first name or contains initials only.
16 Cannot Match COA: Secondary Number Discrepancy - The input record matched to a street level individual or family type record. However, a match is prohibited based on I of the following reasons: 1) There is conflicting secondary information on the input and master file record; 2) the input record contained secondary information and matched to a family record that does not contain secondary information. In item 2, this address match situation requires individual name matching logic to obtain a COA match and individual names do not match.
17 Cannot Match COA: Other Insufficient Name - The input record matched to an individual or family master file record. The input name is different or not sufficient enough to produce a match.
18 Cannot Match COA: General Delivery - The input record matched to a family record on the master file from a General Delivery address. This address situation requires individual name matching logic to obtain a match and individual names do not match.
19 Found COA: New Address not ZIP + 4 coded, New address primary number not DPV confirmable or Temporary Change Of Address - There is a change of address on file but the new address cannot be ZIP + 4 coded and therefore there is no 11-digit DPBC to store or return, the new address primary number cannot be confirmed on DPV or the new address is temporary.
20 Cannot Match COA: Conflicting Directions after re-chaining - Multiple master file records were potential matches for the input record. The master file records contained different new addresses and a single match result could not be determined.
66 Daily Delete - The input record matched to a business, individual or family type master file record with an old address that is present in the daily delete file. The presence of an address in the daily delete file means that a COA with this address is pending deletion from the master file and that no mail may be forwarded from this address.
91 Found COA : Secondary Number dropped from COA. The input record matched to a master file record. The master file record had a secondary number and the input address did not. A new address was provided.
92 Found COA : Secondary Number Dropped from input address. The input record matched to a master file record, but the input address had a secondary number and the master file record did not. The record is a ZIP + 4® street level match. A new address was provided.


Residential Phone Append Codes

Code Description
N This phone number is NOT on the FTC's Do-Not-Call List.
Y This phone number is on the FTC's Do-Not-Call List.


Canadian Change of Address (CCOA) Codes

AVC_CODE (Address Verification/Correction)

Code Description
Y Address Verified
N Address Not Verified
X Nixie (Return Code)


MAILSCORE

1 New Address Provided
Code Description
3 Standardized Address
7 Invalid address or Nixie


ADDERR (Address Errors)

These are the same codes as #Address Error Codes


RETURN_CD (AKA Nixie)

Code Description
N Resident Moved – no forwarding address
D Deceased


MOVETYPE

Code Description
F Family Move
I Individual Move
B Business Move