file:///C:/hold/hold/catalog_details.txt

d source for routing and rating data

Catalog of Products

TRA Catalog Cover

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

LERG OnLine NXQ

Produced first workday monthly

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

Distribution Format(s):  web download, CD

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 lergdown0615.exe to any convenient folder on your PC
  • once the file lergdown0615.exe is downloaded:
    •    double click on it to expand the LERG sample which will be placed in c:\access\LERG_SAMP0615
    •    in c:\access\LERG_SAMP0615, read LERGSAMP.DOC (or TXT) for further information

(13 MB available space required on hard drive for all files once the download is expanded)

NECA Copyright Notice

Return to Product Listing


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.

LERG OnLine:

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.

LERG OnLine NXQ


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 (March, June, September, December)

Distribution Format(s):  CD, web download

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 (700KB download) (based on latest specifications) (clink link to download)

Basic instructions for downloading and viewing TPM sample data follow:

  • download tpmdown0915.exe to any convenient folder on your PC
  • once the file tpmdown0915.exe is downloaded:
    •    double click on it to expand the TPM sample which will be placed in c:\access\TPM_SAMP0915
    •    in c:\access\TPM_SAMP0915, read TPMSAMP.DOC (or TXT) for further information

(5.0 MB available space required on hard drive for all files once the download is expanded)

Return to Product Listing


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 (1.1 MB) (based on latest specifications) (clink link to download)

Basic instructions for downloading and viewing LCADS sample data follow:

  • once the file lcadsdown0813.exe is downloaded:
    •    double click on it to expand the LCADS sample
    •    read the generated README_LCADSSAMP_.DOC (or TXT) for further information

(7 MB available space required on hard drive for all files once the download is expanded)

Return to Product Listing


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.

LERG OnLine NXQ

Produced first workday monthly

Distribution 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)

Return to Product Listing


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

NPA NXXs in the United States are also often assigned at the Thousands-Block level (e.g. line numbers 0000-0999,1000-1999, etc.).  Where such has occurred, the assigned service provider (OCN) of the block within the NPA NXX and all the data noted above at the NPA NXX level is provided.

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.

LERG OnLine NXQ

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)

Return to Product Listing


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

LERG OnLine NXQ

Produced first workday monthly

Distribution 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)

Return to Product Listing


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

LERG OnLine NXQ

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)

Return to Product Listing


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 monthly

Distribution Frequency monthly

Distribution Format(s):  email, web download

Click here to request more information on the LARG.

Return to Product Listing


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 monthly

Distribution Frequency monthly

Distribution Format(s):  email, web download

Click here to request more information on the CNARG.

Return to Product Listing


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 monthly

Distribution Frequency monthly

Distribution Format(s):  web download

Return to Product Listing


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


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)

Return to Product Listing


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.

Return to Product Listing