The SCP Area of Service Expansion Affected Customer Record table contains data related to all Customer Records affected by an SCP AOS Expansion for the Control Responsible Organization, which has update permission (see Table 96 RHDB_SCPAOSEXP_AFFECTED).
Included in this table are the following fields:
- The SCP AOS Expansion ID.
- The date and time the database is searched.
- The earliest date that the Customer Records will start to be scheduled over the link.
- The cutover date which identifies when all affected Customer Records must be converted to the CCS Network.
- The Dial#.
- The Effective Date for the Customer Record.
- An indicator identifying if the Customer Record will be converted by the SCP AOS process or manually converted.
- The current status of the Customer Record.
- The old and new CCS Networks.
- The Responsible Organization for the Dial#.
Table 96 RHDB_SCPAOSEXP_AFFECTED
RHDB_SCPAOSEXP_AFFECTED |
||
Field |
Characters |
Description |
ExpansionID |
char(8) |
The unique ID for this SCP AOS Expansion. |
RunDateTime |
Date |
The date and time the database is searched to generate the report. |
ScheduleDate |
Date |
The earliest date that the Customer Records will start to be scheduled over the link. |
CutOverDate |
Date |
The date by which all affected records must be converted to the new CCS Network. |
DialNbr |
varchar2(15) |
A 10 digit Toll-Free Number (DIAL#) or Template Name. |
EffectiveDate |
Date |
The Effective Date/Time of the listed Customer Record. |
AutoManualFlag |
char(1) |
Indicates if the Customer Record will be converted by the SCP Area of Service Expansion process or if manual conversion will be required. |
CrStatus |
char(1) |
The status of the Customer Record. Status and definitions are:
|
OldNetwork |
char(2) |
The old CSS Network which is being replaced. |
NewNetwork |
char(2) |
The new CSS Network which is replacing the old CSS Network. |
RespOrg |
char(5) |
The Resp Org for the DIAL#. |
Index for RHDB_SCPAOSEXP_AFFECTED Table
The index and fields used for the RHDB_SCPAOSEXP_AFFECTED table are:
RHDB_SCPAOSEXP_AFFECTED |
|
Index Name |
Fields Used |
rhdb_ SCPExp_Affected _idx1 |
|
rhdb_ SCPExp_Affected _idx2 |
|
rhdb_ SCPExp_Affected _idx3 |
|