TFNRegistry Reporting: Pointer Record List Report – Somos

The Pointer Record List Report lists all of the Pointer Records mapped to a queried Resp Org.

To view the report:

On the Pointer Record List Report Landing page, the user can select the Entity, Resp Org, NPA and NXX Start Digit items from the corresponding drop down menu.

Selected Number of Rows

As the user selects each filter, the “Selected Number of Rows” will dynamically refreshes and the number of data rows for the selected filters will be displayed (see Figure 129 Pointer Record List 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.

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” out and displayed with a light blue background after the first time it was selected in a session (see Figure 130 Pointer Record List Report Preview). 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 another tab of the browser. The user can review or download the data on this page (see Figure 131 Pointer Record List Full Report).

The user can select the Pointer Record List tab at the top left corner of the page to view and modify the report again.

Figure 129 Pointer Record List Selected Number of Rows

Figure 130 Pointer Record List Report Preview

Figure 131 Pointer Record List Full Report

The following table identifies the Pointer Record list fields and their descriptions (see Table 25 Pointer Record List Field Descriptions).

Table 25 Pointer Record List Field Descriptions

Pointer Record List Field Descriptions
Field	Description
Entity	An identifier for the Entity.
Resp Org	An identifier for the Resp Org.
Toll-Free Number	The Customer Record Dial Number.
CR Status	The status of the affected Customer Record. The possible statuses are: A – Active D – Disconnect (with referral) F - Failed H - Hold I - Invalid M - Must Check O - Old P - Pending S – Sending U – Saved
Template Name	Name of the Template Record.
Template ID	The Template ID.
Effective Date/Time	Identifies the Effective Date and Time for the Customer Record.
Last Updated Date/Time	The date and time updated in the Transactional database (when activity occurred).
Last Refresh Date/Time	Identifies the date and time the report was last refreshed.
Record Count	Display the count of records associated with the filtered data set (xxxxxxx) and the grand total of records (yyyyyyy) formatted as xxxxxxx/yyyyyyy.

The “RHDB_TEMPLATE_DIALNBR” data source is used to create the Pointer Record List report. The fields used from this table are:

Please Note: Please refer to Chapter 15.52 Pointer Records List (RHDB_TEMPLATE_DIALNBR) for more information.