TFNRegistry Reporting: Mass Carrier Change Rejected Customer Record Table (RHDB_MCC_RJCT) – Somos

The Mass Carrier Change Rejected Customer Record table contains data related to the Customer Records rejected by the Mass Carrier Change conversion programs.

It is possible that records that have been converted automatically will not pass all validations, or that the records could not be converted by the software for other reasons. The changes required to these rejected Customer Records should be made as soon as possible after the data is received (see Table 80 RHDB_MCC_RJCT).

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.
The current status of the Customer Record.
Indicator identifying the reason the record was rejected.
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 80 RHDB_MCC_RJCT

RHDB_MCC_RJCT
Field	Characters	Description
MccId	char(8)	The unique ID for this Mass Carrier Change.
OldCICList	varchar (54)	The list of the CICs that were used as search parameters to identify affected records.
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.
CrStatus	char(1)	The status of the Customer Record. Status and definitions are: A - Active D - Disconnect with Referral F - Failed H - Hold I - Invalid M - Must Check P - Pending S - Sending U - Saved
CvStatus	char(4)	The status of the Customer Record. Status and definitions are: CPSD - Coped and Scheduled CVER - Conversion Error (contact the Help Desk) CVOK - Conversion Successful CRXL - Customer Record Exists Later MODI - Customer Record Modified. CR modified before conversion, manual updates may be needed FAVL - Failed Validation ILST - Illegal Status PAST - Customer Record Past Due RNFD - Record Not Found RLXD - Reservation Limit Exceeded SCHG - Status Change
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: 0 = Not Affected 1 = Affected
OldCICList	varchar (54)	The list of the CICs that were used as search parameters to identify affected records.

Index for RHDB_MCC_RJCT Table

The index and fields used for the RHDB_MCC_RJCT table are:

RHDB_MCC_RJCT
Index Name	Fields Used
rhdb_MCC_Rjct_idx1	MCCId DialNbr EffectiveDate
rhdb_MCC_ Rjct _idx2	RespOrg
rhdb_MCC_Rjct_idx3	RespOrg MCC Id