Terminating Point Master (TPM)

By Elaine Riley,2014-12-03 17:32
12 views 0
Terminating Point Master (TPM)

    ? ?TelcordiaTPM DATA SOURCE

    Data Set / File Specifications


     ?(updated to reflect 7/15/05 Microsoft Access TPM database changes)

     ??This document contains data set / file specifications for the Telcordia TPM Data Source as provided on CD ROM, web download, and transmitted via electronic data transfer, as of the date indicated above. File layouts are those associated ?with the fixed formatted data files provided in the TPM. For further information, call the Telcordia Routing Administration (TRA) Customer Service Center on 866-NPA-NXXS (i.e. 866-672-6997) or 732-699-6700. This

    document may also be downloaded at (documents).

Telcordia and TPM Data Source are trademarks of Telcordia Technologies, Inc.

     ?Copyright 1994-2005 Telcordia Technologies, Inc.

    All Rights Reserved

Issue date: 03/15/05

    TPM Flat File Information - History

The following identifies previous issues of these specifications in this format and identifies pertinent changes associated

    with each issuance of this document.

Note that the “issue date” need not be the same as the “effective date”. Since specifications often need to be issued with

    sufficient lead-time to permit review, cosmetic changes, and error corrections, possible pertinent changes may occur

    before a “final” version can be solidified. If you are concerned as to whether you have the latest version of this document,

    please call TRA on 866-NPA-NXXS (i.e. 866-672-6997) or 732-699-6700 or check, where you can also

    download copies of these specifications.


    Date Changes

    07/01/95 Initial specs in this format

    12/15/95 - Inclusion of "activity" and "master" files into a single TPM product

    - Updates to Glossary (CO TYPE, NXXTYPE) and various clarifications.

    - Introduction of SCAN as a viewer for diskette data.

    - Revisions to naming of supporting diskette files (e.g. "read me").

    03/15/96 - COUNTREC.EXE added to diskette.

    10/15/97 - No structural file changes - supports the incorporation of the VHCD and TPM (previously separate



    - The VHCD NXXMSTR.DAT diskette file becomes TPM.DAT


    - The VHCD NXXACTVY.DAT diskette file becomes TPMACT.DAT

    - Glossary/specs files added to diskette and tape

    04/15/98 - OCN file updated to include CO TYPE, Bill to RAO, Send to RAO

    - TPMEND file added to note the product date and to provide a listing of file record counts for

    reconciliation purposes

    01/15/99 - Inclusion of Portability Indicator on TPM, TPMACT, and MINORVH files

    - Addition of PLNAME file

    - Inclusion of files associated with CD ROM version

    07/15/99 - Inclusion of RAO file

    07/15/00 - Inclusion of Pooling Indicator on TPM, TPMACT, and MINORVH files

    - Addition of TBP file

    01/15/03 - Removal of Special Rating Indicator and “Actual NPA for Non-Mexican "Other Place"” NPA fields

    from TPM and MINORVH files

    - Expansion of fields in TBP file to those in TPM.DAT; addition of Rate Center name information and

    RC file; addition of AOCN data field in TBP file

    - Removal of diskette media notations to support earlier discontinuance

    10/15/03 - Addition of TBPACT.DAT

    - Addition of TPMAPP02.MDB (CD only)

    01/15/04 - Replacement of TPM.DAT and TPMACT.DAT with TBP.DAT and TBPACT.DAT formats (i.e.

    TPM.DAT and TPMACT.DAT file „names‟ continue, TBP file „names‟ do not; former TBP files are

    now entitled the TPM files)

    - MINORVH.DAT reformatted to correlate to basic TBP.DAT format

    - Note: Effective 7/15/04 the magnetic tape version of the TPM was discontinued

     TPMDATA.MDB updated from Access 97 to Access 2000; TPMAP97.MDB removed; TPMAP03.MDB

06/01/05* added. * 03/01/05 re-issue

    TPM? Data Source

    Dataset and File Record Layouts 01/15/04

Product Description:

     ?The Telcordia Routing Administration (TRA) on 866-NPA-NXX (i.e. 866-672-6997) or 732-699-6700, ??provides the Telcordia TPM Data Source in support of systems used in rating telephone calls and other processes that involve the NPA NXX data it contains. The TPM is provided monthly via CD ROM. The files on the CD ROM can also be downloaded from the web. CD ROM and web versions contain an ?additional Microsoft Access version of the data. Electronic transmission of data files via Network Data ?Mover (NDM) (aka Connect:Direct) is also available under certain conditions.

File Descriptions:

    This document provides detailed record layouts of the files provided on the TPM data file products. NDM, CD ROM, and web downloaded data file versions are identical in terms of data content and file layout. Brief field descriptions and a listing of coded values used in certain fields are provided in Appendix A-1 (GLOSSARY file). The definitions and values are subject to clarification and other changes on an ongoing basis.

    The sequence of file layouts in this document follows the sequence of files appearing on the magnetic tape version of the TPM when such was available. The Last Change dates in the file description headers in this document refer to when the file was last structurally changed, or alternatively, first appeared. Dates of 1990 are used as defaults since tracking did not occur prior to that date. Structural changes would include the addition or removal of fields either physically, or though redefinition of filler space as well as the redefinition of a field. Wording changes done to clarify existing fields will not, of and by themselves, generate a "Last Change" date. Please note the following:

; Appendix A-1 to this document (GLOSSARY file), available at (documents) provides

    a brief description of most fields, as well as a listing of specific field values (or other qualifiers) when reasonable and applicable.

    ; The TPM contains both a "primary" (master) file of NPA NXX (and BLOCK ID) data (TPM.DAT) as well as a subset of the primary file, called an "activity" file (TPMACT.DAT) of NPA NXX (and BLOCK ID) data. The primary and respective activity files are structured identically. All data records found in the "activity" file are also found in the "primary" file.

    ; Data in the TPM.DAT and TPMACT.DAT files are provided on a BLOCK ID basis, per NPA NXX. The CO Code Holder company and associated data is represented as BLOCK ID “A”. In addition, where an NPA NXX is further broken down into Thousands Blocks, the TPM files contain information for records identified with BLOCK ID = 0-9 (note that not all 10 blocks may be assigned and thus a record for each of the potential 10 blocks under an NPA NXX may not be provided).

    ; BCR.MINOR.VH (file MINORVH.DAT) is structured identical to the TPM.DAT "master" file with the exception that the "minor" V&H fields have been appended to the end of the record. Only those records containing nonzero minor V&H data are included in this dataset / file. This file should be considered as an “extension” of the data in the “master”, not as different records from the “master”. Note that unless

    the change has to do directly with minor V&Hs, the change code in this file should be the same as that in the “master” file.

    Issue Date: 7/15/05 TPM Data Source - Data Set / File Specifications Page 1 of


     Effective Product Date: 01/15/04

     Copyright ? 1984-2005 Telcordia Technologies, Inc.

    ; Note: Products are shipped (and should be received) approximately 2-3 weeks before the "product" date. Issue Date: 7/15/05 TPM Data Source - Data Set / File Specifications Page 2 of


     Effective Product Date: 01/15/04

     Copyright ? 1984-2005 Telcordia Technologies, Inc.

General Information:

    Dataset (NDM) Name Dataset Dataset CD ROM / web General Description (in sequence order) BLKSIZE LRECL Filename

    BCR.COPY.RIGHT 4000 80 COPYRGHT.DAT Copyright Notice BCR.TPM.MASTER 6050 110 TPM.DAT NPA NXX BLOCK Complete data BCR.TPM.ACTVTY 6050 110 TPMACT.DAT NPA NXX BLOCK Activity data BCR.NUMBER.SCC 3000 30 SCC.DAT Special Calling Cards BCR.NUMBER.OCN 4200 42 OCN.DAT Operating Company Numbers BCR.NUMBER.CIID 3840 256 CIID.DAT Card Issuer IDentifier data BCR.MINOR.VH 6000 120 MINORVH.DAT Minor V&H data BCR.PLNAME.DAT 6208 64 PLNAME.DAT Place Name 10/50 mapping BCR.NUMBER.RAO 6000 500 RAO.DAT RAO Directory BCR.RCNAME.DAT 6208 64 RCNAME.DAT RC Name 10/50 mapping BCR.GLOSSARY.TXT 4000 80 GLOSSARY.TXT References GLOSSARY.DOC BCR.SPECSTP.TXT 4000 80 SPECSTP.TXT References SPECSTP.DOC BCR.TPMEND.TXT 4000 80 TPMEND.TXT Production date w/file record


    The following are only

    on the CD ROM / web:

     READMETP.TXT High level information READ_ME.EXE A means to view "read me(s)" COUNTREC.EXE Counts lines in a file GLOSSARY.DOC WORD version of Glossary SPECSTP.DOC WORD version of SPECSTP TPMAPP00.MDB CD Microsoft Access User

    Interface (V.2000)

    TPMAPP02.MDB CD Microsoft Access User

    Interface (V.2002)

    TPMAPP03.MDB CD Microsoft Access User

    Interface (V.2003) TPMDATA.MDB CD Tables with indexed TPM

    Data Source (V.2000) INSTALL.DOC CD- Instructions / Overview of Microsoft Access version of data

Issue Date: 7/15/05 TPM Data Source - Data Set / File Specifications Page 3 of


     Effective Product Date: 01/15/04

     Copyright ? 1984-2005 Telcordia Technologies, Inc.

    File Layouts: (Note: the following are DATA file layouts, TXT files are not listed below)

    NDM Dataset: File Sequence: 1 Description: Copyright Notice BCR.COPY.RIGHT

    CD ROM Filename: Last Change: 1990 COPYRGHT.DAT

     FIELD DESCRIPTION LENGTH POSITION 1. Copyright and Notice 80 1-80

    NDM Dataset: File Sequence: 2 Description: NXX NPA BLOCK ID BCR.TPM.MASTER

    All records

    CD ROM Filename: Last Change: 1/15/04 TPM.DAT


     4. filler 1 8 5. Range 8 9-16 6. NXXTYPE 2 17-18 7. filler 1 19 8. Effdate of Last Change (mmddyy) 6 20-25 9. Change Code 1 26 10. filler 1 27 11. Operating Company Number (OCN) 4 28-31 12. Administrative Operating Company Number 4 32-35


    13. Company Code 2 36-37 14. Company Type 1 38 15. Bill to RAO 3 39-41 16. Send to RAO 3 42-44 17. filler 1 45 18. Major Vertical Coordinate 5 46-50 19. Major Horizontal Coordinate 5 51-55 20. Rate Center LATA 3 56-58 21. Rate Center LATA Subzone 2 59-60 22. Rate Center Name Abbreviation 10 61-70 23. Rate Center Type 1 71 24. Place Name (or Service Name) 10 72-81 25. State, Province, or Country Abbreviation 2 82-83 26. filler 1 84 27. Time Zone 1 85 28. Daylight Savings Observed Indicator (0=N, 1=Y) 1 86 29. Portability Indicator (0=N, 1=Y) 1 87 30. Thousands Block Pooling Indicator 1 88 31. IDDD Indicator (0=N, 1=Y) 1 89 32. Dialable Indicator (DIND) (0=N, 1=Y) 1 90 33. Other Line Rate Step 2 91-92 34. Point Identification 1 93

    Issue Date: 7/15/05 TPM Data Source - Data Set / File Specifications Page 4 of


     Effective Product Date: 01/15/04

     Copyright ? 1984-2005 Telcordia Technologies, Inc.

    35. Effective Date of Assignment 6 94-99

    36. filler 11 100-110


    1. The “complete” dataset / file (TPM.DAT) is considered the main component of the TPM

    product for most users. The “activity” dataset / file (TPMACT.DAT) usually contains a few

    thousand records, but can theoretically contain up to the total number in the main dataset

    2. The TPM.DAT dataset / file has all NPA NXX BLOCK ID data (including all activity records).

    Records with a BLOCK ID value of “A” represent the CO Code Holder assigned to the NXX

    (e.g. for default routing purposes). Numeric blocks (0-9) represent assignees at the Block

    (1000 lines level). Only assigned blocks are listed. Often, the data associated with the “A”

    record also exists for at least one numeric block within the NXX.

NDM Dataset: File Sequence: 3 Description: NPA NXX BLOCK ID BCR.TPM.ACTVTY

    Activity records

    CD ROM Filename: Last 1/15/04 TPMACT.DAT


    The TPMACT.DAT dataset / file is structured identical to the master (BCR.TPM.MASTER / TPM.DAT). The activity dataset usually contains a few thousand records, but can theoretically contain up to the total number in the complete dataset. With the exception of records containing a change code of "A", this file simply identifies the records in the TPM.DAT file that have a change code. Change codes indicate that there is some "activity" associated with the record since the previous month's product.

NDM Dataset: File Sequence: 4 Description: Special Calling Cards BCR.NUMBER.SCC

    CD ROM Filename: Last Change: 1990 SCC.DAT


    1. Bill to RAO 3 1-3

    2. 0/1XX (SCC Code within RAO) 3 4-6

    3. Send to RAO 3 7-9

    4. NPA 3 10-12

    5. Change Code 1 13

    6. Effdate of Last Change (mmddyy) 6 14-19

    7. Operating Company Number (OCN) 4 20-23

    8. filler 7 24-30

NDM Dataset: File Sequence: 5 Description: OCN Listing BCR.NUMBER.OCN

    CD ROM Filename: Last Change: 7/15/00 OCN.DAT

Issue Date: 7/15/05 TPM Data Source - Data Set / File Specifications Page 5 of


     Effective Product Date: 01/15/04

     Copyright ? 1984-2005 Telcordia Technologies, Inc.

     FIELD DESCRIPTION LENGTH POSITION 1. Operating Company Number (OCN) 4 1-4

    2. Company Name 30 5-34

    3. Change Code 1 35

    4. filler 7 36-42

    Issue Date: 7/15/05 TPM Data Source - Data Set / File Specifications Page 6 of


     Effective Product Date: 01/15/04

     Copyright ? 1984-2005 Telcordia Technologies, Inc.

Report this document

For any questions or suggestions please email