Update Is Local

If Is Local is True, your company has the right to sell local service in the associated NPANXX area. You can change this indication as necessary.

1. Check (or uncheck) the new Is Local check box in the Update Settings area.

2. Use the shortcut menu to select and change the appropriate records. You can change the records:

   • For the selected row.

     (More)

     To change one row, right-click the row and select Update Region > For Selected Row.

   • For the rows in the current view.

     (More)

     To change all the records listed in the current view:

     1. Filter the table to display only those records to be changed.  

        (More)

        Windows with lists (rows with column headings) can be sorted and filtered by:

        Column Heading

        On pages with column headings, you can sort, filter and find items by right-clicking the column heading.

        

        The shortcut menu lets you:

        • Sort Ascending or Sort Descending

        • Apply a Filter. This displays a dialog for entering a text string (expression). Wildcard characters (*) are allowed. For example, entering "Acme*" filters out (hides) all records that do not contain a text string beginning with “Acme". To undo the filter and restore the original search results, select Remove Filter.

        • Find an item based on a text string. This displays a window similar to the Filter window.

          

          However, rather than hiding records that do not match the text string, the Find function finds and highlights the first instance of the text string in the list. Selecting Find Next locates the next instance of the text string.

          Note

          You must enter the complete string in order for it to be found; wildcards are not allowed. For example, if you're searching a column for Los Angeles, you must enter Los Angeles, not just Los *.

        Click Column Heading to Sort

        Left-clicking on column headings will also toggle between sorting them in ascending and descending order.

        Note

        This is a strict alpha sort, so numbers that vary in length will not be sorted numerically. (For example, 100 will come before 15.)

        Selected Cell

        When a list is very large you can apply a filter to make it more manageable. To do this, right click a cell in the grid and choose Filter >

        • By Selection -- to include all rows with the selected filter criteria (cell content).

        • Excluding Selection -- to remove all rows with the selected filter criteria.

          To revert to the complete list, choose Filter > Remove Filter.

     2. Right-click any row and select Update Region > For All Rows in the Current View.

   • For the complete table based on a specific field.  

     (More)

     You can change all the rows in the table based on one of four fields in the selected row:

     • LATA

     • NPA

     • OCN

     • State

       For example, you can change all records in the NNACL table having the 974 LATA.

     1. Right-click a row with the desired LATA (or NPA, OCN or State).

     2. From the shortcut menu, select Update Region > For All Rows in the NNACL Table > By Selected LATA (or NPA, OCN or State).