Port PS Search and Search Results Help
Port PS "Search" Help
In Port PS, you run several types of queries to search for information on TNs, Blocks, or Codes. Click the link to see help for the topic.
Quick TN Search
TN Search
TN Range
Import File
Thousands Block Report
Code Report
Port PS "Search Results" Help
The results of TN, Block or Code search queries are displayed in tables, where similar types of information are grouped together. You may view results of a search in Port PS on the screen or you may download it to an excel file. Click the link to see help for the topic.
TN Query Results
Thousands Block Query Results
Block Table
Ported TNs in Block
Code Report Query Results
Code Table
Blocks for Code Table
Porting History
Download a Query
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
- Port PS "Search" Help -
- Quick TN Search -
This function is only located on the Home screen and is used to find general information about a single TN. If additional details about the TN are needed, click the Actions link at the bottom of the Search Results section to see all the details for the TN.
- Use numeric characters only; no alpha characters are allowed.
- Spaces between the digits of a TN are prohibited, but the digits of a TN can be separated by special characters (i.e. dashes, periods, parenthesis). For example, 914 823 6682 is invalid, but 914-823-6682 is valid, (914) 823-6682 is invalid but (914)823-6682 is valid.
Back to Top Back to Port PS "Search" Help
- TN Search -
Search for a single TN.
- Use numeric characters only; no alpha characters are allowed.
- Spaces between the digits of a TN are prohibited, but the digits of a TN can be separated by special characters (i.e. dashes, periods, parenthesis). For example, 914 823 6682 is invalid, but 914-823-6682 is valid, (914) 823-6682 is invalid but (914)823-6682 is valid.
Back to Top Back to Port PS "Search" Help
- TN Range -
Query a range of contiguous TNs. The format must be: initial TN, comma, then last four digits of last TN e.g. 7033716000,6100. Alpha characters are not allowed.
Back to Top Back to Port PS "Search" Help
- Import File -
Import a file containing TNs. The file must be in .xls, .xlsx, .csv, or .txt format. Click Browse and find the file or if you prefer, type the path and file name directly in the box.
General formatting requirements are:
- TNs must be 10 numeric characters. No alpha or text characters are allowed as TNs. For example, avoid entering 914-823-NOVA. Spaces between the digits of a TN are prohibited, but the digits of a TN can be separated by special characters (i.e. dashes or periods). For example, 914 823 6682 is invalid, but 914-823-6682 is valid.
- The first three digits of a TN can be enclosed in parentheses, as in (914)823-6682.
- 800, 900, and international numbers are not allowed
- A maximum of 1000 TNs can be included in a single query.
- If the wrong format is used for any of the TNs, the file will produce a validation error. The file needs to be fixed in order for the query to run.
- Multiple TNs can be listed on separate lines or along the same line (as long as multiple TNs are separated by spaces or commas). Multiple TNs must be separated by commas or spaces; no other punctuation marks are allowed.
- Ranges of contiguous TNs are allowed. The ending four digits of a range must be greater than the previous four digits. For example, suppose the TN is 914-632-7200. The last four digits can be 7300 but not 7100. in a spreadsheet, the TN and its ending digits must be in contiguous columns of the spreadsheet. For example, to query 703-209-0001 to 1000, put 703-209-0001 in A1 and 1000 in B1.
For .xls files and .xlsx files:
General requirements plus:
- No column headings or labels are allowed.
- TNs do not have to be aligned the same way; i.e., some TNs can be left aligned, others right-aligned, and others centered.
- One TN or TN range per cell.
- Headers and footers are allowed.
- No commas, semicolons, or other punctuation marks are allowed.
- TN ranges: The TN and its ending digits must be in contiguous columns of the spreadsheet. For example, to query 703-209-0001 to 1000, put 703-209-0001 in A1 and 1000 in B1. Commas and spaces between the TNs of a range are prohibited.
.csv files and .txt files
General requirements plus:
- Format for TN ranges: Enter the TN followed by a space or comma and then the ending four digits. For example, 571-203-0001,1000 or 571-203-0001 1000.
Back to Top Back to Port PS "Search" Help
- Thousands Block Report -
Enter a specific NPA-NXX-X and this query returns TNs within a pooled block that have been ported. These TNs are in use and thus unavailable for pooling, and contribute to the level of contamination of the pool.
- Spaces between the digits of a block are prohibited, but the digits of a block can be separated by special characters (i.e. dashes or periods). For example, 914 823 6 is invalid, but 914-823-6 is valid.
- The first three digits of a Block can be enclosed in parentheses, as in (914)823-7
Back to Top Back to Port PS "Search" Help
- Code Report -
Enter a specific NPA-NXX and this query returns code and block information for a specific code.
- Spaces between the digits of a code are prohibited, but the digits of a code can be separated by special characters (i.e. dashes or periods). For example, 914 823 is invalid, but 914-823 is valid.
- The first three digits of a code can be enclosed in parentheses, as in (914)823
Back to Top Back to Port PS "Search" Help
- Port PS "Search Results" Help -
- TN Query Results -
The results of TN queries identify the code owner, current owner of the TN (if the TN has been pooled or ported) and code/block information as well as other details, such as the SV Type. The results of basic TN queries are displayed in a table that contains six (6) tabs which group similar data elements into categories.
- Ownership TAB -
Details about the owner of the phone number are returned for every TN query run in Port PS. If the note "NPA-NXX for this TN has not been opened in the NPAC " is displayed in the table, the TN is a Native number and has not been pooled. Open the Code/Block Info tab and look at the NANPA Code Owner information to determine the owner of the TN. The following data elements are displayed:
- Phone Number (TN) : The Phone Number value is displayed as a link on this tab. Clicking this link opens the porting history for the TN.
- Status
- NPAC SPID (NPAC SPID TN Owner )
- Company (NPAC Company Name)
- Alt SPID: This field may be blank if there is no Alt SPID for the TN
- Alt SPID Company name: This value can be seen by using your mouse to hover over the Alt SPID value in the results table for each TN.
- Last ALT SPID: This field may be blank if there is no Last Alt SPID for the TN.
- Last ALT SPID Company Name: This value can be seen by using your mouse to hover over the Last Alt SPID value in the results table for each TN.
- NANPA OCN
- NANPA OCN Name: This value can be seen by using your mouse to hover over the NANPA OCN value in the results table for each TN.
- SV Type
Back to Top Back to Port PS "Search Results" Help Back to TN Query Results
- Geography TAB -
The Geography Tab contains details about the location of each TN returned in the query. The following data elements are displayed:
Back to Top Back to Port PS "Search Results" Help Back to TN Query Results
- Routing TAB -
The Routing Tab contains routing information for every TN returned in the query. The following data elements are displayed:
- TN: The Phone Number value is displayed as a link on this tab. Clicking this link opens the porting history for the TN.
- Status
- NPAC SPID (NPAC SPID TN Owner )
- NPAC Company Name
- LRN (LRN-TN)
- CLASS DPC/SSN
- LIDB DPC/SSN
- ISVM DPC/SSN
- CNAM DPC/SSN
- WSMSC DPC/SSN
Back to Top Back to Port PS "Search Results" Help Back to TN Query Results
- Code/Block Info TAB -
The Code/Block Info TAB contains code and block level information for each TN in the query. It is important to note that while this tab is displayed using TNs as the identifier, the information in it is at the Code and Block Level even when the TN has been ported. All TNs with the same Block (NPA-NXX-X) will have the same block data element information. All TNs with the same Code (NPA-NXX) will have the same code data element information. For example, given the following TNs: 516-244-1234, 516-244-1573, 516-244-4567 and 516-581-2345
- 516-244-1234 and 516-244-1573 will have the same block data elements and the same code data elements
- 516-244-1234, 516-244-1573, 516-244-4567 will have the same code data elements, but 516-244-4567 will have different block data elements from the other two TNs (assuming the code and block owners are different).
- 516-581-2345 has different code and block data elements from the other TNs.
The following data elements are displayed:
- TN
- Status
- NANPA Code Owner (NPA-NXX)
- PAS Block Owner (NPA-NXX-X): PAS Block ownership information is not populated if the Block has not been pooled and is not in PAS.
- OCN (Block Owner OCN )
- OCN Name (Block Owner OCN Name )
- Status (Block Status)
- Effective date: The date the Block became effective in PAS.
- NPAC Code Owner (NPA-NXX): NPAC Code Owner information is not populated if the NPA-NXX has not been opened for portability in the NPAC.
- ILEC/RBOC for Rate Center: If your account is not LERG enabled, a note will be displayed indicating that LERG is required
Back to Top Back to Port PS "Search Results" Help Back to TN Query Results
- Additional Fields TAB -
The Additional Fields TAB contains 3 "open" fields that are part of an NPAC record. These "open" fields do not have a set definition for what type of data is populated into the fields. You may use these fields at your discretion to add information about a given TN. The following data elements are displayed:
- TN
- Status
- NPAC SPID (NPAC SPID TN Owner )
- NPAC Company Name
- BILLINGID: This value may be blank.
- ENDUSERLOCATION: This value may be blank.
- ENDUSERLOCATIONTYPE: This value may be blank.
Back to Top Back to Port PS "Search Results" Help Back to TN Query Results
- IP Fields TAB -
The IP Fields TAB contains 3 NPAC fields where a URI was populated for a TN. URIs are used for IP routing.
. The following data elements are displayed:
- TN
- Status
- NPAC SPID (NPAC SPID TN Owner )
- NPAC Company Name
- Voice URI: This value may be blank.
- MMS URI: This value may be blank.
- SMS URI: This value may be blank.
Back to Top Back to Port PS "Search Results" Help Back to TN Query Results
- Thousands Block Query Results -
The results of a thousands block query identify ownership information about the block and code as well as identifying TN information of all the ported TNs within the block. Information like the current owner of the TN and code/block information as well as other details, such as the SV Type are also displayed for ported TNs. There are 2 results tables for a Thousands Block query. The Block Table displays information about the Block that was queried. The Ported TNs in Block table displays information only on the TNs in the queried NPA-NXX-X (block) that have been ported. TNs that have not been ported are not in this table.
- Block Table -
The Block Table displays information about the Block that was queried.
Back to Top Back to Thousands Block Query Results
- Block Table, Pooling Administration TAB -
The Pooling Administration TAB contains block information contained in the Pooling Administration System.
Important : If you see the following note on a tab "NPA-NXX-X < > is not in PAS ", the NPA-NXX-X (block) you entered has not been entered into pooling and therefore those data elements will not be displayed.
The following data elements are displayed on this tab:
- Block
- Block Owner
- Block Owner OCN
- Status (Block Status )
- Effective Date: The date the Block became effective in PAS.
- Contaminated (Contaminated Block ): The Contaminated value comes directly from the Pooling Administration. It is dependent on the values the Service Providers give to the Pooling Administration.
Back to Top Back to Thousands Block Query Results Back to Block Table
- Block Table, Geography TAB -
The Geography TAB contains geographic information about the block that was queried. The following data elements are displayed on this tab:
Back to Top Back to Thousands Block Query Results Back to Block Table
- Block Table, NANPA TAB -
The NANPA TAB contains code ownership information for the block that was queried. The following data elements are displayed on this tab:
Back to Top Back to Thousands Block Query Results Back to Block Table
- Block Table, NPAC TAB -
The NPAC TAB contains routing information about the block that was queried. The following data elements are displayed on this tab:
- Block
- Active: An indicator of whether the Block is active in the NPAC. A Yes value means the block is active in the NPAC. A No value means the block is not active in the NPAC. If the block is not active in the NPAC, all other NPAC data elements will be blank.
- LRN (LRN-Block) : If the block is not active in the NPAC this field will be blank.
- Block p-LRN: If the block is not active in the NPAC this field will be blank.
- SPID (NPAC SPID Block Owner ): If the block is not active in the NPAC this field will be blank although the Code (NPA-NXX) may still be active in the NPAC.
- ALT SPID: If the block is not active in the NPAC this field will be blank. If there is no Alt SPID for the Service Provider, this field will be blank.
- ALT SPID Company Name: This value can be seen by using your mouse to hover over the Alt SPID value in the results table for each block.
- Last ALT SPID: If the block is not active in the NPAC this field will be blank.
- Last ALT SPID Company Name: This value can be seen by using your mouse to hover over the Last Alt SPID value in the results table for each block.
Back to Top Back to Thousands Block Query Results Back to Block Table
- Ported TNs in Block Table -
The Ported TNs in Block table displays information only on the TNs in the queried NPA-NXX-X (block) that have been ported. TNs that have not been ported are not in this table. The number of ported TNs returned in the query are displayed in parenthesis next to the table name.
- Ported TNs in Block Table, Ownership TAB -
Details about the owner of the phone number are returned for every TN returned in the query. The following data elements are displayed:
- Phone Number (TN) : The Phone Number value is displayed as a link on this tab. Clicking this link opens the porting history for the TN.
- Status
- NPAC SPID (NPAC SPID TN Owner)
- Company (NPAC Company Name )
- ALT SPID: If there is no Alt SPID for the Service Provider, this field will be blank.
- ALT SPID Company Name: This value can be seen by using your mouse to hover over the Alt SPID value in the results table for each TN.
- Last ALT SPID: If there is no Last Alt SPID for the Service Provider, this field will be blank.
- Last ALT SPID Company Name: This value can be seen by using your mouse to hover over the Last Alt SPID value in the results table for each TN.
- NANPA OCN
- NANPA OCN Name: This value can be seen by using your mouse to hover over the NANPA OCN value in the results table for each TN.
- SV Type
Back to Top Back to Thousands Block Query Results Back to Ported TNs in Block Table
- Ported TNs in Block Table, Geography TAB -
The Geography Tab contains geography information for every TN returned in the query. The following data elements are displayed:
Back to Top Back to Thousands Block Query Results Back to Ported TNs in Block Table
- Ported TNs in Block Table, Routing TAB -
The Routing Tab contains routing information for every TN returned in the query. The following data elements are displayed:
- TN: The Phone Number value is displayed as a link on this tab. Clicking this link opens the porting history for the TN.
- Status
- NPAC SPID (NPAC SPID TN Owner)
- NPAC Company Name
- LRN (LRN-TN)
- CLASS DPC/SSN
- LIDB DPC/SSN
- ISVM DPC/SSN
- CNAM DPC/SSN
- WSMSC DPC/SSN
Back to Top Back to Thousands Block Query Results Back to Ported TNs in Block Table
- Ported TNs in Block Table, Code/Block Info TAB -
The Code/Block Info TAB contains code and block information for every TN returned in the query. It is important to note that while this tab is displayed using TNs as the identifier, the information in it is at the Code and Block Level even when the TN has been ported. All TNs with the same Block (NPA-NXX-X) will have the same block data element information. All TNs with the same Code (NPA-NXX) will have the same code data element information. For example, given the following TNs: 516-244-1234, 516-244-1573, 516-244-4567 and 516-581-2345
- 516-244-1234 and 516-244-1573 will have the same block data elements and the same code data element
- 516-244-1234, 516-244-1573, 516-244-4567 will have the same code data elements, but 516-244-4567 will have different block data elements from the other two TNs (assuming the code and block owners are different).
- 516-581-2345 has different code and block data elements from the other TNs.
The following data elements are displayed:
- TN
- Status
- NANPA Code Owner
- PAS Block Owner
- OCN (Block Owner OCN )
- OCN Name (Block Owner OCN Name )
- Status (Block Status)
- Effective Date: The date the Block became effective in PAS.
- NPAC Code Owner
- ILEC/RBOC for Rate Center: If your account is not LERG enabled, a note will be displayed indicating that LERG is required
Back to Top Back to Thousands Block Query Results Back to Ported TNs in Block Table
- Ported TNs in Block Table, Additional Fields TAB -
The Additional Fields TAB contains 3 "open" fields that are part of an NPAC record. These "open" fields do not have a set definition for what type of data is populated into the fields. You may use these fields at your discretion to add information about a given TN. The following data elements are displayed:
- TN
- Status
- NPAC SPID (NPAC SPID TN Owner )
- NPAC Company Name
- BILLINGID: This value may be blank.
- ENDUSERLOCATION: This value may be blank.
- ENDUSERLOCATIONTYPE: This value may be blank.
Back to Top Back to Thousands Block Query Results Back to Ported TNs in Block Table
- Ported TNs in Block Table, IP Fields TAB -
The IP Fields TAB contains 3 NPAC fields where a URI was populated for a TN. The following data elements are displayed:
- TN
- Status
- NPAC SPID (NPAC SPID TN Owner )
- NPAC Company Name
- Voice URI: This value may be blank.
- MMS URI: This value may be blank.
- SMS URI: This value may be blank.
Back to Top Back to Thousands Block Query Results Back to Ported TNs in Block Table
- Code Report Query Results -
The results of a code report query identify the code owner in NANPA and the NPAC, geography information and routing information. Pooling Administration ownership information for blocks under the code and whether the block is contaminated is also displayed. There are 2 results tables for a Code Report query. The Code (NPA-NXX) table displays information about the code that was queried. The Blocks for Code table displays information about the blocks within the code that was queried.
- Code Table -
The Code table displays the following data elements:
- NPA-NXX
- NANPA
- NPAC
- Geography
- Routing
- ILEC/RBOC for Rate Center: If your account is not LERG enabled, a note will be displayed indicating that LERG is required.
Back to Top Back to Code Report Query Results
- Blocks for Code Table -
The Blocks for Code table displays the following data elements:
- NPA-NXX-X
- Pooling Administration: Important
: If you see the following note "NPA-NXX-X < > is not in PAS
", the NPA-NXX-X (block) has not been entered into pooling and therefore those data elements will not be displayed.
- OCN (Block Owner OCN)
- OCN Name(Block Owner OCN Name)
- Status (Block Status)
- Effective Date: The date the Block became effective in PAS.
- Contaminated (Contaminated Block ) : The contaminated value comes directly from the Pooling Administration. It is dependent on the values the Service Providers give to the Pooling Administration.
- NPAC
- Active: A flag indicating whether the Block is active in the NPAC
- LRN (LRN-Block)
- Block-pLRN
- SPID (NPAC SPID Block Owner)
- ALT SPID: This field may be blank if there is no Alt SPID for this TN.
- ALT SPID Company Name: This value can be seen by using your mouse to hover over the Alt SPID value in the results table for each TN.
- Last ALT SPID: This field may be blank if there is no Last Alt. SPID for this TN.
- Last ALT SPID Company Name: This value can be seen by using your mouse to hover over the Last Alt SPID value in the results table for each TN.
Back to Top Back to Code Report Query Results
- Porting History -
For Queries that return TN records, TN porting history is available. Only the most current TN record value is displayed in the search results. Clicking the TN link in the table will display the porting history for the TN. Values are displayed at the time the event occurred for the following data elements:
- Date: The date the event happened.
- Event: The action that occurred on the TN.
- Status (Porting Status)
- NPAC SPID(NPAC SPID TN Owner)
- NPAC Company Name: This value can be seen by using your mouse to hover over the NPAC SPID value in the results table for each TN.
- ALT SPID: This field may be blank if there is no Alt SPID for this TN.
- ALT SPID Company Name: This value can be seen by using your mouse to hover over the Alt SPID value in the results table for each TN.
- Last ALT SPID: This field may be blank if there is no Last Alt SPID for this TN.
- Last ALT SPID Company Name: This value can be seen by using your mouse to hover over the Last Alt SPID value in the results table for each TN.
- NANPA OCN
- NANPA OCN Name: This value can be seen by using your mouse to hover over the NANPA OCN value in the results table for each TN.
- LRN (LRN-TN): The LRN field will be blank if the TN is a Native number.
- SV Type: This value will be blank if the TN is a native number.
- DPC/SSNs:
- IP Fields:
- Download a Query -
Query results may be downloaded to an excel file.
- If TN results will be downloaded, first specify whether you want to include porting history for the TNs. To include them, click the Include TN History checkbox to mark it as checked. To not include TN porting history, leave the include TN History checkbox as unchecked.
- Click the Export to Excel link.
Note : In an Excel download with TN porting history, the current TN record value is the first record and displays the TN. All historical records are displayed immediately under the first record as sub-records.