TFNRegistry Reporting: Mass Carrier Change Scheduled Customer Record Table (RHDB_MCC_SCHD) – Somos

The Mass Carrier Change Scheduled Customer Record table includes data related to Customer Records that were attempted to be automatically converted by the Mass Carrier Change conversion programs and scheduled to be sent to the appropriate SCPs. The Customer Records were either changed in place or were given a future Effective Date/Time. The data will only include those records that were attempted to be converted automatically by the SMS/800 TFN Registry (see Table 81 RHDB_MCC_SCHD).

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 81 RHDB_MCC_SCHD

RHDB_MCC_SCHD
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.
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_SCHD Table

The index and fields used for the RHDB_MCC_SCHD table are:

RHDB_MCC_SCHD
Index Name		Fields Used
rhdb_MCC_Schd_idx1	MCCId DialNbr EffectiveDate
rhdb_MCC_ Schd _idx2	RespOrg
rhdb_MCC_Schd_idx3	RespOrg MCC Id