d source for routing and rating data
Catalog of Products
A "complete" printable TRA Catalog of Products (more extensive product overviews, licensing details, and an Order Request Form) in pdf format can be accessed by clicking on the catalog image appearing to the right. ===>
A synopsis of each TRA product is provided below.
LERG™ Routing Guide
Scroll down for a downloadable product sample
The LERG Routing Guide is the most comprehensive routing data output available from TRA. Data supports the current local exchange network within the North American Numbering Plan (NANP) and identifies reported planned changes in the network. The LERG Routing Guide is primarily designed to be used for routing of calls by service providers (wireless, wireline, inter and intra exchange, etc.). It also supports functions such as networking planning and engineering, numbering administration, and is used by companies, including many outside of the telecommunications industry, to support a wide range of business operations and planning needs. The LERG has been in existence since 1984, and provides for a common basis for service providers within the NANP to directly report their numbering and routing information. The LERG is supported by integrated and quality-oriented industry processes and is similarly supported by TRA. Data in the LERG includes, but is not limited to:
- Operating Company Numbers, Company Names, Routing Contacts
- Country Code Assignments
- NPA Information (i.e., Area Codes)
- LATA Codes By Region
- Destination Codes (i.e. NPA NXX and Thousands-Blocks) (details on over 750,000 assignments)
- Oddball NXXs (e.g. 911, 976)
- Switching Entity Record detail (e.g. Equipment Type, V&H Coordinates)
- Rate Center details (e.g. V&H Coordinates) and Localities (including county and postal codes)
- Switch Homing Arrangements (tandem and other switch-to-switch interconnections)
- Operator Access Tandem Codes (ATCs)
- Location Routing Numbers (LRNs)
The LERG Routing Guide provided on CD and via the TRA Product Distribution System (PDS) includes a Microsoft® Access database version of the data in addition to fix formatted data files. The Access database version of the LERG provides a graphical user interface front end to access and view data records using a TRA designed "form view" as well as Access "table views". The database requires users to have a local licensed copy of Access. Users with a basic knowledge of Microsoft Access can easily search for specific data elements, create customized queries, cross-relate data files, export data to other software (e.g. Microsoft Excel), generate files that can serve as input files downstream operations support systems, etc.
Note: Equipment type - Switching System Codes (coded values regarding switch equipment types in the LERG) are assigned by COMMON LANGUAGE®. A spreadsheet of valid codes is available at www.commonlanguage.com. Click on “Store” in the upper left corner of the web page then, at the store site, choose Code Center and then CL-DATA-SSC for the spreadsheet.
The following is an image of the user interface provided with each copy of the LERG. This image represents a very small sample example of all the data that is in the LERG and is intended to provide more as an example of the interface than of the data. Since data files are also included in the LERG, use of the user interface is optional. The TRA Catalog that is downloadable at this site conations additional representations of LERG data.
Produced: first workday monthly
Distribution Frequency: monthly or quarterly (March, June, September, December)
Distribution Format(s): web download, CD, electronic data transmission (monthly subscribers only and assessed on a case by case basis)
Bulk data transfer service employs CONNECT:Direct, a third-party software package (Stirling Software), to manage the transfer. If you have or can install CONNECT:Direct, call our Customer Care Center for more information. Data transfer via his method requires a data line between iconectiv and your receiving site. This may be a dedicated physical line (not dial up), or a Virtual Private Network (VPN) tunnel can be established and the Internet used as the data line.
LERG One Day Changes: Monthly subscribers may opt to be provided access to a password-protected web-based LERG One Day Changes Process at no additional charge. This process provides fixed-formatted data files reflecting daily changes to the primary data files.
Click here to request more information on the LERG. Data file specifications and the LERG General Section (includes glossary) are available for download from the "documents" tab at this web site.
Sample LERG Available (1.7 MB download) (based on latest specifications)
Basic instructions for downloading and viewing LERG sample data follow:
- download lergdown0413.exe to any convenient folder on your PC
- once the file lergdown0413.exe is downloaded:
- double click on it to expand the LERG sample which will be placed in c:\access\LERG_SAMP0413
- in c:\access\LERG_SAMP0413, read README_LERGSAMP.DOC (or TXT) for further
information
(13 MB available space required on hard drive for all files once the download is expanded)
LERG Tool:
The following tool, as an offering separate from the LERG itself, provides you the ability to view, manipulate, and manage LERG data via a web interface.
This is an easy-to-use web-based GUI application for monthly LERG subscribers that, like the LERG, is licensed on an enterprise basis for the benefit of everyone in your company. LERG OnLine data is updated daily instead of monthly. The LERG OnLine data can be downloaded to your local environment, which then, as with the LERG Routing Guide data, can be integrated into other applications.
Click here to request more information on LERG OnLine. The following is an example of the interface.
TPM™ Data Source
Scroll down for a downloadable product sample
The TPM Data Source supports various systems used in rating and billing telephone calls and can be used as a source for certain data related to NPA NXXs. It contains data for the United States, American Samoa, the Commonwealth of Northern Mariana Islands, Guam, Puerto Rico, the US Virgin Islands, Canada, Bermuda, 16 island countries in the Caribbean, and Mexico.
Data elements include:
| Numbering Plan Area (Area Code) | IDDD Capability Indicator |
| NXX Code (exchange, prefix - with block) | Rate Center |
| Operating Company Number | Place Name |
| Vertical (V) Coordinate | State, Province, Country |
| Horizontal (H) Coordinate | Portability Indicator |
| Revenue Accounting Office (RAO) | Time Zone |
| Thousands-Block Pooling Indicator | Company Type |
| NXX Type (wireline, paging, cellular, etc.) | Other Line Rate Step |
| Daylight Savings Time Indicator | Special Calling Cards |
The TPM Data Source provided on CD and via the TRA Product Distribution System (PDS) includes a Microsoft® Access database version of the data in addition to fix formatted data files. The Access database version of the TPM provides a graphical user interface front end to access and view data records using a TRA designed "form view" as well as Access "table views".The database requires users to have a local licensed copy of Access. Users with a basic knowledge of Microsoft Access can easily search for specific data elements, create customized queries, cross-relate data files, export data to other software (e.g. Microsoft Excel), generate files that can serve as input files downstream operations support systems, etc.
Produced: mid-month monthly (product issuances are dated the 15th of the month following creation)
Distribution Frequency: monthly or quarterly (issue date: January, July, April, October)
Distribution Format(s): CD, web download, bulk data transmission (monthly subscribers only)
Bulk data transfer service employs CONNECT:Direct, a third-party software package (Stirling Software), to manage the transfer. If you have or can install CONNECT:Direct, call our Customer Care Center for more information. Data transfer via his method requires a data line between iconectiv and your receiving site. This may be a dedicated physical line (not dial up), or a Virtual Private Network (VPN) tunnel can be established and the Internet used as the data line.
Click here to request more information on the TPM. Data file specifications and the TPM Data Source Glossary are available for download from the "documents" tab at this web site.
Sample TPM Available (600KB download) (based on latest specifications) (clink link to download)
Basic instructions for downloading and viewing TPM sample data follow:
- create a folder for which the path is C:\ACCESS\TPM_SAMP0413 and download to that folder
- once the file tpmdownmmyy.exe is downloaded:
- double click on it to expand the TPM
- read the generated TPMSAMP.DOC (or TXT) for further information
(5.0 MB available space required on hard drive for all files once the download is expanded)
Local Calling Area Data Source
The Local Calling Area Data Source (LCADS) is a database containing local calling area information for areas within the United States and Canada. TRA proactively collects and maintains the local calling tariff database information by utilizing the governing sources.
LCADS contains business and residential local calling area plans for various service providers. It is an aid for companies involved with designing optional calling plans, routing of telecom traffic, least cost routing and validating and identifying local / toll calls.
Data elements include:
Distance City Name CO Type (LEC or Wireless) NPA NXX Rate Center State OCN LATA Rate Center V&H Dialing Patterns Calling Plans
Partial Query Example: NPA NXXs Local to me (Residential) - (NPA NXXs that 732699 can call as a Local Call)
Dist |
NPA NXX |
COTYPE |
ST |
OCN |
CITY |
11.63615 |
908262 |
E |
NJ |
7232 |
Belle Mead |
6.395311 |
732302 |
E |
NJ |
5120 |
Bound Brook |
6.708204 |
732273 |
E |
NJ |
7232 |
Dunellen |
5.700877 |
732297 |
E |
NJ |
5120 |
Franklin Park |
5.300943 |
908930 |
W |
NJ |
6391 |
Metuchen |
Dist = Distance of NPA NXX from 732699 Central
Office (miles)
NPA NXX = Area Code / prefix
COTYPE = LEC or Wireless
ST = State
OCN = Telecom Carrier Operating Company Number
CITY = Name of the Rate Center
Produced: 10th calendar day monthly
Distribution Frequency: monthly
Distribution Format(s): web download
Click here to request more information on LCADS.
Sample LCADS Available (0.7 MB) (based on latest specifications) (clink link to download)
Basic instructions for downloading and viewing LCADS sample data follow:
- once the file lcadsdown1009.exe is downloaded:
- double click on it to expand the LCADS sample
- read the generated README_LCADSSAMP_.DOC (or TXT) for further information
(6 MB available space required on hard drive for all files once the download is expanded)
Telemarketing Data Source (TDS)
Scroll down for a downloadable product sample
If you have a need to know which exchanges (NXXs) are most likely cellular, landline, or paging, the Telemarketing Data Source is an economical way to keep up with this information.
If your company has call center operations, needs to verify phone numbers, performs processing of customer contact information, or needs to suppress wireless or page numbers from a database application, or other similar needs, you'll find the Telemarketing Data Source a valuable tool for your business.
The Telemarketing Data Source provides a front-end application that permits you to extract the data provided relative to NPA NXX (prefix, exchange) and Thousands-Block assignments at various levels of selection criteria. Time Zone and Daylight Savings Indicators are also provided by NPA NXX.
Produced:
first workday monthlyDistribution Frequency: monthly
Distribution Format(s): CD, web download
Click here to request more information on TDS.
Sample TDS Available (2.75MB download) (clink link to download)
Basic instructions for downloading and viewing TDS sample data follow:
- place the file TDS4samp.exe in a new folder on your computer::
- double click on TDS4samp.exe to expand the TDS sample
- double click setup.exe to install the user interface
- Windows 7 users, chose the option to Install Only for Me if prompted - read READMEsamp.txt for further information
- a desktop icon will then be installed
(8.0 MB available space required on hard drive for all files once the download is expanded)
NPA-NXX Active Code List (NNACL)
Scroll down for a downloadable product sample
The NPA NXX Active Code List lists all
NPA NXX assignments (as well as block assignments where applicable) that are active (in service) as of these dates. Data provided includes the assigned service
provider (OCN) of the NPA NXX, the type of service that is provided (e.g. wireless) by the
assigned service provider, the associated
NNACL data is provided in fixed-width ASCII files. This data can be locally imported into Excel, loaded into locally developed databases, and/or read with applications that can read text files (e.g. Notepad, Microsoft® Word). Reading and processing of the data is a local consideration, based on user needs, processing environment, etc.
If there is need to reference or track changes that occur between quarterly issuances of the NNACL, the NPA NXX Activity Guide (NNAG), with records formatted the same as the NNACL, provides (only) activity (i.e. adds/deletes, changes to data), and is issued monthly. An integration application to directly update the NNACL data with the NNAG data is not provided due to the wide range of user environments and uses of the data; such must be developed by the user if needed. Due to the vast diversity among user environments, integration of the data into your local environment is your responsibility; however, TRA can assist your staff through explanation of the data, etc.
The following is an image of the user interface provided with each copy of the NNACL. Since data files are also included in the NNACL, use of the user interface is optional. Results from queries generated through this interface can be downloaded to your local environment using various user-controlled options.
Produced:
first workday quarterly (January, April, July, October)Distribution Frequency: quarterly (January, April, July, October)
Distribution Format(s): CD, web download
Click here to request more information on the NNACL.
Sample NNACL Available (1MB download) (clink link to download)
Basic instructions for downloading and viewing NNACL sample data follow:
- once the file nnaclsmp.exe is downloaded:
- double click on it to expand the sample
- read the generated SAMPLE.TXT for more info
(7.4 MB available space required on hard drive for all files once the download is expanded)
NPA-NXX Activity Guide (NNAG)
Scroll down for a downloadable product sample
The NPA NXX Activity Guide (NNAG)
helps you to prepare for all future NPA NXX adds, changes and disconnects, as well
as last minute changes to active records. It
can be considered and used as a standalone product, or as a complement to the NPA NXX
Active Code List (NNACL).
The NNAG consists of NPA NXX records (as
well as block assignments where applicable) associated with future activity
reported by service providers (generally covering several months ahead), as well as last
minute changes made in the prior month. Data
provided includes the assigned service provider (OCN) of the NPA NXX , the type of
service that is provided (e.g. wireless) by the assigned service provider, the associated
The primary NNAG file includes an activity
code associated with the NPA NXX and its data (E=establish, M=modify, D=disconnect), as
well as the date that the activity is currently targeted to occur.
The NNAG does not list active NPA NXX
information unless it is associated with a future modification or deletion. However, the separately available NPA NXX Active
Code List (NNACL) contains a complete list of active codes.
TRA does not provide integration processes between the two lists.
The example provided at the end of this description is a depiction of results from the user interface provided with each copy of the NNAG. Results from queries generated through this interface can be downloaded to your local environment using various user-controlled options.
The following is an image of the user interface provided with each copy of the NNAG. Since data files are also included in the NNAG, use of the user interface is optional. Results from queries generated through this interface can be downloaded to your local environment using various user-controlled options.
Produced:
first workday monthlyDistribution Frequency: monthly
Distribution Format(s): CD, email, web download
Click here to request more information on the NNAG.
Sample NNAG Available (1.6MB) (clink link to download)
Basic instructions for downloading and viewing NNAG sample data follow:
- once the file nnagsamp.exe is downloaded:
- double click on it to expand the sample
- read the generated SAMPLE.TXT for more info
(8.2 MB available space required on hard drive for all files once the download is expanded)
Geographic Exchange List (GEL)
Scroll down for a downloadable product sample
The Geographic Exchange List (GEL) is a source of geographic information associated with each NPA NXX in the LERG™ Routing Guide and TPM™ Data Source.
The GEL is issued quarterly in January, April, July, and October. Each issue contains a complete listing of currently active NPA NXXs within the United States and its territories, with each NPA NXX record associated with a compilation of related geographic data from a variety of sources (e.g. postal codes, localities, counties, MSAs, CSAs, etc. - see screen shot below)
The
GEL is available on CD-ROM and as a Web download
with data in fixed-record ASCII formatted data files. There is also a Windows based
graphical user interface for querying and extracting data in various configurations.
Produced:
first workday quarterly (January, April, July, October)Distribution Frequency: quarterly (January, April, July, October)
Distribution Format(s): CD, web download
Sample GEL Available (650KB download) (clink link to download)
- once the file gelsamp.exe is downloaded:
- double click on it to expand the sample
- read the generated SAMPLE.TXT for more info
3.5 MB available space required on hard drive for all files once the download is expanded)
LIDB Access Routing Guide (LARG)
The LIDB (Line Information DataBase) Access Routing Guide (LARG) is a single source for Line Information DataBase (LIDB) access routing data. The data can be used to administer and maintain Signal Transfer Point global title translation (GTT) tables for routing to data sources supporting Alternate Billing Services (certain calling cards, bill-to-third, collect, etc.). It identifies the responsible Signaling Network Control Center (SNCC), the appropriate Line Information DataBase provider, the inter-network route effective date, and the capability code or pseudo point code data. The LARG’s format and content is similar to the Calling Name Access Routing Guide (CNARG) that is used to manage access for database queries relative to Calling Name information.
The LARG is a useful tool for:
- Alternate Billing Service providers
- Database maintenance staff
- Increasing accuracy of queries
- Improving GTT performance
A text file that defines data fields, provides contact information, etc., is provided with each issue.
Produced:
first workday monthlyDistribution Frequency: monthly
Distribution Format(s): email, web download
Click here to request more information on the LARG.
Calling Name Access Routing Guide (CNARG)
The Calling Name Access Routing Guide (CNARG) is a single source of information for accessing information relative to databases containing subscriber Calling Name information. The CNARG data can be used to administer and maintain Signal Transfer Point Global Title Translations (GTT) tables used to route to points that contain this data. The CNARG’s format and content is similar to the LIDB Access Routing Guide (LARG) that is used to manage access for database queries relative to alternate billing services information.
The Calling Name Access Routing Guide is a useful tool for:
- Calling Name service providers
- Database maintenance staff
- Increasing accuracy of queries
- Improving GTT performance
A text file that defines data fields, provides contact information, etc., is provided with each issue.
Produced:
first workday monthlyDistribution Frequency: monthly
Distribution Format(s): email, web download
Click here to request more information on the CNARG.
Telephone Area Code Directory (TACD)
The Telephone Area Code Directory identifies the Area Code(s) (NPA(s)) associated with a given locality within the North American Numbering Plan. This product is useful as a reference tool to research area codes by state and locality. It most often is used by those knowing a locality and needing to know the associated Area Code. Provided as data files, the user can locally develop various associations of localities, states/provinces/countries, and Area Codes, as may be needed for studies, marketing plans, etc. Data changes to these relationships may result for various factors such as Area Code splits and overlays, renamed localities, new localities, Area Code boundary changes, etc.
Produced:
mid-month monthlyDistribution Frequency: monthly
Distribution Format(s): web download
Emergency Notifications (ENs)
Emergency Notifications report last minute changes that are not included in the current month’s products. Emergency Notifications are published at least once a week.
Emergency Notifications are useful for:
- Engineers responsible for call routing and switch translations
- Network planners/architects to prepare for coming changes
- Call rating and billing operations staff
- Recipients of the LERG and/or TPM that need to be aware of last minute NXX announcements (new code openings)
Emergency Notifications report new NXXs that are effective in less than 45 days from the date they are entered into the underlying TRA database by the service provider or its agent. Industry lead time for an NXX opening is a minimum of 45 days from the data entry date; however, exceptions, for various reasons, may sometimes be necessary. Emergency Notifications may also provide information of general interest such as reported blocked calls, short notice homing changes, and rate center changes. High level information regarding Area Code Splits (dates and test numbers) are provided and summarized once a month.
Produced:
Each Tuesday and as may be needed otherwiseDistribution Frequency: Each Tuesday and as may be needed otherwise
Distribution Format(s): email
Area Code Split Exchange Data (ACSED)
Scroll down for a downloadable product sample
The Area Code Split Exchange Data (ACSED) provides an up-to-date listing of all the exchanges (prefixes, NXXs) involved with an Area Code split. Although lists may be available from other sources, they generally do not reflect changes that occur mid-stream. The ACSED does reflect such changes.
Although Area Code splits are less pervasive than they were just a few years ago, the quarterly ACSED can keep you aware of future splits. An Area Code Split Exchange Data – Historical (ACSED-H) is also available and provides an exchange list for each split since 1989, covering 150 splits. Included with the ACSED, and most splits in the ACSED-H, is a listing of the primary localities associated with each split.
Data is provided as fixed formatted ASCII files that can be read with a text editor, loaded into spreadsheet programs, processed and also loaded into various databases. Due to the vast diversity among user environments, integration of the data into your local environment is your responsibility; however, TRA can assist your staff through explanation of the data, etc. Data is provided as one file for each split. However, an executable program is included with the ACSED that provides options to re-organize the data into a few other layouts, as well as combine data from different files, so as to make it easier to integrate with your local needs.
Produced:
first workday quarterly (March, June, September, December)Distribution Frequency: quarterly (March, June, September, December) (note: ACSED-H is available as a one-time order only)
Distribution Format(s): email, web download
Click here to request more information on the ACSED.
Sample ACSED Available (150KB download)
Basic instructions for downloading and viewing ACSED sample data follow:
- once the file acsedsmp.exe is downloaded:
- double click on it to expand the sample
- read the generated README.TXT for more info
(0.15 MB available space required on hard drive for all files once the download is expanded)
V & H Calculation (VHCALC)
Vertical and Horizontal Calculation Software (VHCALC) can help save staff time by translating latitude and longitude and V&H coordinates for such needs as new switch installations, Rate Centers, and points of interconnection. It also can be used to compute distances between sets of V&H coordinates.
Vertical and Horizontal (V&H) coordinates identify points on the earth’s surface and are derived from latitude and longitude. Developed by the telecommunications industry, they simplify the calculations needed to determine the straight-line airline distance between two sets of geographical points. Distance-sensitive rating processes use Rate Center V&H coordinates to determine mileage relative to rate bands. Switch V&H coordinates are used primarily when developing distance sensitive access charges.
The Vertical and Horizontal Calculation Software is a PC-based program that permits the conversion, in both directions, of V&H coordinates and latitude/longitude. The program has two modes: interactive and batch. It is DOS-based but is executable in Windows. The interactive mode is a user-prompted interface that assesses one set of coordinates at a time. The batch mode provides the capability to convert sets of V&H coordinates and latitude/longitude data in a data file, in either direction, in bulk.
Vertical and Horizontal Calculation-Interactive:
This mode provides the capability to assess the following, one set of coordinates at a time:
Converts Vertical and Horizontal coordinates to latitude/longitude
- Converts latitude/longitude to Vertical and Horizontal coordinates
- Computes the distance between a set of Vertical and Horizontal coordinates
- Provides Vertical and Horizontal coordinates and computes the latitude/longitude for an NPA NXX*
- Computes the distance between a pairs of NPA NXXs*
*Used only with the following data products: TPM™ Data Source, OTCNPG, Geographic Exchange List. These products provide Rate Center Vertical and Horizontal coordinates; the Geographic Exchange List includes Switch Vertical and Horizontal coordinates.
Vertical and Horizontal Calculation-Batch:
This includes the Vertical and Horizontal Calculation-Interactive software, and adds additional programs that convert all records in a user-created data file containing V&H coordinates to latitude/longitude (and in the reverse direction). Data in the Vertical and Horizontal Calculation - Batch software requires a locally prepared ASCII file in a prescribed layout for input to the program. Users should have some experience with PCs and data management to address input and output requirements of the program.
Produced:
ongoing version; updated release if/when necessaryDistribution Frequency: one-time
Distribution Format(s): CD
Industry-Specific Proprietary Data Products
Products specific to, and restricted to, the industry are the Operating Telephone Company Numbering Plan Guide (very similar to the generally available TPM Data Source), and customized Point Code Data that require the concurrence of the data providing party. Please contact TRA for further information.