TFNRegistry Reporting: Spare Number Forecast Report (120 Day Future View)

The Spare Number Forecast Report (120 Day Future View) displays the Disconnected and Transitional TFNs along with dates the TFNs will be returned to the Spare pool. This assumes the TFN/TFNs follow the standard Status progression from Disconnect/Transitional to Spare.

To view the report:

• On the Spare Number Forecast Report (120 Day Future View) Landing page, the user can select specific NPAs or (All) from the drop down menu and select the “Date From” and “Date To” with the slider.
• When no filters are selected, the report will display the default NPA value as (All) with the “Date From” equal to the current date and the “Date To” equals to the current date +120 days or the maximum date of a TFN in Disconnect or Transitional status, not to exceed the current date +120 days.

Selected Number of Rows

• For NPA, the user can select specific NPAs or (All) from the NPA drop down menu.
• For “Date From”, the user can select the beginning date range. The “Date From” selection ranges from the current date to current date +120 days or the maximum date of a TFN in Disconnect or Transitional status, not to exceed the current date +120 days.
• For ‘Date To”, the user can select the ending date range. The “Date To” selection ranges from the current date to the current date +120 days or the maximum date of a TFN in Disconnect or Transitional status, not to exceed the current date +120 days.
• Once the user selects the filters, the “Upcoming Spares” Chart and the “Selected Number of Rows” will dynamically refresh.
• On the chart, the TFNs in Disconnect status are indicated by the dark berry bars and the TFNs in Transitional status are indicated by the indigo bars. The user can hover the mouse device over each bar to see more information (see Figure 112 Spare Number Forecast Report Selected Number of Rows).

Please Note: It is recommended to limit the size of the Selected Number of Rows to 200,000 for optimal performance.

Full Report Results

• By selecting the “Generate List of Toll-Free Numbers” button, the Results page of the full report will be displayed in the same browser tab. The user can review or download the data on this page (see Figure 113 Spare Number Forecast Full Report).

Running the Report again in the same Session

• The user can select the Spare Number Forecast Report tab at the top left corner of the page to view and modify the report again. If the report is run again in the same session, the “Generate List of Toll-Free Numbers” button will be “grayed” out and displayed with a light blue background (see Figure 114 Spare Number Forecast Report New Selection)
• First, re-activate the “Generate List of Toll-Free Numbers” button by selecting it once and it will change back to the indigo background. Next, make the new selections from the NPA drop down filter and/or date slider.
• To get the list of Toll-Free Numbers for the new selections, select the “Generate List of Toll-Free Numbers” button and the new list will be displayed (see Figure 115 Spare Number Forecast New Selection Full Report).

Figure 112 Spare Number Forecast Report Selected Number of Rows

Figure 113 Spare Number Forecast Full Report

Figure 114 Spare Number Forecast Report New Selection

Figure 115 Spare Number Forecast New Selection Full Report

Spare Number Forecast Report Field Descriptions

The following table identifies the Spare Number Forecast Report fields and their descriptions (see Table 15 Spare Number Forecast Report Field Descriptions).

Table 15 Spare Number Forecast Report Field Descriptions

Data Source Used to Create the Report

The “RHDB_SPARE_FORECAST” data source is used to create the Spare Number Forecast Report. The fields used from this table are:

• Npa
• Dialnbr
• Numberstatus
• Sparedate

Please Note: Please refer to Chapter 15.77 Spare Number Forecast Table (RHDB_SPARE_FORECAST) for more information.