Residential Telephone Append Output Layout & Data Definitions
Below is the output layout and data definitions for Residential Telephone Append. 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):
A = Telephone number appended
Blank = Not matched |
|
| TEL_CONF | Chr | 1 | 12 | 12 |
Telephone Match Confidence (key):
1 = Highest confidence
2 3 4 = Lowest confidence |
|
| TEL_PHONE | Chr | 10 | 13 | 22 | 10-digit full telephone number | |
| TEL_AREACD | Chr | 3 | 23 | 25 | 3-digit Area Code | |
| TEL_PREFIX | Chr | 3 | 26 | 28 | 3-digit local area or exchange prefix | |
| TEL_NUMBER | Chr | 4 | 29 | 32 | 4-digit line number | |
| TEL_LOCAL1 | Chr | 7 | 33 | 39 | 7-digit local telephone number | |
| TEL_LOCAL2 | Chr | 8 | 40 | 47 | 7-digit local telephone number hyphenated (###-####) | |
| TEL_FORM1 | Chr | 12 | 48 | 59 | Telephone number format #1 (###-###-####) | |
| TEL_FORM2 | Chr | 14 | 60 | 73 | Telephone number format #2 ((###) ###-####) | |
| TEL_FORM3 | Chr | 12 | 74 | 85 | Telephone number format #3 (###/###-####) | |
| TEL_TIMEZN | Chr | 1 | 86 | 86 |
Time Zone (key):
E = Eastern
C = Central M = Mountain P = Pacific A = Alaska H = Hawaii |
|
| TEL_DAYSAV | Chr | 1 | 87 | 87 | D = Daylight Savings | |
| DNC_FLAG | Chr | 1 | 88 | 88 | D = DMA do-not-call match |
NOTICE: Layouts and content are subject to change—we are always working to improve our services.