Business Telephone Append & Verify Output Layout & Data Definitions

Printable PDF version >>

Below is the output layout and data definitions for Business Telephone Append & 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):
U = Telephone number updated
A = Telephone number appended
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.