Real Intelligence. Better Decisions.™

Neustar solutions ensure you have accurate, timely, reliable and relevant information to make the best decisions for your organization.

To learn more about our solutions that support your entire subscriber lifecycle, please tell us about yourself or call us at +1-877-831-3984

 
 
 
 

*Required Fields

Select the solution(s) you would like to learn about

NUMBER MANAGEMENT REGULATORY COMPLIANCE
     

Thanks for Your
Interest in Neustar

One of our representatives will contact you soon with helpful resources and information on Neustar solutions for your business.

Query Manager Help

Query Manager (QM) is a tool that offers extensive querying capabilities against industry data sources. QM allows the user to use pre-defined queries or to create custom queries at the TN, Block, or Code level using many different parameters. Click the link below to go directly to a specific Query Manager topic.

 

Create Query Project

View Project Results

Download Results Tree (all nodes)

Create Download Results (one for each node)

Clone a Query

Re-Execute a Query

Schedule a Previously Executed Query

Delete a Query

Email Query Results

Use Pre-defined Query Projects

 

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

 

- Create Query Project -

Performing a query in Query Manager requires 3 steps. You must complete all 3 steps to produce the desired output. Click a link below to go directly to that help topic.

Step 1: Select Report Type 

Step 2: Select Optional Query Parameters

Step 3: Define Display Results

 

Schedule a Query

 

- Step 1: Select Report Type -

In this step, you define the type of report you are creating by specifying a query name, the level of reporting, where the data will come from, and what type of report you want.  

Query Name:

Choose and enter a descriptive name for the query. This query name is displayed in the list of all query projects. The query's name is the best way to find a previously executed query. In addition, other QM users within the same account can also find and access queries by locating the named query.

Report On:

The desired level of the TN in your report output. Reports can be generated at the following levels:

  • NPA- NXX-XXXX (TN)
  • NPA- NXX-X (Block)
  • NPA-NXX (Code)

 

Restrict Results To :

Where the data for your report comes from. The data used in the report can come from:

  • An uploaded file of TNs (TN List), Blocks (NPA-NXX-X list), or Codes (NPA-NXX list)
  • SPID or OCN IDs (My TN Inventory)
  • NANPA OCN's (My Code-Level assets)
  • PAS OCN's (My Block Level Assets)

 

