Premium Residential Telephone Append & Verify Output Layout & Data Definitions

Printable PDF version >>

Below is the output layout and data definitions for Premium Residential 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
TEL_CONF Chr 1   12 12 Telephone Match Confidence (key):
1 = Highest confidence
2
3
4 = Lowest confidence
ACUC_FLAG Chr 1   13 13 Area Code Update & Correction Flag (key):
C = Area Code corrected
U = Area Code updated
ACUC_DATE Chr 8   14 21 Effective date of the Area Code update (YYYYMMDD)
TEL_PHONE Chr 10   22 31 10-digit full telephone number
TEL_AREACD Chr 3   32 34 3-digit Area Code
TEL_PREFIX Chr 3   35 37 3-digit local area or exchange prefix
TEL_NUMBER Chr 4   38 41 4-digit line number
TEL_LOCAL1 Chr 7   42 48 7-digit local telephone number
TEL_LOCAL2 Chr 8   49 56 7-digit local telephone number hyphenated (###-####)
TEL_FORM1 Chr 12   57 68 Telephone number format #1 (###-###-####)
TEL_FORM2 Chr 14   69 82 Telephone number format #2 ((###) ###-####)
TEL_FORM3 Chr 12   83 94 Telephone number format #3 (###/###-####)
TEL_TIMEZN Chr 1   95 95 Time Zone (key):
E = Eastern
C = Central
M = Mountain
P = Pacific
A = Alaska
H = Hawaii
TEL_DAYSAV Chr 1   96 96 D = Daylight Savings
DNC_FLAG Chr 1   97 97 D = DMA do-not-call match

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