TFNRegistry Reporting: Destination NPA NXX Table (RHDB_DESTNPANXX) – Somos

The Destination NPA-NXX table includes data related to the destination Plain Old Telephone Service (POTS) numbers and DIAL#s associated with the POTS# for the specified controlling Resp Org (see Table 70 RHDB_DESTNPANXX).

Included in this table are the following fields:

Controlling Resp Org that owns the Dial Number.
Toll-Free Number (also known as the Dial Number).
The Effective Date of the Dial Number.
The current status of the Customer Record.
The current status of the Dial Number in Number Administration.
The Local Serving Office (LSO, LsvcOff).
The Foreign Serving Office (FSO, FsvcOff), which is used when the LSO cannot process the calls.
An indicator denoting whether or not a CPR exists for the Dial Number.
The NPA-NXX of the terminating number.
The terminating number.
The date the record was last updated.

Table 70 RHDB_DESTNPANXX

RHDB_DESTNPANXX
Field	Characters	Description
ControlRespOrg	char(5)	Control Resp Org that owns the Dial Number.
DialNbr	varchar2(12)	Toll-Free Number (also known as the Dial Number).
EffectiveDate	Date	Effective Date of the Dial Number.
CrStatus	char(1)	The status of the Customer Record. Status and definitions are: A – Active D - Disconnect F - Failed H - Hold I - Invalid M - Must Check O - Old P - Pending S - Sending U - Saved
NumberStatus	char(1)	The status of a DIAL#: A (Assigned) - Associated with a pending Customer Record that has been established in SMS/800 TFN Registry, but is not yet active in the Service Control Point (SCP) P (Suspend) - Disconnected but scheduled to be reactivated D (Disconnect) - Service has been terminated R (Reserved) - Holding for future use by a customer T (Transitional) - Service has been terminated for less than the specified number of months and is no longer on intercept U (Unavailable) - Removed from use and cannot be assigned until it is released W (Working) - Has a Customer Record status of active or sending
FsvcOff	char(6)	Foreign Service Office.
LsvcOff	char(6)	Local Service Office.
CprInd	char(1)	Indicator to denote whether or not a CPR exists for the Dial Number.
DestNpaNxx	char(6)	NPA-NXX of the terminating number.
DestTelNumber	char(10)	Terminating number. For example, 8003334444.
ExtractDate	Date	Date the record was last added/updated in Reporting.
Create_LoginID	Varchar2 (8)	The mandatory data field that identifies the Login ID of the SMS/800 TFN Registry user that created the record.
Update_LoginID	Varchar2 (8)	The mandatory data field that identifies the Login ID of the SMS/800 TFN Registry user who last updated the record.
Create_Time	Timestamp (6)	The date and time the record was last updated in the SMS/800 TFN Registry.
Update_Time	Timestamp (6)	The date and time the record was last updated in the SMS/800 TFN Registry.

Index for RHDB_DESTNPANXX Table

The index and fields used for the RHDB_DESTNPANXX table are:

RHDB_DESTNPANXX
Index Name	Fields Used
rhdb_ DestNpaNxx _idx1	ControlRespOrg DespNpaNxx

Index for RHDB_DESTNPANXX Table

Related articles