The Affected Customer Records by SCP AOS Expansion contains all CRs affected by an SCP AOS Expansion for the controlling Resp Org who has made an update.
To view the report:
- On the Affected Customer Records by SCP AOS Expansion 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 146 Affected Customer Record by SCP AOS Expansion 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 147 Affected Customer Record by SCP AOS Expansion 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 148 Affected Customer Record by SCP AOS Expansion Full Report).
- The user can select the Affected Customer Records by tab at the top left corner of the page to view and modify the report again.
Figure 146 Affected Customer Record by SCP AOS Expansion Selected Number of Rows
Figure 147 Affected Customer Record by SCP AOS Expansion Preview
Figure 148 Affected Customer Record by SCP AOS Expansion Full Report
Affected Customer Records by SCP AOS Expansion Field Descriptions
The following table identifies Affected Customer Records by SCP AOS Expansion fields and their descriptions (see Table 36 Affected Customer Records by SCP AOS Expansion Field Descriptions).
Table 36 Affected Customer Records by SCP AOS Expansion Field Descriptions
|
Affected Customer Records by SCP AOS Expansion Field Descriptions |
|
|
Field |
Description |
|
Entity |
An identifier for the Entity. |
|
Resp Org |
An identifier for the Resp Org. |
|
Automatic/Manual Flag |
Indicates if the Customer Record will be converted by the SCP Area of Service Expansion process or if manual conversion will be required. Possible values:
|
|
Toll-Free Number/Template |
The Toll-Free Number or Template Name of the affected Customer Record. Multiple records for the same number or Template Name may be listed if multiple records are affected. |
|
SCP AOS Expansion ID |
The unique ID for this SCP AOS Expansion. |
|
Old CCS Network |
The old CSS Network which is being replaced. |
|
New CCS Network |
The new CSS Network which is replacing the old CSS Network. |
|
Schedule Date |
The earliest date that the Customer Records will start to be scheduled over the link. |
|
Scheduling End Date |
The end date that the Customer Records will start to be scheduled over the link. |
|
As of |
The date the SCP AOS Expansion ID process searches the Customer Record database in order to generate the report. |
|
CR Status |
The status of the affected Customer Record. The possible statuses are:
|
|
Effective Date/Time |
Identifies the Effective Date and Time for the Customer Record. |
|
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_SCPAOSEXP_AFFECTED” data source is used to create the Affected Customer Records by SCP AOS Expansion report. The fields used from this table are:
- As Of
- Automatic Manual Flag
- CCS Network
- CR Status
- Effective Date
- Entity
- New CCS Network
- Old CCS Network
- Resp Org
- Rownum
- Schedule Date
- Scheduling End Date
- SCP AOS Expansion ID
- Toll-Free Number/Template
- Update Time
Please Note: Please refer to Chapter 15.39 SCP Area of Service Expansion Affected Customer Record Table (RHDB_SCPAOSEXP_AFFECTED) for more information.