Data Exchange Version 2


IES RECOMMENDED FORMAT FOR DATA EXCHANGE - VERSION 2

FIELD NAME POSITION BYTES TYPE DESCRIPTION
Function Code 1 1 A Type of activity the record is being submitted for. Valid entries:
C=Change, D=Delete, I=Insert
NPA 2-4 3 N Three digit area code of the Calling Number.
Calling Number 5-11 7 N Seven digit telephone number of the Calling Number.
House Number 12-21 10 AN House Number. The field should contain a one if no house number is available.
House Number Suffix 22-25 4 AN House number extension (e.g./2). The field should be space-filled if no suffix applies.
Prefix Directional 26-27 2 A Leading street direction prefix. The field should be space-filled if no prefix applies. Valid entries:
N, S, E, W, NE, NW, SE, SW
Street Name 28-87 60 AN Valid service address of the Calling Number. (e.g. Main St)
Street Suffix 88-91 4 A Not used by IES.
Post Directional 92-93 2 A Trailing street direction suffix. The field should be space-filled if no suffix applies. Valid entries:
N, S, E, W, NE, NW, SE, SW
Community Name 94-125 32 A Valid service community of the street name/ house number as designated by the MSAG.
State 126-127 2 A Alpha state abbreviation (e.g. TX)
Location 128-187 60 AN Additional address information (free formatted) describing the exact location of the Calling Number (e.g. Apt 718).
Customer Name 188-219 32 AN Subscriber name associated with the Calling Number.
Class of Service 220 1 AN Value of:
1=Residence
2=Business
3=ResidencePBX
4=BusinessPBX
5=Centrex
6=Coin 1W out
7=Coin 2Way
8=Mobile
9=ResidenceOPX
0=BusinessOPX
Type of Service 221 1 N Value of:
0=Not FX nor Non-Pub
1=FX in 911 serving area
2=Fx outside 911 serving area
3=Non-Pub
4=Non-Pub FX in 911 serving area
5=Non-Pub FX outside 911 serving area
Exchange 222-225 4 AN Phone company exchange identifier for the serving telephone office of the customer.
ESN 226-230 5 AN Emergency Service Number associated with the House Number and Street Name.
Main NPA 231-233 3 N Three digit area code of the Main Number associated with the Calling Number.
Main Number 234-240 7 N Seven Digit telephone number of the Main Number associated with the Calling Number.
Order Number 241-250 10 AN Service order number for the activity establishing this record.
Extract Date 251-256 6 N Date on which the record was created in the format MMDDYY.
County ID 257-260 4 AN County Identification Code (usually the FIPS code).
Company ID 261-265 5 AN Telephone Company Identification code.
Source ID 266 1 AN Code which indicates whether data is part of the initial database creation process or part of the daily update process.
Daily=Space
Initial Load=C
Zip Code 267-271 5 AN Postal Zip Code
Zip +4 272-275 4 AN Postal Zip Code Extension.
General Use 276-286 11 AN This field will be mutually used by data exchange partners to pass information not defined in previous fields.
Customer Code 287-289 3 AN Code used to uniquely identify a customer.
Comments 290-319 30 AN Optional notes, may be displayed at PSAP.
X Coordinate 320-328 9 AN Longitude/ X coordinate
Y Coordinate 329-337 9 AN Latitude/ Y coordinate
Z Coordinate 338-342 5 AN Structure elevation
Cell ID 343-348 6 AN Identification number indicating a geographic region of cellular coverage.
Sector ID 349 1 AN Sub set/ section of a cell.
TAR Code 350-355 6 AN Taxing Area Rate Code
Error Code  356-511 156 AN This field is reserved for the number of the error code & its explanation.
End of Record 512 1 AN Always an asterisk (*).
Site created by Vivid Image, Inc.
>