Produced: on or before 5th calendar day monthly
Current Release: August 4, 2020
Distribution Frequency: monthly or quarterly (issue date: January, April, July, October)
Distribution Format: Internet download
The NPA NXX to Postal code database is built using GIS data layers to accurately determine service area by Postal Code and accurately maps Canadian telephone area codes and exchanges to Canadian Postal Codes.
This mapping is based on the geography of the NPA NXX Rate Center and the Postal Code boundaries which yields a true representation of the coverage areas.
NPA NXX numbering resources are assigned by Rate Centers. Rate Centers are the regulated geographic service areas that telecom carriers provide service to and because their boundaries are relatively stable it is possible to compare them to postal carrier routes to determine what NPA NXX combinations are used in specific Postal Codes.
|Field||Data Type||Field Description|
|NPA||CHAR (3)||Numbering Plan Area (NPA) Code. An NPA, also known as a telephone area code, is the first three digits of a 10-digit North American Numbering Plan (NANP) telephone number in the form NXX-NXX-XXXX, where N represents any one of the numbers 2 through 9 and X represents any one of the numbers 0 through 9. Valid numeric range for NPA codes is 200 through 999.|
|NXX||CHAR (3)||Central Office Code (COC). The COC, commonly called the telephone exchange or prefix, is the second three digits (NXX) of a 10-digit NANP telephone number in the form NXX-NXX-XXXX, where N represents any one of the numbers 2 through 9and X represents any one of the numbers 0 through 9. Valid numeric range for NXX codes is 200 through 999.|
|ZIP||CHAR (7)||7-character alpha numeric Canadian Postal Code. Format is A1A 1A1, where A is a letter and 1 is a digit, with a space separating the third and fourth characters.|
For those exchanges and/or services that are not geographically associated with a postal code area (e.g. 211, 411, 811, 911 etc.) or when a postal code cannot be determined, this field will be populated with the value Q0Q 0Q0.
|STATE||CHAR (2)||Province postal abbreviation of the Rate Center locale.|
|CITY||VARCHAR (128)||Name of the city or locale identified by the current postal code.|
|RC||CHAR (10)||10-character industry standard abbreviated name of the Rate Center (or service) where the NPA NXX is assigned.|