VERIZON
REGIONAL E 9-1-1 Electronic Interface Guide
Issue Date January, 2014
IMPORTANT: Please contact the Verizon E911 System Administration group at => for further guidance and direction due to the migration to a new ALI system that is underway.
Welcome to VERIZON’S E 9-1-1 Electronic Interface USER GUIDE!
Competitive Local Exchange Carriers (CLECs), Independent Telephone Companies, and Wireless Carriers (jointly described as ”Carriers use the Verizon E 9-1-1 Electronic Interface to access the Verizon E 9-1-1 database depending on the geographic area in which the Carrier is doing business with Verizon.
The 9-1-1 Information Manager Web portal is being migrated to a new web portal called Intrado Unified Portal. It has similar functionality with new security access method. States are being migrated on a staggered basis and the project should complete by end of year 2015. As of January 2014, the states of California and Florida have already migrated to this new platform.
As used within this document, the term “Verizon East” refers to the following states:
Delaware, District of Columbia, Maryland, Massachusetts, New Jersey, New York, Pennsylvania, and Virginia;
and “Verizon West” refers to the following states:
California, Florida, and Texas
Please contact Verizon E 9-1-1 System Administration below with any questions regarding the appropriate Verizon Electronic Interface at either the telephone numbers shown below or via email at .
Contact Name / Telephone Number / Business CellDonna Beecher / 914-801-3717 / 914-417-5874
Joyce Juliano-Pais / 732-221-7863
Linda Kerkam / 914-801-3740
Julie Leahy / 617-535-5551 / 617-835-3270
Betty Scala / 617-535-5495
National 911 Support / 800-872-3356
:
TABLE OF CONTENTS
1.0 INTRODUCTION 5
1.1 E9-1-1 ELECTRONIC INTERFACE 5
2.0 GETTING STARTED 5
3.0 USER ID/ACCESS REQUEST FORM 6
4.0 ACCESSING VERIZON’S 9-1-1 INFORMATION MANAGER 7
4.1 LOGGING IN TO VERIZON’S 9-1-1 INFORMATION MANAGER 8
4.2 FILE NAMES 8
5.0 MODIFIED NENA 2.1 FORMAT FOR DATA EXCHANGE 9
5.1 DISABILITY INFORMATION – NEW ENGLAND DATABASE 10
6.0 NENA 2.1 DATA RECORD SPECIFICATIONS 11
7.0 PS/ALI DATABASE MANAGEMENT SOFTWARE - DISCONTINUED 16
8.0 VERIZON E9-1-1 CONTACT TELEPHONE NUMBERS 17
9.0 SERVICE ORDER PROCESSING ERROR CODE MESSAGES 19
10.0 AUTOMATIC ERROR CORRECTION FEATURE 25
11.0 LNP 26
11.1 OVERVIEW 26
11.2 AUTOMATIC ERROR CORRECTION FEATURE FOR LOCAL NUMBER PORTABIILTY 27
11.3 AUTOMATIC ERROR CORRECTION SAMPLE FILES 28
11.4 CHANGES TO SERVICE ORDER PROCESSING IN AN LNP ENVIRONMENT 29
11.5 763 AUTO-REPROCESS FUNCTIONALITY 30
11.6 LNP UNLOCK REPORT 31
12.0 VERIZON’S ELECTRONIC INTERFACE SAMPLE FILES 32
12.1 ATTACHMENT 1 33
12.2 VERIFYING THAT FILE PROCESSED SUCCESSFULLY 34
12.3 ATTACHMENT 2 35
12.4 ATTACHMENT 3A & 3B 36
12.5 ATTACHMENT 4 38
12.6 ATTACHMENT 5A &5B 39
12.7 ATTACHMENT 6 41
12.8 ATTACHMENT 7 42
12.9 ATTACHMENT 8 43
TABLE OF CONTENTS
13.0 NEW YORK STREET THOROUGHFARES – VALID ABBREVIATIONS 44
14.0 NEW ENGLAND STREET THOROUGHFARES – VALID ABBREVIATIONS 45
15.0 PA AND DELAWARE STREET SUFFIX THOROUGHFARES – VALID ABBREVIATIONS 46
16.0 NEW ENGLAND STREET ADDRESS GUIDELINES 47
17.0 NEW YORK STREET ADDRESS GUIDELINES 48
18.0 PENNSYLVANIA AND DELAWARE ADDRESS GUIDELINES 49
19.0 PENNSYLVANIA AND DELAWARE – CONDITIONAL POSTING 50
20.0 COUNTY CODES FOR NEW YORK 51
21.0 TAR CODE LISTINGS FOR PENNSYLVANIA AND DELAWARE 53
22.0 WASHINGTON DC TAR CODE LISTING 54
23.0 VIRGINIA TAR CODE LISTING 55
24.0 MARYLAND TAR CODE LISTING 64
25.0 NEW JERSEY E9-1-1 REQUIREMENTS 65
26.1 NEW JERSEY MSAG QUARTERLY EXTRACTS 106
26.2 OUTPUT FILE FORMAT FOR NEW JERSEY MSAGS 107
26.3 NEW JERSEY COUNTY ABBREVIATION CODES 110
26.0 GLOSSARY OF ACRONYMS 111
1.0 Introduction
1.1 E 9-1-1 Electronic Interface:
Within the Verizon footprint, there are two unique Electronic Interfaces that are utilized depending on the geographic area in which the Carrier operates. The guide contains general information for both Verizon East and Verizon West and for the State of New Jersey. Descriptions on how to access each of the individual interfaces are described in the following User Guides:
Verizon East and West: 911 IM USER GUIDE
New Jersey: SYSTEM-9 ONLINE INTERFACE
2.0 Getting Started
· Before contacting E 9-1-1 System Administration, contact must be made with a Verizon Account Representative in order to establish a business relationship with Verizon.
· Read through this entire Guide before contacting System Administration.
· Each local service provider must register with the National Emergency Number Association (NENA) to establish a company identifier. The telephone number to call to obtain a (NENA) company ID is 1-800-332-3911 or 202-466-4911.
· You can register on-line at http://www.nena.org/?page=CID2014· Obtain Internet Explorer and an internet connection as this is how you will access the Verizon E9-1-1 Systems.
· Obtain a copy of the appropriate User Guide from E9-1-1 System Administration.
· The E 9-1-1 records that a carrier transmits to Verizon need to be entered in a database by using software such as Microsoft Access. Microsoft EXCEL is not acceptable because the data that is transmitted is not formatted properly.
· Verizon uses modified NENA 2 data requirements for file transfer. There are mandatory field requirements as shown in the NENA 2 Section of this Guide.
· In order to obtain access to the Verizon E911 Electronic Interface to transmit, update and maintain your customer records in the Verizon E911 Database, please have your Verizon Account Manager contact the Verizon E911 System Administration Group by completing the form below and forwarding as indicated. An electronic version of the login form is available by contacting
· In Verizon East (states MA, NY, NJ, PA, DE, MD, DC, VA, the account manager will forward the customer’s completed 9-1-1 Information Manager Login Request form (see below) to: .
· In Verizon West (states CA, FL,TX) the account manager will forward the customer’s completed 9-1-1 Information Manager Login Request form (see below) to (via internal Notes): dbmc-ca-fl-request.
Once the Verizon Account Manager has contacted the Verizon E911 System Administration Group, a member of that group will contact the customer to work with you on this matter.
· Notify Verizon E 9-1-1 System Administration (Verizon West – Database Management Center) when NENA/Company ID is obtained.
3.0 USER ID/Access Request Form
Verizon 9-1-1 Information Manager
Login Request Form
Note: An electronic version of this form will be provided when you are ready to convert.
4.0 Accessing Verizon’s 9-1-1 Information Manager
SYSTEM REQUIREMENTS
The following list identifies general requirements for 9-1-1 Information Manager:
· Users access the server over a secured network.
· The software is designed for use with Internet Explorer version 6.0 or higher. Compatibility with other browsers is not guaranteed.
· The software is designed for use with Windows® 2000 Professional and Windows XP and Windows 7. Compatibility with other operating systems is not guaranteed.
SECURITY
Overall Security Requirements
· All users must have a digital certificate as well as a login and password to access the system. The Verizon E9-1-1 System Administration group will submit the request for the digital certificate on behalf of the user to the Verizon Wholesale Access Gateway (WAG) group. It will take at least 24 hours for the digital certificate request to be processed.
· All user instructions regarding digital certificates can be obtained by contacting the Verizon E911 System Administration Group via email at .
· These instructions are also available on the Verizon Wholesale E911 Website: http://www22.verizon.com/wholesale/local/E911/enhanced-9-1-1.html
· Users must change their passwords the first time they log in, and can then change it at any time thereafter.
· System functionality and information retrieval is determined by the user’s profile.
.
4.1 Accessing Verizon’s 9-1-1 Information Manager
When a carrier is ready to access the system for the first time, it should contact the E 9-1-1 System Administration Team. Verizon will provide detailed instructions required to access the system. Verizon will also provide the appropriate URL and an initial user name and password. All 9-1-1 Information Manager functionality is detailed in the 9-1-1 Information Manager User Guide
4.2 File Names
Update files must be sent using the naming convention below:
Filename= xxxxyyyz.dat· Verizon E 9-1-1 System Administration provides the first four digits of your filename ‘xxxx’ to the Carrier. It is unique for your company alone.
· The ‘yyy’ of the filename is the three digit Julian calendar day that indicates the
· Actual calendar day that the file was actually transmitted.
· The ‘z’ of the filename is a sequence number.
· The sequence number can be a digit 0 to 9 as the Carrier may send up to 10 files to Verizon on a daily basis.
· The “.dat” extension signifies that a data file is being transmitted to Verizon. This transmission is required or else the file will not process. The “.dat” extension is required, otherwise the file will not process.
5.0 Modified NENA 2.1 Format for Data Exchange
This Section displays the unique differences that exist in several of the East states within Verizon that must be recognized when inputting data into the E 9-1-1 database. NENA Version 2.1 Format for Data Exchange is displayed in Section 6 of this document.
FIELD NAME / POS / BYTES / IMPORTANT INFO TO REVIEWHOUSE NUMBER SUFFIX / 22-25 / 4 / NOTE: IN THE MID-ATLANTIC STATES
(PA, DE, VA, DC, MD) THE 1ST CHARACTER OF THIS FIELD MUST CONTAIN A HYPHEN (FOR EX: -1/2 OR –A
* STREET NAME / 28-87 / 60 / Verizon READS 48 BYTES FOR STREET NAME.
STREET SUFFIX / 88-91 / 4 / NEED TO DISCUSS
NEED TO COMPLY WITH STATE REQUIREMENTS
FIELD NAME POS BYTES IMPORTANT NOTES TO DISCUSS
LOCATION 128-187 60
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
NOTE 1: THE LOCATION FIELD IN THE NEW ENGLAND & NEW YORK DATABASE IS LISTED AS THE TELCO FIELD. IT IS 30 BYTES IN LENGTH AND IS FOUND IN POSITIONS 128-157. THIS IS WHERE LOCATION INFORMATION SUCH AS APARTMENT, FLOOR AND BUILDING SHOULD BE ENTERED.
NOTE 2: THE LOCATION FIELD IN THE PENNSYLVANIA AND DELAWARE DATABASES IS LISTED AS THE ADDRESS EXTENSION FIELD.
NOTE 3: THE LOCATION FIELD IN THE GATEWAY DATABASE (VIRGINIA, MARYLAND AND DC) IS LISTED AS LOCATION/DRIVING INSTRUCTIONS.
* See Sections 13- 18 for Valid Street Thoroughfares for NY, NE, PA and DE, all others use valid Postal abbreviations.
TAR / 350-355 / 6 / Populate this field with the applicable TAR Code inNew York, Virginia, Maryland, Pennsylvania, Delaware, Maryland and Washington DC. All other states should space fill
5.1 Disability Information New England Database
In New England disability information is populated in the ‘location’ field using the following specific ‘disability indicators’.
DISABILITY INDICATORS / USED FOR:LSS / LIFE SUPPORT SYSTEM
MI / MOBILITY IMPAIRED
B / BLIND
DHH / DEAF & HARD OF HEARING
TTY / TELETYPWRITER
SI / SPEECH IMPAIRED
DD / DEVELOPMENTALLY DISABLED
NOTE: In New York, there are no specific procedures or indicators used to reference disability information in the database. Handicapped information may be entered within the “location” field as a ‘free floating’ remark and is entered at the discretion of the telephone company provider.
NENA 2.1 Data Record Specifications
The following section contains the Data Record, Header Record, and Trailer Record specifications based on the National Emergency Number Association (NENA) recommended format for data exchange - Version 2. This version can also be found on the Internet at http://www.nena.org/9-1-1TechStandards/nena_recommended_standards.htm.
Field Name / Positions / Bytes / Type / Req’d / Description /Function Code / 1 / 1 / A / R / The type of activity the record is being submitted for. Valid entries are:
C = Change, D= Delete, I = Insert
U= Unlock, M=Migrate
NPA / 2 - 4 / 3 / N / R / The three-digit area code of the Calling/Working Number.
Calling Number / 5 - 11 / 7 / N / R / The seven-digit telephone number of the Calling/Working Number.
House Number / 12 - 21 / 10 / AN / R/SF / The house number. This field should be spaced filled if no house number is available.
House Suffix Number / 22 - 25 / 4 / AN / R/SF / ***NEED TO DISCUSS WITH VERIZON***
The house number extension. (e.g. 1/2) This field should be space filled if no suffix applies.
Prefix Directional / 26 - 27 / 2 / A / R/SF / The leading street direction prefix. Valid entries are: N, S, E, W, NE, NW, SE, and SW. This field should be space filled if no prefix applies.
Street Name / 28 - 87 / 60 / AN / R / ***NEED TO DISCUSS WITH VERIZON***
The service address of the Calling Number.
Street Suffix / 88 - 91 / 4 / A / R/SF / ***NEED TO DISCUSS***
The street abbreviation, as defined by the U. S. Postal Service Publication 28. (e.g. AVE) This field should be space filled if no suffix applies.
Post Directional / 92 - 93 / 2 / A / R/SF / The trailing street direction suffix. Valid entries are: N, S, E, W, NE, NW, SE, and SW. This field should be space filled if no suffix applies.
Community Name / 94 - 125 / 32 / A / R / The service community name of the street / house number as assigned by
the Municipal Street Address Guide.
State / 126 - 127 / 2 / A / R / The alphabetic state abbreviation as defined by the U. S. Postal Service. (e.g. PA)
Location / 128 - 187 / 60 / AN / R/SF / The additional address information describing the exact location of the Calling Number. (e.g. SUITE 2002, APT 706A) This field should be space filled if no location applies. See Notes for additional information on the use this field.
Customer Name / 188 - 219 / 32 / AN / R / The subscriber name associated with the Calling Number.
Class of Service / 220 / 1 / AN / R / Valid entries are:
1 = Residence
2 = Business
3 = Residence Private Branch Exchange (PBX)
4 = Business PBX
5 = CENTREX
6 = Coin 1 way out
7 = Coin 2 way
8 = Mobile
9 = Residence Off Premise Extension (OPX)
0 = Business OPX
A= Customer Owned Coin Telephone
G= Wireless Phase 1
H= Wireless Phase 2
V= VOIP
Type of Service / 221 / 1 / N / R / Valid entries are:
0 = Not Foreign Exchange (FX) or Non Published (Non Pub)
1 = FX in 9-1-1 serving area
2 = FX outside 9-1-1 serving area
3 = Non Pub
4 = Non Pub FX in 9-1-1 serving area