Skip to main content

TruOps Telecom Routing Administration (TRA)

The industry recognized source for routing and rating data

 

Catalog of Products

Download complete  TRA Catalog of Products, which includes extensive product overviews, licensing details, and ordering information.


LERG™ Routing Guide

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 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:

 

  • 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 900,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 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 “Common Language Store” in the lower left corner of the web page then, at the store site, choose SSC Codes 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. Data files are also included in the LERG, use of the user interface is optional. The TRA Catalog co-nations additional representations of LERG data.

 

lerg6

 

Produced: first workday monthly

Distribution Frequency: monthly or quarterly (March, June, September, December)

Distribution Format(s): web download

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.

Sample LERG Available

NECA Copyright Notice

Return to Product Listing


LERG OnLine:

This easy-to-use web-based GUI application for monthly LERG subscribers is licensed on an enterprise-basis. 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.

The following is an example of the interface.

 

LERG OnLine

TPM™ Data Source

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) CoordinateState, Province, Country
Horizontal (H) CoordinatePortability Indicator
Revenue Accounting Office (RAO)Time Zone
Thousands-Block Pooling IndicatorCompany Type
NXX Type (wireline, paging, cellular, etc.)Other Line Rate Step
Daylight Savings Time IndicatorSpecial Calling Cards

 

 

The TPM Data Source provided 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 view". 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 (March, June, September, December)

Distribution Format(s):  web download

Click here to request more information on the TPM. Data file specifications and the TPM Data Source Glossary are available for download.


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 and toll calls.

 

Data elements include:

DistanceCity NameCO Type (LEC or Wireless)
NPA NXXRate CenterState
OCNLATARate Center V&H
Dialing PatternsCalling 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.

Download a sample LCADS.


 

Telemarketing Data Source (TDS)

If you have a need to know which exchanges (NXXs) are most likely cellular, landline or paging, the Telemarketing Data Source (TDS) 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, you'll find the TDS a valuable tool for your business.

 

The TDS 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.

 

TDS

 

Produced:  first workday monthly

Distribution Frequency:  monthly

Distribution Format(s):  web download

Click here to request more information on TDS.

Download a sample TDS.

 

NPA-NXX Active Code List (NNACL)

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 Operating Company Number (OCN) of the NPA NXX, the type of service that is provided (e.g. wireless) by the assigned service provider, the associated Rate Center and State/Province/Country, and a Portability Indicator. Also included is a file that can be used to translate the Operating Company Number (OCN) to a company name. A user-friendly and dynamic “search” program to facilitate data selection and extraction is also provided with each issue of the product. A general information section explains the data in greater detail.

 

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. 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.

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.

 

NNACL

 

Produced:  first workday quarterly (January, April, July, October)

Distribution Frequency:  quarterly (January, April, July, October)

Distribution Format(s):  web download

Click here to request more information on the NNACL.

Download a sample NNACL.


NPA-NXX Activity Guide (NNAG)

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 Operating Company Number (OCN) of the NPA NXX , the type of service that is provided (e.g. wireless) by the assigned service provider, the associated Rate Center and State/Province/Country, and a Portability Indicator. Also included is a file that can be used to translate the Operating Company Number (OCN) to a company name. A user-friendly and dynamic “search” program to facilitate data selection and extraction is also provided with each issue of the product. A general information section explains the data in greater detail.

 

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. NNAG 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.

 

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.

 

nnag

 

Produced:  first workday monthly

Distribution Frequency:  monthly

Distribution Format(s):  email, web download

Click here to request more information on the NNAG.

Download a sample NNAG.


LIDB Access Routing Guide (LARG)

The LIDB (Line Information Data Base) 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 (STP) global title translation (GTT) tables for routing to data sources supporting Alternate Billing Services (certain calling cards, bill-to-third, collect). 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 monthly

Distribution 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 (STP) 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 monthly

Distribution Frequency:  monthly

Distribution Format(s):  email, web download

Click here to request more information on the CNARG.


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 otherwise

Distribution Frequency:  Each Tuesday and as may be needed otherwise

Distribution Format(s):  email

Return to Product Listing


Operating Telephone Company Numbering Plan Guide (OTCNPG)

Distribution of the Operating Telephone Company Numbering Plan Guide (OTCNPG) is restricted to local Service Providers and their service bureaus. The OTCNPG is provided under license and is not available to the general public.

 

The OTCNPG is used to support:

 

  • Various systems used in call rating
  • Processes that involve the NPA NXX data contained in the product

 

Data elements include:

NPA NXX dataRAO DirectoryCard Issue Identification (CIID) codes
CNA ContactsSpecial Calling Card dataOperating Company Numbers (OCNs)
Business Office dataToll Library Directory

Produced:  mid-month monthly

Distribution Frequency:  monthly or quarterly (March, June, September, December)

Distribution Format(s):  web download

Return to Product Listing