The Mass Carrier Change Post Identification Affected Customer Record table contains data related to any affected records that still require manual intervention after the Mass Carrier Change ID process end date has been reached (see Table 78 RHDB_MCC_AFFECTED).
Included in this table are the following fields:
- The Mass Carrier Change ID.
- The run date and time, which identifies when the Mass Carrier Change ID/Conversion process searches the Customer Record database in order to generate the report.
- The Mass Change start and end date.
- The Dial# for the affected Customer Record.
- The Effective Date for the Customer Record.
- Indicator identifying if the Mass Carrier Change process will convert the Customer Record or if manual conversion is required.
- The current status of the Customer Record.
- The Responsible Organization for the Dial#.
- An indication as to whether or not the CAD or both the CAD and CPR portion of the record is affected.
- The CICs that were used to identify affected records.
Table 78 RHDB_MCC_AFFECTED_POST
|
RHDB_MCC_AFFECTED_POST |
||
|
Field |
Characters |
Description |
|
MccId |
Char (8) |
The unique ID for this Mass Carrier Change. |
|
RunDateTime |
Date |
The date the Mass Carrier Change ID/Conversion process searches the Customer Record database. |
|
MccStartDate |
Date |
The earliest date that the new CIC may be used for routing. |
|
MccEndDate |
Date |
The date by which all affected records must be converted to the new CIC. |
|
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 Mass Carrier Change process or if manual conversion will be required. |
|
CrStatus |
Char (1) |
The status of the Customer Record. Status and definitions are:
|
|
RespOrg |
Char (5) |
The responsible organization for the DIAL#. |
|
AffectedField |
Char (1) |
Indicates whether just the CAD or both the CAD and CPR portion of the record is affected. Values are:
|
|
OldCICList |
Varchar (54) |
The list of the CICs that were used as search parameters to identify affected records. |
Index for RHDB_MCC_AFFECTED_POST Table
The index and fields used for the RHDB_MCC_AFFECTED_POST table are:
|
RHDB_MCC_AFFECTED_POST |
|
|
Index Name |
Fields Used |
|
rhdb_ MassCallingData _idx1 |
|