Business Telephone Verify Output Layout & Data Definitions

Printable PDF version >>

Below is the output layout and data definitions for Business Telephone Verify. These fields are typically appended to the right of your original data. On request, we can alternatively update your existing fields.

Field: name of the field. Type: field type; Chr = character or alphanumeric, Num = numeric. Width: field width. Dec: number of decimal points. From: field starting point. To: field ending point. Description: data definition of the field contents.

Field Type Width Dec From To Description
PEACOCK_ID Chr 10   1 10 Unique ID number assigned to each record - used for support
TEL_FLAG Chr 1   11 11 Telephone Match Flag (key):
V = Telephone number verified
N = Not verified, valid input number
I = Not verified, invalid input number
Blank = Not matched
ACUC_FLAG Chr 1   12 12 Area Code Update & Correction Flag (key):
C = Area Code corrected
U = Area Code updated
ACUC_DATE Chr 8   13 20 Effective date of the Area Code update (YYYYMMDD)
TEL_PHONE Chr 10   21 30 10-digit full telephone number
TEL_AREACD Chr 3   31 33 3-digit Area Code
TEL_PREFIX Chr 3   34 36 3-digit local area or exchange prefix
TEL_NUMBER Chr 4   37 40 4-digit line number
TEL_LOCAL1 Chr 7   41 47 7-digit local telephone number
TEL_LOCAL2 Chr 8   48 55 7-digit local telephone number hyphenated (###-####)
TEL_FORM1 Chr 12   56 67 Telephone number format #1 (###-###-####)
TEL_FORM2 Chr 14   68 81 Telephone number format #2 ((###) ###-####)
TEL_FORM3 Chr 12   82 93 Telephone number format #3 (###/###-####)

NOTICE: Layouts and content are subject to change—we are always working to improve our services.