Telephone Formatting Output Layout & Data Definitions

Printable PDF version >>

Below is a sample layout for Telephone Formatting. Because this service is customized for individual needs, consider this a guideline for the output information.

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_PHONE Chr 10   11 20 10-digit full telephone number
TEL_AREACD Chr 3   21 23 3-digit Area Code
TEL_PREFIX Chr 3   24 26 3-digit local area or exchange prefix
TEL_NUMBER Chr 4   27 30 4-digit line number
TEL_LOCAL1 Chr 7   31 37 7-digit local telephone number
TEL_LOCAL2 Chr 8   38 45 7-digit local telephone number hyphenated (###-####)
TEL_FORM1 Chr 12   46 57 Telephone number format #1 (###-###-####)
TEL_FORM2 Chr 14   58 71 Telephone number format #2 ((###) ###-####)
TEL_FORM3 Chr 12   72 83 Telephone number format #3 (###/###-####)

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