|
|
ListWare® Error and Information Codes
Address Error Codes
Code
| Definition
|
| C | Canadian ZIP Code.
| 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 address failed DPV checking. There is no mail receptacle at this
location. | | 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. For more information,
see page 40.
| | 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
| Definition
| 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 |
Definition
| A
| 1000+
| B
| 500-999
|
D
|
50-99
|
E
|
20-49
| F
| 10-19 |
G
|
5-9
|
H
|
1-4
|
| J | 100-249
| | K | 250-499
|
Z
| NOT AVAILABLE |
|
Annual Sales Volume Range
|
| Code |
Definition
| A
| 1,000,000,000+
| B
| 500,000,000 -
999,999,999
|
C
|
100,000,000 - 499,999,999
|
| D |
10,000,000 - 99,999,999
| E
|
5,000,000 - 9,999,999
| F
| 2,500,000 - 4,999,999 |
G
|
1,000,000 - 2,499,999
|
H
|
500,000 - 999,999
| |
I | Under 500,000
|
Z
| NOT AVAILABLE |
|
Headquarters / Branch (Field Name: BusinessStatusCode)
|
| Code |
Definition
| 0
|
Single Location |
1
|
Headquarters
|
2
|
Branch |
Consumer Enhancement Codes
| Head
of Household Age Code (HOH_AGE) |
18 = Person's age is 18 to 19
20 = Person's age is 20 to 21
22 = Person's age is 22 to 23
24 = Person's age is 24 to 25
26 = Person's age is 26 to 27
28 = Person's age is 28 to 29
30 = Person's age is 30 to 31
32 = Person's age is 32 to 33
34 = Person's age is 34 to 35
36 = Person' s age is 36 to 37
38 = Person's age is 38 to 39
40 = Person's age is 40 to 41
42 = Person's age is 42 to 43
44 = Person's age is 44 to 45
46 = Person's age is 46 to 47
48 = Person's age is 48 to 49
50 = Person's age is 50 to 51
52 = Person's age is 52 to 53
54 = Person's age is 54 to 55
56 = Person's age is 56 to 57
58 = Person's age is 58 to 59
60 = Person's age is 60 to 61
62 = Person's age is 62 to 63
64 = Person's age is 64 to 65
66 = Person's age is 66 to 67
68 = Person's age is 68 to 69
70 = Person's age is 70 to 71
72 = Person's age is 72 to 73
74 = Person's age is 74 to 75
76 = Person's age is 76 to 77
78 = Person's age is 78 to 79
80 = Person's age is 80 to 81
82 = Person's age is 82 to 83
84 = Person's age is 84 to 85
86 = Person's age is 86 to 87
88 = Person's age is 88 to 89
90 = Person's age is 90 to 91
92 = Person's age is 92 to 93
94 = Person's age is 94 to 95
96 = Person's age is 96 to 97
98 = Person's age is 98 to 99
99 = Person's age is greater than 99
|
Selected
Household Member Age (in Years) (Name_Age)
The age of the person named in the record.
18 = Person's age is 18 to 19
20 = Person's age is 20 to 21
22 = Person's age is 22 to 23
24 = Person's age is 24 to 25
26 = Person's age is 26 to 27
28 = Person's age is 28 to 29
30 = Person's age is 30 to 31
32 = Person's age is 32 to 33
34 = Person's age is 34 to 35
36 = Person's age is 36 to 37
38 = Person's age is 38 to 39
40 = Person's age is 40 to 41
42 = Person's age is 42 to 43
44 = Person's age is 44 to 45
46 = Person's age is 46 to 47
48 = Person's age is 48 to 49
50 = Person's age is 50 to 51
52 = Person's age is 52 to 53
54 = Person's age is 54 to 55
56 = Person's age is 56 to 57
58 = Person's age is 58 to 59
60 = Person's age is 60 to 61
62 = Person's age is 62 to 63
64 = Person's age is 64 to 65
66 = Person's age is 66 to 67
68 = Person's age is 68 to 69
70 = Person's age is 70 to 71
72 = Person's age is 72 to 73
74 = Person's age is 74 to 75
76 = Person's age is 76 to 77
78 = Person's age is 78 to 79
80 = Person's age is 80 to 81
82 = Person's age is 82 to 83
84 = Person's age is 84 to 85
86 = Person's age is 86 to 87
88 = Person's age is 88 to 89
90 = Person's age is 90 to 91
92 = Person's age is 92 to 93
94 = Person's age is 94 to 95
96 = Person's age is 96 to 97
98 = Person's age is 98 to 99
99 = Person's age is greater than 99 | Household
Member Section Count (PERS_IN_HH)
Number of persons in household
1 = One person
2 = Two persons
3 = Three persons
4 = Four persons
5 = Five persons
6 = Six persons
7 = Seven persons
8 = Eight persons
9 = Nine or more persons
|
Number
Of Named (No_Adults)
Number of adults (18 or older) in household
1 = One adult
2 = Two adults
3 = Three adults
4 = Four adults
5 = Five adults
6 = Six adults
7 = Seven adults
8 = Eight adults
9 = Nine or more adults
|
Number
Of Children (Pres_Child)
Presence of children unknown gender 0-17
1 = Unknown gender, 0-17 yrs. present
2 = Unknown gender, 0- 17 yrs. inferred
|
Length
Of Residence In Years (Len_Res)
The actual number of years the person has resided at this address
(0-43).
A = 00 - 06 Months
B = 07 - 12 Months
C = 13 - 18 Months
D = 19 - 24 Months
E = In the 3rd Year
F = In the 4th Year
G = In the 5th Year
H =-In the 6th Year
I = In the 7th Year
J = In the 8th Year
K = In the 9th Year
L = In the 10th Year
M = In the 11th Year
N = In the 12th Year
O = In the 13th Year
P = In the 14th Year
Q = In the 15th Year
R = In the 16th Year
S = In the 17th Year
T = In the 18th Year
U = In the 19th Year
V = 20 or more Years
|
LIKELIHOOD HOME IS OWNED OR RENTED (OWN_RENT)
1: Definite Renter
2: Probable Renter
3: Probable Owner (any type dwelling unit)
4: Definite Owner (any type dwelling unit) |
Household Member 1 Marital Status Code (Mari_Stat)
1 = Household contains at least one Married person
2 = Household contains at least one Single person
3 = Household contains both Married & Single persons
|
Family Income Detector Code (Income)
1 = Income under $15,000
2 = Income of $15,000 to $19,999
3 = Income of $20,000 to $29,999
4 = Income of $30,000 to $39,999
5 = Income of $40,000 to $49,999
6 = Income of $50,000 to $74,999
7 = Income of $75,000 to $99,999
8 = Income of $100,000 to $124,999
9 = Income of $125,000 to $149,999
A = Income of $150,000 and over
| |
INCOME MODEL INDICATOR (INCOME_IND)
I = The Income Code is Inferred from a Model
S = The Income Code is specific (Self-Reported)
|
Bank Card (Mastercard Or Visa) Holder (Bankcard)
N: No
Y: Yes
|
BANK CARD (ADDRESS LOCATION TYPE) (DWELL_TYPE)
Type of dwelling
1 = House Number & Street Name Present
2 = Rural/Highway Contract; Rte No. with Box #
3 = Box Number only
4 = Rural/Highway Contract; Rte No. without Box #
5 = Street name only present
6 = General Delivery/No Address Line
7 = Special Delivery Point Matchcode for Address Only
|
FINANCIAL DATA (FIN_DATA)
Miscellaneous Credit Card (Y=yes) (MISC_CC)
Standard Retail Card (Y=yes) (SR_CC)
Standard Specialty Card (Y=yes) (SS_CC)
Upscale Retail Card (Y=yes) (UR_CC)
Upscale Specialty Retail Card (Y=yes) (US_CC)
Bank Card (Y=yes) (BANKCARD)
Oil-Gas Card (Y=yes) (OG_CC)
Finance Company Card (Y=yes) (FC_CC)
Travel/Entertainment Card (Y=yes) (TE_CC)
|
Delivery Drop (DEL_DROP)
Code
| Definition
| C
| Commercial Mail Box Company
| N
| Delivery Point is not a Drop
| Y
| Delivery Point is a Drop
|
Delivery Type (DEL_TYPE)
Code
| Definition
| 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
| Definition
| 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.
|
Match Level Codes for D&B Appends
| 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. |
Name Parse Codes
| Code |
Gender |
| M |
Male |
| F |
Female |
| N |
Neutral (Pat, Chris etc.) |
| U |
Unknown |
GeoCoding Error Codes
| Code |
Definition |
| Z |
Incomplete, incorrect, or missing
ZIP+4 Code. |
| N |
No data available for the ZIP+4 Code |
Mail Score
Code
| Definition
|
1 |
The address is accurate as it matches Delivery Point Validation (DPV).
This applies primarily to Address Correction services but NCOA updated
addresses also match the DPV file. |
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. The address is seasonal and it matches
the Delivery Sequence File (DSF). This only applies to Address
Correction services. |
3 |
The address is accurate enough to match the ZIP+4 file. |
4 |
Not currently coded
in updated score system. |
5 |
The primary address has errors that prevent it from matching the Delivery Sequence File (DSF) and ZIP+4. |
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 and ADDERR or a poor Return Code. |
NCOALink Codes
|
Move Type Codes
| | Code
| Definition
| I
|
Individual Moved, new address provided |
F
| Family
Moved, new address provided
| B
| Firm
Moved, new address provided
|
|
Return Codes
|
| Code |
Definition
| |
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 -
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.
|
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
| Definition
| |
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. |
|
|
|
|
