For reports that have more than 200,000 rows, the following filters are available to the user so that the report runs efficiently and the results are easily accessible and manageable:
- Entity
- Resp Org
- NPA
- NXX Start Digit
- Activity Date (for some reports)
If the user’s Entity or Resp Org ID has more than 200,000 records for a particular report, please select the filters to limit the number of records. If the number of Resp Org IDs in the user’s Entity are more than 200, the user can use the filter and limit the Resp Org IDs.
For selecting NPA, the user can select specific NPAs or (All) NPAs. By default, (All) will be displayed on the report. To select a specific NPA or NPAs, the user can select the drop down arrow. A list of all the available NPA items will be displayed.
- When the user selects a single NPA from the drop down menu, then that NPA will only be displayed in the corresponding field.
- When the user selects multiple filters from the drop down menu, then Multiple values will be displayed indicating that the multiple entries are selected for the corresponding field.
- Select the (All) check box to deselect all the filters and then select the specific NPA’s check box one after the other. Then, select the “Apply” button.
For additional information, please refer to the following chapters: