The Pointer Record List Report – Enhanced Filtering is similar to the existing Pointer Record List Report but will allow the user to perform Template Name filtering on the Landing page and Number Status filtering on the results page.
To view the report:
- On the Pointer Record List Report – Enhanced Filtering Landing page, the user can select the Entity, Resp Org and Template Name 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 132 Pointer Record List – Enhanced Filtering 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 133 Pointer Record List – Enhanced Filtering 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 134 Pointer Record List – Enhanced Filtering Full Report).
The user can select the Pointer Record List Report – Enhanced Filtering tab at the top left corner of the page to view and modify the report again.
Figure 132 Pointer Record List – Enhanced Filtering Selected Number of Rows
Figure 133 Pointer Record List – Enhanced Filtering Preview
Figure 134 Pointer Record List – Enhanced Filtering Full Report
Pointer Record List – Enhanced Filtering Field Descriptions
The following table identifies the Pointer Record List – Enhanced Filtering fields and their descriptions (see Table 26 Pointer Record List – Enhanced Filtering Field Descriptions).
Table 26 Pointer Record List – Enhanced Filtering Field Descriptions
|
Pointer Record List – Enhanced Filtering 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. |
|
Number Status |
Status of Dial Number in Number Administration. Possible values:
|
|
CR Status |
The status of the affected Customer Record. The possible statuses are: Pending
|
|
Template Name |
Name of the Template Record. |
|
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. |
Data Source Used to Create the Report
The “RHDB_NEW_POINTER_RECORD_LIST_VIEW” data source is used to create the Pointer Record List – Enhanced Filtering report. The fields used from this table are:
- Templateid
- Templatename
- Controlresporg
- Crdialnumber
- Creffectivedatetime
- Crstatus
- Extractdate
- Create_logonid
- Update_logonid
- Create_time
- Update_time
- Numberstatus
Please Note: Please refer to Chapter 15.78 Pointer Record List Report – Enhanced Filtering (RHDB_NEW_POINTER_RECORD_LIST_VIEW) for more information.