TFNRegistry Reporting: Resp Org Change Report

The Resp Org Change Report allows the users to view Toll-Free Numbers (TFNs) that were transferred in and/or out of their Responsible Organization’s (Resp Orgs) Entity ID. This report has the capability of returning up to 5 years’ worth of data related to Resp Org Change (ROC) transfers.

To view the report:

• On the Resp Org Change Report Landing page, the user’s Entity will be the default for the Entity Filter. The user can select the desired Resp Org(s) and NPA(s) from the drop down filters and a date range from the date slider.
• On the date slider, the user can either use the mouse to adjust the “Date From” and “Date To” range by sliding the endpoints to the desired start and end dates or by selecting each date under the “Date From” and “Date To” and use the calendar drop down to select the desired date ranges.

Selected Number of Rows

• As the user selects each filter, the “Selected Number of Rows” will dynamically refresh and the total number of data rows for the selected filters will be displayed.
• Once the filters are selected, two report buttons “Generate Preview (10 Rows)” and “Generate Full Report” can be selected.

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

Generate Preview (10 Rows)

• By selecting the “Generate Preview (10 Rows)” button, the user can preview the first 10 rows of the report. This button will be grayed after the first time it was selected in a session (see Figure 116 Resp Org Change Preview Report).
• The preview data auto refreshes every time the user modifies the filters without the need to reselect the “Generate Preview (10 Rows)” button again.

Full Report Results

• By selecting the “Generate Full Report” button, the Results page of the full report will be displayed in the same tab of the browser. The user can review or download the data on this page (see Figure 117 Resp Org Change Full Report).
• The report displays three charts and tabular data. The three charts are as follows: A pie chart for “Ratio of Transferred In and Transferred Out” Toll-Free Numbers and two bar charts, “Resp Org Changes-Transferred In from Entity” and “Resp Org Changes-Transferred Out to Entity.”
• The pie chart is divided into two slices depicting the “Ratio of Transferred In and Transferred Out” Toll-Free Numbers by percentage. Each slice can be selected to modify the tabular data in the lower section of the report. The pie chart will not alter the two bar charts located to the right of the pie chart.
• The two bar charts depict the Toll-Free Numbers by Entity that were gained, “Resp Org Changes-Transferred In from Entity” and lost, “Resp Org Changes-Transferred Out to Entity”. These charts are interactive and allow the user to select a specific bar to get data on specific Entities and the Toll-Free Numbers that were gained or lost through the Resp Org Change process.
• If the user selects a “bar” in one chart, for example the “Resp Org Changes-Transferred In from Entity” and then wants to select a “bar” from the other chart, the “Resp Org Changes-Transferred Out to Entity” chart, the user must first “reset” the first chart by clicking in the white space inside the first chart before selecting a bar in the second chart. The tabular data will be refreshed based on the bar selected.

Internal Transfers

• Internal Transfers are defined as transfers from one Resp Org ID to another Resp Org ID under the same Entity. Both transfers are included in the report data and will be shown as two rows in the data for the same Toll-Free Number: one for the submitting (new, gaining) Resp Org ID of the Toll-Free Number and one for the controlling (current, losing) Resp Org ID the Toll-Free Number.
• Use the “Internal Transfer” drop down to either Include Internal Transfers or Exclude Internal Transfers from the report. If you select “Include”, Internal Transfers from one Resp Org ID to another within your Entity will be included in the counts as well as in the calculation for the pie chart: Ratio of Transfer In and Out and the other two charts: Resp Org Changes - Transferred In from Entity and Resp Org Changes - Transferred Out from Entity (see Figure 118 Resp Org Change Report - Include Filters).
• If “Exclude” is selected, Internal Transfers will not be included in the calculation for the pie chart: Ratio of Transfer In and Out and will not be included on the two reports: Resp Org Changes- Transferred In from Entity and Resp Org Changes - Transferred Out from Entity (see Figure 119 Resp Org Change Report - Exclude Filters).

Running the Report again in the same Session

• The user can select the Resp Org Change Report tab at the top left corner of the page to view and modify the report again (see top left corner of Figure 117 Resp Org Change Full Report).
• If the report is re-run in the same session, the “Generate Full Report” button will be “grayed” out and displayed with a light blue background.
• First, re-activate the “Generate Full Report” button by selecting on it once and the button’s background will change back to the indigo color (see Figure 120 Resp Org Change Full Report Again). The “Generate Preview (10 Rows) button does not have to be re-activated, even though the button is displayed with the light blue background.
• Next, make your new selections from the Resp Org and NPA drop down filters and/or the date slider. To get the new full report, select the “Generate Full Report” button and the results will be displayed in the same browser tab.

Figure 116 Resp Org Change Preview Report

Figure 117 Resp Org Change Full Report

Figure 118 Resp Org Change Report - Include Filters

Figure 119 Resp Org Change Report - Exclude Filters

Figure 120 Resp Org Change Full Report Again

Resp Org Change Report Field Descriptions

The following table identifies the Resp Org Change Report fields and their descriptions (see Table 16 Resp Org Change Report Field Descriptions).

Table 16 Resp Org Change Report Field Descriptions

Data Source Used to Create the Report

The “RHDB_RESPORG_CHANGE_REPORT” data source is used to create the Resp Org Change report. The fields used from this table are:

• Resporgfilter
• Entity
• Org
• Resporg
• Dialnbr
• Numberstatus
• Transfertype
• Preventity
• Prevorg
• Prevresporg
• Statuschangedate
• Extractdate
• Lastupdatedatetime

Please Note: Please refer to Chapter 15.80 Resp Org Change Report (RHDB_RESPORG_CHANGE_REPORT) for more information.