Business Telephone Append Output Layout & Data Definitions
Below is the output layout and data definitions for Business 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_PHONE | Chr | 10 | 12 | 21 | 10-digit full telephone number | |
| TEL_AREACD | Chr | 3 | 22 | 24 | 3-digit Area Code | |
| TEL_PREFIX | Chr | 3 | 25 | 27 | 3-digit local area or exchange prefix | |
| TEL_NUMBER | Chr | 4 | 28 | 31 | 4-digit line number | |
| TEL_LOCAL1 | Chr | 7 | 32 | 38 | 7-digit local telephone number | |
| TEL_LOCAL2 | Chr | 8 | 39 | 46 | 7-digit local telephone number hyphenated (###-####) | |
| TEL_FORM1 | Chr | 12 | 47 | 58 | Telephone number format #1 (###-###-####) | |
| TEL_FORM2 | Chr | 14 | 59 | 72 | Telephone number format #2 ((###) ###-####) | |
| TEL_FORM3 | Chr | 12 | 73 | 84 | Telephone number format #3 (###/###-####) |
NOTICE: Layouts and content are subject to change—we are always working to improve our services.