TFNRegistry Reporting: MCC ID Records Prior to Conversion – Somos

The Mass Carrier Change (MCC) ID Records Prior to Conversion Report provides information to Help Desk and involved Responsible Organizations (Resp Orgs) about the Customer Records affected by a MCC. Only the affected Customer Records that are in the Resp Org's control and for which update permission is allowed are reported. This report is generated by the MCC ID process prior to the Carrier Identification Code (CIC) conversion. The Resp Org in control of the Customer Records on this report should look at the affected areas for the records that require manual intervention and access the appropriate pages (i.e. Customer Record (CAD) (also known as a CR) or Template Record (TAD) (also known as a TR) to make the appropriate changes (see Figure 142 Mass Carrier Change Customer Record ID Prior to Conversion).

Figure 142 Mass Carrier Change Customer Record ID Prior to Conversion

Mass Carrier Change Customer Record ID Prior to Conversion Summary Field Descriptions

The following table identifies Mass Carrier Change Customer Record ID Prior to Conversion fields and their descriptions (see Table 31 Mass Carrier Change Customer Record ID Prior to Conversion Summary Descriptions).

Table 31 Mass Carrier Change Customer Record ID Prior to Conversion Summary Descriptions

Mass Carrier Change Customer Record ID Prior to Conversion Summary Descriptions
Field	Description
Entity	An identifier for the Entity.
Resp Org	An identifier for the Resp Org.
Automatic Manual Flag	Indicates if the record that will be converted by the MCC ID process or if manual conversion will be required. Possible values: Automatic Manual
MCC ID	The unique ID for each MCC performed.
Start Date	The earliest date that the new CIC may be used for routing.
End Date	The date by which all affected records must be converted to the new CIC.
As Of	The date the MCC Post Conversion process was run.
Toll-Free Number/Template	The Toll-Free Number (TFN) or Template Name of the affected records. Multiple records for the same number or Template Name may be listed if multiple records are affected.
Area	Indicates whether just the CAD or both the CAD and Call Processing Record (CPR) portions of the record are affected.
CR Status	The status of the affected CR, PR or TR. 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
Effective Date/Time	Identifies the Effective Date and Time for the 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_MCC_AFFECTED_PRIOR” data source is used to create the Mass Carrier Change Customer Record ID Prior to Conversion report. The fields used from this table are:

Area
As Of
Automatic Manual Flag
CR Status
Effective Date
End Date
Entity
MCC ID
Resp Org
Start Date
Toll-Free Number/Template
Update Time

Please Note: Please refer to Chapter 15.22 Mass Carrier Change Prior Identification Affected Customer Record Table (RHDB_MCC_AFFECTED_PRIOR) for more information.