TFNRegistry Reporting: SCP NPA-NXX List Table (RHDB_SCPNPANXX) – Somos

The SCP NPA-NXX List table contains the NPA-NXX data for each SCP (see Table 98 RHDB_SCPNPANXX).

Table 98 RHDB_SCPNPANXX

RHDB_SCPNPANXX
Field	Characters	Description
ScpId	varchar2(4)	The SCP that generated the exception report data.
ClliCode	varchar2(11)	The eleven character Common Language code for the SCP Id.
Npanxx	varchar2(6)	The NPA-NXX value in the SMS NPA-NXX list.
EffectiveDate	Date	The Effective Date of the SCP NPA-NXX list.
Status	varchar2(1)	The Status of the NPA-NXX List. The Status may be one of the following: F - Failed O - Old I - Invalid A - Active S - Sending M - Must Check P – Pending
TaIndicator	varchar2(1)	An indication of the disposition of the NPA-NXX. T indicates turnaround is desired. N indicates turnaround is not desired. V returns a Vacant Code Announcement (VCA) to the caller. B returns an Out of Band Announcement (OBA) to the caller. D indicates delayed turnaround.
ExtractDate	Date	The date when the record was sent to the RHDB database.

The index and fields used for the RHDB_SCPNPANXX table are: