TFNRegistry Reporting: Number Inventory Report – Somos

The Number Inventory Report is an on-demand report and provides the details of TFNs controlled by the given Resp Org and their routing information.

In the Number Inventory Report, following rules are applied for a TFN to be displayed:

TFNs in any status except Spare are displayed.
- If a TFN has multiple Customer Records, only 1 Customer Record is displayed.
If the TFN has a Sending record then that record is displayed or else if the TFN has Active or Disconnect record then that record is displayed.
If the TFN has no Active, Disconnect or Sending record then CR with a nearest future Effective Date (any status) is displayed.
If a record mentioned in the a or b does not exist, then a CR with past Effective Date and Time that is closest to the current Date and Time (any status) is displayed.
When a Customer Record is a Pointer Record, the Intra/Inter LATA Carriers and AOS details displayed in the report are fetched from the associated Template Name based on the below rules:
The Template Record that is closest previous to the Pointer Record’s Effective Date and Time is selected. For Example:

If the Pointer Record is in PENDING status with Effective Date and Time as 08/07/2019 10:30 AM and associated Template Name has two records as below:

ACTIVE 07/30/2019 10:30 AM

PENDING 08/01/2019 10:30 AM

Intra/InterLATA and AOS details are fetched from the Template Name with Effective Date and Time 08/01/2019 10:30 AM.
If the status of the record selected in (a) is not FAILED then the data is fetched from that Template Record.
If the status of the record selected in (a) is FAILED then the data is fetched from the SENDING (or) ACTIVE Template Record in the same order of priority.
If there are no Template Records preceding the Effective Date and Time of the Pointer Record, then the data is fetched from the SENDING (or) ACTIVE Template Record in the same order of priority. For Example:

If the Pointer Record is in PENDING status with Effective Date and Time 08/07/2019 10:30 AM and associated Template Name has two records as below.

ACTIVE 07/30/2019 10:30 AM

PENDING 08/01/2019 10:30 AM

Intra/InterLATA and AOS details are fetched from the Template Name with Effective Date and Time 08/01/2019 10:30 AM.

To view the report:

On the Number Inventory Report Landing page, the user can select the Entity, Resp Org, NPA and NXX Start Digit items from the corresponding drop down menu.

Selected Number of Rows

As the user selects each filter, the “Selected Number of Rows” will dynamically refreshes and the number of data rows for the selected filters will be displayed (see Figure 104 Number Inventory Report Selected Number of Rows).

Please Note: It is recommended to limit the size of the Selected Number of Rows to 200,000 for optimal performance.

Generate Preview (10 Rows)

By selecting the “Generate Preview (10 Rows)” button, the user can preview the first 10 rows of the report. This button will be “grayed” out and displayed with a light blue background after the first time it was selected in a session (see Figure 105 Number Inventory Report Preview). The preview data auto refreshes every time the user modifies the filters without the need to reselect the “Generate Preview (10 Rows)” button again.

Full Report Results

By selecting the “Generate Full Report” button, the Results page of the full report will be displayed in another tab of the browser. The user can review or download the data on this page (see Figure 106 Number Inventory Full Report).
The user can select the Customer Inventory tab at the top left corner of the page to view and modify the report again.

Figure 104 Number Inventory Report Selected Number of Rows

Figure 105 Number Inventory Report Preview

Figure 106 Number Inventory Full Report

Number Inventory Report Field Descriptions

The following table identifies the Number Inventory Report fields and their descriptions (see Table 13 Number Inventory Report Field Descriptions).

Table 13 Number Inventory Report Field Descriptions

Number Inventory Report Field Descriptions
Field	Description
Entity	An identifier for the Entity.
Resp Org	An identifier for the Resp Org.
Toll-Free Number	The Toll-Free Number that has been assigned for the Customer Record.
Number Status	Identifies the status of the TFN. Possible values: 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
Status Change Date	Identifies the date at which TFN status has last changed.
AOS Networks	The Area of Service Networks data of the Customer Record. If the CR used by TFN is a Pointer Record, AOS data is fetched from the Template Record. Multiple Networks are represented using comma separated list. Will be blank if the TFN does not have CR.
AOS States	The Area of Service States data of the Customer Record. If the CR used by TFN is a Pointer Record, AOS is fetched from the Template Record. Will be blank if the TFN does not have CR.
AOS NPAs	The Area of Service NPA data of the Customer Record. If the CR used by TFN is a Pointer Record, AOS data is fetched from the Template Record. Multiple NPAs are represented using comma separated list. Will be blank if the TFN does not have CR.
AOS LATAs	The Area of Service LATA data of the Customer Record. If the CR used by TFN is a Pointer Record, AOS data from the Template Record is fetched. Multiple Networks are represented as comma separated list. Will be blank if the TFN does not have CR.
AOS Labels	The Area of Service Labels data of the Customer Record. If the CR used by TFN is a Pointer Record, AOS data from the Template Record is fetched. Multiple Networks are represented as comma separated list. Will be blank if the TFN does not have CR.
Effective Date/Time	The date and time at which the CR is sent to SCP. Must be blank if TFN does not have CRs.
CR Status	Identifies the status of the CR. Must be blank if TFN does not have CRs. Possible values are: A – Active D - Disconnect F - Failed H - Hold I - Invalid M - Must Check O - Old P - Pending S - Sending U – Saved
Template Name	Identifies the Template Name used in the Pointer Record if the TFN uses a Pointer Record. Must be blank if TFN does not have CRs (or) the default record of the TFN as per SM.NCR.REQ.SR-001 is not a Pointer Record.
CPR Indicator	Indicates if the Customer Record or Template Record has a CPR portion. If a CPR exists, the field will be populated with a “Y” and if a CPR does not exist, the field will be populated with a “N”.
InterLATA Carrier	InterLATA CIC/CICs (from CAD or TAD).
IntraLATA Carrier	IntraLATA CIC/CICs (from CAD or TAD).
Last Refresh Date/Time	Identifies the date and time the report was last refreshed.
Record Count	Display the count of records associated with the filtered data set (xxxxxxx) and the grand total of records (yyyyyyy) formatted as xxxxxxx/yyyyyyy.

Data Source Used to Create the Report

The “RHDB_CRINVENTORY_VIEW” data source is used to create the Number Inventory Report. The fields used from this table are:

Dialnbr
Numberstatus
StatusChangeDate
Entity
Resporg
Update_Time
Effectivedate
CRStatus
CPRInd
InterLATAcarr
IntraLATAcarr
TemplateName
AOSlabel
Network
LATA
NPA
State
Extractdate

Please Note: Please refer to Chapter 15.72 Number AOS and CIC Table (RHDB_CRINVENTORY_VIEW) for more information.

Number Inventory Report Field Descriptions

Data Source Used to Create the Report

Related articles