TFNRegistry Reporting: SCP Area of Service Expansion Rejected Customer Record Table (RHDB_SCPAOSEXP_RJCT) – Somos

The SCP Area of Service Expansion Rejected Customer Record table contains data related to Customer Records rejected by the SCP AOS Expansion 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 (see Table 97 RHDB_SCPAOSEXP_RJCT).

The changes required to these rejected customer records should be made as soon as possible after the data is received.

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.
The reason the Customer Record was rejected.
The old and new CCS Networks.
The Responsible Organization for the Dial#.

Table 97 RHDB_SCPAOSEXP_RJCT

RHDB_SCPAOSEXP_RJCT
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.
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)	Identifies the conversion status. CNCP - Cannot Copy CR or CR Exists Later CVER – Conversion Error (contact Help Desk). RNFD – Customer Record Not Found (Possibly Deleted). ILST – Invalid CR Status for Conversion. FAVL – CR Failed Validation.
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 responsible organization for the DIAL#.

Index for RHDB_SCPAOSEXP_RJCT Table

The index and fields used for the RHDB_SCPAOSEXP_RJCT table are:

RHDB_SCPAOSEXP_RJCT
Index Name	Fields Used
rhdb_ SCPAOSExp_Rjct _idx1	ExpansionId DialNbr EffectiveDate
rhdb_ SCPAOSExp_Rjct _idx2	RespOrg
rhdb_ SCPAOSExp_Rjct _idx3	RespOrg ExpansionId