The NXX Percent Used table contains the percent of the 10,000 line numbers that are currently in use for each NPA-NXX.
This table is available via the SMSADM universe in Reporting. The data is viewable only by Help Desk and Administrators via Reporting (see Table 127 RHDB_NXXUSED).
Table 127 RHDB_NXXUSED
| RHDB_NXXUSED | ||
| Field | Characters | Description |
| Npanxx | varchar2(6) | The NPANXX to which the Percent Used applies (open or once opened but now closed NPANXX). |
| Status | varchar2(6) | Indicates the status of the NPA-NXX:
|
| PercentUsed | varchar2(5) | The percentage of the 10,000 possible line numbers for the NPA- NXXs that are currently in use (i.e., that have a number status other than Spare). For example, if the field contained 07599 that would be interpreted as 75.99% used. |
| ExtractDate | Date | The date when the record was sent to the RHDB database. |
Index for RHDB_NXXUSED Table
The index and fields used for the RHDB_NXXUSED table are:
| rhdb_NXXUsed | |
| Index Name | Fields Used |
| rhdb_NXXUsed_idx1 | NpaNxx |