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 |