CHAPTER 12.0 - Error Resolution

12.4 Electronic Error Delivery

All ICOs that send daily update records to Intrado electronically via Intrado Connect receive their errors generated from the processing of their daily update records electronically. The errors are delivered to the ICOs Intrado Connect Mailbox.

Confirmation files and Statistics files with information on error records and records that have processed successfully are generated to ICOs that send their daily update records to Intrado electronically.

12.4.1 The Confirmation Report

The Confirmation reports list the daily update records that are in error, along with a three-digit error code. The error code descriptions and corrective action are provided in this tab.

Note:
Only records in error are included on this report. If the record has successfully processed and posted in the ALI database it will not be included on this report. Only records in error are included on this report. If the record has successfully processed and posted in the ALI database it will not be included on this report.

Example of the Confirmation report is shown below. The record layout for electronic errors is in NENA Version 2 format. There is a three-digit error code located at the end of the record in reserved fields 378 - 380 followed by an "E" to indicate the record is in error.

Table K. Field and Description

FIELD	DESCRIPTION
FUNCTION CODE	Function code. Valid codes are: I=Insert, C=Change, P=Main account delete, E=Error delete, U=Unlock, M=Migrate
NPA	Three(3) digit number of Calling Number
CALLING NUMBER	Seven(7) digit number of Calling Number
HOUSE NUMBER	House Number. The field should be spaced filled if no house number is available.
HOUSE NUMBER SUFFIX	House number extension (e.g. /2). The field should be spaced filled if no suffix applies.
PREFIX DIRECTIONAL	Leading street direction prefix. The field should be spaced filled if no prefix applies. Valid entries: N, S, E, W, NE, NW, SE, SW
STREET NAME	Valid street abbreviation.
POST DIRECTIONAL	Trailing street direction suffix. The field should be spaced filled if no suffix applies. Valid entries: N, S, E, W, NE, NW, SE, SW
COMMUNITY NAME	Valid service community of the street name/house number as designated by the MSAG.
STATE	Alpha state abbreviation
LOCATION	Additional address information (free formatted) describing the exact location of the Calling Number (e.g. APT 718).
CUSTOMER NAME	Subscriber name associated with the Calling Number.
CLASS OF SERVICE	Value of:
	1 = Residence 2 = Business 3 = Residence PBX	4 = Business PBX 5 = CENTREX / ESSX 6=Semi-Public Coin	7 = Public Coin 8 = Mobile 9 = DPA Residence	0 = DPA Business A = Outdial Semi-Public B = Outdial Public
TYPE OF SERVICE	Value of:
	0 = Not Non-pub or FX 1 = FX not Non-pub	2 = Not used 3 = Non-pub, not FX	4 = Non-pub, FX 5 = Not Used
EXCHANGE	Local Exchange Carrier exchange identifier for the serving telephone office of the customer.
MAIN NPA	Three(3) digit area code of the Main Number associated with the Calling Number.
MAIN NUMBER	Seven(7) digit telephone number of the Main Number associated with the Calling Number.
ORDER NUMBER	Service order number for the activity establishing this record.
EXTRACT DATE	Date for which the record was created in the form MMDDYY
COUNTY ID	County Identification Code (usually the FIPS code).
COMPANY ID	NENA registered Company Identification Code.
SOURCE ID	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	Postal Zip Code
ZIP+4	Postal Zip Code Extension
GENERAL USE	Mutually used by data exchange partners to pass information not defined in previous fields.
CUSTOMER CODE	Code used to uniquely identify customer.
COMMENTS	Optional notes may be displayed at PSAP
X COORDINATE	Longitude / X coordinate
Y COORDINATE	Latitude / Y coordinate
Z COORDINATE	Structure elevation
CELL ID	Identification number indicating a geographic region of cellular coverage.
SECTOR ID	Sub set / section of a cell.
TAR CODE	Taxing Area Rate Code
RESERVED	Positions 356-511 are reserved. Positions 378-380 are used by Intrado to populate the three(3) digit error code (e.g. 709).
END OF RECORD	Always an asterisk (*)

12.4.2 The Statistics Report

The Statistics Report provides information about the processed daily update records. The top portion of the report show the number of records received, followed by the number of records in error, and the number of inserts, changes and deletes that were successfully processed. The top portion of the report list the number of daily update records received by Intrado, the number of daily update records in error and the number of each record type by FOC (function of change) that was processed and applied to the E911 database. The bottom portion of the report lists all the valid error codes for the BellSouth region.

Example of the Statistics Report is shown below.

Figure 18. Statistics Report

12.4.3 Distribution of Daily Reports

Intrado forwards daily reports to the ICO's Intrado Connect Mailbox each business day. The Saturday and Sunday Confirmation and Statistical reports are included in Monday's cycle. To retrieve reports after sending a file: (1) return to Intrado Connect, (2) click on the transfer key, (3) click on the download key and automatically retrieve your reports.