Testimonials!

Landline Phone Append Return File Layout

Phone return data format will match the format of the data you uploaded for processing, appended with the Phone fields. For example, if you upload a XLS file, your return data will be XLS; if you upload a tab-delimited format, your return data will be tab-delimited.


NCOA Logo

NCOA source

National Phone Lookup Return File Layout


Landline Phone Append Standard Return Layout v6.1

Simple, straight-forward, easy-to-use

  • Return format equals input format (e.g. if input format = CSV, then Return format = CSV; if Input Format = XLS, then Return Format = XLS)
  • Return data includes Column Names for simple data integration
  • Each return record begins with the original client data, followed by appended phone columns, as shown below:

    LENGTH DESCRIPTION
CLIENT'S  ORIGINAL  INPUT DATA
       
       
CLIENT'S  ORIGINAL  INPUT DATA
       
       
CLIENT'S  ORIGINAL  INPUT DATA
       
       
CLIENT'S  ORIGINAL  INPUT DATA
    1

PHONE_MATCH_FLAG  

Y = Phone number match
 N = no match
    10

TELEPHONE  

10-char Phone Number
    3 TIMEZONE
(EST, CST, MST, PST, AST, HST, unknown)
    1 MATCH LEVEL

1-3 Best Matches -
Phone numbers assigned to these names are very likely to agree:


1 = Match exactly on (State / PFN / Last 4 digits of House Number / Phonetic Street / Phonetic Surname). Given names match (allowing initials and nicknames).

2 = Match exactly on (State / PFN / Last 4 digits of House Number / Phonetic Street / Phonetic Surname).

3 = Match exactly on (State / PFN / Phonetic Street / Phonetic Surname). 
Surnames match exactly. First six characters of street name match exactly. Given names match (allowing initials and nicknames).


4-5 Good Matches -
Recommend Testing:


4 = Match exactly on (State / PFN / Phonetic Surname). Surnames match exactly. Given names match (initials are not allowed).

5 = Match exactly on (State / PFN / Phonetic Street / Phonetic Surname). Surnames match exactly. First six characters of street name match exactly.


6-7 Weak Matches -
If it is important that you have the correct name do not call these numbers:


6 = Match exactly on (State / PFN / Phonetic Surname). Surnames match exactly. Surnames match exactly. Given names match (allowing initials and nicknames).

7 = Match exactly on (State / PFN / Phonetic Surname). Surnames match exactly.


9 = Non-match


    1 PHONE_STATUS
Telephone Listing Status

C = Current

R = Retained*

V = Disconnect**
    1 PHONE_NUMBER_TYPE

2 = Alternate
3 = Add'l Number to be Dialed Outside Local Area
4 = After-Hours
9 = Emergency
B = Business Voice Line
C = Car, Cellular, or Mobile
D = TDD Device for the Deaf
F = Fax Line
H = Work-at-Home Voice Line
I = Toll Free Voice Line
M = Modem Line
P = Pager
O = Teletypewriter or Other Data Line
T = Teen Line, Teen/Children's Phone
U = Unknown Telephone Line
V = Consumer Voice Line
W = Converted to Wireless

    1 SUPPRESS_CODE

A - State Attorney General - Restricted

B - Business Phone

T - TPS - DM Phone Preference

P - Phone Directory Flag

* Retained means that we have not been able to re-verify this number during the last 12-18 months. May be ineffective for direct marketing.

** Disconnected numbers will be ineffective for direct marketing but may have significant value in other capacities.

Both Retained and Disconnect numbers are kept on the Phone Enhancement services because they provide value to the client in identifying that we did at one point have that number associated with that person and it is possible it still is associated to that person.

Questions...Feel free to ask us!

Copyright NCOAsource All rights reserved