Table Of Contents
Using the ALI Formatting Tool for Bell Canada
NENA Fields and Corresponding Bell Canada Fields
Modifying Bell Canada-Specific Fields in the ALI Formatting Tool
Modifying the Transaction Code
Entering Bell Canada-Specific Data
Using the ALI Formatting Tool for Bell Canada
This chapter provides information about the ALI Formatting Tool (AFT) fields that are specific to Bell Canada. Use this information along with "Using the ALI Formatting Tool" to generate ALI files in the format specified in Bell Canada's ALI data support documentation.
This chapter contains the following sections:
•
NENA Fields and Corresponding Bell Canada Fields
•
Modifying Bell Canada-Specific Fields in the ALI Formatting Tool
For more details, refer to the latest Bell Canada's ALI data support documentation.
NENA Fields and Corresponding Bell Canada Fields
Table A-1 lists NENA fields and the corresponding Bell Canada fields. Be aware that some NENA fields and some Bell Canada fields must be populated with data and some may be left blank. For more details, refer to Bell Canada's ALI data support documentation.
For information about the Bell Canada-specific fields that you may need to modify, see the "Modifying Bell Canada-Specific Fields in the ALI Formatting Tool" section.
Table A-1 NENA Fields and Corresponding Bell Canada Fields
NENA Fields
|
Data Required
|
Bell Canada Fields
|
Data Required
|
Comments
|
House Number
|
Yes
|
Civic Number
|
Yes
|
|
House Number Suffix
|
No
|
Civic Number Suffix
|
No
|
|
Street Name
|
Yes
|
Street Name
|
Yes
|
|
Prefix Directional
|
No
|
Street Directional
|
No
|
|
Street Suffix
|
No
|
Street Suffix
|
Yes
|
The Street Suffix field is not mandatory in NENA but must be data filled in the Bell Canada format.
|
Post Directional
|
No
|
|
Not applicable
|
This NENA field is not used by Bell Canada.
|
Community Name
|
Yes
|
Extended Municipality Name
|
Yes
|
|
State
|
Yes
|
Province
|
Yes
|
|
Main NPA
|
No
|
Pilot NPA
|
Yes
|
|
Main Telephone No.
|
No
|
Pilot NXX + Pilot LINE
|
Yes
|
|
Customer Name
|
Yes
|
Subscriber Name
|
Yes
|
|
Class of Service
|
Yes
|
|
Not applicable
|
AFT does not use the Class of Service from Cisco Emergency Responder (Cisco ER). You must configure this in AFT. See Table A-3.
However, you must enter a dummy value (1 alphanumeric character) for this mandatory field in Cisco ER for the Cisco ER ALI configuration to work correctly.
|
Type of Service
|
Yes
|
|
Not applicable
|
Because this is a mandatory field in NENA, you must configure some dummy value for this field in Cisco ER.
AFT ignores this value.
|
Exchange
|
No
|
|
Not applicable
|
This NENA field is not used by Bell Canada.
|
Order Number
|
No
|
|
Not applicable
|
This NENA field is not used by Bell Canada.
|
Extract Date
|
No
|
|
Not applicable
|
This NENA field is not used by Bell Canada.
|
County
|
No
|
|
Not applicable
|
This NENA field is not used by Bell Canada.
|
Company ID
|
Yes
|
DATA LSP ID
|
Yes
|
|
Zip Code
|
No
|
|
Not applicable
|
This NENA field is not used by Bell Canada.
Postal Code is defined in a Bell Canada-specific field. See Table A-3.
|
Zip Code Extension
|
No
|
|
Not applicable
|
This NENA field is not used by Bell Canada.
|
Customer Code
|
Yes
|
Subscriber Account ID
|
Yes
|
|
Comments
|
No
|
|
Not applicable
|
This NENA field is not used by Bell Canada.
|
Longitude
|
No
|
|
Not applicable
|
This NENA field is not used by Bell Canada.
|
Latitude
|
No
|
|
Not applicable
|
This NENA field is not used by Bell Canada.
|
Elevation
|
No
|
|
Not applicable
|
This NENA field is not used by Bell Canada.
|
TAR code
|
No
|
|
Not applicable
|
This NENA field is not used by Bell Canada.
|
Location
|
No
|
Additional Information
|
No
|
|
Reserved (for Service Provider Use)
|
No
|
|
Not applicable
|
This NENA field is not used by Bell Canada.
|

Note
The NENA Function Code field is called Transaction Code field in the Bell Canada format. See the "Modifying the Transaction Code" section.
Modifying Bell Canada-Specific Fields in the ALI Formatting Tool
This section covers the following topics:
•
Modifying the Transaction Code
•
Entering Bell Canada-Specific Data
Modifying the Transaction Code
Table A-2 shows the values displayed in the Function Field in NENA records and the corresponding values for the Transaction Code in Bell Canada records.
.
Table A-2 NENA and Bell Canada Function/Transaction Fields
NENA Function Code Field
|
Bell Canada Transaction Code Field
|
I for Insert a new record
|
A for Add a new record
|
C for Change a record
|
A for Change a record.
The NENA Function Code C is mapped to Bell Canada's Transaction Code A.
|
D for Delete a record
|
D for Delete a record
|
Make sure that the Transaction Code for Bell Canada is either A or D. Otherwise, Bell Canada will reject the record and return the record in an Error Return file with an error message.
Entering Bell Canada-Specific Data
Table A-3 describes the remaining Bell Canada-specific fields. Some require data to generate ALI files in the format specified in Bell Canada's ALI data support documentation; others may remain blank.
If there is an error in these fields, Bell Canada will reject the record and send back a Error Return file with an error code. For more details and for information about field validation, refer to the latest Bell Canada ALI data support documentation.
Table A-3 Modifying Bell Canada Specific-Fields
Field
|
Description
|
Format
|
Notes
|
Service Class
|
Type of telephone service of the customer's Terminal Number
|
3 alphanumeric characters
|
Must not be blank.
|
Postal Code
|
Postal code of the customer's service address
|
6 alphanumeric characters
|
Must not be blank.
First character must be alphabetic.
|
Municipality Code
|
Unique code assigned to each municipality
|
3 alphanumeric characters
|
Must not be blank.
|
Class of Service
|
Code identify the grade, class and type of service
|
5 alphanumeric characters
|
May be blank.
|
System Source
|
Identifies the source database of the Transaction Record
|
1 alphabetic character
|
Must not be blank.
|
Location Type
|
Type of location within a building (for example, apartment)
|
15 alphanumeric characters
|
May be blank.
|
Location Number
|
Number of the location identified in the Location Type field (for example, apartment 2, floor 2)
|
6 alphanumeric characters
|
May be blank.
|
Service Municipality
|
City, town, village, borough or locality
|
35 alphanumeric characters
|
Must not be blank.
|
LSP ID
|
Unique code provided to the PS ALI customer by Bell Canada. It denotes the provider of local telephone service.
|
5 alphanumeric characters
|
Must not be blank.
Must be the valid LSP Identifier provided to the PS ALI customer.
|

Note
You do not configure the Language Indicator field using AFT; AFT sets the field to E for English.