The Number AOS and CIC report is an on-demand report and provides the Areas of Service details and details of CICs used by the TFNs controlled by the given Resp Org. The report includes all the TFNs controlled by the given Resp Org.
In the Number AOS and CIC Report, the following rules are applied for a TFN to be displayed:
- TFN 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 a TFN has multiple Customer Records, only 1 Customer Record is displayed.
If the Pointer Record is in PENDING status with Effective Date & 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 & 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 & 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 & 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 & Time 08/01/2019 10:30 AM.
To view the report:
- On the Number AOS and CIC 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 153 Number AOS and CIC 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 154 Number AOS and CIC 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 155 Number AOS and CIC Full Report).
The user can select the Number AOS and CIC Report tab at the top left corner of the page to view and modify the report again.
Figure 153 Number AOS and CIC Report Selected Number of Rows
Figure 154 Number AOS and CIC Report Preview
Figure 155 Number AOS and CIC Full Report
Number AOS and CIC Report Field Descriptions
The following table identifies the Number AOS and CIC report fields and their descriptions (see Table 39 Number AOS and CIC Report Field Descriptions).
Table 39 Number AOS and CIC Report Field Descriptions
|
Number AOS and CIC Report Field Descriptions |
|
|
Field |
Description |
|
Entity |
Entity of the control Resp Org. |
|
Resp Org |
Identifies the Resp Org that controls the Toll-Free Number. |
|
Toll-Free Number |
Identifies the 10-digit Toll-Free Number. |
|
Number Status |
Identifies the number status of the Toll-Free Number. Valid values are:
|
|
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 (Regular CR or PR) is sent to SCP. Will be blank if TFN has no CR. |
|
CR Status |
Identifies the status of the CR. Will be blank if TFN does not have CR. Possible values:
|
|
Template Name |
Identifies the Template Name if the TFN uses a Pointer Record. Will be blank if TFN does not have CR or the default record of the TFN 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”. |
|
IntraLATA Carrier |
IntraLATA CICs used for the TFN. If the CR used by TFN is a Pointer Record, CICs are fetched from Template Record. Multiple carriers are represented using comma separated list. Will be blank if TFN does not have CR. |
|
InterLATA Carrier |
InterLATA CICs used for the TFN. If the CR used by TFN is a Pointer Record, CICs are fetched from Template Record. Multiple carriers are represented using comma separated list. Will be blank if TFN does not have CR. |
|
Last Updated Date/Time |
The date and time when transactional DB is updated for the record. 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 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 AOS and CIC Report. The fields used from this table are:
- Toll-Free Number
- Number Status
- Status Change Date
- Entity
- Resp Org
- Update Time
- Effective Date
- CR Status
- CPR Indicator
- InterLATA Carrier
- IntraLATA Carrier
- Template Name
- AOS Labels
- AOS Networks
- AOS LATA
- AOS NPA
- AOS States
- Extract Date
- Number of Resp Org Changes
Please Note: Please refer to Chapter 15.72 Number AOS and CIC Table (RHDB_CRINVENTORY_VIEW) for more information.