This report is an on-demand report that provides a Resp Org with the list of TFNs and the types of Customer Records existing for the TFN.
To view the report:
- On the Number Inventory by Customer Record Type 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 156 Number Inventory Customer Record Type 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 157 Number Inventory Customer Record Type 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 158 Number Inventory Customer Record Type Full Report).
The user can select the Number Inventory by Customer tab at the top left corner of the page to view and modify the report again.
Figure 156 Number Inventory Customer Record Type Selected Number of Rows
Figure 157 Number Inventory Customer Record Type Report Preview
Figure 158 Number Inventory Customer Record Type Full Report
Number Inventory by Customer Record Field Descriptions
The following table identifies the Number Inventory by Customer Record Type report fields and their descriptions (see Table 40 Number Inventory by Customer Record Type Report Field Descriptions).
Table 40 Number Inventory by Customer Record Type Report Field Descriptions
|
Number Inventory by Customer Record Type Report Field Descriptions |
|
|
Field |
Description |
|
Entity |
Entity for the control Resp Org. |
|
Resp Org |
Resp Org ID for the Toll-Free Number. |
|
Toll-Free Number |
Identifies the 10-digit Toll-Free Number. |
|
CR Status |
Identifies the status of the CR. Possible values are:
|
|
Customer Record Type |
Type of Customer Record. Possible values:
|
|
Effective Date & Time of the CR |
Identifies the date/time at which the CR is sent to SCP. |
|
Number Status |
Identifies the status of the Toll-Free Number. Possible status:
|
|
CPR Indicator |
Y/N, Indicates if the Customer Record has a CPR Portion. Applicable only for Regular CRs. Must be blank for Pointer Records. |
|
LAD Exists |
Y/N, Indicates if the Customer Record has a LAD Portion. Applicable only for Regular CRs. Must be blank for Pointer Records. |
|
Last Updated Date/Time |
The date and time when Transactional DB table is updated. This is the date and time at which user or system (batch jobs) last updated the record’s data. This is same as the last updated date/time in CAD/PAD page. |
|
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_NBR_INVTRY_CR_TYPE_REP” data source is used to create the Number Inventory by Customer Record Type Report. The fields used from this table are:
- Calculation Admin and Resporg
- CPR Indicator
- CR Status
- Customer Record Type
- Effective Date/Time
- Entity ID
- LAD Indicator
- Last Updated Date/Time
- NPA
- Number Status
- NXX Start Digit
- Resp Org
- Toll-Free Number
- Number of Records
Please Note: Please refer to Chapter 15.74 Number Inventory by Customer Record Table (RHDB_NBR_INVTRY_CR_TYPE_REP) for more information.