Choose one of the following input/boundaries for the query. The values entered here determine the data range for the query. The available choices for restrictions change depending on the level of numbering (TN, Block, Code) you chose to report on in the previous entry field. Each of the 4 options in the Restrict Results To section is described in the table below.

  • TN List/NPA-NXX-X List/NPA-NXX list (Upload a file)
  • My TN Inventory (select from a list of SPID/OCNs)
  • My Code Level Assets (select from a list of SPID/OCN's)
  • My Block Level Assets (select from a list of SPID/OCN's)

 

TN List

NPA-NXX-X List 

NPA-NXX List

Choosing this option means that you will upload a file containing the list of data the query will process.

  • TN List: This option is available if TN level reporting is chosen. This allows you to upload a saved file of TNs.
  • NPA-NXX-X list : This option is available if Block level reporting is chosen. This allows you to upload a saved file of NPA-NXX-Xs (blocks).
  • NPA-NXX List: This option is available if Code level reporting is chosen. This allows you to upload a saved file of NPA-NXXs (codes).

 

Files may be uploaded in the following formats:

  • Excel (either .xls or .xlsx),
  • Text file (.txt),
  • Comma separated value file (CSV).

 

File Format Restrictions:

  • QM expects the list of TN/NPA-NXX-X/NPA-NXX's to be in the first column of the file.
  • QM accepts multiple formats. Spaces, dashes, parenthesis, etc. may be placed between NPA, NXX, XXXX or no spaces is acceptable, i.e. 555-123-1111 or 5551231111.
  • QM requires that TN/NPA-NXX-X/NPA-NXX's be stored as numeric values if uploading from an excel file.

 

Note: If a single TN within a file is in an unacceptable format or doesn't contain enough digits, the file may upload successfully, ignoring the invalid TN. For example, if the uploaded file contains 1000 TNs and 10 of them are invalid, the results of the query only execute on 990 TNs.

 

My TN Inventory

This option is available when TN level reporting is chosen. It allows you to select SPIDs or OCNs from a list of available values.

  • SPID Values are listed in Blue
  • OCN Values are listed in Red
  • SPID/OCN Values are listed in Purple

 

Check the box next to the desired SPID or OCN to include it in the report. 

 All TNs within the selected SPID/OCNs that are still owned by the code or block owner are reported on. TNs that are not still owned by the code or block owner do not appear in the report.

 

My Code Level Assets

This option is available when TN, Block, or Code level reporting is chosen. It allows you to select NANPA OCN's from a list of available values.

The Code asset report is designed to accept OCN's as inputs. Codes are tracked by OCN versus the NPAC's SPID identifier.

Check the box next to the desired OCN to include it in the report. 

 Note: The Code asset report, unlike My TN Inventory reports return results for all TNs (or blocks) within a code even if that TN is no longer owned by the code owner.

 

My Block Level Assets

This option is available when TN or Block level reporting is chosen. It allows you to select PAS OCNs from a list of available values.

The Block asset report is designed to accept OCN's as inputs. Blocks are tracked by OCN versus the NPAC's SPID identifier.

Check the box next to the desired to include it in the report. 

Note: Block asset reports, unlike My TN Inventory reports return results for all TNs within a block even if that TN is no longer owned by the block owner.

 

Report Type:

Specify the desired type of report results. Query results may be either summary or detailed. Running a summary report minimizes run time because actual TNs/blocks/codes are not being pulled.

Choose whether you would like the output of the query to be in Summary form (counts) or in Detailed form (individual TNs/Blocks/Codes). Options are:

 

View Summary Report Choose this report type to get a summary level TN count given the query criteria. This report type minimizes query run time because QM does not actually pull the individual TNs, but rather counts the occurrences and organizes them based your input for the displayed fields.  You can subsequently get the individual TNs that a Summary Report generates.

Download TNs

Download Blocks

Download Codes

Choose this report type to have QM generate a report of the individual TNs/Blocks/Codes. This report type may take longer to execute than a Summary Report. However, if the ultimate desire is to get a list of TNs/Blocks/Codes as output, you do not have to run a Summary Report first. Refining the query by using the parameters to narrow the report results helps keep query run time down.

 

Click the desired options in each section.  When you have completed specifying the type of report you are creating, click Select Optional Query Parameters  to move on to the next step.

Back to Top  Back to Create Query Project

 

- Step 2: Select Optional Query Parameters -

This step enables you to narrow the search for TNs, Blocks, or Codes. Providing values and choices for query parameters enables you to home in on the exact set of TNs that are desired.

Specifying a value for each parameter is optional. All values default to "Don't use", meaning the parameter will not be used to narrow the results of the report.  The query parameters are organized as links on the left side of the screen, into the following 8 categories. 

  • Ownership
  • Geography
  • Numbering
  • Pooling
  • LNP
  • IP Fields
  • Facilities
  • Calculated Fields

 

To select optional query parameters:

1. Click a category link (on the left side of the screen) to reveal the available parameters in that category.

2. Click a parameter (on the right side of the screen) to reveal the available values for the parameter. For definitions of each parameter, see the Glossary.

3. To include the parameter in the report, click the Select  radial button.  A list of available options for that parameter is displayed (Not Equal To, is Null, Is Not Null).

4. Click the drop down arrow to select or deselect values for the parameter by clicking the box next to each value.  Note :  For some parameters, you may need to type your desired values directly into the space available. 

• To enter multiple value options for the same parameter, separate the values using commas (,).

5. When you have completed specifying the parameters for your query, click Define Display Results  to move on to the next step.

 

Back to Top  Back to Create Query Project

 

- Step 3: Define Display Results -

This step provides a quick summary of the query that you defined. It also provides you with the ability to customize the way the report is displayed. You choose what data should be displayed as output fields and in what order they should be displayed. The TN/Block/Code values will always be displayed in the column A, the first column. You specify what data will be in column B, C, etc.  

Selecting the display fields and sort order is independent of defining the query criteria.  You can select many different fields to add information about the TNs that are returned for the query.

 

Summary Report Types

Based on the optional query parameters selected in step 2, QM automatically selects those fields for display. You may deselect those fields if desired and may add additional fields by clicking and dragging the fields or using the directional arrows.

 

Download  Report Types

You select the fields you want to display and then select a maximum of 3 values you want to sort by. 

To select fields for display, click a category link to reveal the available parameters in that category, then check the box next to the parameter you want to include.

 

To specify sort order:

1. For Download report types, you may elect to include a header row at the top of the downloaded TN file by selecting the header row checkbox.

2. Click on the right and left arrows in the center to move values back and forth between the Available and Selected columns (This can also be done by dragging the value from one column to another).

3. Highlight the value in the Selected column and use the up and down arrows in the center to move that value higher or lower on the list. The order of the values in the Selected list is the order in which they are displayed in the report. Column A will always contain the TN. Block/Code values.  The first data element in your list will be in column B, the second, in column C, and so on.    A Clear button at the bottom of the screen allows you to clear all selected fields if desired.

4.  If you do not want to run the query immediately, but would rather schedule the query to run at a later date and time, Schedule a Query.

After selecting the fields for display and determining the sort order for your report, click Submit Query to execute the query.  QM provides a brief confirmation message that the query has been submitted and that you are will be notified via email when your query is completed.

 

Back to Top  Back to Create Query Project

 

- Schedule a Query -

Once you have created a query, but before you submit the query, you may schedule it to run at a future date/time.  To schedule a previously executed query to run again (or multiple times) with current data, see section Schedule a Previously Executed Query. 

To schedule a query that has not yet executed: 

1. From the Define Display Results  screen, click the Click Here to Schedule the Query  link.

2. Select the Date you want the Query to run.

3. Select the Time you want the Query to run.

4.  Select a frequency or reoccurrence of the scheduled report from the Repeats drop down box if desired.

  • Select Does Not Repeat  to schedule the query to run only once, at the date and time you specified. 
  • If you select Weekly , choose the day of the week you would like the report to run on each week.  You may choose more than one day a week. 

 

5.  Optionally enter one to many email addresses where you would like the results of your query to be emailed in the Email List  field. Separate multiple email addresses with a comma.

6.  Optionally enter text to be included in the email in the Note to Include in Email  field.

7.  Click Submit Scheduled Query  to submit the query.  Note :  The query will not run for the first time until the date and time you specified in the query.  If you want the query to execute immediately and to schedule it to run again at a later time, remove the scheduling and see Schedule a Previously Executed Query.

 

Back to Top  Back to Create Query Project

 

- View Project Results -

To view queries that have been completed, click the View Project Results option on the green task bar.  QM displays a summary list of all submitted and completed query projects.  The screen defaults to show only queries created by you.  Click the drop down arrow to change the display to show all queries for all users within your organization.

A status is displayed next to each query that hasn't completed, indicating whether the query project is "Pending" or "Processing". Completed Queries display the type of query and date and time of execution.  To view a specific completed query, find the named query in the list of projects and click on the report type link or the more results link in the Most Recent Result column.

When the most recently run, completed, query result associated with a Query Project is older than 6 months (approximately), the Query Project is archived and no longer displayed in the Query Project list.  All results associated with the Query Project are also archived. For Scheduled Queries, 2 archiving rules apply:

  • If a query result is older than approximately 6 months, the query result is archived and no longer displayed in the result list for the project. 
  • Any given query project may not have more than 60 results associated to it at one time.  When more than 60 results (approximately) are created for a query project, the archive process will archive the oldest query so only 60 remain in the Result list. 

 

Archived Queries may be restored to the Query Project List only by a direct request to Neustar via the helpdesk.

Click a link below to go directly to that help topic.

Summary 

Download 

More Results

 

Back to Top  Back to View Project Results

 

- "Summary" Query Project Results -

The Summary Query Project Results screen for a Summary query type displays the following information:

 

Execution Information

At the top of the page, information about who submitted the query, and when it was executed is displayed. This tells you how recent the summary results information in the report is.

 

Action Buttons

Allow the query to be: Cloned, re-executed, scheduled for a future date, or deleted.

 

Query Information

  In the middle of the screen, the parameters of the query and the selected display fields are displayed. This tells you exactly what the report results came from.

 

Summary Results

Towards the bottom of the screen, QM provides a results tree with summary totals that can be expanded and contracted to allow you to see subsets of TNs based on the display fields selected and organized during the definition of the query.

 

Download Action Buttons

At the bottom of the screen, there are 2 action buttons that allow you to perform further actions on the report you are viewing.

 

 

Back to Top  Back to View Project Results

 

- "Download" Query Project Results -

The Download Query Project Results page for a Download query type displays the following information:

 

Execution Information

At the top of the page, information about who submitted the query, and when it was executed is displayed. This tells you how recent the summary results information in the report is.

 

Query Information

In the middle of the screen, the parameters of the query and the selected display fields are displayed. This tells you exactly what the report results came from.

 

Summary Results

Towards the bottom of the screen, QM provides a list of the fields that are displayed in the results file.

 

Download link

Click this link to open or save the results file for your query.

 

Action Buttons

  At the bottom of the screen, there are 5 action buttons that allow you to perform further actions on the report you are viewing. 

 

 

 

Back to Top  Back to View Project Results

 

- "More Results" Query Project Results  -

Clicking a more results link in the Most Recent Result  column opens the Detailed Download Query Project Results which were created when you used the download action buttons or re-executed results.  These detailed downloads create a new query result under the original overall query project.  This screen displays a list of the detailed download query results associated with the original query. This screen also allows you to Re-execute, schedule, clone, or delete the query results.

Access the Detailed Download Query Results by clicking the Result Name or the Result Type  link for the report you wish to view. This opens a Download Query Project view of the query results.

 

Back to Top  Back to View Project Results

 

- Download Results Tree (all nodes) -

Click the Download Results Tree (all nodes) button to  generate an output file that contains summary TN Counts given the selected display fields and the sort order. The report provides all the information that is contained in the results tree regardless of what is expanded or highlighted on the results tree.

Note: Creating a download result from the summary results node(s) is creating a new query request.  Each time a new query result is created and submitted, QM executes a new query and uses the most current source data contained in QM.  Be aware of this feature because downloaded results can differ from the initial summary results if there is significant elapsed time between the time of the summary query and the time of the requested downloaded result.

 

Back to Top  Back to View Project Results Back to Summary Reports Results

 

- Create Download Results (one for each node)-

Click Create Download Results (one for each node) to create a new query to find and list out the exact TNs that are displayed in specific, selected, result node(s) of the results tree. 

Navigate the results tree by clicking on the plus (+) signs next to the grouped results and expand the sections.  Click on the desired nodes to highlight them.

Results will show the specific TN lists on the highlighted nodes. If a single node is highlighted, a single new query is created. When multiple nodes are selected, multiple new queries are created; one for each node. You are prompted to enter a name for the new download. If multiple queries are created, they all have the name provided for that download.

Note: Creating a download result from the summary results node(s) is creating a new query request.  Each time a new query result is created and submitted, QM executes a new query and uses the most current source data contained in QM.  Be aware of this feature because downloaded results can differ from the initial summary results if there is significant elapsed time between the time of the summary query and the time of the requested downloaded result.

 

Back to Top  Back to View Project Results Back to Summary Reports Results

 

- Clone a Query -

You may "clone' or copy an existing query project and make changes to that query from the Summary or Download Query Project Results screen or the Detailed Download List view of the query results.   

This feature is useful for saving time when creating new queries that are similar, but not exactly the same as a previous query. When cloning a query, QM keeps all the same query criteria and display results as the cloned query and then allows you to make adjustments and/or additions to those criteria. Cloning a query creates a new query project so you are asked to provide a new name.  

Click Clone to initiate the cloning process.

Cloning a query takes you through the same screens as the initial creation of the query however the values selected in the original query set up are defaulted. After creating a new Query Project name, you may make changes by navigating through the Create a Query screens and making updates.

 

Back to Top  Back to View Project Results

 

- Re-execute a Query -

You may re-execute a query result for a date and time in the future from the Summary or Download Query Projects Results screen or the Detailed Download List view of the query results. 

Re-executing the query result does not change any query definition parameters or display fields. It simply re-runs the query against the most current data that QM contains. This is useful if you want to get an update of results that takes into account the porting and pooling activity that has occurred since the query originally completed. The re-executed results are listed as a new query result under the initial query project so that the user can track the various results.

 

1. Click Re-Execute Result  to re-execute a query result.

2. Confirm you want to perform the re-execute action before the query executes.

 

 

Back to Top  Back to View Project Results

 

- Schedule a Previously Executed Query -

You may schedule a previously executed query result from the Summary or Download Query Project Results screen or the Detailed Download List view of the query results.   This function is useful if the same query is run regularly to get current data. Queries may be scheduled to run one time or regularly at a desired frequency.  To schedule a query to run for the first time (not immediately upon submission) see Schedule a Query.

 

1. Click Schedule Result  to initiate the scheduling process.

2. Enter a date and time for the query to execute.

3. Select a frequency or reoccurrence of the scheduled report from the Repeats drop down box if desired.

4. Click Schedule Result to complete the scheduling process.

 

Scheduled queries are displayed in the View Project Results Summary list  page as a pending query. Only the next query scheduled to execute will display. For example, if a query is scheduled to execute every week, the current week's query displays as Pending until it executes. After it executes, that query displays with the date and time of execution, and the next week's scheduled query displays as pending.

To stop a future scheduled query from executing, simply delete the pending query.  Deleting the pending query deletes all associated scheduled queries.

 

Back to Top  Back to View Project Results

 

- Delete a Query -

You may delete a query from the Summary or Download  Query Project Results screen or the Detailed Download List view of the query results. 

Click Delete Result to  remove the selected query result from a given project. If there are multiple query results under a given query project, only the selected query result under that query project is deleted and other query results are not impacted.

You are prompted to confirm the delete action before it actually occurs.

 

Back to Top  Back to View Project Results

 

- Email Query Results -

You may generate an email containing the results of the query from the Summary or Download Query Project Results  screen.  Click the Email Result  function to send a one-time email with the results of the query and a note, to a list of user entered email addresses.

1.  Click Email Result  to open a new section where you enter email address details.

2.  In the Email List  section, enter one to many email addresses where you want the link to the results to go.  Multiple email addresses should be separated by a comma.

3.  Optionally, enter a note for the reader in the Note to include in email  section.

4.  Click Send to generate the email or Cancel to not send an email.

 

Back to Top  Back to View Project Results

 

- Use Pre-defined Query Projects -

You may select one of the pre-defined reports and quickly enter a few key inputs and QM creates a report without requiring you to specify the various query criteria, display options, and sorting orders.

1. To select a pre-defined report, select the Use Pre-Defined Query Projects from the Query Manager main menu.

2. Click on the desired pre-defined report from the Report Type  column.

 

Click a link below to go directly to the help information for that report.

Basic Information for TN List

TN Report by Specific LRNs

LRN by SPID or NPA-NXX

TN Port Out Activity

TN Port In Activity

Compare Industry Sources

TN Inventory Report

Summary DPC Information

LRN History

Block Utilization Report

Block Utilization Trending Report

Rate Center Utilization Threshold Report

Historical Port Ins from Blocks and Codes Report

Historical Port Outs from Blocks and Codes Report

Ported TNs From Block(s)

 

- Basic Information for TN List -

This report is useful for uploading a list of TNs stored in a file and getting general information about the uploaded list of TNs.

The results of this query display the following information:

TN, TN Type, NPAC Code SPID, TN SPID, TN ALTSPID, Region, State, LATA, Rate Center, TN LNP Type, TN Activate Date, TN Activate Time, TN LRN.


The following file formatting rules apply:

  • Excel (either .xls or .xlsx), Text file (.txt), or Comma separated value file (CSV).
  • The list of TNs must be in the first column of the file.
  • Spaces, dashes, parenthesis, etc. may be placed between NPA, NXX, XXXX or no spaces is acceptable, i.e. 555-123-1111 or 5551231111.
  • TNs must be stored as numeric values if uploading from an excel file.

 

Note : If a single TN within a file is in an unacceptable format or doesn't contain enough digits, the file may upload successfully, ignoring the invalid TN. For example, if the uploaded file contains 1000 TNs and 10 of them are invalid, the results of the query only execute on 990 TNs.

To execute the Basic Information for TN list Report:

1. Enter a Query Name for the File.

2. A Browse button allows you to search directories on your computer for the file you want to upload.

3. Click Run Report.

4. Go to View Project Results to see the results of the query.

 

Back to Top  Back to Use Pre-defined Query Projects

 

- TN Report by Specific LRNs -

The TN Report by Specific LRNs provides a quick way to get a report on all TNs that are associated with a given LRN(s).

The results of this query display the following information:

TN or Block, TN Type, Region, State, LATA, LRN, TN Count.


To execute the TN Report by Specific LRNs Report:

1. Create a new Query Project name.

2. Select the desired SPID/OCN(s).

3. Enter the desired LRN(s). Multiple LRNs can be entered either sequentially by rows or separated by commas. LRNs can also be copied and pasted from other applications into the input box.

4. If desired, narrow the TN Type (ported or pooled), and/or the NPAC region. Query time is reduced when the parameters are narrowed.

5. Click Run Report.

6. Go to View Project Results to see the results of the query.

 

Back to Top  Back to Use Pre-defined Query Projects

 

- LRN by SPID or NPA-NXX -

The LRN by SPID report provides a list of LRNs that are associated with the entered SPIDS or NPA-NXXs.

The results of this query display the following information:

LRN By SPID: LRN, SPID, Region, State, LATA, Rate Center, # of Ported TNs, # of Pooled TNs, # of Total TNs.

NPA-NXX by SPID: NPA-NXX, SPID, Region, State, LATA, Rate Center.


To execute the LRN by SPID or NPA-NXX Report:

1. Create a new Query Project name.

2. Type the desired SPIDs or click the Add my SPIDs checkbox to add all of your SPIDs.

3. Type in the desired NPA-NXXs.

4. Click Run Report.  

5. Go to View Project Results to see the results of the query.

 

Back to Top  Back to Use Pre-defined Query Projects

 

- TN Port Out Activity -

The TN Port Out Activity report provides a list of TNs that have been ported out for a given SPID during a specific timeframe.

The results of this query display the following information:

TN, Region, State, LATA, Rate Center, Port Activity Type, Port Date, Port Time, Old SPID, New SPID, TN LRN


 To execute the Tn Port Out Activity Report:

1.  Create a new Query Project name.

2.  Select the desired SPIDs to report on by clicking the checkbox next to the SPID.

3.  Select the type of TN Port activity you would like to report on.

 

Inter-SPID Port Outs

Inter-SPID Port Outs reflect activity when the old SPID value is different than the new SPID value.  QM reports porting activity between two SPIDs as competitive even in circumstances when the same service provider owns both SPIDs.

Click this option to include all Inter-SPID Port Outs.

  • Inter SPID Port Out:   Select this option to see inter-SPID ports that occurred when the old SPID was neither the code or block owner, but the old SPID did have an individual TN record in the NPAC.
  • Inter-SPID Port Out from Block:   Select this option to report on port out activity when the old SPID was the block owner.
  • Inter- SPID Port out from Code:   Select this option to report on port out activity when the old SPID was the code owner.
  • TN Disconnected - snapped back to Block with different SPID:   Select this option to report on when an individual TN record in the NPAC was owned by the old SPID, but was removed from the NPAC and snapped back to the original block owner.
  • TN Disconnected - snapped back to Code with different SPID:   Select this option to report on when an individual TN record in the NPAC was owned by the old SPID, but was removed from the NPAC and snapped back to the original code owner.
Intra-SPID Activity

Intra-SPID Activity reflects activity when the old and new SPID values are the same. 

Click this option to include all Intra-SPID Port Outs.

  • TN Disconnected - snapped back to Block with same SPID:   Select this option to report on TN snap backs to blocks when the old and new SPIDs are the same.
  • TN Disconnected - snapped back to Code with same SPID :  Select this option to report on TN snap backs to codes when the old and new SPIDs are the same.
  • Block Disconnected - TN snapped back to Code with same SPID:   Select this option to report on
  • Block Disconnected - TN snapped back to Code with different SPID:   Select this option to report on

 

4.  Enter a date range to report on or select from available ranges. The start time for the report will be 12:00am of the previous night.

Important:  You may not run this report on a date range that is longer than 3 months to prevent overly long execution times. Even when the requested date range is less than 3 months, you should plan for queries to take considerable time and assume that your query may take up to 24 hours.  

5.  Click Run Report .

6.  Go to View Project Results to see the results of the query.

 

Back to Top  Back to Use Pre-defined Query Projects

 

- TN Port In Activity Report -

The TN Port Out Activity report provides a list of TNs that have been ported into a  given SPID during a specific timeframe.

The results of this query display the following information:

TN, Region, State, LATA, Rate Center, Port Activity Type, Port Date, Port Time, Old SPID, New SPID, TN LRN.


To execute this report:

1. Create a new Query Project name.

2.  Select the desired SPIDs to report on by clicking the checkbox next to the SPID.

3.  Select the type of TN Port activity you would like to report on.

 

Inter-SPID Port Ins:

Inter-SPID Port outs reflect activity when the old SPID value is different than the new SPID value.  QM reports porting activity between two SPIDs as competitive even in circumstances when the same service provider owns both SPIDs.

Click this option to include all Inter-SPID Port Outs.

  • Inter SPID Port Out:   Select this option to see inter-SPID ports that occurred when the old SPID was neither the code or block owner, but the old SPID did have an individual TN record in the NPAC.
  • Inter-SPID Port Out from Block:   Select this option to report on port out activity when the old SPID was the block owner.
  • Inter- SPID Port out from Code:   Select this option to report on port out activity when the old SPID was the code owner.
  • TN Disconnected - snapped back to Block with different SPID:   Select this option to report on when an individual TN record in the NPAC was owned by the old SPID, but was removed from the NPAC and snapped back to the original block owner.
  • TN Disconnected - snapped back to Code with different SPID:   Select this option to report on when an individual TN record in the NPAC was owned by the old SPID, but was removed from the NPAC and snapped back to the original code owner.
Intra-SPID Activity

Intra-SPID Activity reflects activity when the old and new SPID values are the same. 

Click this option to include all Intra-SPID Port Outs.

  • TN Disconnected - snapped back to Block with same SPID:   Select this option to report on TN snap backs to blocks when the old and new SPIDs are the same.
  • TN Disconnected - snapped back to Code with same SPID :  Select this option to report on TN snap backs to codes when the old and new SPIDs are the same.
  • Block Disconnected - TN snapped back to Code with same SPID:   Select this option to report on
  • Block Disconnected - TN snapped back to Code with different SPID:   Select this option to report on

 

4.  Enter a date range to report on or select from available ranges. The start time for the report will be 12:00am of the previous night.

Important:  You may not run this report on a date range that is longer than 3 months to prevent overly long execution times. Even when the requested date range is less than 3 months, you should plan for queries to take considerable time and assume that your query may take up to 24 hours.  

5.  Click Run Report.

6.  Go to View Project Results to see the results of the query.

 

Back to Top  Back to Use Pre-defined Query Projects

 

- Compare Industry Sources -

The Compare Industry Sources Report provides a comparison of ownership information at either the code or block level between NANPA, Pooling, NPAC and LERG.

Note: The Service Provider must be providing LERG data to Neustar in order to see the LERG related values in this report.

The results of this query display the following information:

NPA-NXX-X, PAS OCN, NPAC SPID Blk Owner, LERG OCN, LERG AOCN, LERG Block ID, LERG Portable, LERG 1000 Blk, NANPA OCN, Region, State, LATA, Rate Center.


To execute this report:

1. Create a new Query Project name.

2. Enter SPIDs or OCNs for the comparison.

3. Select the desired level of ownership information to compare.

4. Click Run Report .

5. Go to View Project Results to see the results of the query.

 

Back to Top  Back to Use Pre-defined Query Projects

 

- TN Inventory Report –

The TN Inventory Report  provides a snapshot of the TNs currently owned by the selected SPIDs and OCNs. If you want to include native OCNs that are not in the NPAC, you must include the OCNs of the desired native TNs.

This report is useful as a starting point to perform further drill downs on groups of TNs.

The results of this query display the following information:

Region, TN SPID, TN Type, State, LATA, Rate Center, TN LRN, TN CLLI Code, TN Tandem, Count.


To execute this report:

1. Create a new Query Project name.

2. Select the desired OCNs. OCN values are required in order to return results for native TNs.

3. Select desired TN types.

4. If desired, narrow the results using the region(s) parameter. Query time is reduced when the parameters are narrowed.

5. Click Run Report .

6. Go to View Project Results to see the results of the query.

 

Back to Top  Back to Use Pre-defined Query Projects

 

- Summary DPC Information –

The Summary DPC Information Report  provides a summary of NPAC DPC values by each LRN for a selected SPID.

The output of the Summary DPC Information report  is designed so that additional sorting and filtering of results is possible. It is strongly recommended to use Excel filtering and pivot table functionality to create additional reports from the DPC output.

The report output may, and most likely will, contain more than one row or record for any given LRN. This occurs if there are any different DPC value combinations for a given LRN.

The results of this query display the following information:

Region, TN Type, TN SPID, TN LNP Type, TN LRN, TN LIDB DPC-SSN, TN CLASS DPC-SSN, TN CNAM DPC-SSN, TN ISVM DPC-SSN, TN WSMSC DPC-SSN, TN Voice URI, TN MMS URI, TN SMS URI, Count


To execute this report:

1. Create a new Query Project name.

2. Select the desired SPID/OCNs.

3. If desired, narrow the results using the region(s) parameter. Query time is reduced when the parameters are narrowed.

4. Click Run Report .

5. Go to View Project Results to see the results of the query.

 

Back to Top  Back to Use Pre-defined Query Projects

 

- LRN History –

The LRN History report  reports on ownership and LRN value for a specified date.

The results of this query display the following information:

TN, Query Date, LRN Indicator, TN LRN, TN Type, TN SPID, Code NANPA OCN.


For the LRN History Report, files must be uploaded with a specific format.

  • The first column of the uploaded file must contain TN values. The TNs must be a 10 digit value with no spaces, dashes, or parenthesis.
  • The second column of the file must contain a date value. The date must be an 8 digit date with no slashes or other characters. QM uses the date value to find the owner of the TN on the date provided. QM returns the SPID (or OCN if native) and the associated LRN for the TN on that date.

 

It is recommended that the uploaded file be a .csv (comma separated value) text file. Below is the expected format for the upload file.

TN, date

7248614155,01152003

7033716535,09092007

7022428020,12122008

 

To execute this report:

1. Create a new Query Project name.

 2. Browse the directories on your PC to find the input file.

3. Click Run Report .

4. Go to View Project Results to see the results of the query.

 

Back to Top  Back to Use Pre-defined Query Projects

 

- Block Utilization Report -

The Block Utilization Report provides a total count of the TNs that are assigned (both internal and ported out), reserved, aging, administrative, intermediate, and available within each block. Downloading the counts provides a breakdown of the total by each category per rate center and block and provides a utilization percentage.

Note: You must provide Neustar with utilization information to run this report.

To execute this report:

1. Create a new Query Project name.

2. Enter the OCN to run the report against.

3. Click Run Report .

4. Go to View Project Results to see the results of the query.

 

Column Name
Block Level Description
Summary Level Description
Block Level/Summary Level Indicates the section of the report that provides block level details. Indicates the section of the report that provides Summary level details (i.e. Rate Center)
Rate Center The Rate Center being reported on. The Rate Center being summarized
State The State of the Block The State being summarized.
Block The Block Number. NA
Reported Block? A Yes / No flag indicating whether the block was reported to RIMS by the Service Provider in their utilization files. NA
Industry: Assigned in the Last 90 Days?

A Yes / No /Not Pooled flag indicating whether the block was assigned to the SP in the last 90 days.

 

  • A Yes  value indicates it was assigned in the last 90 days.
  • A No  value indicates it was not assigned in the last 90 days
  • A Not Pooled  value indicates the block is not pooled  (Assigned date information is not accounted for)

 

NA
Internally Assigned Internally Assigned is the number of TNs that are assigned, not including Port Outs as reported to RIMS by the Service Provider in their utilization files. This value is a sum of the Block level Internally Assigned  values.  For non-reported blocks, 0's are included in the sum.
Industry: Ported Out Contains a count of the number of TNs that have been ported from the Service Provider to another Service Provider in the block.  This value is a sum of the Block level Ported Out  values. 
Admin Contains a count of the number of TNs that are in Admin status in the block, as reported on the Utilization files provided to RIMS by the Service Provider. This value is a sum of the Block level Admin  values.  For non-reported blocks, 0's are included in the sum.
Intermediate Contains a count of the number of TNs that are in Intermediate status in the block, as reported on the Utilization files provided to RIMS by the Service Provider. This value is a sum of the Block level Intermediate  values.  For non-reported blocks, 0's are included in the sum.
Reserved Contains a count of the number of TNs that are in Reserved status in the block, as reported on the Utilization files provided to RIMS by the Service Provider. This value is a sum of the Block level Reserved  values.  For non-reported blocks, 0's are included in the sum.
Aging Contains a count of the number of TNs that are in Aging status in the block, as reported on the Utilization files provided to RIMS by the Service Provider. This value is a sum of the Block level Aging  values.  For non-reported blocks, 0's are included in the sum.
Available Contains a count of the number of TNs that are available for Assignment in the block.  This value is a sum of the Block level Available  values.  For non-reported blocks, 0's are included in the sum.
% Not Available/ Average % Not Available The percentage of TNs that are not available in the block as per the utilization information reported by the Service provider. Not Available means any TN not available to be assigned to an end user (assigned, intermediate, reserved, aging, admin, ported out) The Average % Not Available  value is an average of the Block level % Not Available  values for only blocks that were Reported.  Blocks that were not reported are ignored in this calculation.
% Utilized/Average % Utilized The percentage of TNs that are utilized in the block as per the utilization information reported by the Service provider. Utilized means any TN assigned to an end user (assigned, ported out) The Average % Utilized  value is an average of the Block level % Utilized  values for only blocks that were Reported.  Blocks that were not reported are ignored in this calculation.
Industry: Average % Not Available NA The Industry: Average % Not Available  value is an average of all the block level % Not Available  values, including the blocks that were not reported.
Industry: Average % Not Available w/out pooled blocks Assigned in last 90 days NA The Average % Utilized Industry w/out pooled blocks Assigned in last 90 days  value is an average Utilization calculation across all blocks assigned to this service provider according to the industry, less pooled  blocks that were assigned within the last 90 days, regardless of whether the blocks were reported.  Any non-pooled blocks are included in this calculation, regardless of their assigned date. 

 

Back to Top  Back to Use Pre-defined Query Projects 

 

- Block Utilization Trending Report -

The Block Utilization Trending Report provides the current utilization percentage at the block and rate center level and a trending of that percentage over the past 6 months.

To execute this report:

1. Create a new Query Project name.

2. Enter the OCN to run the report against.

3. Click Run Report .

4. Go to View Project Results to see the results of the query.

 

Note: You must provide Neustar with utilization information to run this report.

 

Back to Top  Back to Use Pre-defined Query Projects

 

- Rate Center Utilization Threshold Report -

The Rate Center Utilization Threshold Report provides a report of rate centers within a Market and OCN which are above a user specified utilization percentage.

Note: You must provide Neustar with utilization information to run this report.

To execute this report:

1. Create a new Query Project name.

2. Select the Market(s) and OCN(s) to run the report against.

  • If the Market or Markets are selected first, the list of available OCNs will be automatically filtered
  • If the OCN or OCNs are selected first, the list of available Markets will be automatically filtered
  • If a Market is selected first and the user would prefer to select an OCN first, refresh the page and begin with OCN.
  • If an OCN is selected first and the user would prefer to select a Market first, refresh the page and begin with Market.

3. Enter a utilization threshold.

4. Click Run Report .

5. Go to View Project Results to see the results of the query.

 

Column Name
Description
State The State the Rate Center is in.
Rate Center The Rate Center being reported. 
OCN The OCN of the Rate Center being reported.
Industry: % Not Available The average % not available calculation across all blocks assigned to this service provider according to the industry, regardless of whether the blocks were reported.  Not Available means any TN not available to be assigned to an End User (assigned, intermediate, reserved, aging, admin, ported out)
Industry: % Not Available w/out pooled blocks Assigned in last 90 days The average % not available calculation across all blocks assigned to this service provider according to the industry, less pooled  blocks that were assigned within the last 90 days, regardless of whether the blocks were reported.  Not Available means any TN not available to be assigned to an End User (assigned, intermediate, reserved, aging, admin, ported out)
Industry: Ported Out The Port out value obtained from the NPAC at the time the report is generated.
Industry: Number Blocks Assigned The number of blocks the industry says the service provider owns.
Number Blocks Reported The number of blocks the Service Provider reports owning in the Rate Center as reported on the Utilization files provided to RIMS by the Service Provider.
Assigned Contains a count of the number of TNs that are no longer available for Assignment as reported on the Utilization files provided to RIMS by the Service Provider.
Ported Out Contains a count of the number of TNs that have been ported from the Service Provider to another Service Provider which is obtained when Service Provider utilization reports are processed by Neustar.  
Admin Contains a count of the number of TNs that are in Admin status as reported on the Utilization files provided to RIMS by the Service Provider.
Intermediate Contains a count of the number of TNs that are in Intermediate status as reported on the Utilization files provided to RIMS by the Service Provider.
Reserved Contains a count of the number of TNs that are in Reserved status as reported on the Utilization files provided to RIMS by the Service Provider.
Aging Contains a count of the number of TNs that are in Aging status as reported on the Utilization files provided to RIMS by the Service Provider.
Available Contains a count of the number of TNs that are available for Assignment.  The Available data is calculated based on data obtained from the Utilization files provided to RIMS by the Service Provider (except for the Ported Out value which is obtained from the NPAC):
Internally Assigned Internally Assigned is the number of TNs that are assigned, not including Port Outs.
% Not Available The average % not available calculation for all blocks the service provider owns within the Rate Center as reported on te Utilization files provided to RIMs by the Service Provider.  Not Available means any TN not available to be assigned to an End User (assigned, intermediate, reserved, aging, admin, ported out)
% Utilized The Average Utilization calculation for all the blocks the service provider owns within the Rate Center as reported on the Utilization files provided to RIMS by the Service Provider.  % Utilized means any TN assigned to an End User (assigned, ported out)
Current Month - 5 Contains the difference in the number of Assigned TNs between the historical months occurring 5 and 6 months prior to the current month.
Current Month - 4 Contains the difference in the number of Assigned TNs between the historical months occurring 4 and 5 months prior to the current month.
Current Month - 3 Contains the difference in the number of Assigned TNs between the historical months occurring 3 and 4 months prior to the current month.
Current Month - 2 Contains the difference in the number of Assigned TNs between the historical months occurring 2 and 3  months prior to the current month.
Current Month – 1 Contains the difference in the number of Assigned TNs between the historical months occurring 1 and 2 months prior to the current month.
Current Month Contains the difference in the number of assigned TNs between the current month and the previous month. Only reported blocks are counted in these columns.
6 Month Average Growth Contains an average growth in assigned TNs across the previous 6 months in the rate center.  Only Reported Blocks are counted in this column.

 

Back to Top  Back to Use Pre-defined Query Projects

 

- Historical Port Ins from Blocks and Codes Report -

The Historical Port Ins from Blocks and Codes Report provides 2 reports.

  • A list of all the TNs that have been Ported In from the blocks not owned by the selected OCNs.
  • A list of all the TNs that have been Ported In from the codes not owned by the selected OCNs.


The results of the reports display the following information:

Block Report: TN, Block PAS OCN, TN SPID, LATA, Rate Center, TN Activate Date, TN Activate Time.

Code Report: TN, Code NANPA OCN, TN SPID, LATA, Rate Center, TN Activate Date, TN Activate Time.


To execute the Historical Port Ins from Blocks and Codes Report:

1. Enter a Query name.

2. Select the desired TN SPID(s) to include in the report, you may select one to many but must select at least one.

  • Click Select All  to run the report on all TN SPIDs available in your profile.
  • Note: This feature is defaulted to select (i.e. include) all TN SPIDs available in your profile.

 

3. Select one to many Regions from the dropdown list.

4. Click Run Report.  

5. Go to View Project Results to see the results of the query.

 

Back to Top  Back to Use Pre-defined Query Projects

 

- Historical Port Outs from Blocks and Codes Report -

The Historical Port Outs from Blocks and Codes Report provides 2 reports.

  • A list of all the TNs that have been Ported Out from the blocks owned by the selected OCNs.
  • A list of all the TNs that have been Ported Out from the codes owned by the selected OCNs.


The results of the Reports display the following information:

Block Report: TN, Block PAS OCN, TN SPID, LATA, Rate Center, TN Activate Date, TN Activate Time.

Code Report: TN, Code NANPA OCN, TN SPID, LATA, Rate Center, TN Activate Date, TN Activate Time.


To execute the Historical Port Outs from Blocks and Codes Report:

1. Enter a Query name.

2. Select the desired OCN(s) on which to run the report, you may select one to many but must select at least one.

  • Click Select All  to run the report on all OCNs available in your profile.
  • Note: Limit the number of OCNs selected to avoid extremely long run times for your query.

 

3. Select the SPID(s)you wish to exclude from the report. This excludes porting activities to those SPIDs.

  • Click Deselect All  to include all SPIDs available in your profile.
  • Note: This feature is defaulted to select (i.e. exclude) all SPIDs available in your profile.

 

4. Select one to many Regions from the dropdown list.

5. Click Run Report.

6. Go to View Project Results to see the results of the query.

 

Back to Top  Back to Use Pre-defined Query Projects

 

- Ported TNs From Block(s) -

The Ported TNs From Block(s) report provides a list of TNs that have been ported out of a Block or Blocks.

The results of this query display the following information:

TN, NPAC TN SPID, NPAC TN Activation Date, NPA-NXX-X, NPAC Block SPID.


To execute the Ported TNs From Block(s) Report:

1. Enter a Query name.

2. Upload or type in a list of Blocks (NPA-NXX-X) to find the TNs that have been ported out of the entered Block(s).

  • Rules for typing in a list of Blocks
    • Each block must be 7 digits long. The following formats are acceptable: dashes, parenthesis,no spaces [703-111-1, (703)111-1, or 7031111 are all acceptable formats].
    • Multiple Blocks must be seperated by a comma or carriage return
  • Rules for uploading a list of Blocks
    • Each block must be 7 digits long. The following formats are acceptable: dashes, parenthesis,no spaces [703-111-1, (703)111-1, or 7031111 are all acceptable formats].
    • The file must be in one of the following formats: Excel (either .xls or .xlsx), Text file (.txt), or Comma separated value file (.CSV)
    • The list of NPA-NXX-Xs must be in the first column of the file
    • Headers and Footers are not allowed in the file

 

3. Select the SPID(s) in your profile to exclude from the report to retrieve only TNs that have been ported to an external SPID. You may select zero to many SPIDs to exclude.  Note : If you choose to exclude no SPIDs (i.e. include all SPIDs), the report is limited to 500 blocks or less.

  • Click Deselect All  to include all SPIDs available in your profile.
  • Note: This feature is defaulted to select (i.e. exclude) all SPIDs available in your profile.

 

4. Enter any additional SPIDs you wish to exclude. TNs ported to these SPIDs will not be included in the report.

5. Select the Port Date  range for which you wish to run the report.

  • Select On or Before  or On or After  from the dropdown menu next to Port Date  heading
  • Select the date  you wish to use as a maker for your query. Depending on your previous selection the report will be run on TNs ported either On or Before  the selected date  or On or After  the selected date .

 

5. Click Run Report.

6. Go to View Project Results to see the results of the query.

 

Back to Top  Back to Use Pre-defined Query Projects